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] DB6 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.
SAP Knowledge Base Article - Preview