SAP Knowledge Base Article - Preview

2807687 - Error: "invalid table name: Could not find table/view PUSERADDRESS" during DMO upgrade

Symptom

When performing a DMO upgrade with SUM tool, the following error occurs during phase EU_CLONE_CRE_SHDVIEWS:

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Phase: EU_CLONE_CRE_SHDVIEWS
R3LOAD IMPORT ERRORS
Find the detailed log in SHDVIEWS_00014_IMP.LOG
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
A1 EDBS 002 Connected to DB 'HDB'
A1 EHDB 005 HANA Kernel version 2.00.040.00.1553674765 SQLDBC 2.04.126.1551801496
A1 EIMP 000 ====================================================
A1 ETSK 007 Starting create for object "PUSADDR002" of type "CDS view" #20190621122608
A1 EHDB 008 PUSADDR002 dropped
A1EEIMP 007 Task failed with error: (HDB) DbSlExecute failed for DDL statement 'CREATE VIEW "PUSADDR002" AS
A1EEIMP 007 SELECT "PUSERADDRESS"."MANDT", "PUSERADDRESS"."BNAME", "=A0"."NAME_FIRST",
A1EEIMP 007 "=A0"."NAME_LAST", "=A0"."NAME_TEXT" AS "NAME_TEXTC", "=A1"."TEL_EXTENS",
A1EEIMP 007 "PUSERADDRESS"."KOSTL", "=A1"."BUILDING", "=A1"."ROOMNUMBER", "=A1"."DEPARTMENT",
A1EEIMP 007 "=A1"."IH_MAIL" AS "INHOUSE_ML", "=A2"."NAME1", "=A2"."CITY1", "=A2"."POST_CODE1",
A1EEIMP 007 "=A0"."MC_NAMEFIR", "=A0"."MC_NAMELAS", "=A2"."MC_NAME1", "=A2"."MC_CITY1",
A1EEIMP 007 "PUSERADDRESS"."IDADTYPE", "=A3"."PARTNER" AS "PARTNER", "=A4"."SMTP_ADDR",
A1EEIMP 007 "PUSERADDRESS"."CLASS" FROM ( ( ( ( "PUSERADDRESS" "PUSERADDRESS" LEFT
A1EEIMP 007 OUTER MANY TO ONE JOIN "ADRP" "=A0" ON ( "=A0"."PERSNUMBER" = "PUSERADDRESS"."PERSNUMBER"
A1EEIMP 007 AND "=A0"."NATION" = N'' AND "=A0"."DATE_FROM" = N'00010101' AND "PUSERADDRESS"."MANDT" = "=A0"."CLIENT"
A1EEIMP 007 ) ) LEFT OUTER MANY TO ONE JOIN "ADCP" "=A1" ON ( "=A1"."PERSNUMBER" = "PUSERADDRESS"."PERSNUMBER"
A1EEIMP 007 AND "=A1"."ADDRNUMBER" = "PUSERADDRESS"."ADDRNUMBER" AND "=A1"."NATION" = N''
A1EEIMP 007 AND "=A1"."DATE_FROM" = N'00010101' AND "PUSERADDRESS"."MANDT" = "=A1"."CLIENT"
A1EEIMP 007 ) ) LEFT OUTER MANY TO ONE JOIN "ADRC" "=A2" ON ( "=A2"."ADDRNUMBER" = "PUSERADDRESS"."ADDRNUMBER"
A1EEIMP 007 AND "=A2"."NATION" = N'' AND "=A2"."DATE_FROM" = N'00010101' AND "PUSERADDRESS"."MANDT" = "=A2"."CLIENT"
A1EEIMP 007 ) ) LEFT OUTER MANY TO ONE JOIN "BUT000" "=A3" ON ( "=A3"."PERSNUMBER" = "PUSERADDRESS"."PERSNUMBER"
A1EEIMP 007 AND "=A3"."PARTNER_GUID" = "PUSERADDRESS"."BPPERSON" AND "PUSERADDRESS"."MANDT" = "=A3"."CLIENT"
A1EEIMP 007 ) ) LEFT OUTER MANY TO ONE JOIN "ADR6" "=A4" ON ( "=A4"."PERSNUMBER" = "PUSERADDRESS"."PERSNUMBER"
A1EEIMP 007 AND "=A4"."ADDRNUMBER" = "PUSERADDRESS"."ADDRNUMBER" AND "=A4"."DATE_FROM" = N'00010101'
A1EEIMP 007 AND "=A4"."FLGDEFAULT" = N'X' AND "PUSERADDRESS"."MANDT" = "=A4"."CLIENT"
A1EEIMP 007 )'
A1EEIMP 007 (HDB) DbSlErrorMsg rc = 103 'table/view does not exist'
A1EEIMP 007 (HDB) SQL error = 259
A1EEIMP 007 (HDB) invalid table name: Could not find table/view PUSERADDRESS in schema SAPABAP1SHD: line 8 col 43 (at pos 570)
A1EEIMP 007 (HDB) DBCreate failed
A1EETSK 013 Finished create for object "PUSADDR002" of type "CDS view" with error in 0 sec #20190621122608
A1 EGEN 002 ====================================================
A1 EDMP 008 Resource usage: GENERAL times: 0.638/ 0.610/ 0.004 98.6%/100.0%/76.1% real/usr/sys
A1 EDMP 008 Resource usage: DATABASE times: 0.009/ 0.000/ 0.001 1.4%/ 0.0%/23.9% real/usr/sys
A1 EDMP 007 Memory usage: 12/0 MB buffer/disk (0 reused buffers)
A1EEGEN 025 Number of error(s): 1
1 ETP111 exit code : "8"


Read more...

Environment

  • SAP S/4HANA
  • SAP NetWeaver 7.52

Product

SAP enhancement package 1 for SAP NetWeaver 7.3

Keywords

KBA, shadow views , 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.