Error: EventSubSystem and Teamsite not start

quentin

Hi,

We are currently using Teamsite6.5,Opend Deploy 6.0.2 & SP1,Oracle 10.2.0(source) and Data Deploy in solaris9. After completing the installation the event subsystem is not up.

iweventsubd: ---------- STOPPED: Fri Sep 7 20:04:46 IST 2007
iweventsubd: ---------- STARTING: Fri Sep 7 20:04:53 IST 2007
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
org.exolab.jms.server.ServerException: org.exolab.jms.persistence.PersistenceException: java.sql.SQLException: ORA-00942: table or view does not exist

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1451)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:651)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2117)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2331)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:422)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:366)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:205)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:205)
at org.exolab.jms.persistence.RDBMSAdapter.getSchemaVersion(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)

Thanks & Regards,
Antony

Migrateduser

>>org.exolab.jms.server.ServerException: org.exolab.jms.persistence.PersistenceException: java.sql.SQLException: ORA-00942: table or view does not exist

Did you pointed to the DB while the install or this is post install Oracle configuration. Can you please verify that the eventsubsytem tables are created in the database.
You might need to run the create_oracle..sql script in the TS_HOME/eventsubsyetm/conf/ddl to create the tables manually. Thease tables are named as consumers, messages, messages_handles, destinations and users.