SAP Knowledge Base Article - Preview

2944145 - SAP system copy failed while creating the tables part of the packages on SAPDFACT - NetWeaver

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

SAP NetWeaver 2004 ; SAP NetWeaver 7.0 ; SAP NetWeaver 7.1 ; SAP NetWeaver 7.2 ; SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5 ; SAP enhancement package 1 for SAP NetWeaver 7.0 ; SAP enhancement package 1 for SAP NetWeaver 7.3 ; SAP enhancement package 2 for SAP NetWeaver 7.0 ; SAP enhancement package 3 for SAP NetWeaver 7.0

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.