Installation error at import abap phase for SAP ECC6 IDES SR3.

[Former Member]

Dear Experts,

My platform is Windows 2003 R2 x64 bit, and Oracle is 10.2.0.4 version.

When i install the SAP ECC6 IDES SR3. During the Import ABAP phase, i got some errors, but i don't understand what the message mean, and how to solved ?

Pls, experts tell me how to solved these problems. thx.

import_monitor.java.log：

java version "1.4.2"

Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2-b28)

Java HotSpot(TM) Client VM (build 1.4.2-b28, mixed mode)

Import Monitor jobs: running 1, waiting 0, completed 102, failed 0, total 103.

Loading of 'SAPVIEW' import package: ERROR

Import Monitor jobs: running 0, waiting 0, completed 102, failed 1, total 103.

import_monitor.log：

TRACE: 2011-06-26 00:29:32 com.sap.inst.migmon.LoadTask run

Loading of 'SAPVIEW' import package is started.

TRACE: 2011-06-26 00:29:32 com.sap.inst.migmon.LoadTask processPackage

Loading of 'SAPVIEW' import package into database:

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

ERROR: 2011-06-26 00:29:36 com.sap.inst.migmon.LoadTask run

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

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

For mode details see 'SAPVIEW.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-26 00:29:59

All import packages are processed.

WARNING: 2011-06-26 00:29:59

1 error(s) during processing of packages.

INFO: 2011-06-26 00:29:59

Import Monitor is stopped.

SAPVIEW.log：

C:\usr\sap\IDS\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20300626002932

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

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

Compiled Feb 24 2009 23:41:07

C:\usr\sap\IDS\SYS\exe\uc\NTAMD64\R3load.exe -i SAPVIEW.cmd -dbcodepage 4103 -l SAPVIEW.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): UTF8

(DB) ERROR: DDL statement failed

(DROP VIEW "APPL_PROG")

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

(DB) ERROR: DDL statement failed

(CREATE VIEW "APPL_PROG" ( "PROG" , "R3STATE" , "DEVCLASS" , "OBJ_NAME" ) AS SELECT T0001."PROGNAME", T0001."R3STATE", T0002."DEVCLASS", T0002."OBJ_NAME" FROM "REPOSRC" T0001, "TADIR" T0002 WHERE T0001."PROGNAME" = T0002."OBJ_NAME" AND T0001."R3STATE" = 'A' AND T0002."PGMID" = 'R3TR' AND T0002."OBJECT" = 'PROG' AND ( T0001."SUBC" = '1' OR T0001."SUBC" = 'M' OR T0001."SUBC" = 'S' ))

DbSlExecute: rc = 103

(SQL error 942)

error message returned by DbSl:

ORA-00942: table or view does not exist

(DB) INFO: disconnected from DB

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

C:\usr\sap\IDS\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20300626002936

[Former Member]

in case you want to rebuild it from scratch(ops$<sid>) read note 50088

[volker_borowski2]

Hi,

the missing SAPUSER is no prob at this stage of the installation at all.

Right after the 1403 you get

(DB) INFO: connected to DB
(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF8
(DB) ERROR: DDL statement failed
(DROP VIEW "APPL_PROG")
DbSlExecute: rc = 103
(SQL error 942)
error message returned by DbSl:
ORA-00942: table or view does not exist

And since you do NOT get "not connected to the db" at the drop but

ORA-00942: table or view does not exist

this suggests you have a correctly established session, trying to execute the drop.

So the create view seems to fail, because one of the soure tables does not exist.

What does

select owner, segment_type,segment_name from dba_segments where segment_name like 'TADIR%';

and

select owner, segment_type,segment_name from dba_segments where segment_name like 'REPOSRC%';

return ?

Volker

[Former Member]

Hi,

>> -DbSl Trace: ORA-1403 when accessing table SAPUSER

Please check the note 400241 - Problems with ops$ or sapr3 connect to Oracle

Best regards,

Orkun Gedik

[Former Member]

Can you tell me more detail steps to solve that problem?

[Former Member]

Hi,

It seem like you are not able to access SAPUSER table. Please read the note and check the steps very carefully .

Best regards,

Orkun Gedik