Environment
Novell Sentinel 6.1
Situation
In various log files the following error message may be seen after applying Hotfix 2 to Sentinel 6.1 SP1:
The error may repeat several times causing the log files to grow and rotate more quickly than usual. One example of the full Java exception stack is shown below.
2009|WARNING|main|esecurity.base.db.schema.TableInfo.initialize
Table SCHEDULED_JOB_DETAIL does not exist (Execute SELECT * FROM
SCHEDULED_JOB_DETAIL WHERE 1=0 Params [ ] - SQLState : 42000 - ErrorCode :
942)
The error may repeat several times causing the log files to grow and rotate more quickly than usual. One example of the full Java exception stack is shown below.
Resolution
This message is cosmetic in nature and, aside from causing faster file rotation, does not indicate a risk to the Sentinel system. The table referenced is used in Sentinel RD for jobs. The Structured Query Language (SQL) shown in the error indicates that the system is attempting to, incorrectly, query this table in an environment that does not have the table. The result is a failed query and a message in the log; this message can be safely ignored.
This has been resolved in Sentinel 6.1 SP2
Additional Information
Wed Sep 30 02:00:23 MDT
2009|WARNING|main|esecurity.base.db.schema.TableInfo.initialize
Table SCHEDULED_JOB_DETAIL does not exist (Execute SELECT * FROM
SCHEDULED_JOB_DETAIL WHERE 1=0 Params [ ] - SQLState : 42000 - ErrorCode :
942)
Wed Sep 30 02:00:23 MDT
2009|SEVERE|main|esecurity.base.query.db.BaseJDBCQuery.executeSelect
Error; Going to rollback transaction.; Exception ORA-00942: table or view
does not exist
; java.sql.SQLException;
Wed Sep 30 02:00:23 MDT
2009|SEVERE|main|esecurity.base.query.db.BaseJDBCQuery.executeSelect
java.sql.SQLException: ORA-00942: table or view does not exist
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
at
oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:810)
at
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1039)
at
oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:850)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1134)
at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3384)
at
esecurity.base.query.db.BaseJDBCQuery.executeSelect(BaseJDBCQuery.java:312)
at esecurity.base.db.schema.TableInfo.initialize(TableInfo.java:52)
at esecurity.base.db.schema.TableInfo.<init>(TableInfo.java:42)
at
esecurity.base.configuration.DBMetaDataFactory.verifyObjectPersistence(DBMetaDataFactory.java:273)
at
esecurity.ccs.comp.ExtMetaDataManager.verifyPersistentObject(ExtMetaDataManager.java:197)
at
esecurity.ccs.comp.ExtMetaDataManager.verifyPersistentObjects(ExtMetaDataManager.java:218)
at
esecurity.ccs.comp.ExtMetaDataManager.postInit(ExtMetaDataManager.java:110)
at
esecurity.base.configuration.MetaDataManager.getInstance(MetaDataManager.java:173)
at
esecurity.base.configuration.MetaDataManager.getInstance(MetaDataManager.java:164)
at
esecurity.base.ccs.comp.publisher.PublisherServiceImpl.componentActivated(PublisherServiceImpl.java:104)
at esecurity.base.ccs.BasicComponent.activate(BasicComponent.java:227)
at
esecurity.base.ccs.proxy.ComponentElementProxy.activate(ComponentElementProxy.java:141)
at
esecurity.base.ccs.proxy.ComponentElementProxy.changeChildrenStatus(ComponentElementProxy.java:213)
at
esecurity.base.ccs.proxy.ComponentElementProxy.activate(ComponentElementProxy.java:134)
at
esecurity.base.ccs.proxy.ComponentElementProxy.componentStateChange(ComponentElementProxy.java:121)
at
esecurity.base.ccs.services.ComponentListenerSupport.fireListenerChange(ComponentListenerSupport.java:77)
at
esecurity.base.ccs.services.ComponentListenerSupport.fireListenerChange(ComponentListenerSupport.java:56)
at
esecurity.base.ccs.services.ComponentServices.activateAllComponents(ComponentServices.java:65)
at
esecurity.base.ccs.proxy.ContainerProxy.activateContainer(ContainerProxy.java:35)
at
esecurity.base.ccs.ContainerExecutor.execute(ContainerExecutor.java:113)
at
esecurity.base.ccs.ContainerExecutor.main(ContainerExecutor.java:208)