cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Create Index error on all jobs of import abap installation phase

Former Member

on ‎03-31-2010 9:38 PM

0 Kudos

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

Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
‎05-11-2010 4:49 PM
0 Kudos

Dear Friends,

All issues that we had with MaxDB index creation was due a mistake, we pick a NON UNICODE kernel from Marketplace.

Thanks for your time,

Deiby

Show replies
Show replies
Former Member
‎04-15-2010 11:46 AM
0 Kudos

hello friends,

i have a similar error in context of an unicode conversion in phase import with r3load. in logs in file D010TAB.log i see the following output:

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

ERROR : Execute for create index /BI0/E0D_DECU~P on /BI0/E0D_DECU failed (dbrc=99).
  (SQL error -7055)
  error message returned by DbSl:
SQL-Statement: CREATE  INDEX "/BI0/E0D_DECU~P" ON "/BI0/E0D_DECU" ( "KEY_0D_DECUP" , "KEY_0D_DECUT" , "KEY_0D_DECUU" , "KEY_0D_DECU1" , "KEY_0D_DECU2" , "KEY_0D_DECU3" , "KEY_0D_DECU4" , "KEY_0D_DECU5"  )  
POS(55) Column(s) already indexed:/BI0/E0D_DECU~P

/usr/sap/SPV/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/SPV/SYS/exe/run/R3load: END OF LOG: 20100414185908

45 / 47 are complete in phase import.

For a TEST Case , i have deleted all indices on tables in selection of /BI0/*. I will rerun this procedure. the largest part of indices on tables come from a bw-installation in a seperate client.

best regards,

christoph

Show replies
Show replies
markus_doehr2
Active Contributor
‎03-31-2010 9:52 PM
0 Kudos

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

Be aware that MaxDB 7.6 is not supported on SLES 11, you need MaxDB 7.7 for that.

I'd try with a newer MaxDB version, seems like the version you use has a problem (and is pretty old though).

Markus

Show replies
Show replies
Former Member
‎04-04-2010 4:14 AM
0 Kudos

Markus, I will try again on SLES 10 SP2.

I don't know how I could try a new MaxDB version due that I had downloaded the latest version of IDES from Marketplace and it is the MaxDB version included in the RDBMS DVD.

Thank you, Deiby

Ask a Question