ORA-1403 error acessing table SAPUSER during install

[Former Member]

in ERP 2005 installation, I get an ORA-1403 error in my last import step (there are 37 of them - all but one succeeded). It's trying to import the SAPVIEW step and gives the below output in the log. IT suggests the SAPVIEW.TSK file is corrupt, but I renamed it and ran the step again where it then created a new SAPVIEW.TSK file and still gives the error. I've checked the OPS$<user> and insured it's the only one in the SAPUSER table per note 400241. Any other ideas?

/usr/sap/RD6/SYS/exe/run/R3load: START OF LOG: 20060725085716

/usr/sap/RD6/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#6 $ SAP

/usr/sap/RD6/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]

Compiled Apr 1 2006 03:18:31

/usr/sap/RD6/SYS/exe/run/R3load -i SAPVIEW.cmd -dbcodepage 4102 -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

(TSK) ERROR: file /oracle/MD2/sapdata2/put_MD2/RD6inst/SAPVIEW.TSK.bck already seems to exist

a previous run may not have been finished cleanly

file /oracle/MD2/sapdata2/put_MD2/RD6inst/SAPVIEW.TSK possibly corrupted

/usr/sap/RD6/SYS/exe/run/R3load: job finished with 1 error(s)

/usr/sap/RD6/SYS/exe/run/R3load: END OF LOG: 20060725085716

[Former Member]

My problem ended up being my network client timing out. I'm doing this with a UNIX X-Window client on my PC. During the import phase I was leaving my computer at the end of the day while this long phase was running. With no activity on my PC client, our network was timing my UNIX session out, so the install was aborting since the client was being dropped. My solution was to run the UNIX Xclock in a seperate window (/usr/. This basically created some network activity between my PC and the host indefinitely. When I started the install over and left it run overnight, it was all good when I came in the next morning.

[Former Member]

Thanks a lot for your description of solving problem. I have exactly the same problem on Solaris 10. I tried to use Xming instead cygwin and it helped !

[Former Member]

I have same problem. Thanks in advance if some body give me solution.

Details mentioned below:

D:\usr\sap\DEV\SYS\exe\run/R3load.exe: START OF LOG: 20071214094304

D:\usr\sap\DEV\SYS\exe\run/R3load.exe: sccsid @(#) $Id: //bas/640_REL/src/R3ld/R3load/R3ldmain.c#6 $ SAP

D:\usr\sap\DEV\SYS\exe\run/R3load.exe: version R6.40/V1.4 [UNICODE]

D:\usr\sap\DEV\SYS\exe\run/R3load.exe -ctf I E:/ERP2004/Export/SAP/EXP8/DATA/SAPVIEW.STR C:\Program Files\sapinst_instdir\ECC04SR1\WEBAS_ABAP_ORA_UC\DB/DDLORA.TPL C:\Program Files\sapinst_instdir\ECC04SR1\WEBAS_ABAP_ORA_UC\DB/SAPVIEW.TSK ORA -l C:\Program Files\sapinst_instdir\ECC04SR1\WEBAS_ABAP_ORA_UC\DB/SAPVIEW.log -o D

D:\usr\sap\DEV\SYS\exe\run/R3load.exe: job completed

D:\usr\sap\DEV\SYS\exe\run/R3load.exe: END OF LOG: 20071214094306

D:\usr\sap\DEV\SYS\exe\run/R3load.exe: START OF LOG: 20080107075023

D:\usr\sap\DEV\SYS\exe\run/R3load.exe: sccsid @(#) $Id: //bas/640_REL/src/R3ld/R3load/R3ldmain.c#6 $ SAP

D:\usr\sap\DEV\SYS\exe\run/R3load.exe: version R6.40/V1.4 [UNICODE]

D:\usr\sap\DEV\SYS\exe\run/R3load.exe -dbcodepage 4103 -i C:\Program Files\sapinst_instdir\ECC04SR1\WEBAS_ABAP_ORA_UC\DB/SAPVIEW.cmd -l C:\Program Files\sapinst_instdir\ECC04SR1\WEBAS_ABAP_ORA_UC\DB/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

(CREATE VIEW "/BEV1/CADD03VTV" ( "TABNAME" , "FIELDNAME" , "AS4LOCAL" , "AS4VERS" , "DDLANGUAGE" , "DDTEXT" ) AS SELECT T0001."TABNAME", T0001."FIELDNAME", T0001."AS4LOCAL", T0001."AS4VERS", T0002."DDLANGUAGE", T0002."DDTEXT" FROM "DD03L" T0001, "DD04T" T0002, "DD04L" T0003 WHERE T0003."ROLLNAME" = T0001."ROLLNAME" AND T0003."ROLLNAME" = T0002."ROLLNAME")

DbSlExecute: rc = 103

(SQL error 942)

error message returned by DbSl:

ORA-00942: table or view does not exist

(DB) INFO: disconnected from DB

D:\usr\sap\DEV\SYS\exe\run/R3load.exe: job finished with 1 error(s)

D:\usr\sap\DEV\SYS\exe\run/R3load.exe: END OF LOG: 20080107075026

D:\usr\sap\DEV\SYS\exe\run/R3load.exe: START OF LOG: 20080107081956

[Former Member]

Hi Manoj,

Did you manage to solve this issue? We are getting same issue for same view?

Thanks in advance.

[Former Member]

Hi,

Did u manager to find the fix, I'm facing the same problem.

Rgds

Felix