Teamsite Search / Index issue

Hi All,

I have a Solaris Server dedicated for TeamSite Search. I did SP3 installation and DB upgrade from oracle 9i to 10g. After completing these activites. I try hitting the Search button in GUI, I got the following error 'The search manager is unable to contact the index manager.()'

When I try stopping the index server I get the following error

[12 Jul 2007 11:07:49,693] INFO com.interwoven.hunter.index.IndexServer (main) - *************************************************
[12 Jul 2007 11:07:49,697] INFO com.interwoven.hunter.index.IndexServer (main) - Server starting....
[12 Jul 2007 11:07:49,737] INFO com.interwoven.hunter.index.IndexServer (main) - Trying to bind to port 6715
[12 Jul 2007 11:07:50,203] INFO com.interwoven.hunter.index.IndexServer (main) - Bound to port 6715
[12 Jul 2007 11:07:50,439] INFO com.interwoven.hunter.index.IndexServer (main) - TeamSite server is up, continuing with initialization of index server
[12 Jul 2007 11:07:54,597] INFO com.interwoven.hunter.config.field.FieldMapping (main) - Found 0 indexed global EAs.
[12 Jul 2007 11:07:54,605] INFO com.interwoven.hunter.config.field.FieldMapping (main) - Found 0 templating entries.
[12 Jul 2007 11:07:55,126] INFO com.interwoven.hunter.config.field.FieldMapping (main) - Found 14 Standard File Attributes.
[12 Jul 2007 11:07:55,135] INFO com.interwoven.hunter.config.field.FieldMapping (main) - Creator added to global field list
[12 Jul 2007 11:07:55,136] INFO com.interwoven.hunter.config.field.FieldMapping (main) - CreateDate added to global field list
[12 Jul 2007 11:07:55,136] INFO com.interwoven.hunter.config.field.FieldMapping (main) - AreaRelativePath added to global field list
[12 Jul 2007 11:07:55,137] INFO com.interwoven.hunter.config.field.FieldMapping (main) - Version added to global field list
[12 Jul 2007 11:07:55,138] INFO com.interwoven.hunter.config.field.FieldMapping (main) - BranchId added to global field list
[12 Jul 2007 11:07:55,139] INFO com.interwoven.hunter.config.field.FieldMapping (main) - OwningAreaId added to global field list
[12 Jul 2007 11:07:55,146] INFO com.interwoven.hunter.config.field.FieldMapping (main) - LastModifier added to global field list
[12 Jul 2007 11:07:55,147] INFO com.interwoven.hunter.config.field.FieldMapping (main) - LastModifiedDate added to global field list
[12 Jul 2007 11:07:55,147] INFO com.interwoven.hunter.config.field.FieldMapping (main) - Indexed added to global field list
[12 Jul 2007 11:07:55,148] INFO com.interwoven.hunter.config.field.FieldMapping (main) - IndexedDate added to global field list
[12 Jul 2007 11:07:55,149] INFO com.interwoven.hunter.config.field.FieldMapping (main) - Size added to global field list
[12 Jul 2007 11:07:55,149] INFO com.interwoven.hunter.config.field.FieldMapping (main) - Title added to global field list
[12 Jul 2007 11:07:55,151] INFO com.interwoven.hunter.config.field.FieldMapping (main) - Author added to global field list
[12 Jul 2007 11:07:55,151] INFO com.interwoven.hunter.config.field.FieldMapping (main) - Keywords added to global field list
[12 Jul 2007 11:07:55,177] INFO com.interwoven.hunter.config.field.FieldMapping (main) - Found 3 Standard Extended Attributes.
[12 Jul 2007 11:07:55,179] INFO com.interwoven.hunter.config.field.FieldMapping (main) - TeamSite/Templating/PrimaryDCR added to global field list
[12 Jul 2007 11:07:55,179] INFO com.interwoven.hunter.config.field.FieldMapping (main) - TeamSite/Templating/PrimaryDocumentType added to global field list
[12 Jul 2007 11:07:55,181] INFO com.interwoven.hunter.config.field.FieldMapping (main) - TeamSite/Templating/DCR/Type added to global field list
[12 Jul 2007 11:07:55,355] INFO com.interwoven.hunter.common.agent.AgentService (main) - Agent main port is 6716
[12 Jul 2007 11:07:55,356] INFO com.interwoven.hunter.common.agent.AgentService (main) - Agent callback port is 6717
[12 Jul 2007 11:07:55,445] INFO com.interwoven.hunter.common.agent.AgentService (agent-cbl) - Agent callback listener ready
[12 Jul 2007 11:07:55,450] INFO com.interwoven.hunter.common.agent.AgentService (agent-ml) - Agent connection listener ready
[12 Jul 2007 11:07:55,465] INFO com.interwoven.hunter.common.agent.AgentProxy (main) - Starting indexagent_0 with params: /opt/tssearch/bin/iwsrchagent indexa
gent_0 index_agent /opt/tssearch/verity/vdk/common /opt/tssearch/shared 6716 6717 INFO 1 false , and env: LD_LIBRARY_PATH=/opt/tssearch/verity/vdk/_ssol26/bin

[12 Jul 2007 11:07:55,812] INFO com.interwoven.hunter.common.agent.AgentProxy (main) - Agent Agent indexagent_0 started
[12 Jul 2007 11:07:55,814] INFO com.interwoven.hunter.common.agent.AgentProxy (main) - Starting indexagent_1 with params: /opt/tssearch/bin/iwsrchagent indexa
gent_1 index_agent /opt/tssearch/verity/vdk/common /opt/tssearch/shared 6716 6717 INFO 1 false , and env: LD_LIBRARY_PATH=/opt/tssearch/verity/vdk/_ssol26/bin

