Symptom
• SAP system copy failed when splitting datafile.
• Import two packages failed while creating the tables part of the packages SAPDDIM and SAPDFACT.
• Following error message shows in SAPDFACR.log:
==========================
A1EEIMP 010 Task failed with error: (MSS) DDL statement failed
A1EEIMP 010 (CREATE TABLE "/BIC/F100002" ("KEY_100002P" NUMBER (000010) DEFAULT 0 NOT NULL, "KEY_100002T" NUMBER (000010) DEFAULT 0 NOT NULL, "KEY_1000021" NUMBER (000010) DEFAULT 0 NOT NULL, "KEY_1000022" NUMBER (000010) DEFAULT 0 NOT NULL, "KEY_1000023" NUMBER (000010) DEFAULT 0 NOT NULL, "KEY_1000024" NUMBER (000010) DEFAULT 0 NOT NULL, "KEY_1000025" NUMBER (000010) DEFAULT 0 NOT NULL, "KEY_1000026" NUMBER (000010) DEFAULT 0 NOT NULL, "FACTCOUNT" NUMBER (000010) DEFAULT 0 NOT NULL, "TCTDURTION" FLOAT DEFAULT 0 NOT NULL, "TCTENDDAT" VARCHAR2 (000008) DEFAULT '00000000' NOT NULL, "TCTENDTIM" VARCHAR2 (000006) DEFAULT '000000' NOT NULL, "TCTENDTST" NUMBER (000017, 000003) DEFAULT 0 NOT NULL, "TCTRECORDS" NUMBER (000017, 000003) DEFAULT 0 NOT NULL, "TCTSTAUIK" NUMBER (000017, 000003) DEFAULT 0 NOT NULL, "TCTSTIMEK" VARCHAR2 (000006) DEFAULT '000000' NOT NULL, "TCTSTRTDAT" VARCHAR2 (000008) DEFAULT '00000000' NOT NULL, "TCTSTRTTIM" VARCHAR2 (000006) DEFAULT '000000' NOT NULL, "TCTSTRTTST" NUMBER (000017, 000003) DEFAULT 0 NOT NULL ) CLUSTER ("KEY_100002T") PACKED FACT)
A1EEIMP 010 DbSlExecute: rc = 99
A1EEIMP 010 (MSS) SQL error = 102
A1EEIMP 010 (MSS) Incorrect syntax near 'CLUSTER'.
A2EETSK 012 Finished create for object "/BIC/F100002" of type "table" with error in 0.00 sec #20200620125647
==========================
Read more...
Environment
• SAP Systems based on SAP NetWeaver
• Microsoft SQL Server 2005 and higher
Product
Keywords
SAPDFACT,99,DFACT.SQL,102,CLUSTER,SMIGR_CREATE_DDL , KBA , BC-DB-MSS , SQL Server in SAP NetWeaver Products , 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.