SAP Knowledge Base Article - Preview

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

Symptom

Running an update with SUM you are in MAIN_SHDRUN/ACT_UPG phase and it is time to run SPDD.

[SAPup.log]

CURRENTPHASE MAIN_SHDRUN/ACT_UPG
...started at <xxxxxxxxxxxxxx>
# SPDD HALT for phase ACT_UPG performed
...begin dialog at  <xxxxxxxxxxxxxx>

In your update, shadow instance is used so SPDD should be run on this but calling SPDD transaction you get a DBSQL_SQL_ERROR short dump:

[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, you see that the 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, you should 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 |

You need to identify a modification on the programs.


Read more...

Keywords

user exit, SUM , 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 ONE Support launchpad (Login required).

Search for additional results

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