IBM Support

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

Technote (FAQ)


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
at oracle.jdbc.driver.DatabaseError.newSQLException( 31)
at oracle.jdbc.driver.DatabaseError.throwSqlException( :204)
at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4C8Oall.receive(
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.Java:194)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePrepar
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(Oracl
at Source)
at Source)


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.


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 )

Document information

More support for: Maximo Asset Management
System Related

Software version: 7.1

Operating system(s): Platform Independent

Reference #: 1624356

Modified date: 20 January 2015

Translate this page: