Troubleshooting
Problem
Executed the dump_info.cmd. The output file contained the ORA-00942 error when the script attempted to obtain database meta-data for the SI database schema.
Symptom
<DatabaseMetaData>
Product Name: Oracle
Product Version: Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
Default Trans: 2
Driver Name: Oracle JDBC driver
Driver Version: 11.2.0.3.0
Driver Major Version: 11
Driver Minor Version: 2
</DatabaseMetaData>
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:884)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3628)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1493)
at com.sterlingcommerce.woodstock.util.frame.jdbc.OracleVarData.getDBConfig(OracleVarData.java:329)
at com.sterlingcommerce.db.DumpDbInfo.doit(DumpDbInfo.java:220)
at com.sterlingcommerce.db.DumpDbInfo.main(DumpDbInfo.java:84)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:94)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
at java.lang.reflect.Method.invoke(Method.java:619)
at com.sterlingcommerce.woodstock.noapp.NoAppLoader.main(NoAppLoader.java:82)
SQLException:
SQLState: 42000
Message: ORA-00942: table or view does not exist
Vendor: 942
Log InLog in to view more of this document
Was this topic helpful?
Document Information
Modified date:
04 December 2019
UID
swg21965939