IBM Support

ORA-00942: table or view does not exist

Troubleshooting


Problem

There are error messages as below in Platform Analytics lsfJobmartDaily.log " com.platform.pi.etl.EtlStatusReporter.etlStartUpdate(EtlStatusReporter.java:102) there have occured error when executing the update 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.executeForRows(T4CPreparedStatement.java:966) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3423) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101) at com.platform.pi.etl.EtlStatusReporter.etlStartUpdate(EtlStatusReporter.java:84) at com.platform.pi.etl.Etl.execute(Etl.java:270) at com.platform.pi.etl.EtlEngine.main(EtlEngine.java:204) " Checked Platform Analytics database, table SYS_ETL_HEALTH is normal but not updated.

Symptom


There are false ETL latency warning notifications.

Cause


There are multiple Platform Analytics data source, Platform Analytics database is not set as default data source in datasource.xml, Platform Analytics ETL cannot find table SYS_ETL_HEALTH.

Resolving The Problem


Resolve this issue by the following procedure,
1 Stop Platform Analytics Task Scheduler service from Windows services
2 Kill all Java processes from Windows task manager
3 Modify datasource.xml to set Platform Analytics database as default data source
4 Start Platform Analytics Task Scheduler service from Windows services
5 Run task LSFDataAggDaily from Platform Analytics console

[{"Product":{"code":"SSJSMF","label":"Platform Analytics"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Not Applicable","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.6","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SSZTRM","label":"IBM Spectrum LSF Analytics Server"},"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Component":null,"Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
17 June 2018

UID

isg3T1020772

Page Feedback