SAP Ides ECC 6.0 Install: Import ABAP - Package SAPDODS Error - ORA-00903

[Former Member]

Experts,

Good Morning!

I'm trying to install SAP IDES ECC 6.0 version on a Windows 2008 R2 Server with Oracle 11g DB (11.2).

System Info: 16GM RAM & 600GB Hdd. Prereqs passed.

I'm getting the following error during the Import ABAP phase (16 of 29) in the sapinst log:

"An error occurred while processing option Enhancement Package 6 for SAP ERP 6.0 > SAP Application Server ABAP > Oracle > Central System > Central System( Last error reported by the step: Program 'Migration Monitor' exits with error code 103. "

Here's the dump of import_monitor.java.log

java version "1.4.2_32"

Java(TM) 2 Runtime Environment, Standard Edition (build 4.1.012)

SAP Java Server VM (build 4.1.012 1.6-b03, Oct 21 2011 14:18:45 - 41_REL - optU - windows amd64 - 6 - bas2:161688 (mixed mode))

Import Monitor jobs: running 1, waiting 1, completed 141, failed 0, total 143.

Loading of 'SAPDODS' import package: ERROR

Import Monitor jobs: running 0, waiting 1, completed 141, failed 1, total 143.

Here's the dump of import_monitor.log:

INFO: 2014-07-05 13:42:53

Data codepage 4103 is determined using TOC file 'C:\Target\Export1\DATA\D010TAB.TOC' for package 'D010TAB'.

TRACE: 2014-07-05 13:42:53 com.sap.inst.migmon.LoadTask run

Loading of 'SAPDODS' import package is started.

TRACE: 2014-07-05 13:42:53 com.sap.inst.migmon.LoadTask processPackage

Loading of 'SAPDODS' import package into database:

C:\usr\sap\AVV\SYS\exe\uc\NTAMD64\R3load.exe -i SAPDODS.cmd -dbcodepage 4103 -l SAPDODS.log -stop_on_error

ERROR: 2014-07-05 13:42:54 com.sap.inst.migmon.LoadTask run

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

Process 'C:\usr\sap\AVV\SYS\exe\uc\NTAMD64\R3load.exe -i SAPDODS.cmd -dbcodepage 4103 -l SAPDODS.log -stop_on_error' exited with return code 2.

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

WARNING: 2014-07-05 13:43:21

Cannot start import of packages with views because not all import packages with tables are loaded successfully.

WARNING: 2014-07-05 13:43:21

1 error(s) during processing of packages.

INFO: 2014-07-05 13:43:21

Import Monitor is stopped.

Here's the log of SAPDODS...

C:\usr\sap\AVV\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20140705134253

C:\usr\sap\AVV\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#13 $ SAP

C:\usr\sap\AVV\SYS\exe\uc\NTAMD64\R3load.exe: version R7.20/V1.4 [UNICODE]

Compiled Aug 16 2011 02:26:36

patchinfo (patches.h): (0.098) DB6: correction for R3load PL 91 on HP-UX and SOLARIS (note 1609719)

process id 1488

C:\usr\sap\AVV\SYS\exe\uc\NTAMD64\R3load.exe -i SAPDODS.cmd -dbcodepage 4103 -l SAPDODS.log -stop_on_error

DbSl Trace: ORA-1403 when accessing table SAPUSER

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF16

(SQL) INFO: Searching for SQL file SQLFiles.LST

(SQL) INFO: SQLFiles.LST not found

(SQL) INFO: Searching for SQL file C:\Target\Export1\DB/SQLFiles.LST

(SQL) INFO: C:\Target\Export1\DB/SQLFiles.LST not found

(SQL) INFO: Searching for SQL file DODS.SQL

(SQL) INFO: DODS.SQL not found

(SQL) INFO: Searching for SQL file C:\Target\Export1\DB/ORA/DODS.SQL

(SQL) INFO: found C:\Target\Export1\DB/ORA/DODS.SQL

(SQL) INFO: Trying to open C:\Target\Export1\DB/ORA/DODS.SQL

(SQL) INFO: C:\Target\Export1\DB/ORA/DODS.SQL opened

(DB) ERROR: DDL statement failed

(DROP TABLE "/BI0/APERS_BOD00")

DbSlExecute: rc = 103

  (SQL error 942)

  error message returned by DbSl:

ORA-00942: table or view does not exist

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

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

DbSl Trace: ORA-00903 occurred at SQL stmt (parse error offset=15)

(DB) ERROR: DDL statement failed

(  CREATE TABLE [/BI0/APERS_BOD00]         (  [TCTUSERNM] nvarchar(000012)          NOT NULL  ,           [TCTOBJVERS] nvarchar(000001)          NOT NULL  ,           [TCTSYSID] nvarchar(000010)          NOT NULL  ,           [TCTQUACT] nvarchar(000001)          NOT NULL  ,           [TCTOBJNM] nvarchar(000040)          NOT NULL  ,           [TCTTLOGO] nvarchar(000004)          NOT NULL  ,           [RECORDMODE] nvarchar(000001)          NOT NULL  ,           [TCTTIMSTMP] nvarchar(000014)          NOT NULL   )          WITH ( DATA_COMPRESSION = PAGE )   )

DbSlExecute: rc = 99

  (SQL error 903)

  error message returned by DbSl:

ORA-00903: invalid table name

(DB) INFO: disconnected from DB

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

C:\usr\sap\AVV\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20140705134254

FYI - A retry does not help. Also tried to search for the error on scn, google but haven't been able to find the right solution.

Can you help?

Regards,

Cobain.

[Former Member]

Hi,

I think its better you update kernel.

[divyanshu_srivastava3]

Hi,

1st step is to update R3load and R3trans.

Also repeat the process

Regards

[Former Member]

Divyanshu - sorry to ask but can you explain why i need to update r3load and r3trans to resolve this error? Just want to understand why I'm doing a correction so I can learn from the same.

Also, can you clarify the file update process:

For R3load:

a) the r3load used by the command is dated 8/16/2011 (location:C:\usr\sap\AVV\SYS\exe\uc\NTAMD64\...)

b) the r3load i have in my db folder is dated 10/23/2011 (location:C:\Final\Installer\BS7i2011_Installation_Master_\DATA_UNITS\BS2011_IM_WINDOWS_X86_64\ORA\UC\...)

Do i replace (a) with (b)?

For R3trans:

How do I update this file?

- Cobain.

[divyanshu_srivastava3]

Hi Kurt,

If you see the above logs than operations with DB were performed using these files. Also, any program of kernel is not always 100% bug free. At times, the version which we are using have bugs corrected in future releases.

Download R3* files from SMP and patch in kernel directory.

Regards

[Former Member]

Divyanshu,

Thanks again for the quick response.

I'm struggling to find the right path of the r3* files in SMP.

I'm doing a search under search for installations and upgrades

Can you help me with that?

[divyanshu_srivastava3]

Hi Kurt,

Goto kernel in service market place and download the files.

Regards

[Former Member]

Thank you. I'm downloading the files.

Will let you know the outcome of the activity.

Cobain.