Error: "Table SCHEDULED_JOB_DETAIL does not exist" in Sentinel log files.

  • 7004975
  • 03-Dec-2009
  • 10-Jun-2013

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:

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)

Feedback service temporarily unavailable. For content questions or problems, please contact Support.