SAP Knowledge Base Article - Preview

2560074 - OpenSQLExceptionCategories: [NON_TRANSIENT, DB_OBJECT_UNKNOWN] com.sap.sql.exception.OpenSQLException: ORA-00942: table or view does not exist

Symptom

While Upgrading PORTAL ADD-ON SAP NW from 7.0 to 7.4 error occurs in phase CREATE-SHADOW-TABLES :

Error :

CREATE-SHADOW-TABLES_04.LOG :

Sep 1, 2017 3:58:26 PM [Error ]: Error while executing command ddic.
Sep 1, 2017 3:58:26 PM [Error ]: Return code condition success evaluated to false for process java for action ddic.
Sep 1, 2017 3:58:26 PM [Error ]: The following problem has occurred during step execution: com.sap.sdt.db.dmtif.DMTProcessException: Could not complete DMT process. Check the DMT.CREATE_SHD_TABLE.LOG log file.
Could not execute DMT command ddic with arguments /oracle/SUM/sdt/config/DMT.CREATE_SHD_TABLE.xml.
Return code condition success evaluated to false for process java for action ddic.

==================

DMT.CREATE_SHD_TABLE_04_01.ERR :

Execution failed: Program has finished with error. Exit code: 1
Execution has been terminated. More information can be found in the log file /oracle/SUM/sdt/log/DMT.CREATE_SHD_TABLE_04.LOG.
Could not execute DMT command ddic. See previous messages.
Could not perform dictionary operation CREATE_SHD_TABLE.
Could not perform dictionary operation CREATE_SHD_TABLE.
msg.tools.ddic.0004 SHD_ZDM_CHANGE_LOG
Could not process table description file /oracle/SUM/sdt/data/archives/ddic/tc~lm~nzdm~crrmgr_ddic.sda.
Could not parse the table description. See previous messages.
Could not parse the table description. See previous messages.
Could not parse the table description. See previous messages.
Could not check existence of index BC_NZDM_CHANGE_LOG_I0. See previous messages.
Could not check whether object BC_NZDM_CHANGE_LOG_I0 (type $(1)) exists.
Could not access the DB catalog for object BC_NZDM_CHANGE_LOG.
SQL Exception code 942: ORA-00942: table or view does not exist

OpenSQLExceptionCategories: [NON_TRANSIENT, DB_OBJECT_UNKNOWN]
com.sap.sql.exception.OpenSQLException: ORA-00942: table or view does not exist

OpenSQLExceptionCategories: [NON_TRANSIENT, DB_OBJECT_UNKNOWN]
java.sql.SQLException: ORA-00942: table or view does not exist


Return code: 1

=====================

DMT.CREATE_SHD_TABLE_04.LOG :

Sep 1, 2017 3:58:26 PM [Info ]: msg.tools.ddic.0006 BC_NZDM_CHANGE_LOG /oracle/SUM/sdt/data/archives/ddic/tc~lm~nzdm~crrmgr_ddic.sda datatypes/BC_NZDM_CHANGE_LOG.gdbtable
Sep 1, 2017 3:58:26 PM [Info ]: msg.tools.ddic.0007 SHD_ZDM_CHANGE_LOG BC_NZDM_CHANGE_LOG
Sep 1, 2017 3:58:26 PM [Info ]: Setting up the OpenSQL connection with secure store.
Sep 1, 2017 3:58:26 PM [Info ]: Connection to SAPSR3DB has been established.
Sep 1, 2017 3:58:26 PM[Error ]: com.sap.sql.exception.OpenSQLException: ORA-00942: table or view does not exist

OpenSQLExceptionCategories: [NON_TRANSIENT, DB_OBJECT_UNKNOWN]
Sep 1, 2017 3:58:26 PM [Error ]: SQL Exception code 942: ORA-00942: table or view does not exist

OpenSQLExceptionCategories: [NON_TRANSIENT, DB_OBJECT_UNKNOWN]
Sep 1, 2017 3:58:26 PM [Error ]: Could not access the DB catalog for object BC_NZDM_CHANGE_LOG.
Sep 1, 2017 3:58:26 PM [Error ]: Could not check whether object BC_NZDM_CHANGE_LOG_I0 (type $(1)) exists.
Sep 1, 2017 3:58:26 PM [Error ]: Could not check existence of index BC_NZDM_CHANGE_LOG_I0. See previous messages.
Sep 1, 2017 3:58:26 PM [Error ]: Could not parse the table description. See previous messages.
Sep 1, 2017 3:58:26 PM [Error ]: Could not parse the table description. See previous messages.
Sep 1, 2017 3:58:26 PM [Error ]: Could not parse the table description. See previous messages.
Sep 1, 2017 3:58:26 PM [Error ]: Could not process table description file /oracle/SUM/sdt/data/archives/ddic/tc~lm~nzdm~crrmgr_ddic.sda.
Sep 1, 2017 3:58:26 PM [Error ]: msg.tools.ddic.0004 SHD_ZDM_CHANGE_LOG
Sep 1, 2017 3:58:26 PM [Error ]: com.sap.sql.exception.OpenSQLException: ORA-00942: table or view does not exist

