System Copy Import is giving error

[former_member430534]

We are getting error while importing database export through system copy SAPAPPL1.log shows the following error. Can any buddy guide us how we can resolve this issue.

/usr/sap/DEV/SYS/exe/run/R3load: START OF LOG: 20100714181009

/usr/sap/DEV/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/701_REL/src/R3ld/R3load/R3ldmain.c#5 $ SAP

/usr/sap/DEV/SYS/exe/run/R3load: version R7.01/V1.4 [UNICODE]

Compiled Feb 24 2009 21:39:36

/usr/sap/DEV/SYS/exe/run/R3load -ctf I /SAP_Installation_dump/dev_export/ABAP/DATA/SAPAPPL1.STR /tmp/sapinst_instdir/ERPEhP4/LM/COPY/ADA/SYSTEM/CENTRAL/AS-ABAP/DDLADA.TPL SAPAPPL1.TSK ADA -l SAPAPPL1.log

/usr/sap/DEV/SYS/exe/run/R3load: job completed

/usr/sap/DEV/SYS/exe/run/R3load: END OF LOG: 20100714181010

/usr/sap/DEV/SYS/exe/run/R3load: START OF LOG: 20100714181010

/usr/sap/DEV/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/701_REL/src/R3ld/R3load/R3ldmain.c#5 $ SAP

/usr/sap/DEV/SYS/exe/run/R3load: version R7.01/V1.4 [UNICODE]

Compiled Feb 24 2009 21:39:36

/usr/sap/DEV/SYS/exe/run/R3load -i SAPAPPL1.cmd -dbcodepage 4103 -l SAPAPPL1.log -nolog -c 50000

(DB) INFO: connected to DB

(DB) INFO: The MaxDB logwriter is switched off#20100714181010

(GSI) INFO: dbname = "DEV "

(GSI) INFO: vname = "ADABAS D "

(GSI) INFO: hostname = "sapdevqa "

(GSI) INFO: sysname = "Linux"

(GSI) INFO: nodename = "sapdevqa"

(GSI) INFO: release = "2.6.16.60-0.21-smp"

(GSI) INFO: version = "#1 SMP Tue May 6 12:41:02 UTC 2008"

(GSI) INFO: machine = "x86_64"

(DB) ERROR: DDL statement failed

(CREATE TABLE "/BDL/ADDONKEYS" ( "TASK_ID" VARCHAR2(10) UNICODE DEFAULT ' ' NOT NULL , "REQ_CONTRACT" VARCHAR2(8) UNICODE DEFAULT ' ' NOT NULL , "REQ_DESCR" VARCHAR2(8) UNICODE DEFAULT ' ' NOT NULL , "SEQNO" VARCHAR2(4) UNICODE DEFAULT '0000' NOT NULL , "ADDONKEY" VARCHAR2(128) UNICODE DEFAULT ' ' NOT NULL , "COLLECTED" VARCHAR2(1) UNICODE DEFAULT ' ' NOT NULL , "UNAME" VARCHAR2(12) UNICODE DEFAULT ' ' NOT NULL , "COLL_STAMP" VARCHAR2(14) UNICODE DEFAULT ' ' NOT NULL ) NO FIXED LENGTH COLUMN )

DbSlExecute: rc = 102

(SQL error -955)

error message returned by DbSl:

(DB) INFO: Savepoint on database executed#20100714181025

(DB) INFO: /BDL/ADDONKEYS~0 created#20100714181025

(IMP) INFO: import of /BDL/ADDONKEYS completed (0 rows) #20100714181025

(DB) ERROR: DDL statement failed

(CREATE TABLE "/BDL/BADHOST" ( "SESSNO" VARCHAR2(10) UNICODE DEFAULT ' ' NOT NULL , "CLIENT" VARCHAR2(3) UNICODE DEFAULT ' ' NOT NULL , "SOURCEDEST" VARCHAR2(32) UNICODE DEFAULT ' ' NOT NULL , "TARGETDEST" VARCHAR2(32) UNICODE DEFAULT ' ' NOT NULL , "TYPE" VARCHAR2(3) UNICODE DEFAULT ' ' NOT NULL , "HOST" VARCHAR2(20) UNICODE DEFAULT ' ' NOT NULL ) NO FIXED LENGTH COLUMN )

DbSlExecute: rc = 102

(SQL error -955)

error message returned by DbSl:

(DB) INFO: Savepoint on database executed#20100714181025

(DB) INFO: /BDL/BADHOST~0 created#20100714181025

(IMP) INFO: import of /BDL/BADHOST completed (0 rows) #20100714181025

(DB) ERROR: DDL statement failed

(CREATE TABLE "/BDL/BADHOSTS" ( "SESSIONNR" VARCHAR2(10) UNICODE DEFAULT ' ' NOT NULL , "MANDANT" VARCHAR2(3) UNICODE DEFAULT ' ' NOT NULL , "INSTALL_NO" VARCHAR2(10) UNICODE DEFAULT '0000000000' NOT NULL , "SID" VARCHAR2(8) UNICODE DEFAULT ' ' NOT NULL , "HOST" VARCHAR2(20) UNICODE DEFAULT ' ' NOT NULL , "SOURCEDEST" VARCHAR2(32) UNICODE DEFAULT ' ' NOT NULL , "TARGETDEST" VARCHAR2(32) UNICODE DEFAULT ' ' NOT NULL , "CREATED" VARCHAR2(14) UNICODE DEFAULT ' ' NOT NULL , "CHANGED" VARCHAR2(14) UNICODE DEFAULT ' ' NOT NULL ) NO FIXED LENGTH COLUMN )

DbSlExecute: rc = 102

(SQL error -955)

error message returned by DbSl:

(DB) INFO: Savepoint on database executed#20100714181025

