2220206 - ACT_UPG: ORA-00942: table or view does not exist calling SPDD in shadow instance

Running an update with Software Update Manager (SUM) stops in MAIN_SHDRUN/ACT_UPG phase and it is time to run SPDD.

While calling SPDD transaction in shadow instance, a DBSQL_SQL_ERROR short dump appears:

[ST22]

Runtime Errors DBSQL_TABLE_UNKNOWN
Date and Time 27.06.2019 13:17:27
----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------
|Short text |
| There is no help text for this runtime error |
| Either the text was inadvertently deleted or the release of |
| the kernel differs from that of the database. |
| Refer to the Note system for further information on |
| this runtime error. |
----------------------------------------------------------------------------------------------------

and in the Error analysis section of the dump, a missing table is a Z* table (table created in a customer namespace). For example:

|Error analysis |
| Description not available |
| 

| Parameters: |
| P1 "ZTABLE" |
| P2 0 |
| P3 "ORA-00942: table or view does not exist" |

To recognize the programs affected, go to active calls section of the short dump. For example:

|Active Calls/Events |
----------------------------------------------------------------------------------------------------
|No. Ty. Program Include Line |
| Name |
----------------------------------------------------------------------------------------------------

| 13  OPEN_FORM SAPLSTXC  ZFORM_MODIFY |
| 12  PRINT_TEXT SAPLSTXD  LSTXDU12 |
| 11  STATUS_0300 SAPLSPO6  LSPO6O01 |
| 10  POPUP_DISPLAY_TEXT_USER_BUTTON SAPLSPO6  LSPO6U02 |
| 9  POPUP_DISPLAY_TEXT SAPLSEMM  LSEMMF05 |

It's required to identify a modification on the programs.

• Software Update Manager (SUM)
• SAP NetWeaver AS ABAP

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, DBIF_RSQL_TABLE_UNKNOWN, DBSQL_TABLE_UNKNOWN, SPDD, SPAU, Shadow system, Update, Upgrade, Table is unknown, DSYS_LODESC_E_CD, SQL message: invalid table name, Could not find table/view, Shadow instance, ST22, SAPLSDCL, 1970888, ACT_UPG, dump, ST22, shadow  , KBA , BC-UPG-TLS-TLA , Upgrade tools for ABAP , Problem