MCOD Installation - Error ORA-1403 when accessing table SAPUSER

[Former Member]

Hello.

We are in middle of a MCOD installation of 4.7 x 2.00 SR1 with BW 3.1 on Windows 2003/Oracle.

BW 3.1 is up and running, while 4.7 fails on R3loads.

Following are SAP000.log and SAPUSER.log files:

SAP000.log

===============================

D:\usr\sap\D11\SYS\exe\run/R3load.exe: START OF LOG: 20060507193904

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

D:\usr\sap\D11\SYS\exe\run/R3load.exe: version R6.40/V1.4

D:\usr\sap\D11\SYS\exe\run/R3load.exe -dbcodepage 1100 -i D:\Program Files\sapinst_instdir\R3E_472SR1_ABAP_NUC\DB/SAP0000.cmd -l D:\Program Files\sapinst_instdir\R3E_472SR1_ABAP_NUC\DB/SAP0000.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): WE8DEC

(DB) ERROR: DDL statement failed

(DROP TABLE "REPOLOAD")

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: ORA-406 occured when executing SQL statement (parse error offset = 0)

(DB) ERROR: DDL statement failed

(CREATE TABLE "REPOLOAD" ( "PROGNAME" VARCHAR2(40) DEFAULT ' ' NOT NULL , "R3STATE" VARCHAR2(1) DEFAULT ' ' NOT NULL , "MACH" NUMBER(5) DEFAULT 0 NOT NULL , "UNAM" VARCHAR2(12) DEFAULT ' ' NOT NULL , "UDAT" VARCHAR2(8) DEFAULT '00000000' NOT NULL , "UTIME" VARCHAR2(6) DEFAULT '000000' NOT NULL , "L_DATALG" NUMBER(10) DEFAULT 0 NOT NULL , "Q_DATALG" NUMBER(10) DEFAULT 0 NOT NULL , "SDAT" VARCHAR2(8) DEFAULT '00000000' NOT NULL , "STIME" VARCHAR2(6) DEFAULT '000000' NOT NULL , "MINOR_VERS" NUMBER(5) DEFAULT 0 NOT NULL , "MAJOR_VERS" NUMBER(10) DEFAULT 0 NOT NULL , "LDATA" BLOB , "QDATA" BLOB ) TABLESPACE PSAPD11620 STORAGE (INITIAL 0000000016K NEXT 0000040960K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) )

DbSlExecute: rc = 99

(SQL error 406)

error message returned by DbSl:

ORA-00406: COMPATIBLE parameter needs to be 9.2.0.0.0 or greater

(DB) INFO: disconnected from DB

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

D:\usr\sap\D11\SYS\exe\run/R3load.exe: END OF LOG: 20060507193905

========================================

SAPUSER.log

==============================

D:\usr\sap\D11\SYS\exe\run/R3load.exe: START OF LOG: 20060507193834

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

D:\usr\sap\D11\SYS\exe\run/R3load.exe: version R6.40/V1.4

D:\usr\sap\D11\SYS\exe\run/R3load.exe -dbcodepage 1100 -i D:\Program Files\sapinst_instdir\R3E_472SR1_ABAP_NUC\DB/SAPUSER.cmd -l D:\Program Files\sapinst_instdir\R3E_472SR1_ABAP_NUC\DB/SAPUSER.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): WE8DEC

(DB) INFO: disconnected from DB

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

D:\usr\sap\D11\SYS\exe\run/R3load.exe: END OF LOG: 20060507193835

==============================================

Kindly look into it.

Thanks

KT

[Former Member · Accepted solution]

Hi KT,

Actually the problem is not ORA-1403, but the <i>ORA-00406: COMPATIBLE parameter needs to be 9.2.0.0.0 or greater</i>.

Please update the COMPATIBLE parameter in your init<SID>.ora file and restart the database. This should fix your problem.

Kind regards,

Alexander Webster

P.S. points are appreciated if my reply was helpfull.

Message was edited by: Alexander Webster

Removed typo