Skip to Content
0
Former Member
Mar 31, 2010 at 08:38 PM

Create Index error on all jobs of import abap installation phase

149 Views

Hello,

I'm facing an issue on import abap phase on IDES SAP ERP 2004 installation over SLES 11/MaxDB 7.6.03 build 9.

Logs below are focused on table REPOSRC because it is the first error over installation, the same error appear again and again for the next tables.

We ran the installation again changing the number of parallel processes to 1 job at time but finally nothing change.

sapdb log size : -rw-rw---- 1 sdb sdba 8808038400 Mar 30 23:01 DISKL001

cache_size = 159488

Thanks in advance, Deiby

import_monitor.log

....

....

TRACE: 2010-03-29 16:53:00 com.sap.inst.migmon.LoadTask run

Loading of 'REPOSRC' import package is started.

TRACE: 2010-03-29 16:53:00 com.sap.inst.migmon.LoadTask processPackage

Task file generation for 'REPOSRC' import package:

/usr/sap/IDS/SYS/exe/run/R3load -ctf I /software/51034985/51034985_2/EXP2/DATA/REPOSRC.STR /tmp/sapinst_instdir/ERP/SYSTEM/ADA/CENTRAL/AS/DDLADA.TPL REPOSRC.TSK ADA -l REPOSRC.log

TRACE: 2010-03-29 16:53:00 com.sap.inst.migmon.LoadTask processPackage

Loading of 'REPOSRC' import package into database:

/usr/sap/IDS/SYS/exe/run/R3load -i REPOSRC.cmd -dbcodepage 4103 -l REPOSRC.log -nolog -c 10000

ERROR: 2010-03-29 16:53:04 com.sap.inst.migmon.LoadTask run

Loading of 'REPOSRC' import package is interrupted with R3load error.

Process '/usr/sap/IDS/SYS/exe/run/R3load -i REPOSRC.cmd -dbcodepage 4103 -l REPOSRC.log -nolog -c 10000' exited with return code 2.

For mode details see 'REPOSRC.log' file.

Standard error output:

sapparam: sapargv( argc, argv) has not been called.

sapparam(1c): No Profile used.

sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

....

....

REPOSRC.log

/usr/sap/IDS/SYS/exe/run/R3load: START OF LOG: 20100329165300

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

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

Compiled Jan 23 2008 17:32:58

/usr/sap/IDS/SYS/exe/run/R3load -ctf I /software/51034985/51034985_2/EXP2/DATA/REPOSRC.STR /tmp/sapinst_instdir/ERP/SYSTEM/ADA/CENTRAL/AS/DDLADA.TPL REPOSRC.TSK ADA -l REPOSRC.log

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

/usr/sap/IDS/SYS/exe/run/R3load: END OF LOG: 20100329165300

/usr/sap/IDS/SYS/exe/run/R3load: START OF LOG: 20100329165300

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

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

Compiled Jan 23 2008 17:32:58

/usr/sap/IDS/SYS/exe/run/R3load -i REPOSRC.cmd -dbcodepage 4103 -l REPOSRC.log -nolog -c 10000

DbSl Trace: prepare() of C_0000, rc=1, rcSQL=-942 (POS(28) Unknown table name:SVERS)

DbSl Trace: SQL PREPARE on connection 0, rc=-942 (POS(28) Unknown table name:SVERS)

(DB) INFO: connected to DB

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

(DB) INFO: Savepoint on database executed#20100329165300

(DB) INFO: REPOSRC created#20100329165300

(DB) INFO: Savepoint on database executed#20100329165301

(DB) INFO: REPOSRC~0 created#20100329165301

DbSl Trace: writeLob() of C_0003, rc=1, rcSQL=-10201 (Function sequence error (no data for execution expected))

DbSl Trace: LOB_WRITE on connection 0, rc=-10201 (Function sequence error (no data for execution expected))

(IMP) ERROR: DbSlExeModify/DbSlLobPutPiece failed

rc = 99, table "REPOSRC"

(SQL error -10201)

error message returned by DbSl:

Function sequence error (no data for execution expected)

(DB) INFO: disconnected from DB

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

/usr/sap/IDS/SYS/exe/run/R3load: END OF LOG: 20100329165304

/usr/sap/IDS/SYS/exe/run/R3load: START OF LOG: 20100330120734

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

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

Compiled Jan 23 2008 17:32:58

/usr/sap/IDS/SYS/exe/run/R3load -i REPOSRC.cmd -dbcodepage 4103 -l REPOSRC.log -nolog -c 10000

(DB) INFO: connected to DB

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

(DB) INFO: Savepoint on database executed#20100330120735

(DB) INFO: REPOSRC deleted/truncated#20100330120735

DbSl Trace: writeLob() of C_0004, rc=1, rcSQL=-10201 (Function sequence error (no data for execution expected))

DbSl Trace: LOB_WRITE on connection 0, rc=-10201 (Function sequence error (no data for execution expected))

(IMP) ERROR: DbSlExeModify/DbSlLobPutPiece failed

rc = 99, table "REPOSRC"

(SQL error -10201)

error message returned by DbSl:

Function sequence error (no data for execution expected)

DbSl Trace: EXECUTE on connection 0, rc=-1452 (POS(1) Duplicate secondary key)

ERROR : Execute for create index BNK_BATCH_HEADERBA on BNK_BATCH_HEADER failed (dbrc=99).

(SQL error -1452)

error message returned by DbSl:

SQL-Statement: CREATE UNIQUE INDEX "BNK_BATCH_HEADERBA" ON "BNK_BATCH_HEADER" ( "MANDT" , "BATCH_NO" )

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

/usr/sap/IDS/SYS/exe/run/R3load: END OF LOG: 20100330120739

REPOSRC.TSK

T REPOSRC C ok

P REPOSRC~0 C ok

D REPOSRC I err

Edited by: Deiby Alvez on Mar 31, 2010 10:39 PM