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.