SAP Knowledge Base Article - Preview

3616044 - SPAM + IBM Db2 LUW DB6 DB ... SQL204N syntax error in SAP ERP during SPAM update after system refresh from PROD to QA

Symptom

  • SPAM reporting SQL204N with CREATE TABLE DDL statements being sent into IBM Db2 LUW DB6 DB Server
        
  • SQL0204N error occurs with create of each of these tables               
            OCSSIM_ATTRIBUTE,    OCSSIM_TRSELHDR,     OCSSIM_TRSELITM,      OCS_API_VERSION,
            OCS_COMP_CACHE,     OCS_DELCONF_HDR,   OCS_DELCONF_OBJ,    OCS_SCV_IGNORE,
            PATDDQUOTA.                  PATSTATUS,                         SPMRC_CHECK_RUN,  SPMRC_DISABLECHK,
            SPMRC_RUN_RESULT
              
  • SAP ABAP log / trace dev_w##    single example of one of many tables
        ERROR in ExecuteDirect[/bas/753_REL/src/dbs/db6/dbdb6.c, 7435] CON = 0 CACHEID = -1 (BEGIN)
             dsql_db6_exec_immediate( SQLExecDirect ):
             [IBM][CLI Driver][DB2/AIX64]
             SQL0204N  "PP1#DDICD" is an undefined name. SQLSTATE=42704                                                                                                  
                                                                                                                         
                   CREATE TABLE "OCSSIM_ATTRIBUTE"
                             ("COMPONENT" VARCHAR(30) DEFAULT ' ' NOT NULL,
                              "CRELEASE" VARCHAR(10)     DEFAULT ' ' NOT NULL,
                              "X_ATTRIB" VARCHAR(20)      DEFAULT ' ' NOT NULL,
                               "VALUE" VARCHAR(60)          DEFAULT ' ' NOT NULL)
                   IN "PP1#DDICD" INDEX IN "PP1#DDICI" LONG IN "PP1#DDICD"                                                
                                                                                                                         
             ABAP location info 'SAPLSMVNTAB', 29                                                                              
        ERROR in ExecuteDirect[/bas/753_REL/src/dbs/db6/dbdb6.c, 7435] (END)
            
  • SAP SPAM client tool update resulted in a short dump with errors
        Category: ABAP Programming Error
        Runtime Errors: SYNTAX_ERROR
        ABAP Program: SAPLSPAM
        Application Component: BC-UPG-OCS
        Error analysis: Field "PAT106-PATCH" is unknown. It is neither in one of the specified tables nor defined by a "DATA" statement. "DATA" statement.


Read more...

Environment

  • SAP ERP
  • SAP SPAM client
  • SAP IBM DB2 Linux Unix Windows [LUW] Universal Database for Unix / NT

Product

SAP ERP all versions

Keywords

syntax error, SPAM update, system refresh, ABAP Programming Error, SYNTAX_ERROR, DB2, tablespace, TADB6, TSDB6, IADB6, DDSTORAGE, SAP ERP, ECC, short dump, inconsistencies, SAP DDIC, SYSCAT.TABLES , 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.