IBM Support

Non-fatal error “ORA-00942: table or view does not exist” when running UpdateDB.bat for MAXROWSTAMP table

Question & Answer


Question

Why am I seeing the similar following non-fatal error message when running UpdateDB.bat file? Product Base Services updatedb process starts... java.sql.SQLException: ORA-00942: table or view does not exist at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.ja va:74) at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:1 31) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java :204) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.Java:194) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:953) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme nt.java:1222) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePrepar edStatement.java:3468) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(Oracl epreparedStatementWrapper.java:1062) at psdi.tools.UpdateDB.updateMaxRowStamp(Unknown Source) at psdi.tools.UpdateDB.loadScriptInfo(Unknown Source)

Cause

This error message is printed out when the UpdateDB.bat code is putting the highest value of ROWSTAMP into each column of a temp table. It's expecting the temp table to exist and it does not. It either creates the table and continues, or it ignores this and continues.

In the code, when this error occurs it just keeps going without throwing an exception and it just prints stack trace info.

This info is related to translations, and relevant when UpdateDB changes something to be translatable. The only impact would be a fix pack that added a new L_tablename or loaded new translated data into existing L-tables and you will see a following UpdateDB error on the logs.

Answer

The temp table MAXROWSTAMP table is missing. You may create it using Database Configuration to get rid of this harmless warning message in such scenario.

For creating the MAXROWSTAMP temp table, please follow the instruction on the attached file below ( Creating_MAXROWSTAMP_Object_71x.doc )

[{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"System Related","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.1","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
17 June 2018

UID

swg21624356