Skip to Content
0
Former Member
Jan 20, 2010 at 02:04 PM

Upgrade stuck at MAIN_SHDINST/SQLSCREXE_ALI_ORG , retuern code ORA 1403

68 Views

The Upgrade is stuck at step MAIN_SHDINST/SQLSCREXE_ALI_ORG, in the Pre Processing phase , Now we are facing a different return code ORA 1403. It is the same step which caused problems , just the return codes keep changing

The shadow system directories are created and SAP Shadow system is trying to login to Database , which is throwing the error .

Below is the message in log file

-


0.076796

TRACE-INFO: 75: [dev trc ,00000] OCIStmtExecute() completed, rc=100=OCI_NO_DATA, no further data 465 0.077261

TRACE-INFO: 76: [dev trc ,00000] -> rc=1403=OCI_ERR_NOT_FOUND 9 0.077270

TRACE-INFO: 77: [dev trc ,00000] <--oci_execute_stmt(rc=1403, iters-errors = 1-0) [time 0,000s] 17 0.077287

TRACE-INFO: 78: [dbsloci. ,00000] *** ERROR => ORA-1403 when accessing table SAPUSER 17 0.077304

TRACE-INFO: 79: [dev trc ,00000] set_ocica() -> SQL code 1403 9 0.077313

TRACE-INFO: 80: [dev trc ,00000] -->oci_get_errmsg (con_hdl=0, rc=1403) 9 0.077322

TRACE-INFO: 81: [dev trc ,00000] OCIErrorGet -> SQL error code: 1403 30 0.077352

TRACE-INFO: 82: [dev trc ,00000] ORA-01403: no data found

TRACE-INFO: 83: 13 0.077365

TRACE-INFO: 84: [dev trc ,00000] Disconnecting from connection 0 ...

-


This is Sandbox system copied from Production , so the SAP schema ID owner in Database is SAPCRM .

The DBSID ,SAPSID are CMG .dbs_ora_schema is set to SAPCRM

I have checked the note 400241 and done checks