SAP Knowledge Base Article - Preview

3699683 - SUM 1.1 SP4 (PL7) Shadow Instance ORA-00942: table or view does not exist

Symptom

When upgrading NetWeaver 7.4 SPS level, got below error at phase EU_CLONE_CRE_SHDVIEWS

R3LDCALLRUN.ELG
****************************
A1EEIMP 007 Task failed with error: (ORA) DDL statement failed
A1EEIMP 007     (CREATE VIEW "SUID_SH_BPPERSON" (  "CLIENT" ,  "PARTNER" ,  "NAME_FIRST" ,  "NAME_LAST" ,  "PARTNER_GUID"  ) AS SELECT T0001."CLIENT", T0001."PARTNER", T0001."NAME_FIRST", T0001."NAME_LAST", T0001."PARTNER_GUID" FROM "BUT000" T0001 WHERE T0001."TYPE" = '1')
A1EEIMP 007     (rc = 103)
A1EEIMP 007 (ORA) DbSlErrorMsg rc = 0 'everything went well'
A1EEIMP 007 (ORA) ORA-00942: table or view does not exist
A1EEIMP 016 Finished create for object "SUID_SH_BPPERSON" of type "view" with error in 0 sec #20251129145408
A1 EIMP 012 Starting create for object "SUID_SH_ORGADDR" of type "view" #20251129145408
A1EEIMP 007 Task failed with error: (ORA) DDL statement failed
A1EEIMP 007     (CREATE VIEW "SUID_SH_ORGADDR" (  "CLIENT" ,  "PARTNER" ,  "ADDRNUMBER" ,  "NAME_ORG1" ,  "PARTNER_GUID"  ) AS SELECT T0002."CLIENT", T0002."PARTNER", T0002."ADDRNUMBER", T0001."NAME_ORG1", T0001."PARTNER_GUID" FROM "BUT000" T0001, "BUT020" T0002 WHERE T0001."CLIENT" = T0002."CLIENT" AND T0001."PARTNER" = T0002."PARTNER" AND T0001."TYPE" = '2')
A1EEIMP 007     (rc = 103)
A1EEIMP 007 (ORA) DbSlErrorMsg rc = 0 'everything went well'
A1EEIMP 007 (ORA) ORA-00942: table or view does not exist
A1EEIMP 016 Finished create for object "SUID_SH_ORGADDR" of type "view" with error in 0 sec #20251129145408
****************************

According to the above log, Table BUT000 and BUT020 were referred.

In SE11, table BUT000 and BUT020 exists. The tables belong to package "S_BUPA_GENERAL". But the package "S_BUPA_GENERAL" does not exist in the system.


Read more...

Environment

SUM 1.1
NetWeaver 7.4

Product

SAP NetWeaver 7.4

Keywords

EU_CLONE_CRE_SHDVIEWS, 7.4, ORA-00942, table or view does not exist, reset, SUM, SUM 1.1 , 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.