System Export Error (MS-SQL, WIN2003)

[Former Member]

Dear All,

During our System export of a ERP system ( systemcopy with sapinst) one of the 219 steps in the abap export fails with the following error message.

Kindly do the needful. Thanks in advance.

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

K:\usr\sap\KMR\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20110603122401

K:\usr\sap\KMR\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20110603122612

K:\usr\sap\KMR\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/701_REL/src/R3ld/R3load/R3ldmain.c#8 $ SAP

K:\usr\sap\KMR\SYS\exe\uc\NTAMD64\R3load.exe: version R7.01/V1.4 [UNICODE]

Compiled Sep 23 2010 23:50:28

K:\usr\sap\KMR\SYS\exe\uc\NTAMD64\R3load.exe -e SAPAPPL1_103.cmd -datacodepage 4103 -l SAPAPPL1_103.log -stop_on_error

(DB) INFO: connected to DB

(DB) INFO: Export without hintfile

(GSI) INFO: dbname = "KMRERP-PRD "

(GSI) INFO: vname = "MSSQL "

(GSI) INFO: hostname = "ERP-PRD "

(GSI) INFO: sysname = "Windows NT"

(GSI) INFO: nodename = "ERP-PRD"

(GSI) INFO: release = "5.2"

(GSI) INFO: version = "3790 Service Pack 2"

(GSI) INFO: machine = "4x AMD64 Level 6 (Mod 26 Step 5)"

(GSI) INFO: instno = "INITIAL "

(EXP) ERROR: DbSlPrepare/BegRead failed

rc = 103, table "SCI_TEMPT"

(SQL error 208)

error message returned by DbSl:

Invalid object name 'SCI_TEMPT'.

Statement(s) could not be prepared.

(DB) INFO: disconnected from DB

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

K:\usr\sap\KMR\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20110603122612

Bst Rgds,

Kanthi

[Former Member]

Dear,

Please find the attached log for reference.

*An error occurred while processing option SAP ERP 6.0 EHP4 Ready - Support Release 1 > Software Life-Cycle Options > System Copy > MS SQL Server > Source System Export > Central System > Based on AS ABAP > Database Instance Export( Last error reported by the step :Program 'Migration Monitor' exits with error code 103. For details see log file(s) export_monitor.java.log, export_monitor.log.). *

export_monitor.java.log Shos the following Log.

java version "1.4.2_21"

Java(TM) Platform, Standard Edition for Business (build 1.4.2_21-b03)

Java HotSpot(TM) 64-Bit Server VM (build 1.4.2_21-b03, mixed mode)

Export Monitor jobs: running 1, waiting 0, completed 218, failed 0, total 219.

Unloading of 'SAPAPPL1_103' export package: ERROR

Export Monitor jobs: running 0, waiting 0, completed 218, failed 1, total 219.

export_monitor.log Shows the following log.

ERROR: 2011-06-03 12:24:02 com.sap.inst.migmon.LoadTask run

Unloading of 'SAPAPPL1_103' export package is interrupted with R3load error.

Process 'K:\usr\sap\KMR\SYS\exe\uc\NTAMD64\R3load.exe -e SAPAPPL1_103.cmd -datacodepage 4103 -l SAPAPPL1_103.log -stop_on_error' exited with return code 2.

For mode details see 'SAPAPPL1_103.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

INFO: 2011-06-03 12:24:27

All export packages are generated.

INFO: 2011-06-03 12:24:27

All export packages are processed.

WARNING: 2011-06-03 12:24:27

1 error(s) during processing of packages.

INFO: 2011-06-03 12:24:27

Export Monitor is stopped.

INFO: 2011-06-03 12:26:11

Export Monitor is started.

CONFIG: 2011-06-03 12:26:11

Application options:

dataCodepage=4103

dbType=MSS

exportDirs=E:\Export\ABAP

installDir=C:\Program Files\sapinst_instdir\ERPEhP4\LM\COPY\MSS\EXP\CENTRAL\AS-ABAP\EXP

jobNum=3

loadArgs=-stop_on_error

monitorTimeout=30

orderBy=

r3loadExe=K:\usr\sap\KMR\SYS\exe\uc\NTAMD64\R3load.exe

sapinst=

server=

trace=all

tskFiles=yes

CONFIG: 2011-06-03 12:26:11

List of packages with table structure: 'SAP0000'.

CONFIG: 2011-06-03 12:26:11

List of packages with views: 'SAPVIEW'.

TRACE: 2011-06-03 12:26:11 com.sap.inst.migmon.LoadTask run

Unloading of 'SAPAPPL1_103' export package is started.

TRACE: 2011-06-03 12:26:11 com.sap.inst.migmon.LoadTask processPackage

Unloading of 'SAPAPPL1_103' export package from database:

K:\usr\sap\KMR\SYS\exe\uc\NTAMD64\R3load.exe -e SAPAPPL1_103.cmd -datacodepage 4103 -l SAPAPPL1_103.log -stop_on_error

ERROR: 2011-06-03 12:26:12 com.sap.inst.migmon.LoadTask run

Unloading of 'SAPAPPL1_103' export package is interrupted with R3load error.

Process 'K:\usr\sap\KMR\SYS\exe\uc\NTAMD64\R3load.exe -e SAPAPPL1_103.cmd -datacodepage 4103 -l SAPAPPL1_103.log -stop_on_error' exited with return code 2.

For mode details see 'SAPAPPL1_103.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

INFO: 2011-06-03 12:26:41

All export packages are generated.

INFO: 2011-06-03 12:26:41

All export packages are processed.

WARNING: 2011-06-03 12:26:41

1 error(s) during processing of packages.

INFO: 2011-06-03 12:26:41

Export Monitor is stopped.

Regards,

Kanthi

[Former Member]

Dear All,

My issue resolved.

Here is the steps i followed.

As per SAP note 849692 and

SCI_TEMPT SAP Table - Code Inspector: Temporary Table for Join

SCI_TEMPT is a standard SAP table available within R/3 SAP systems depending on your version and release level. Below is the standard documentation available for this table and a few details of the fields which make up this table. You can view this information and more if you enter the table name SCI_TEMPT into the relevant SAP transaction such as SE11 or SE80. You can also view the data contained in this database table via these transactions or alternatively use transaction SE16

Within the comments section below there is also an opportunity for anyone to be able add useful hints and information specific to this SAP object. This means that you and other users will be able to find these details quickly by simply searching on the object name SCI_TEMPT .

Dictionary fields for SAP Table SCI_TEMPT

Field Data Element Data Type length Checktable

OBJ_TYPE TROBJTYPE CHAR 000004

OBJ_NAME SOBJ_NAME CHAR 000040

NAME PROGRAMM CHAR 000040 *

CNAM CNAM CHAR 000012

UNAM UNAM CHAR 000012

SUBC SUBC CHAR 000001

Regards,

Kanthi

[sunny_pahuja2]

Hi

Try with latest R3load executable.

Thanks

Sunny

[Former Member]

Dear Sunny,

I used latest R3Load only...

Rgds,

Kanthi