[12 Jul 2007 11:07:55,923] INFO com.interwoven.hunter.common.agent.AgentProxy (main) - Agent Agent indexagent_1 started
[12 Jul 2007 11:07:55,925] INFO com.interwoven.hunter.common.agent.AgentProxy (main) - Starting indexagent_2 with params: /opt/tssearch/bin/iwsrchagent indexa
gent_2 index_agent /opt/tssearch/verity/vdk/common /opt/tssearch/shared 6716 6717 INFO 1 false , and env: LD_LIBRARY_PATH=/opt/tssearch/verity/vdk/_ssol26/bin

[12 Jul 2007 11:07:56,224] INFO com.interwoven.hunter.common.agent.AgentProxy (main) - Agent Agent indexagent_2 started
[12 Jul 2007 11:07:56,225] INFO com.interwoven.hunter.common.agent.AgentService (main) - Agent service is initialized
[12 Jul 2007 11:07:56,227] INFO com.interwoven.hunter.index.IndexServer (main) - Starting Event Listeners
[12 Jul 2007 11:07:56,227] INFO com.interwoven.hunter.index.IndexServer (main) - Number of JMS topics to listen to: 1
[12 Jul 2007 11:07:56,264] INFO com.interwoven.hunter.index.Listener (main) - Looking for event system ...

when I try to start search I am getting the following error...

[12 Jul 2007 10:43:30,025] ERROR com.interwoven.hunter.search.BranchMapping (Thread-0) - Error registering with index server:
java.net.ConnectException: Connection refused
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:305)
at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:171)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:158)
at java.net.Socket.connect(Socket.java:452)
at java.net.Socket.connect(Socket.java:402)
at java.net.Socket.(Socket.java:309)
at java.net.Socket.(Socket.java:124)
at com.interwoven.hunter.index.api.XmlRpcIndexAPI.openSocketIfNeeded(XmlRpcIndexAPI.java:74)
at com.interwoven.hunter.index.api.XmlRpcIndexAPI.sendDataGram(XmlRpcIndexAPI.java:591)
at com.interwoven.hunter.index.api.XmlRpcIndexAPI.registerSearchServer(XmlRpcIndexAPI.java:543)
at com.interwoven.hunter.search.BranchMapping.(BranchMapping.java:170)
at com.interwoven.hunter.search.BranchMapping.getInstance(BranchMapping.java:197)
at com.interwoven.hunter.search.commands.GetIndexStatusByVpathCommand.execute(GetIndexStatusByVpathCommand.java:65)
at com.interwoven.hunter.search.SearchWorker.run(SearchWorker.java:88)
at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:748)
at java.lang.Thread.run(Thread.java:534)

Can anyone help me resolving this?

Jay

Find more posts tagged with

Comments

nipper

Check your event subsystem and see if it is connecting to Oracle. It appears that it is not running.

Icebreaker

Hi Nipper,

Thanks for your instant reply.

When I try starting eventsubsystem, I am getting the following error

iweventsubd: ---------- STARTING: Thu Jul 12 12:05:01 EDT 2007
Starting the event subsystem...
Getting the Event Subsystem Password...
Done.
Starting the event subsystem...
EVENTSUBD_HOME is set to /app/iw-home/eventsubsystem
OpenJMS 0.7.6.1
The OpenJMS Group. (C) 1999-2004. All rights reserved.
http://openjms.sourceforge.net
Done starting server...
Setting the Password to dummy password...
Done.
org.exolab.jms.server.ServerException: org.exolab.jms.persistence.PersistenceException: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConn
ectionFactory, cause:
java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=169870080)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:335)
at oracle.jdbc.driver.OracleConnection.(OracleConnection.java:361)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:442)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:321)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:82)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:300)
at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:838)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:821)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:518)
at org.exolab.jms.persistence.DBCPConnectionManager.getConnection(Unknown Source)
at org.exolab.jms.persistence.RDBMSAdapter.getConnection(Unknown Source)
at org.exolab.jms.persistence.RDBMSAdapter.(Unknown Source)
at org.exolab.jms.persistence.DatabaseService.createRdbmsAdapter(Unknown Source)
at org.exolab.jms.persistence.DatabaseService.(Unknown Source)
at org.exolab.jms.persistence.DatabaseService.instance(Unknown Source)
at org.exolab.jms.server.JmsServer.registerServices(Unknown Source)
at org.exolab.jms.server.JmsServer.init(Unknown Source)
at org.exolab.jms.server.JmsServer.main(Unknown Source)

Any idea what could be wrong?

Regards,

nipper

Obviously something there Smiley Very Happy

You changed DBs, so I am thinking either the new DB drivers did not get loaded on that system, or the subsystem is pointing to the old Oracle 9 configuration rather than the Oracle 10.

Andy

Icebreaker

Hi Nipper,

Thanks for your reply.

I have 2 Servers, one for TeamSite and the other for Search. The oracle database that I upgraded on Search is not up, so when I started the eventsubsystem on TeamSite Server. It errored out.

I corrected that, even after correcting that I hit with table or view not found while starting the eventsubsystem. Then I figured the issue and created basic tables in the database and started the eventsubsytem. Then restarted the search and index on the Search Search server. Everything worked fine.

Thanks for your all your help. I appreciate that.

Regards,