OpenSQLExceptionCategories: [NON_TRANSIENT, DB_OBJECT_UNKNOWN]
Sep 1, 2017 3:58:26 PM [Error ]: SQL Exception code 942: ORA-00942: table or view does not exist

OpenSQLExceptionCategories: [NON_TRANSIENT, DB_OBJECT_UNKNOWN]
Sep 1, 2017 3:58:26 PM [Error ]: Could not access the DB catalog for object BC_NZDM_CHANGE_LOG.
Sep 1, 2017 3:58:26 PM [Error ]: Could not check whether object BC_NZDM_CHANGE_LOG_I0 (type $(1)) exists.
Sep 1, 2017 3:58:26 PM [Error ]: Could not check existence of index BC_NZDM_CHANGE_LOG_I0. See previous messages.
Sep 1, 2017 3:58:26 PM [Error ]: Could not parse the table description. See previous messages.
Sep 1, 2017 3:58:26 PM [Error ]: Could not parse the table description. See previous messages.
Sep 1, 2017 3:58:26 PM [Error ]: Could not parse the table description. See previous messages.
Sep 1, 2017 3:58:26 PM [Error ]: Could not process table description file /oracle/SUM/sdt/data/archives/ddic/tc~lm~nzdm~crrmgr_ddic.sda.
Sep 1, 2017 3:58:26 PM [Error ]: msg.tools.ddic.0004 SHD_ZDM_CHANGE_LOG
Sep 1, 2017 3:58:26 PM [Error ]: Could not perform dictionary operation CREATE_SHD_TABLE.
Sep 1, 2017 3:58:26 PM [Info ]: Could not execute command ddic.
Sep 1, 2017 3:58:26 PM [Info ]: Connection has been closed.
Sep 1, 2017 3:58:26 PM [Info ]: Start time: 2017/09/01 15:58:19
Sep 1, 2017 3:58:26 PM [Info ]: Stop time : 2017/09/01 15:58:26
Sep 1, 2017 3:58:26 PM [Info ]: Duration : 0:00:07.004
Sep 1, 2017 3:58:26 PM [Error ]: Error during execution.
Sep 1, 2017 3:58:26 PM [Error ]: com.sap.sql.exception.OpenSQLException: ORA-00942: table or view does not exist

OpenSQLExceptionCategories: [NON_TRANSIENT, DB_OBJECT_UNKNOWN]
Sep 1, 2017 3:58:26 PM [Error ]: SQL Exception code 942: ORA-00942: table or view does not exist

OpenSQLExceptionCategories: [NON_TRANSIENT, DB_OBJECT_UNKNOWN]
Sep 1, 2017 3:58:26 PM [Error ]: Could not access the DB catalog for object BC_NZDM_CHANGE_LOG.
Sep 1, 2017 3:58:26 PM [Error ]: Could not check whether object BC_NZDM_CHANGE_LOG_I0 (type $(1)) exists.
Sep 1, 2017 3:58:26 PM [Error ]: Could not check existence of index BC_NZDM_CHANGE_LOG_I0. See previous messages.
Sep 1, 2017 3:58:26 PM [Error ]: Could not parse the table description. See previous messages.
Sep 1, 2017 3:58:26 PM [Error ]: Could not parse the table description. See previous messages.
Sep 1, 2017 3:58:26 PM [Error ]: Could not parse the table description. See previous messages.
Sep 1, 2017 3:58:26 PM [Error ]: Could not process table description file /oracle/SUM/sdt/data/archives/ddic/tc~lm~nzdm~crrmgr_ddic.sda.
Sep 1, 2017 3:58:26 PM [Error ]: msg.tools.ddic.0004 SHD_ZDM_CHANGE_LOG
Sep 1, 2017 3:58:26 PM [Error ]: Could not perform dictionary operation CREATE_SHD_TABLE.
Sep 1, 2017 3:58:26 PM [Error ]: Could not perform dictionary operation CREATE_SHD_TABLE.
Sep 1, 2017 3:58:26 PM [Error ]: Could not execute DMT command ddic. See previous messages.
Sep 1, 2017 3:58:26 PM [Error ]: Execution has been terminated. More information can be found in the log file /oracle/SUM/sdt/log/DMT.CREATE_SHD_TABLE_04.LOG.
Sep 1, 2017 3:58:26 PM [Error ]:Program has finished with error. Exit code: 1


Read more...

Environment

SAP NetWeaver

Product

SAP NetWeaver 7.4 ; SAP NetWeaver 7.5

Keywords

DB_OBJECT_UNKNOWN,  BC_NZDM_CHANGE_LOG, CREATE-SHADOW-TABLES, DMT.CREATE_SHD_TABLE, NON_TRANSIENT, OpenSQLException, CREATE_SHD_TABLE, SQL Exception code 942: ORA-00942, , KBA , BC-UPG-TLS-TLJ , Upgrade tools for Java , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.