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

Document ID:7004975
Creation Date:03-Dec-2009
Modified Date:10-Jun-2013
- Micro Focus Products:
  Sentinel

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)