SAP Knowledge Base Article - Preview

3152216 - IBM Db2 LUW DB6 . . . ST-PI SPAM / SAINT Update IMPORT_PROPER phase . . . Error -204-SQL0204N when executing ADD-FIELD of is an undefined name

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

SAP NetWeaver 7.4

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.