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

Search for additional results

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