ora-1031 during sapinst creating views

[Former Member]

hi all,

during the installation of a CRM 5.0 system i encounter the following error during the abap load, while creating views this is what i can find in de sapview.log

<i><b>D:\usr\sap\CRU\SYS\exe\uc\NTI386\R3load.exe: job finished with 1 error(s)

D:\usr\sap\CRU\SYS\exe\uc\NTI386\R3load.exe: END OF LOG: 20071024103009

D:\usr\sap\CRU\SYS\exe\uc\NTI386\R3load.exe: START OF LOG: 20071024103506

D:\usr\sap\CRU\SYS\exe\uc\NTI386\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#4 $ SAP

D:\usr\sap\CRU\SYS\exe\uc\NTI386\R3load.exe: version R7.00/V1.4 [UNICODE]

Compiled Sep 6 2005 23:34:18

D:\usr\sap\CRU\SYS\exe\uc\NTI386\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 "/1CN/A3DSAP00002")

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-1031 occurred when executing SQL statement (parse error offset=12)

(DB) ERROR: DDL statement failed

(CREATE VIEW "/1CN/A3DSAP00002" ( "CLIENT" , "BEF_APPL" , "OBJTYPE" , "SRC_PROCESS_TYPE" , "SRC_ITEM_TYPE" , "KSCHL" , "OBJECT_ID" , "TIMESTAMP_TO" , "RELEASE_STATUS" , "KOPOS" , "CREATED_ON" , "VARNUMH" , "TIMESTAMP_FROM" , "KSCHL_SUPP" , "COND_GROUP_ID" , "MAINT_STATUS" , "CREATED_BY" , "SUPP_EXIST" , "SCALE_DIM" , "ITEM_CATEGORY" ) AS SELECT T0001."CLIENT", T0001."BEF_APPL", T0001."OBJTYPE", T0001."SRC_PROCESS_TYPE", T0001."SRC_ITEM_TYPE", T0001."KSCHL", T0001."OBJECT_ID", T0001."TIMESTAMP_TO", T0001."RELEASE_STATUS", T0001."KOPOS", T0001."CREATED_ON", T0001."VARNUMH", T0001."TIMESTAMP_FROM", T0001."KSCHL_SUPP", T0001."COND_GROUP_ID", T0001."MAINT_STATUS", T0001."CREATED_BY", T0001."SUPP_EXIST", T0001."SCALE_DIM", T0001."ITEM_CATEGORY" FROM "/1CN/C3DSAP00002" T0001)

DbSlExecute: rc = 99

(SQL error 1031)

error message returned by DbSl:

ORA-01031: insufficient privileges

(DB) INFO: disconnected from DB

D:\usr\sap\CRU\SYS\exe\uc\NTI386\R3load.exe: job finished with 1 error(s)

D:\usr\sap\CRU\SYS\exe\uc\NTI386\R3load.exe: END OF LOG: 20071024103506</b></i>

anyone seen this before and can help me out.

all connects r3trans r3load seem fine

all other 17 loads finisched succesfully except this last one.

Kind regards,

Peter

[vincentlim826]

Try to run the script sapdba_role.sql exactly as per note #134592 for ABAP schema_id, if helps.

[Former Member]

Hey,

This is an oracle issue,

The user of the sap installation tries to execute several commands, but it is missing authorizations:

1)

CREATE VIEW "/1CN/A3DSAP00002" ( "CLIENT" , "BEF_APPL" , "OBJTYPE" , "SRC_PROCESS_TYPE" , "SRC_ITEM_TYPE" , "KSCHL" , "OBJECT_ID" , "TIMESTAMP_TO" , "RELEASE_STATUS" , "KOPOS" , "CREATED_ON" , "VARNUMH" , "TIMESTAMP_FROM" , "KSCHL_SUPP" , "COND_GROUP_ID" , "MAINT_STATUS" , "CREATED_BY" , "SUPP_EXIST" , "SCALE_DIM" , "ITEM_CATEGORY" ) AS SELECT T0001."CLIENT", T0001."BEF_APPL", T0001."OBJTYPE", T0001."SRC_PROCESS_TYPE", T0001."SRC_ITEM_TYPE", T0001."KSCHL", T0001."OBJECT_ID", T0001."TIMESTAMP_TO", T0001."RELEASE_STATUS", T0001."KOPOS", T0001."CREATED_ON", T0001."VARNUMH", T0001."TIMESTAMP_FROM", T0001."KSCHL_SUPP", T0001."COND_GROUP_ID", T0001."MAINT_STATUS", T0001."CREATED_BY", T0001."SUPP_EXIST", T0001."SCALE_DIM", T0001."ITEM_CATEGORY" FROM "/1CN/C3DSAP00002" T0001)

DbSlExecute: rc = 99

(SQL error 1031)

error message returned by DbSl:

ORA-01031: insufficient privileges

2)

DbSl Trace: ORA-1403 when accessing table SAPUSER

in order to solve the problem, please all the proper authorization in the ORACLE db.