Import ABAP phase has failed jobs during ECC6 EHP4 system copy on target

[Former Member]

Hi Experts,

I am encountering the error as follows during Import process on target system.

What i understood is that export data might be corrupted.Please suggest .

Package log:

(GSI) INFO: machine = "6x AMD64 Level 6 (Mod 46 Step 6)"

(RTF) ########## WARNING ###########

Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases

(DB) INFO: BSIS deleted/truncated #20110510082028

DbSl Trace: invalid sign in BCD number: 3

DbSl Trace: invalid BCD number (len=7, dec=2): 00 00 00 00 36 00 33

DbSl Trace: BCD -> NUMBER conversion failed: Table=BSIS , FldNo=20

(IMP) ERROR: DbSlExeModify/DbSlLobPutPiece failed

rc = 27, table "BSIS"

(DB) INFO: disconnected from DB

T:\usr\sap\SOG\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)

T:\usr\sap\SOG\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20110510082522

Import_monitor log:

(GSI) INFO: machine = "6x AMD64 Level 6 (Mod 46 Step 6)"

(RTF) ########## WARNING ###########

Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases

(DB) INFO: BSIS deleted/truncated #20110510082028

DbSl Trace: invalid sign in BCD number: 3

DbSl Trace: invalid BCD number (len=7, dec=2): 00 00 00 00 36 00 33

DbSl Trace: BCD -> NUMBER conversion failed: Table=BSIS , FldNo=20

(IMP) ERROR: DbSlExeModify/DbSlLobPutPiece failed

rc = 27, table "BSIS"

(DB) INFO: disconnected from DB

T:\usr\sap\SOG\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)

T:\usr\sap\SOG\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20110510082522

Import_monitor_java.log:

Import Monitor jobs: running 15, waiting 281, completed 51, failed 15, total 362.

Loading of 'REPOSRC' import package: ERROR

Import Monitor jobs: running 14, waiting 281, completed 51, failed 16, total 362.

Loading of 'CDCLS-17' import package: ERROR

Import Monitor jobs: running 13, waiting 281, completed 51, failed 17, total 362.

Import Monitor jobs: running 14, waiting 280, completed 51, failed 17, total 362.

Import Monitor jobs: running 15, waiting 279, completed 51, failed 17, total 362.

Import Monitor jobs: running 16, waiting 278, completed 51, failed 17, total 362.

Import Monitor jobs: running 17, waiting 277, completed 51, failed 17, total 362.

Import Monitor jobs: running 18, waiting 276, completed 51, failed 17, total 362.

Loading of 'KOCLU' import package: ERROR

Import Monitor jobs: running 17, waiting 276, completed 51, failed 18, total 362.

Import Monitor jobs: running 18, waiting 275, completed 51, failed 18, total 362.

Loading of 'BSIS' import package: ERROR

Import Monitor jobs: running 17, waiting 275, completed 51, failed 19, total 362.

Import Monitor jobs: running 18, waiting 274, completed 51, failed 19, total 362.

Loading of 'RFBLG-5' import package: ERROR

Import Monitor jobs: running 17, waiting 273, completed 51, failed 21, total 362.

Loading of 'GLPCA' import package: ERROR

Import Monitor jobs: running 16, waiting 273, completed 51, failed 22, total 362.

Import Monitor jobs: running 17, waiting 272, completed 51, failed 22, total 362.

Import Monitor jobs: running 18, waiting 271, completed 51, failed 22, total 362

Regards,

Dheeraj

[Former Member]

Hi,

Will you please check this sap note 1251735.

Regards

Bhuban

RKFL

[markus_doehr2]

Are you using

- a recent R3load tool

- a recent liboraslib.dll?

- a recent instantclient?

Markus

[Former Member]

hi markus,

R3load tool is updated one as i didn't find the remaining 2 files in kernel folder.

however there are certain jobs which are getting completed only few of them are getting failed as follows.

(RTF) ########## WARNING ###########

Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases

(DB) INFO: BSIS deleted/truncated #20110510082028

DbSl Trace: invalid sign in BCD number: 3

DbSl Trace: invalid BCD number (len=7, dec=2): 00 00 00 00 36 00 33

DbSl Trace: BCD -> NUMBER conversion failed: Table=BSIS , FldNo=20

(IMP) ERROR: DbSlExeModify/DbSlLobPutPiece failed

rc = 27, table "BSIS"

(DB) INFO: disconnected from DB

Regards,

Dheeraj

[Former Member]

Hello Dheeraj

How about filesystem do you have enough space on target system?

Regards

Vivek

[Former Member]

You have to run this report in Source System SDBI_CHECK_ORANUMBERS and correct the Tables BSIS and other tables before you export the DB using r3Load or SAPINST.

This report will correct those tables in Source System.

Refer: SDBI_CHECK_ORANUMBERS

Thanks

SM

[Former Member]

Is there a guide to do a HSC on EHP4? Also, how can you do a HSC on EHP4 when the installation requires that you do an installation with an ECC EHP4 Ready system, then do an upgrade? I would like to do the same.

Thanks,

Jim

[markus_doehr2]

> Is there a guide to do a HSC on EHP4?

Yes, they are on the same place as the installation guides: http://service.sap.com/instguides

> Also, how can you do a HSC on EHP4 when the installation requires that you do an installation with an ECC EHP4 Ready system, then do an upgrade? I would like to do the same.

What R3load does is exporting the content of the database, no matter which ABAP compoents are installed.

Markus

[Former Member]

Dheeraj ,

Please try SAP Note 339932 - invalid BCD number in developer trace.

Thanks..

Mohit

[Former Member]

Hi Mohit,

My scenario is a system copy where i cannot login to SAP and execute the reports suggested as per the note.

I am currently running in to Import ABAP phase of system copy on target.

Pls suggest accordingly.

Regards,

Dheeraj

[Former Member]

Hi,

Latest error status

(RTF) ########## WARNING ###########

Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases

DbSl Trace: Error 1555 in exec_immediate() from oci_execute_stmt(), orpc=0

DbSl Trace: ORA-1555 occurred when executing SQL stmt (parse error offset=12)

(DB) ERROR: DDL statement failed

(DELETE FROM "RFBLG"WHERE ("BELNR" > '0909453988') AND ("BELNR" <= '2010008504'))

DbSlExecute: rc = 99

(SQL error 1555)

error message returned by DbSl:

ORA-01555: snapshot too old: rollback segment number 17 with name "_SYSSMU17_3018655928$" too small

(DB) INFO: disconnected from DB

T:\usr\sap\SOG\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)

T:\usr\sap\SOG\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20110510084017