ABAP ERROR WHILE SYSTEM MIGRATION

[Former Member]

Hi All,

We have started heterogenious sytem copy from windows (mssql_ to linux(maxdb).

In import abap phase at the 128th job it ended with an error Here i attach the log of IMPORT_MONITOR.LOG

ERROR : Execute for create index /BI0/F0RSTT_C01~P on /BI0/F0RSTT_C01 failed (dbrc=99).

(SQL error -7055)

error message returned by DbSl:

SQL-Statement: CREATE INDEX "/BI0/F0RSTT_C01~P" ON "/BI0/F0RSTT_C01" ( "KEY_0RSTT_C01P" , "KEY_0RSTT_C01T" , "KEY_0RSTT_C01U" , "KEY_0RSTT_C011" , "KEY_0RSTT_C012" , "KEY_0RSTT_C013" , "KEY_0RSTT_C014" , "KEY_0RSTT_C015" , "KEY_0RSTT_C016" , "KEY_0RSTT_C017" , "KEY_0RSTT_C018" , "KEY_0RSTT_C019" , "KEY_0RSTT_C01A" )

(DB) INFO: disconnected from DB

/usr/sap/DM1/SYS/exe/run/R3load: job finished with 1 error(s)

/usr/sap/DM1/SYS/exe/run/R3load: END OF LOG: 20110417003352

/usr/sap/DM1/SYS/exe/run/R3load: START OF LOG: 20110417004819

/usr/sap/DM1/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP

/usr/sap/DM1/SYS/exe/run/R3load: version R7.00/V1.4 UNICODE

Compiled Jan 23 2008 17:39:05

/usr/sap/DM1/SYS/exe/run/R3load -i SAPAPPL1_24.cmd -dbcodepage 4103 -k -l SAPAPPL1_24.log -nolog -c 10000

(DB) INFO: connected to DB

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

(GSI) INFO: dbname = "DM1 "

(GSI) INFO: vname = "ADABAS D "

(GSI) INFO: hostname = "sgmw-s-relse1 "

(GSI) INFO: sysname = "Linux"

(GSI) INFO: nodename = "sgmw-s-relse1"

(GSI) INFO: release = "2.6.32.12-0.7-xen"

(GSI) INFO: version = "#1 SMP 2010-05-20 11:14:20 +0200"

(GSI) INFO: machine = "x86_64"

(DB) ERROR: DDL statement failed

(DROP INDEX "PCL4~XPS" ON "PCL4")

DbSlExecute: rc = 103

(SQL error -4011)

error message returned by DbSl:

(IMP) INFO: a failed DROP attempt is not necessarily a problem

DbSl Trace: EXECUTE on connection 0, rc=-7055 (POS(59) Column(s) already indexed:/BI0/F0RSTT_C01~P)

ERROR : Execute for create index /BI0/F0RSTT_C01~P on /BI0/F0RSTT_C01 failed (dbrc=99).

(SQL error -7055)

error message returned by DbSl:

SQL-Statement: CREATE INDEX "/BI0/F0RSTT_C01~P" ON "/BI0/F0RSTT_C01" ( "KEY_0RSTT_C01P" , "KEY_0RSTT_C01T" , "KEY_0RSTT_C01U" , "KEY_0RSTT_C011" , "KEY_0RSTT_C012" , "KEY_0RSTT_C013" , "KEY_0RSTT_C014" , "KEY_0RSTT_C015" , "KEY_0RSTT_C016" , "KEY_0RSTT_C017" , "KEY_0RSTT_C018" , "KEY_0RSTT_C019" , "KEY_0RSTT_C01A" )

(DB) INFO: disconnected from DB

/usr/sap/DM1/SYS/exe/run/R3load: job finished with 1 error(s)

/usr/sap/DM1/SYS/exe/run/R3load: END OF LOG: 20110417004819

Import Monitor jobs: running 1, waiting 1, completed 128, failed 0, total 130.

Loading of 'SAPAPPL1_24' import package: ERROR

Import Monitor jobs: running 0, waiting 1, completed 128, failed 1, total 130.

could any one please help me in solving this issue

Thanks!

Vardhan.

[former_member709110 · Accepted solution]

Hi Vardhan,

Could plz check if Note 1155785 - SQL error 7055 in heterogeneous system copy is applicable in your case ?

If the note is not applicable then i would drop the table and associated objects and try to import again, just in case if its works.

Regards,

Neel

[Former Member · Accepted solution]

HI NEEL,

I gone through the note earlier.

the error can be avoided by removing the superfluous CREATE INDEX command from the table "/MAXDB/INDEXSTATEMENTS".

Can you please help me how to remove this superflous createindex command from that table.

could you please help me

Thanks!

Vardhan.

[Former Member · Accepted solution]

Hi neel

I tryed executing the command which is given in that note

but the table "/maxdb/indexstatements"

doesnot exists.

Thanks!

Vardhan.

Edited by: vardhan197 on Apr 18, 2011 10:59 AM

[Former Member]

Hi ALL

I found the below log file with err message when i was going through the note 455195

here i paste the log details

T PCL4 C err

T PCL4~0 C ok

T PCL4 I err

T PCL4~XGG C err

T PCL4~XPS I ok

[sivakumar_kilari3]

Hi,

Loading of 'SAPAPPL1_24' import package: ERROR

Can you paste this log file here SAPAPPL1_24.log

Thanks

Siva

[Former Member]

(GSI) INFO: hostname = "sgmw-s-relse1 "

(GSI) INFO: sysname = "Linux"

(GSI) INFO: nodename = "sgmw-s-relse1"

(GSI) INFO: release = "2.6.32.12-0.7-xen"

(GSI) INFO: version = "#1 SMP 2010-05-20 11:14:20 +0200"

(GSI) INFO: machine = "x86_64"

(TSK) ERROR: file /tmp/sapinst_instdir/ERP/LM/COPY/ADA/SYSTEM/CENTRAL/AS-ABAP/SAPAPPL1_24.TSK.bck already seems to exist

a previous run may not have been finished cleanly

file /tmp/sapinst_instdir/ERP/LM/COPY/ADA/SYSTEM/CENTRAL/AS-ABAP/SAPAPPL1_24.TSK possibly corrupted

/usr/sap/DM1/SYS/exe/run/R3load: job finished with 1 error(s)

/usr/sap/DM1/SYS/exe/run/R3load: END OF LOG: 20110419000843

/usr/sap/DM1/SYS/exe/run/R3load: START OF LOG: 20110419001137

/usr/sap/DM1/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP

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

Compiled Jan 23 2008 17:39:05

/usr/sap/DM1/SYS/exe/run/R3load -i SAPAPPL1_24.cmd -dbcodepage 4103 -k 1G5fdEM50DmIrBzjt6TE5Pae -l SAPAPPL1_24.log -nolog -c 10000

(DB) INFO: connected to DB

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

(GSI) INFO: dbname = "DM1 "

(GSI) INFO: vname = "ADABAS D "

(GSI) INFO: hostname = "sgmw-s-relse1 "

(GSI) INFO: sysname = "Linux"

(GSI) INFO: nodename = "sgmw-s-relse1"

(GSI) INFO: release = "2.6.32.12-0.7-xen"

(GSI) INFO: version = "#1 SMP 2010-05-20 11:14:20 +0200"

(GSI) INFO: machine = "x86_64"

DbSl Trace: EXECUTE on connection 0, rc=-7055 (POS(59) Column(s) already indexed:/BI0/F0RSTT_C01~P)

ERROR : Execute for create index /BI0/F0RSTT_C01~P on /BI0/F0RSTT_C01 failed (dbrc=99).

(SQL error -7055)

error message returned by DbSl:

SQL-Statement: CREATE INDEX "/BI0/F0RSTT_C01~P" ON "/BI0/F0RSTT_C01" ( "KEY_0RSTT_C01P" , "KEY_0RSTT_C01T" , "KEY_0RSTT_C01U" , "KEY_0RSTT_C011" , "KEY_0RSTT_C012" , "KEY_0RSTT_C013" , "KEY_0RSTT_C014" , "KEY_0RSTT_C015" , "KEY_0RSTT_C016" , "KEY_0RSTT_C017" , "KEY_0RSTT_C018" , "KEY_0RSTT_C019" , "KEY_0RSTT_C01A" )

/usr/sap/DM1/SYS/exe/run/R3load: job finished with 1 error(s)

/usr/sap/DM1/SYS/exe/run/R3load: END OF LOG: 20110419001138

/usr/sap/DM1/SYS/exe/run/R3load: START OF LOG: 20110419013326

/usr/sap/DM1/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP

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

Compiled Jan 23 2008 17:39:05

/usr/sap/DM1/SYS/exe/run/R3load -i SAPAPPL1_24.cmd -dbcodepage 4103 -k 1G5fdEM50DmIrBzjt6TE5Pae -l SAPAPPL1_24.log -nolog -c 10000

(DB) INFO: connected to DB

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

(GSI) INFO: dbname = "DM1 "

(GSI) INFO: vname = "ADABAS D "

(GSI) INFO: hostname = "sgmw-s-relse1 "

(GSI) INFO: sysname = "Linux"

(GSI) INFO: nodename = "sgmw-s-relse1"

(GSI) INFO: release = "2.6.32.12-0.7-xen"

(GSI) INFO: version = "#1 SMP 2010-05-20 11:14:20 +0200"

(GSI) INFO: machine = "x86_64"

DbSl Trace: EXECUTE on connection 0, rc=-7055 (POS(59) Column(s) already indexed:/BI0/F0RSTT_C01~P)

ERROR : Execute for create index /BI0/F0RSTT_C01~P on /BI0/F0RSTT_C01 failed (dbrc=99).

(SQL error -7055)

error message returned by DbSl:

SQL-Statement: CREATE INDEX "/BI0/F0RSTT_C01~P" ON "/BI0/F0RSTT_C01" ( "KEY_0RSTT_C01P" , "KEY_0RSTT_C01T" , "KEY_0RSTT_C01U" , "KEY_0RSTT_C011" , "KEY_0RSTT_C012" , "KEY_0RSTT_C013" , "KEY_0RSTT_C014" , "KEY_0RSTT_C015" , "KEY_0RSTT_C016" , "KEY_0RSTT_C017" , "KEY_0RSTT_C018" , "KEY_0RSTT_C019" , "KEY_0RSTT_C01A" )

/usr/sap/DM1/SYS/exe/run/R3load: job finished with 1 error(s)

/usr/sap/DM1/SYS/exe/run/R3load: END OF LOG: 20110419013327

/usr/sap/DM1/SYS/exe/run/R3load: START OF LOG: 20110419014028

/usr/sap/DM1/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP

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

Compiled Jan 23 2008 17:39:05

/usr/sap/DM1/SYS/exe/run/R3load -ctf I /export_disk/DM1_EXPORT/ABAP/DATA/SAPAPPL1_24.STR /tmp/sapinst_instdir/ERP/LM/COPY/ADA/SYSTEM/CENTRAL/AS-ABAP/DDLADA.TPL SAPAPPL1_24.TSK ADA -l SAPAPPL1_24.log

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

/usr/sap/DM1/SYS/exe/run/R3load: END OF LOG: 20110419014028

/usr/sap/DM1/SYS/exe/run/R3load: START OF LOG: 20110419014028

/usr/sap/DM1/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP

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

Compiled Jan 23 2008 17:39:05

/usr/sap/DM1/SYS/exe/run/R3load -i SAPAPPL1_24.cmd -dbcodepage 4103 -k 1G5fdEM50DmIrBzjt6TE5Pae -l SAPAPPL1_24.log -nolog -c 10000

(DB) INFO: connected to DB

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

(GSI) INFO: dbname = "DM1 "

(GSI) INFO: vname = "ADABAS D "

(GSI) INFO: hostname = "sgmw-s-relse1 "

(GSI) INFO: sysname = "Linux"

(GSI) INFO: nodename = "sgmw-s-relse1"

(GSI) INFO: release = "2.6.32.12-0.7-xen"

(GSI) INFO: version = "#1 SMP 2010-05-20 11:14:20 +0200"

(GSI) INFO: machine = "x86_64"

(TSK) ERROR: file /tmp/sapinst_instdir/ERP/LM/COPY/ADA/SYSTEM/CENTRAL/AS-ABAP/SAPAPPL1_24.TSK.bck already seems to exist

a previous run may not have been finished cleanly

file /tmp/sapinst_instdir/ERP/LM/COPY/ADA/SYSTEM/CENTRAL/AS-ABAP/SAPAPPL1_24.TSK possibly corrupted

/usr/sap/DM1/SYS/exe/run/R3load: job finished with 1 error(s)

/usr/sap/DM1/SYS/exe/run/R3load: END OF LOG: 20110419014028

/usr/sap/DM1/SYS/exe/run/R3load: START OF LOG: 20110419014105

/usr/sap/DM1/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP

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

Compiled Jan 23 2008 17:39:05

/usr/sap/DM1/SYS/exe/run/R3load -i SAPAPPL1_24.cmd -dbcodepage 4103 -k 1G5fdEM50DmIrBzjt6TE5Pae -l SAPAPPL1_24.log -nolog -c 10000

(DB) INFO: connected to DB

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

(GSI) INFO: dbname = "DM1 "

(GSI) INFO: vname = "ADABAS D "

(GSI) INFO: hostname = "sgmw-s-relse1 "

(GSI) INFO: sysname = "Linux"

(GSI) INFO: nodename = "sgmw-s-relse1"

(GSI) INFO: release = "2.6.32.12-0.7-xen"

(GSI) INFO: version = "#1 SMP 2010-05-20 11:14:20 +0200"

(GSI) INFO: machine = "x86_64"

(DB) ERROR: DDL statement failed

(CREATE TABLE "PCL4" ( "CLIENT" VARCHAR2(3) UNICODE DEFAULT '000' NOT NULL , "RELID" VARCHAR2(2) UNICODE DEFAULT ' ' NOT NULL , "SRTFD" VARCHAR2(40) UNICODE DEFAULT ' ' NOT NULL , "SRTF2" NUMBER(10) DEFAULT 0 NOT NULL , "HISTO" VARCHAR2(1) UNICODE DEFAULT ' ' NOT NULL , "AEDTM" VARCHAR2(8) UNICODE DEFAULT '00000000' NOT NULL , "UNAME" VARCHAR2(12) UNICODE DEFAULT ' ' NOT NULL , "PGMID" VARCHAR2(8) UNICODE DEFAULT ' ' NOT NULL , "VERSN" VARCHAR2(2) UNICODE DEFAULT ' ' NOT NULL , "CLUSTR" NUMBER(5) DEFAULT 0 NOT NULL , "CLUSTD" LONG RAW ) NO FIXED LENGTH COLUMN )

DbSlExecute: rc = 102

(SQL error -955)

error message returned by DbSl:

(DB) INFO: Savepoint on database executed#20110419014247

(DB) INFO: PCL4~0 created#20110419014247

(IMP) ERROR: DbSlExeModify/DbSlLobPutPiece failed

rc = 26, table "PCL4"

DbSl Trace: EXECUTE on connection 0, rc=-7055 (POS(59) Column(s) already indexed:/BI0/F0RSTT_C01~P)

ERROR : Execute for create index /BI0/F0RSTT_C01~P on /BI0/F0RSTT_C01 failed (dbrc=99).

(SQL error -7055)

error message returned by DbSl:

SQL-Statement: CREATE INDEX "/BI0/F0RSTT_C01~P" ON "/BI0/F0RSTT_C01" ( "KEY_0RSTT_C01P" , "KEY_0RSTT_C01T" , "KEY_0RSTT_C01U" , "KEY_0RSTT_C011" , "KEY_0RSTT_C012" , "KEY_0RSTT_C013" , "KEY_0RSTT_C014" , "KEY_0RSTT_C015" , "KEY_0RSTT_C016" , "KEY_0RSTT_C017" , "KEY_0RSTT_C018" , "KEY_0RSTT_C019" , "KEY_0RSTT_C01A" )

(DB) INFO: PCL4~XPS created later with other R3load process#20110419014247

(DB) INFO: PCL4~XPS created#20110419014247

(DB) INFO: disconnected from DB

/usr/sap/DM1/SYS/exe/run/R3load: job finished with 3 error(s)

/usr/sap/DM1/SYS/exe/run/R3load: END OF LOG: 20110419014247

/usr/sap/DM1/SYS/exe/run/R3load: START OF LOG: 20110419015957

/usr/sap/DM1/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP

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

Compiled Jan 23 2008 17:39:05

/usr/sap/DM1/SYS/exe/run/R3load -i SAPAPPL1_24.cmd -dbcodepage 4103 -k 1G5fdEM50DmIrBzjt6TE5Pae -l SAPAPPL1_24.log -nolog -c 10000

(DB) INFO: connected to DB

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

(GSI) INFO: dbname = "DM1 "

(GSI) INFO: vname = "ADABAS D "

(GSI) INFO: hostname = "sgmw-s-relse1 "

(GSI) INFO: sysname = "Linux"

(GSI) INFO: nodename = "sgmw-s-relse1"

(GSI) INFO: release = "2.6.32.12-0.7-xen"

(GSI) INFO: version = "#1 SMP 2010-05-20 11:14:20 +0200"

(GSI) INFO: machine = "x86_64"

(DB) INFO: Savepoint on database executed#20110419015958

(DB) INFO: PCL4 dropped#20110419015958

(DB) INFO: Savepoint on database executed#20110419015959

(DB) INFO: PCL4 created#20110419015959

(DB) INFO: Savepoint on database executed#20110419015959

(DB) INFO: PCL4 deleted/truncated#20110419015959

(DB) INFO: Savepoint on database executed#20110419022435

(IMP) INFO: import of PCL4 completed (662723 rows) #20110419022435

(DB) ERROR: DDL statement failed

(DROP INDEX "PCL4~XGG" ON "PCL4")

DbSlExecute: rc = 103

(SQL error -4011)

error message returned by DbSl:

(IMP) INFO: a failed DROP attempt is not necessarily a problem

DbSl Trace: EXECUTE on connection 0, rc=-7055 (POS(59) Column(s) already indexed:/BI0/F0RSTT_C01~P)

ERROR : Execute for create index /BI0/F0RSTT_C01~P on /BI0/F0RSTT_C01 failed (dbrc=99).

(SQL error -7055)

error message returned by DbSl:

SQL-Statement: CREATE INDEX "/BI0/F0RSTT_C01~P" ON "/BI0/F0RSTT_C01" ( "KEY_0RSTT_C01P" , "KEY_0RSTT_C01T" , "KEY_0RSTT_C01U" , "KEY_0RSTT_C011" , "KEY_0RSTT_C012" , "KEY_0RSTT_C013" , "KEY_0RSTT_C014" , "KEY_0RSTT_C015" , "KEY_0RSTT_C016" , "KEY_0RSTT_C017" , "KEY_0RSTT_C018" , "KEY_0RSTT_C019" , "KEY_0RSTT_C01A" )

(DB) INFO: disconnected from DB

/usr/sap/DM1/SYS/exe/run/R3load: job finished with 1 error(s)

/usr/sap/DM1/SYS/exe/run/R3load: END OF LOG: 20110419022512

/usr/sap/DM1/SYS/exe/run/R3load: START OF LOG: 20110419023447

/usr/sap/DM1/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP

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

Compiled Jan 23 2008 17:39:05

/usr/sap/DM1/SYS/exe/run/R3load -i SAPAPPL1_24.cmd -dbcodepage 4103 -k 1G5fdEM50DmIrBzjt6TE5Pae -l SAPAPPL1_24.log -nolog -c 10000

(DB) INFO: connected to DB

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

(GSI) INFO: dbname = "DM1 "

(GSI) INFO: vname = "ADABAS D "

(GSI) INFO: hostname = "sgmw-s-relse1 "

(GSI) INFO: sysname = "Linux"

(GSI) INFO: nodename = "sgmw-s-relse1"

(GSI) INFO: release = "2.6.32.12-0.7-xen"

(GSI) INFO: version = "#1 SMP 2010-05-20 11:14:20 +0200"

(GSI) INFO: machine = "x86_64"

(DB) ERROR: DDL statement failed

(DROP INDEX "PCL4~XGG" ON "PCL4")

DbSlExecute: rc = 103

(SQL error -4011)

error message returned by DbSl:

(IMP) INFO: a failed DROP attempt is not necessarily a problem

DbSl Trace: EXECUTE on connection 0, rc=-7055 (POS(59) Column(s) already indexed:/BI0/F0RSTT_C01~P)

ERROR : Execute for create index /BI0/F0RSTT_C01~P on /BI0/F0RSTT_C01 failed (dbrc=99).

(SQL error -7055)

error message returned by DbSl:

SQL-Statement: CREATE INDEX "/BI0/F0RSTT_C01~P" ON "/BI0/F0RSTT_C01" ( "KEY_0RSTT_C01P" , "KEY_0RSTT_C01T" , "KEY_0RSTT_C01U" , "KEY_0RSTT_C011" , "KEY_0RSTT_C012" , "KEY_0RSTT_C013" , "KEY_0RSTT_C014" , "KEY_0RSTT_C015" , "KEY_0RSTT_C016" , "KEY_0RSTT_C017" , "KEY_0RSTT_C018" , "KEY_0RSTT_C019" , "KEY_0RSTT_C01A" )

(DB) INFO: disconnected from DB

/usr/sap/DM1/SYS/exe/run/R3load: job finished with 1 error(s)

/usr/sap/DM1/SYS/exe/run/R3load: END OF LOG: 20110419023447

sgmw-s-relse1:/tmp/sapinst_instdir/ERP/LM/COPY/ADA/SYSTEM/CENTRAL/AS-ABAP #

[Former Member]

Hi Siva

Thanks fro the reply

sorry for the above paste

here is the log details of SAPAPPL1_24.log

(GSI) INFO: hostname = "sgmw-s-relse1 "

(GSI) INFO: sysname = "Linux"

(GSI) INFO: nodename = "sgmw-s-relse1"

(GSI) INFO: release = "2.6.32.12-0.7-xen"

(GSI) INFO: version = "#1 SMP 2010-05-20 11:14:20 +0200"

(GSI) INFO: machine = "x86_64"

(TSK) ERROR: file /tmp/sapinst_instdir/ERP/LM/COPY/ADA/SYSTEM/CENTRAL/AS-ABAP/SAPAPPL1_24.TSK.bck already seems to exist

a previous run may not have been finished cleanly

file /tmp/sapinst_instdir/ERP/LM/COPY/ADA/SYSTEM/CENTRAL/AS-ABAP/SAPAPPL1_24.TSK possibly corrupted

/usr/sap/DM1/SYS/exe/run/R3load: job finished with 1 error(s)

/usr/sap/DM1/SYS/exe/run/R3load: END OF LOG: 20110419000843

/usr/sap/DM1/SYS/exe/run/R3load: START OF LOG: 20110419001137

/usr/sap/DM1/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP

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

Compiled Jan 23 2008 17:39:05

/usr/sap/DM1/SYS/exe/run/R3load -i SAPAPPL1_24.cmd -dbcodepage 4103 -k 1G5fdEM50DmIrBzjt6TE5Pae -l SAPAPPL1_24.log -nolog -c 10000

(DB) INFO: connected to DB

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

(GSI) INFO: dbname = "DM1 "

(GSI) INFO: vname = "ADABAS D "

(GSI) INFO: hostname = "sgmw-s-relse1 "

(GSI) INFO: sysname = "Linux"

(GSI) INFO: nodename = "sgmw-s-relse1"

(GSI) INFO: release = "2.6.32.12-0.7-xen"

(GSI) INFO: version = "#1 SMP 2010-05-20 11:14:20 +0200"

(GSI) INFO: machine = "x86_64"

DbSl Trace: EXECUTE on connection 0, rc=-7055 (POS(59) Column(s) already indexed:/BI0/F0RSTT_C01~P)

ERROR : Execute for create index /BI0/F0RSTT_C01~P on /BI0/F0RSTT_C01 failed (dbrc=99).

(SQL error -7055)

error message returned by DbSl:

SQL-Statement: CREATE INDEX "/BI0/F0RSTT_C01~P" ON "/BI0/F0RSTT_C01" ( "KEY_0RSTT_C01P" , "KEY_0RSTT_C01T" , "KEY_0RSTT_C01U" , "KEY_0RSTT_C011" , "KEY_0RSTT_C012" , "KEY_0RSTT_C013" , "KEY_0RSTT_C014" , "KEY_0RSTT_C015" , "KEY_0RSTT_C016" , "KEY_0RSTT_C017" , "KEY_0RSTT_C018" , "KEY_0RSTT_C019" , "KEY_0RSTT_C01A" )

/usr/sap/DM1/SYS/exe/run/R3load: job finished with 1 error(s)

/usr/sap/DM1/SYS/exe/run/R3load: END OF LOG: 20110419001138

/usr/sap/DM1/SYS/exe/run/R3load: START OF LOG: 20110419013326

/usr/sap/DM1/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP

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

Compiled Jan 23 2008 17:39:05

/usr/sap/DM1/SYS/exe/run/R3load -i SAPAPPL1_24.cmd -dbcodepage 4103 -k 1G5fdEM50DmIrBzjt6TE5Pae -l SAPAPPL1_24.log -nolog -c 10000

(DB) INFO: connected to DB

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

(GSI) INFO: dbname = "DM1 "

(GSI) INFO: vname = "ADABAS D "

(GSI) INFO: hostname = "sgmw-s-relse1 "

(GSI) INFO: sysname = "Linux"

(GSI) INFO: nodename = "sgmw-s-relse1"

(GSI) INFO: release = "2.6.32.12-0.7-xen"

(GSI) INFO: version = "#1 SMP 2010-05-20 11:14:20 +0200"

(GSI) INFO: machine = "x86_64"

DbSl Trace: EXECUTE on connection 0, rc=-7055 (POS(59) Column(s) already indexed:/BI0/F0RSTT_C01~P)

ERROR : Execute for create index /BI0/F0RSTT_C01~P on /BI0/F0RSTT_C01 failed (dbrc=99).

(SQL error -7055)

error message returned by DbSl:

SQL-Statement: CREATE INDEX "/BI0/F0RSTT_C01~P" ON "/BI0/F0RSTT_C01" ( "KEY_0RSTT_C01P" , "KEY_0RSTT_C01T" , "KEY_0RSTT_C01U" , "KEY_0RSTT_C011" , "KEY_0RSTT_C012" , "KEY_0RSTT_C013" , "KEY_0RSTT_C014" , "KEY_0RSTT_C015" , "KEY_0RSTT_C016" , "KEY_0RSTT_C017" , "KEY_0RSTT_C018" , "KEY_0RSTT_C019" , "KEY_0RSTT_C01A" )

/usr/sap/DM1/SYS/exe/run/R3load: job finished with 1 error(s)

/usr/sap/DM1/SYS/exe/run/R3load: END OF LOG: 20110419013327

/usr/sap/DM1/SYS/exe/run/R3load: START OF LOG: 20110419014028

/usr/sap/DM1/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP

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

Compiled Jan 23 2008 17:39:05

/usr/sap/DM1/SYS/exe/run/R3load -ctf I /export_disk/DM1_EXPORT/ABAP/DATA/SAPAPPL1_24.STR /tmp/sapinst_instdir/ERP/LM/COPY/ADA/SYSTEM/CENTRAL/AS-ABAP/DDLADA.TPL SAPAPPL1_24.TSK ADA -l SAPAPPL1_24.log

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

/usr/sap/DM1/SYS/exe/run/R3load: END OF LOG: 20110419014028

/usr/sap/DM1/SYS/exe/run/R3load: START OF LOG: 20110419014028

/usr/sap/DM1/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP

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

Compiled Jan 23 2008 17:39:05

/usr/sap/DM1/SYS/exe/run/R3load -i SAPAPPL1_24.cmd -dbcodepage 4103 -k 1G5fdEM50DmIrBzjt6TE5Pae -l SAPAPPL1_24.log -nolog -c 10000

(DB) INFO: connected to DB

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

(GSI) INFO: dbname = "DM1 "

(GSI) INFO: vname = "ADABAS D "

(GSI) INFO: hostname = "sgmw-s-relse1 "

(GSI) INFO: sysname = "Linux"

(GSI) INFO: nodename = "sgmw-s-relse1"

(GSI) INFO: release = "2.6.32.12-0.7-xen"

(GSI) INFO: version = "#1 SMP 2010-05-20 11:14:20 +0200"

(GSI) INFO: machine = "x86_64"

(TSK) ERROR: file /tmp/sapinst_instdir/ERP/LM/COPY/ADA/SYSTEM/CENTRAL/AS-ABAP/SAPAPPL1_24.TSK.bck already seems to exist

a previous run may not have been finished cleanly

file /tmp/sapinst_instdir/ERP/LM/COPY/ADA/SYSTEM/CENTRAL/AS-ABAP/SAPAPPL1_24.TSK possibly corrupted

/usr/sap/DM1/SYS/exe/run/R3load: job finished with 1 error(s)

/usr/sap/DM1/SYS/exe/run/R3load: END OF LOG: 20110419014028

/usr/sap/DM1/SYS/exe/run/R3load: START OF LOG: 20110419014105

/usr/sap/DM1/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP

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

Compiled Jan 23 2008 17:39:05

/usr/sap/DM1/SYS/exe/run/R3load -i SAPAPPL1_24.cmd -dbcodepage 4103 -k 1G5fdEM50DmIrBzjt6TE5Pae -l SAPAPPL1_24.log -nolog -c 10000

(DB) INFO: connected to DB

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

(GSI) INFO: dbname = "DM1 "

(GSI) INFO: vname = "ADABAS D "

(GSI) INFO: hostname = "sgmw-s-relse1 "

(GSI) INFO: sysname = "Linux"

(GSI) INFO: nodename = "sgmw-s-relse1"

(GSI) INFO: release = "2.6.32.12-0.7-xen"

(GSI) INFO: version = "#1 SMP 2010-05-20 11:14:20 +0200"

(GSI) INFO: machine = "x86_64"

(DB) ERROR: DDL statement failed

(CREATE TABLE "PCL4" ( "CLIENT" VARCHAR2(3) UNICODE DEFAULT '000' NOT NULL , "RELID" VARCHAR2(2) UNICODE DEFAULT ' ' NOT NULL , "SRTFD" VARCHAR2(40) UNICODE DEFAULT ' ' NOT NULL , "SRTF2" NUMBER(10) DEFAULT 0 NOT NULL , "HISTO" VARCHAR2(1) UNICODE DEFAULT ' ' NOT NULL , "AEDTM" VARCHAR2(8) UNICODE DEFAULT '00000000' NOT NULL , "UNAME" VARCHAR2(12) UNICODE DEFAULT ' ' NOT NULL , "PGMID" VARCHAR2(8) UNICODE DEFAULT ' ' NOT NULL , "VERSN" VARCHAR2(2) UNICODE DEFAULT ' ' NOT NULL , "CLUSTR" NUMBER(5) DEFAULT 0 NOT NULL , "CLUSTD" LONG RAW ) NO FIXED LENGTH COLUMN )

DbSlExecute: rc = 102

(SQL error -955)

error message returned by DbSl:

(DB) INFO: Savepoint on database executed#20110419014247

(DB) INFO: PCL4~0 created#20110419014247

(IMP) ERROR: DbSlExeModify/DbSlLobPutPiece failed

rc = 26, table "PCL4"

DbSl Trace: EXECUTE on connection 0, rc=-7055 (POS(59) Column(s) already indexed:/BI0/F0RSTT_C01~P)

ERROR : Execute for create index /BI0/F0RSTT_C01~P on /BI0/F0RSTT_C01 failed (dbrc=99).

(SQL error -7055)

error message returned by DbSl:

SQL-Statement: CREATE INDEX "/BI0/F0RSTT_C01~P" ON "/BI0/F0RSTT_C01" ( "KEY_0RSTT_C01P" , "KEY_0RSTT_C01T" , "KEY_0RSTT_C01U" , "KEY_0RSTT_C011" , "KEY_0RSTT_C012" , "KEY_0RSTT_C013" , "KEY_0RSTT_C014" , "KEY_0RSTT_C015" , "KEY_0RSTT_C016" , "KEY_0RSTT_C017" , "KEY_0RSTT_C018" , "KEY_0RSTT_C019" , "KEY_0RSTT_C01A" )

(DB) INFO: PCL4~XPS created later with other R3load process#20110419014247

(DB) INFO: PCL4~XPS created#20110419014247

(DB) INFO: disconnected from DB

/usr/sap/DM1/SYS/exe/run/R3load: job finished with 3 error(s)

/usr/sap/DM1/SYS/exe/run/R3load: END OF LOG: 20110419014247

/usr/sap/DM1/SYS/exe/run/R3load: START OF LOG: 20110419015957

/usr/sap/DM1/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP

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

Compiled Jan 23 2008 17:39:05

/usr/sap/DM1/SYS/exe/run/R3load -i SAPAPPL1_24.cmd -dbcodepage 4103 -k 1G5fdEM50DmIrBzjt6TE5Pae -l SAPAPPL1_24.log -nolog -c 10000

(DB) INFO: connected to DB

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

(GSI) INFO: dbname = "DM1 "

(GSI) INFO: vname = "ADABAS D "

(GSI) INFO: hostname = "sgmw-s-relse1 "

(GSI) INFO: sysname = "Linux"

(GSI) INFO: nodename = "sgmw-s-relse1"

(GSI) INFO: release = "2.6.32.12-0.7-xen"

(GSI) INFO: version = "#1 SMP 2010-05-20 11:14:20 +0200"

(GSI) INFO: machine = "x86_64"

(DB) INFO: Savepoint on database executed#20110419015958

(DB) INFO: PCL4 dropped#20110419015958

(DB) INFO: Savepoint on database executed#20110419015959

(DB) INFO: PCL4 created#20110419015959

(DB) INFO: Savepoint on database executed#20110419015959

(DB) INFO: PCL4 deleted/truncated#20110419015959

(DB) INFO: Savepoint on database executed#20110419022435

(IMP) INFO: import of PCL4 completed (662723 rows) #20110419022435

(DB) ERROR: DDL statement failed

(DROP INDEX "PCL4~XGG" ON "PCL4")

DbSlExecute: rc = 103

(SQL error -4011)

error message returned by DbSl:

(IMP) INFO: a failed DROP attempt is not necessarily a problem

DbSl Trace: EXECUTE on connection 0, rc=-7055 (POS(59) Column(s) already indexed:/BI0/F0RSTT_C01~P)

ERROR : Execute for create index /BI0/F0RSTT_C01~P on /BI0/F0RSTT_C01 failed (dbrc=99).

(SQL error -7055)

error message returned by DbSl:

SQL-Statement: CREATE INDEX "/BI0/F0RSTT_C01~P" ON "/BI0/F0RSTT_C01" ( "KEY_0RSTT_C01P" , "KEY_0RSTT_C01T" , "KEY_0RSTT_C01U" , "KEY_0RSTT_C011" , "KEY_0RSTT_C012" , "KEY_0RSTT_C013" , "KEY_0RSTT_C014" , "KEY_0RSTT_C015" , "KEY_0RSTT_C016" , "KEY_0RSTT_C017" , "KEY_0RSTT_C018" , "KEY_0RSTT_C019" , "KEY_0RSTT_C01A" )

(DB) INFO: disconnected from DB

/usr/sap/DM1/SYS/exe/run/R3load: job finished with 1 error(s)

/usr/sap/DM1/SYS/exe/run/R3load: END OF LOG: 20110419022512

/usr/sap/DM1/SYS/exe/run/R3load: START OF LOG: 20110419023447

/usr/sap/DM1/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP

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

Compiled Jan 23 2008 17:39:05

/usr/sap/DM1/SYS/exe/run/R3load -i SAPAPPL1_24.cmd -dbcodepage 4103 -k 1G5fdEM50DmIrBzjt6TE5Pae -l SAPAPPL1_24.log -nolog -c 10000

(DB) INFO: connected to DB

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

(GSI) INFO: dbname = "DM1 "

(GSI) INFO: vname = "ADABAS D "

(GSI) INFO: hostname = "sgmw-s-relse1 "

(GSI) INFO: sysname = "Linux"

(GSI) INFO: nodename = "sgmw-s-relse1"

(GSI) INFO: release = "2.6.32.12-0.7-xen"

(GSI) INFO: version = "#1 SMP 2010-05-20 11:14:20 +0200"

(GSI) INFO: machine = "x86_64"

(DB) ERROR: DDL statement failed

(DROP INDEX "PCL4~XGG" ON "PCL4")

DbSlExecute: rc = 103

(SQL error -4011)

error message returned by DbSl:

(IMP) INFO: a failed DROP attempt is not necessarily a problem

DbSl Trace: EXECUTE on connection 0, rc=-7055 (POS(59) Column(s) already indexed:/BI0/F0RSTT_C01~P)

ERROR : Execute for create index /BI0/F0RSTT_C01~P on /BI0/F0RSTT_C01 failed (dbrc=99).

(SQL error -7055)

error message returned by DbSl:

SQL-Statement: CREATE INDEX "/BI0/F0RSTT_C01~P" ON "/BI0/F0RSTT_C01" ( "KEY_0RSTT_C01P" , "KEY_0RSTT_C01T" , "KEY_0RSTT_C01U" , "KEY_0RSTT_C011" , "KEY_0RSTT_C012" , "KEY_0RSTT_C013" , "KEY_0RSTT_C014" , "KEY_0RSTT_C015" , "KEY_0RSTT_C016" , "KEY_0RSTT_C017" , "KEY_0RSTT_C018" , "KEY_0RSTT_C019" , "KEY_0RSTT_C01A" )

(DB) INFO: disconnected from DB

/usr/sap/DM1/SYS/exe/run/R3load: job finished with 1 error(s)

/usr/sap/DM1/SYS/exe/run/R3load: END OF LOG: 20110419023447

sgmw-s-relse1:/tmp/sapinst_instdir/ERP/LM/COPY/ADA/SYSTEM/CENTRAL/AS-ABAP #

[markus_doehr2]

> Compiled Jan 23 2008 17:39:05

>

> /usr/sap/DM1/SYS/exe/run/R3load -i SAPAPPL1_24.cmd -dbcodepage 4103 -k 1G5fdEM50DmIrBzjt6TE5Pae -l SAPAPPL1_24.log -nolog -c 10000

Your tools are ancient.

I would:

- stop the whole migration and delete the installed database instance so the system is "clean" again

- restore the source system

- update the system copy tools on the source system (R3ldctl, R3load, R3szchk, lib_dbsl)

- use a recent installation master DVD (!!!)

- read the system copy gudes

- start the export again with the new DVD

- execute SMIGR_CREATE_DDL

- make sure the resulting SQL files are in <export-directory>\ABAP\DB\ADA

- when the system stops and requests to start the migration monitor update the kernel and the system copy tools to the latest versions (R3load, lib_dbsl)

- use "-loadprocedure fast -merge_bck -force_repeat" as load options for R3load

- start the import using migmon

There is no easy way to "fix" the error you already ran into because you missed basic steps that have to be done when doing a heterogeneous copy. That's why SAP recommends to have a certified migration consultant if you do such migrations (see http://service.sap.com/osdbmigration)

Markus

[sivakumar_kilari3]

ERROR: file /tmp/sapinst_instdir/ERP/LM/COPY/ADA/SYSTEM/CENTRAL/AS-ABAP/SAPAPPL1_24.TSK.bck already seems to exist a previous run may not have been finished cleanly file /tmp/sapinst_instdir/ERP/LM/COPY/ADA/SYSTEM/CENTRAL/AS-ABAP/SAPAPPL1_24.TSK possibly corrupted

Delete this SAPAPPL1_24.TSK file and try .

Thanks

Siva

[Former Member]

Hi Siva,

I have deleted the file and retry the installation but had stopped in the same phase.

And my R3load version is R7.00/ V1.4 [UNICODE]

Thanks

Vardhan.

[markus_doehr2]

> I have deleted the file and retry the installation but had stopped in the same phase.

And you have SQL files in the ABAP\DB\ADA directory? Are they opened? Check the logfiles!

> And my R3load version is R7.00/ V1.4 [UNICODE]

Yes, but it's built in 2008 so it's three years old. Always use the latest tools.

Markus

[sivakumar_kilari3]

Check this SAPAPPL1_24.log again

Thanks

Siva

[Former Member]

Hi siva

SAPAPPL1_24.log is same again but SAPAPPL1_24.TSK ifound

T PCL4 C ok

T PCL4~0 C ok

T PCL4 I ok

T PCL4~XGG C err

T PCL4~XPS C ok

[Former Member]

Hi Markus,

After executing SMIGR_CREATE_DDL two text files were created

I have pasted them in ABAP\DB\ADA

but still it is not moving forward.

[sivakumar_kilari3]

> SAPAPPL1_24.log is same again but SAPAPPL1_24.TSK ifound

Delete this file again SAPAPPL1_24.TSK

try to install from starting

if you stuck again same step. paste logs here

Thanks

Siva

[Former Member]

Hi Markus ,

Thanks for all that you had helped us.

And one major thing i want to know is

I have export with me

later i have executed SMIGR_CREATE_DDL. And generated those files .

Now the question is should i Generate and Copy this file in export directory \ABAP\DB\ADA. After taking the export ,

Or should i do it at the time of taking new export.

If i would clear my doubt then i would start kicking off new import.

Thanks!

Vardhan.

[markus_doehr2]

> And one major thing i want to know is

> I have export with me

> later i have executed SMIGR_CREATE_DDL. And generated those files .

If there were imports of support packages or transports that changed the DDIC those files are useless.

> Now the question is should i Generate and Copy this file in export directory \ABAP\DB\ADA. After taking the export ,

> Or should i do it at the time of taking new export.

Take a new export, use a new installation master DVD, it will request to execute that report at a specific time.

Use the newest tools for export and import.

Read the system copy guide and the corresponding notes for your version, don't blindly "click around". (no offense)

Markus

[markus_doehr2]

> We have started heterogenious sytem copy from windows (mssql_ to linux(maxdb).

> In import abap phase at the 128th job it ended with an error Here i attach the log of IMPORT_MONITOR.LOG

Did you execute SMIGR_CREATE_DDL in the source system before you started the import? You need to have various SQL files in order to create the proper cubes/tables on the database.

Markus

[Former Member]

HI Markus,

Thanks fro the reply.

No we havent executed it .

Now do we have any solution to cross that step.

Thanks!

Vardhan.