Upgrade stuck at MAIN_SHDINST/SQLSCREXE_ALI_ORG , retuern code ORA 1403

[Former Member]

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

[Former Member]

This is was fixed . the main problem was having different DB Schema name than DB SID and the OPS$ mechanism problem . We ahd to reset the upgrade and reastart it .

As the log files were nto picking up the latest changes made in Database .

thanks

Prasanna

[JPReyes]

ORA-1403 when accessing table SAPUSER

That seems to be an issue with the OPS$ user in the shadow system ...

Read Note 400241

Regards

Juan

[Former Member]

Yes , we have implemented that Note .

Now we get a different error . Dont know if this is related .

sscrm002:cmgadm 28> more TPSQLSTD.OUT

BLOCKED SIGNALS: ''

SAPup> Starting subprocess 10674204 at 20100120084118

ENV: DIR_LIBRARY=/usr/sap/CMG/upg/abap/exe

ENV: JAVA_HOME=/usr/java14_64

ENV: LIBPATH=/usr/sap/CMG/upg/abap/exe:/usr/sap/CMG/upg/jvm/jre/lib/ppc64/server:/usr/sap/CMG/upg/jvm/jre/lib/ppc64:/usr/sap/CMG/upg/jvm/jre/../lib/ppc64:/usr

/lib:/lib:/usr/sap/CMG/SYS/exe/run:/oracle/client/10x_64/instantclient

ENV: NLS_LANG=AMERICAN_AMERICA.WE8DEC

ENV: ORACLE_BASE=/oracle

ENV: ORACLE_HOME=/oracle/CMG/102_64

ENV: ORACLE_PSRV=CMG

ENV: ORACLE_SID=CMG

ENV: PATH=/usr/sap/CMG/upg/abap/exe:/oracle/CMG/102_64/bin:.:/home/cmgadm:/usr/sap/CMG/SYS/exe/run:/usr/bin:/etc:/usr/sbin:/usr/ucb:/usr/bin/X11:/sbin:/usr/ja

va14/jre/bin:/usr/java14/bin:/usr/bin:/etc:/usr/sbin:/usr/ucb:/home/cmgadm/bin:/usr/bin/X11:/sbin:/usr/java14_64:.

ENV: SAPSYSTEMNAME=CMG

ENV: auth_shadow_upgrade=1

ENV: dbms_type=ORA

ENV: dbs_ora_schema=SAPCRM

ENV: dbs_ora_tnsname=CMG

EXECUTING /usr/sap/CMG/upg/abap/exe/tp (/usr/sap/CMG/upg/abap/exe/tp) pf=/usr/sap/CMG/upg/abap/bin/EXDBNEW.TPP execdbscript CMG -x ALORDC.XQL

This is /usr/sap/CMG/upg/abap/exe/tp version 372.04.65 (release 701)

Warning: Parameter INTERRUPT is no longer used.

Warning: Parameter DAYLIGHT_SHUTDOWN is no longer used.

Warning: Parameter WITH_TACOB is no longer used.

Warning: Parameter IMPDP_BY_EVENT is no longer used.

Warning: Parameter INTERRUPT is no longer used.

Warning: Parameter DAYLIGHT_SHUTDOWN is no longer used.

Warning: Parameter WITH_TACOB is no longer used.

Warning: Parameter IMPDP_BY_EVENT is no longer used.

Warning: Parameter DBCONFPATH is no longer used.

2EETP000 sap_dext called with msgnr "2":

2EETP000 -

---

db call info -

---

2EETP000 function: db_ntab

2EETP000 fcode: NT_RDTDESCR

2EETP000 tabname: TADIR

2EETP000 len: 5

2EETP000 key: TADIR

2EETP000 retcode: 2

1AETP000 exit in function texitnow

ERROR: EXIT(16) -> process ID is: 10674204

tp returncode summary:

TOOLS: Highest return code of single steps was: 16

ERRORS: Highest tp internal error was: 0200

tp finished with return code: 200

meaning:

ERROR: see tp's stdout (Standard Out may not be available)

Process with ID 10674204 terminated with status 200

[markus_doehr2]

> 2EETP000 sap_dext called with msgnr "2":

> 2EETP000 -

---

db call info -

---

> 2EETP000 function: db_ntab

> 2EETP000 fcode: NT_RDTDESCR

> 2EETP000 tabname: TADIR

> 2EETP000 len: 5

> 2EETP000 key: TADIR

> 2EETP000 retcode: 2

> 1AETP000 exit in function texitnow

Try

Note 534765 - db connect fails because of wrong db schema in environment

Markus

[Former Member]

Checked this Note . The ENV value is set to SAPCRM , and table owner is also SAPCRM .

According to another SDN post , i put the latest kernel release of the target system into the exe,exenew sub directory of upgarde directory .

Now i get this error , the ORA errors are gone .

ERROR: EXIT(16) -> process ID is: 10723570

1. Phase SQLSCREXE_ALI_ORG:

ERROR: No connect due to DbSl Load Lib Failure

ERROR: The values set for DIR_LIBRARY ('/usr/sap/CMG/upg/abap/exe') or dbms_type ('ORA') are invalid.

ERROR: Connect to CMG failed (20100120110609).

1. Phase SQLSCREXE_ALI_ORG:

ERROR: No connect due to DbSl Load Lib Failure

ERROR: The values set for DIR_LIBRARY ('/usr/sap/CMG/upg/abap/exe') or dbms_type ('ORA') are invalid.

ERROR: Connect to CMG failed (20100120110715).

1. Phase SQLSCREXE_ALI_ORG:

2EETP000 sap_dext called with msgnr "2":

2EETP000 -

---

db call info -

---

2EETP000 function: db_ntab

2EETP000 fcode: NT_RDTDESCR

2EETP000 tabname: TADIR

2EETP000 len: 5

2EETP000 key: TADIR

2EETP000 retcode: 2

1AETP000 exit in function texitnow

ERROR: EXIT(16) -> process ID is: 11538632

1. Phase SQLSCREXE_ALI_ORG:

2EETP000 sap_dext called with msgnr "2":

2EETP000 -

---

db call info -

---

2EETP000 function: db_ntab

2EETP000 fcode: NT_RDTDESCR

2EETP000 tabname: TADIR

2EETP000 len: 5

2EETP000 key: TADIR

2EETP000 retcode: 2

1AETP000 exit in function texitnow

[markus_doehr2]

> According to another SDN post , i put the latest kernel release of the target system into the exe,exenew sub directory of upgarde directory .

Did you exchange all of the necessary files:

SAPEXE

SAPEXEDB

igsexe_*

DBATLS_700*

> Now i get this error , the ORA errors are gone .

>

>

> ERROR: EXIT(16) -> process ID is: 10723570

> ### Phase SQLSCREXE_ALI_ORG:

> ERROR: No connect due to DbSl Load Lib Failure

> ERROR: The values set for DIR_LIBRARY ('/usr/sap/CMG/upg/abap/exe') or dbms_type ('ORA') are invalid.

> ERROR: Connect to CMG failed (20100120110609).

> ### Phase SQLSCREXE_ALI_ORG:

> ERROR: No connect due to DbSl Load Lib Failure

> ERROR: The values set for DIR_LIBRARY ('/usr/sap/CMG/upg/abap/exe') or dbms_type ('ORA') are invalid.

> ERROR: Connect to CMG failed (20100120110715).

The system can't read the database interface libraries (lib_dbsl*).

Markus