1904259 - DB6: DBCLONE phase: SQL0204N "<schema>#<tablespace>" is an undefined name

**** "Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."***

Symptom 1

During DBCLONE phase, an error occurs:

SQL0204N  "<schema>#<tablespace>" is an undefined name.  SQLSTATE=42704

when the phase is trying to create a table or index.

In the error message, the <schema> is not belonging to the current system, it is from a different system.

e.g. If the current system being upgraded has schema LN8 and the error shows

SQL0204N "LN7#DDICD" is an undefined name. SQLSTATE=42704

Symptom 2 

SQL0204N "LN7#DDICD" is an undefined name. SQLSTATE=42704

SUM is trying to create the shadow table ~ in the wrong tablespace where an old tablespace exists. 
IN the example below, SUM is trying to create table LN8_TEST1  in the wrong  "LN7#DDICD" tablespace

CREATE TABLE "LN8_TEST1~"...........

.......... (IN  "LN7#DDICD" INDEX IN  "LN7#DDICI", LONG IN " "LN7#DDICD"" COMPRESS YES STATIC

The expected tablespaces are LN8#DDICD" INDEX IN  "LN7#DDICDI", LONG IN " "LN8#DDICI""
This can also be seen for 700 ->750 tablespaces, Data and Index.  This is where you could have Basis 750 and old Basis 700 tablespaces and SUM is trying to create the tables in the old 700 tablespaces
when it should create them in the Basis 750 tablespaces.

#" is an undefined name"> Read more...

BC-DB-DB6-UPG
BC-UPG-TLS-TLA

SAP NetWeaver 2004 ; SAP NetWeaver 7.0 ; SAP NetWeaver 7.1 ; SAP NetWeaver 7.2 ; SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5 ; SAP enhancement package 1 for SAP NetWeaver 7.0 ; SAP enhancement package 1 for SAP NetWeaver 7.3 ; SAP enhancement package 2 for SAP NetWeaver 7.0 ; SAP enhancement package 3 for SAP NetWeaver 7.0

abap upgrade, data classes, ~, shadow, deferred table creation. , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , BC-UPG-TLS-TLA , Upgrade tools for ABAP , Problem