(DB) INFO: /BDL/BADHOSTS~0 created#20100714181025

.

.

.

.

.

.

.

.

.

(DB) ERROR: DDL statement failed

(CREATE TABLE "CACS00_DOCSE" ( "MANDT" VARCHAR2(3) UNICODE DEFAULT '000' NOT NULL , "POST_YEAR" VARCHAR2(4) UNICODE DEFAULT '0000' NOT NULL , "DOC_ID" VARCHAR2(10) UNICODE DEFAULT ' ' NOT NULL , "SETTL_POS" VARCHAR2(4) UNICODE DEFAULT ' ' NOT NULL , "FLG_REVERSED" VARCHAR2(1) UNICODE DEFAULT ' ' NOT NULL , "STATUS_POS" VARCHAR2(1) UNICODE DEFAULT ' ' NOT NULL , "STATUS_WORK" VARCHAR2(1) UNICODE DEFAULT ' ' NOT NULL , "CTRTBU_ID" VARCHAR2(20) UNICODE DEFAULT ' ' NOT NULL , "GPART" VARCHAR2(10) UNICODE DEFAULT ' ' NOT NULL , "DUE_DATE" VARCHAR2(8) UNICODE DEFAULT '00000000' NOT NULL , "DUE_YEAR" VARCHAR2(4) UNICODE DEFAULT '0000' NOT NULL , "DUE_MONTH" VARCHAR2(2) UNICODE DEFAULT '00' NOT NULL , "STMTYPE_ID" VARCHAR2(4) UNICODE DEFAULT ' ' NOT NULL , "REMUNERATION" VARCHAR2(4) UNICODE DEFAULT ' ' NOT NULL , "SETTLE_GROUP" VARCHAR2(4) UNICODE DEFAULT ' ' NOT NULL , "FLG_INTSETTLE" VARCHAR2(1) UNICODE DEFAULT ' ' NOT NULL , "DET_GRP" VARCHAR2(4) UNICODE DEFAULT ' ' NOT NULL , "CON_CURR" VARCHAR2(5) UNICODE DEFAULT ' ' NOT NULL , "DUE_CONAMNT" NUMBER(15,2) DEFAULT 0 NOT NULL , "LED_CURR" VARCHAR2(5) UNICODE DEFAULT ' ' NOT NULL , "DUE_LEDAMNT" NUMBER(15,2) DEFAULT 0 NOT NULL , "REM_UNIT" VARCHAR2(3) UNICODE DEFAULT ' ' NOT NULL , "DUE_QUAN" NUMBER(11,2) DEFAULT 0 NOT NULL , "SETTLE_DATE" VARCHAR2(8) UNICODE DEFAULT '00000000' NOT NULL , "SETTLE_POST_YEAR" VARCHAR2(4) UNICODE DEFAULT '0000' NOT NULL , "SETTLE_DOC_ID" VARCHAR2(10) UNICODE DEFAULT ' ' NOT NULL , "PMNT_BLOCK" VARCHAR2(1) UNICODE DEFAULT ' ' NOT NULL , "REM_CASE_TXT" VARCHAR2(40) UNICODE DEFAULT ' ' NOT NULL , "REV_POS" VARCHAR2(4) UNICODE DEFAULT ' ' NOT NULL , "SETT_LOCK" VARCHAR2(1) UNICODE DEFAULT ' ' NOT NULL , "UPD_TIMESTAMP" VARCHAR2(14) UNICODE DEFAULT '00000000000000' NOT NULL ) NO FIXED LENGTH COLUMN )

DbSlExecute: rc = 102

(SQL error -955)

error message returned by DbSl:

(DB) INFO: Savepoint on database executed#20100714182632

(DB) INFO: CACS00_DOCSE~0 created#20100714182632

(IMP) INFO: import of CACS00_DOCSE completed (0 rows) #20100714182632

(DB) INFO: CACS00_DOCSE~CTR created later with other R3load process#20100714182632

(DB) INFO: CACS00_DOCSE~CTR created#20100714182632

(DB) INFO: CACS00_DOCSE~STM created later with other R3load process#20100714182632

(DB) INFO: CACS00_DOCSE~STM created#20100714182632

(DB) ERROR: DDL statement failed

(CREATE TABLE "CACS00_DOCSE01" ( "MANDT" VARCHAR2(3) UNICODE DEFAULT '000' NOT NULL , "POST_YEAR" VARCHAR2(4) UNICODE DEFAULT '0000' NOT NULL , "DOC_ID" VARCHAR2(10) UNICODE DEFAULT ' ' NOT NULL , "REMUN_POS" VARCHAR2(4) UNICODE DEFAULT ' ' NOT NULL , "CACSDUMMY" NUMBER(10,0) DEFAULT 0 NOT NULL ) NO FIXED LENGTH COLUMN )

DbSlExecute: rc = 102

(SQL error -955)

error message returned by DbSl:

(DB) INFO: Savepoint on database executed#20100714182632

(DB) INFO: CACS00_DOCSE01~0 created#20100714182632

(IMP) INFO: import of CACS00_DOCSE01 completed (0 rows) #20100714182632

[JPReyes]

SQL error -955

That error means that the table already exist...

Are you installing the system using sapinst?... Can you give more details?

Regards

Juan

[former_member430534]

I am importing database backup using SAPINST through "System Copy" procedure on already installed SAP server. I have selected SYSTEM COPY option instead of HOMOGENEOUS option.

[former_member430534]

We remove all the existing tables in the schema and then we run import which is successful.

Thank you for the support

[Former Member]

Looks like table /BDL/ADDONKEYS was already created, since the index can be created. Can you check in the database if table /BDL/ADDONKEYS exists?

Kind regards,

Mark