3262009 - Issue in EU_CLONE_CRE_SHDVIEWS due to "Could not find table/view Z*"

Symptom

SUM upgrade fails with below error in phase EU_CLONE_CRE_SHDVIEWS due to missing a customized Z* table/view in shadow schema

-----------------------------------------------------
Checks after phase MAIN_SHDINST/SUBMOD_SHDALIASCRE/SUBMOD_SHDVIEWCRE/EU_CLONE_CRE_SHDVIEWS were negative!

ERROR:
The following errors were detected in the log files:

# Find the detailed information in log 'SHDVIEWS_00xxx_IMP.LOG':
A1 EGEN 011 CMDLINE: "/<PATH>/SUM/abap/bin/R3load -i /<PATH>/SUM/abap/load/shdviews/SHDVIEWS_00xxx_IMP.CMD -dbcodepage 4103 -l /<PATH>/SUM/abap/load/shdviews/SHDVIEWS_00xxx_IMP.LOG"
A1 ETPL 002 Template '/<PATH>/SUM/abap/load/shdviews/DDLHDB_LRG.TPL' has version 4.
A1 EDBS 001 Connected to DB 'HDB'.
A1 EIMP 000 ====================================================
A2 ETSK 000 Starting create for object "CWORKFLOWTASK" of type "CDS view" #20221015184449
A2 EIMP 004 CWORKFLOWTASK dropped #20221015184449
A1EEIMP 008 Task failed with error: (HDB) DbSlExecute failed for DDL statement #0 'CREATE OR REPLACE VIEW "CWORKFLOWTASK" AS
A1EEIMP 008 SELECT "IWORKFLOWTASK"."MANDT" AS "MANDT", "IWORKFLOWTASK"."WORKFLOWTASKINTERNALID"
A1EEIMP 008 AS "WORKFLOWTASKINTERNALID", SESSION_CONTEXT( 'LOCALE_SAP') AS "LANGUA'
A1EEIMP 008 (HDB) dbrc = 103 'table/view does not exist'
A1EEIMP 008 (HDB) SQL error = 259
A1EEIMP 008 (HDB) invalid table name: Could not find table/view Zxxx in schema SAPHANADBSHD: line 35 col 13 (at pos 3067)
A1EEIMP 008 (HDB) DBCreate failed
A1EEIMP 008 (IMP) Statement 1 of 1 failed for the object CWORKFLOWTASK
A2EETSK 007 Finished create for object "CWORKFLOWTASK" of type "CDS view" with error in 0.01 sec #20221015184449

* Here is an example, the error could happen on creating other objects due to missing a Z* table/view in shadow schema

Environment

SAP Netweaver or SAP ERP or S4HANA

Product

SAP S/4HANA all versions

Keywords

EU_CLONE_CRE_SHDVIEWS, dbrc = 103, table/view does not exist, SQL error = 259, invalid table name, Could not find table/view, , 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.