Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

ora-1031 during sapinst creating views

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

Former Member
Not what you were looking for? View more on this topic or Ask a question