SAP Knowledge Base Article - Preview

2474180 - SUM error due to customer enhancements

Symptom

Your upgrade with Software Update Manager (SUM) fails in a SHADOW phase due to a missing database table.

Depending on the database, the error could be:


Runtime Errors         DBSQL_TABLE_UNKNOWN

Short Text
Table is unknown or does not exist.
what happened?
   Error in the ABAP application program.
   The current ABAP program "<program name>" had to be terminated
because it found a statement that could not be executed.
Error analysis
    In an SAP Open SQL statement, a table is specified that either does not exist on the database,
or that is not known to the ABAP Data Dictionary.
    This is table "<table name>", or another table which the statement wants to
    access. The database has returned SQL code "SQL code: -204" with the error text
    "SQL message: SQL0204N  "SAPSR3SHD.<table name>" is an undefined name.
Or
    In an SAP Open SQL statement, a table is specified that either does not exist on the database, 
or that is not known to the ABAP Data Dictionary.
    This is table "<table name>", or another table which the statement wants to
    access. The database has returned SQL code "SQL code: 942" with the error text
    "SQL message: ORA-00942: table or view does not exist".
Or
    In an SAP Open SQL statement, a table is specified that either does not exist on the database, 
or that is not known to the ABAP Data Dictionary.
    This is table "<table name>", or another table which the statement wants to
    access. The database has returned SQL code "SQL code: 259" with the error text
    "SQL message: invalid table name: Could not find table/view <table name> in schema <shadow instance DB schema>: line <xx> col <yy> (at pos <zz>)".


Or the shadow instance cannot be started or accessed (logon via RFC) due to a missing customer table/view in the schema of the shadow instance.

By checking the work trace files (dev_w*) of the shadow instance, you can locate the following information.

A ABAP Program <Z program> .
A Source <Z program source> Line <nn>.
A Error Code DBSQL_TABLE_UNKNOWN.
A Module $Id: //bas/754_STACK/src/krn/dbi/dbsql/dbdbslstatement.cpp#2 $ SAP.
A Function DbDbslStatement::handleDbslRc Line 5180.
A P1: <z table/view name>
A P2: SQL code: 259
A P3: SQL message: invalid table name: Could not find table/view <z table/view name> in schema <schema name>: line 1 col 194 (at pos 193)
A P4: SQL dbsl rc: 103




            


Read more...

Environment

  • Software Update Manager
  • running on a shadow phase

Product

SAP NetWeaver all versions

Keywords

shadow, table, missing, unknown, fehlt, XPRA, SQL0204N, ORA-00904, ORA-00942, /UR4/, /UR4/REFAC_CO, namespace, Namensraum, RSUPG_WRP_REGEN_SAPALL, JOB_RSUPG_WRP_SHD2, DBSQL_TABLE_UNKNOWN , KBA , BC-UPG-TLS-TLA , Upgrade tools for ABAP , Problem

About this page

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

Search for additional results

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