Symptom
ST-PI SPAM / SAINT Update
stops in IMPORT_PROPER phase
Error seen in /usr/sap/trans/log/P######.P##
. . .
10:21:08: Retcode 512: error in DDL statement for <table_name> - repeat
Error -204-SQL0204N when executing ADD-FIELD of is an undefined name. SQLSTA
Error in DDL statement for when executing ADD-FIELD of
DB-ROLLBACK()
No DDL commands found for activation of /SDF/AJM_JOBS
stops in IMPORT_PROPER phase
2WETP000 16:12:08: Retcode 1024: error in DDL statement for "/SDF/CCA_METRICS " - repeat at
2EETP345 16:12:20: Retcode 1024: SQL-error "-601-SQL0601N The name of the object to be created is
2EETP345 identical to the existing name "<schema>./SDF/CCA_METRICS" of type "TABLE". SQLSTATE=42710"
2EETP345 in DDL statement for "/SDF/CCA_METRICS "
2 ETP000 DB-ROLLBACK()
2EETP334 16:12:21: error in DDL, nametab for "/SDF/CCA_METRICS" not activated
2 ETP301
3 ETP361 "0" Shadow-Nametabs activated, DDL executed
2 ETP362 "5" Shadow-Nametab activations failed
2 ETP360 Begin: Act. of Shadow-Nametabs with DDL ("2022/02/19 16:11:12")
2 ETP363 End : Act. of Shadow-Nametabs with DDL ("2022/02/19 16:12:21")
dev_w98
. . .
C Sat Feb 19 16:12:17:621 2022
C *** ERROR in ExecuteDirect[/bas/753_REL/src/dbs/db6/dbdb6.c, 7435] CON = 0 CACHEID = -1 (BEGIN)
C &+ dsql_db6_exec_immediate( SQLExecDirect ): [IBM][CLI Driver][DB2/AIX64] SQL0601N The name of the object to be crea
C &+ ted is identical to the existing name "<schema>./SDF/CCA_METRICS" of type "TABLE". SQLSTATE=42710
C &+
C &+ CREATE TABLE "/SDF/CCA_METRICS" ("OBJ_ID" INTEGER DEFAULT 0 NOT NULL, "TOTAL" INTEGER DEFAULT 0 NOT NULL, "K1" INT
C &+ EGER DEFAULT 0 NOT NULL, "K2" INTEGER DEFAULT 0 NOT NULL, "K3" INTEGER DEFAULT 0 NOT NULL, "K4" INTEGER DEFAULT 0
C &+ NOT NULL, "K5" INTEGER DEFAULT 0 NOT NULL) IN "<SID>#BTABD" INDEX IN "<SID>#BTABI" LONG IN "<SID>#BTABD"
C &+
C &+ ABAP location info 'SAPLSMVNTAB', 29
Read more...
Environment
IBM Db2 LUW DB6
Product
Keywords
IBM Db2 LUW DB6 ST-PI SPAM SAINT Update IMPORT_PROPER phase SQL0204N ADD-FIELD SQL0601N , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , 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.
SAP Knowledge Base Article - Preview