Skip to Content
0
Former Member
Nov 08, 2006 at 12:17 PM

Upgrade phase "SQLSCREXE_ALI_ORG" aborted with errors

51 Views

Hi ,

Need some assistance. Logged message with SAP AG, still waiting for response.Anyone that can assist will be appreciated. Error from logs.

/usr/sap/put/log# more SEDCORG.LOG

1 ETQ201XEntering upgrade-phase "SQLSCREXE_ALI_ORG" ("20061108125644")

2 ETQ366 Connect variables are set for shadow instance access

4 ETQ399 System-nr = '01', GwService = 'sapgw01'

4 ETQ399 Environment variables:

4 ETQ399 dbs_ora_schema=SAPR3

4 ETQ399 auth_shadow_upgrade=1

4 ETQ380 computing toolpath for request "TP_EXECDBSCRIPT_NEW"

4 ETQ381 request "TP_EXECDBSCRIPT_NEW" means "execdbscript with 46A feature"

4 ETQ382 translates to group "R3UP_TOOL_GROUP_NEW"

4 ETQ383 translates to path "exe"

4 ETQ383 translates to path "exe"

4 ETQ276 Executing SQL-script "ALORDC.XQL"

4 ETQ399 ext. env.: DIR_LIBRARY=/usr/sap/put/exe

4 ETQ399 ext. env.: LIBPATH=/usr/sap/put/exe:/usr/sap/BB1/sapjco:/usr/lib:/lib:/usr/sap/BB1/SYS/exe/run:/usr/java131

/jre/bin:/usr/java131/jre/bin/classic

4 ETQ399 2006/11/08 12:56:44: put_execute: (tp) forkpid:97258

2EETQ278 Errors during execution of SQL-script "ALORDC.XQL"

1EETQ203 Upgrade phase "SQLSCREXE_ALI_ORG" aborted with errors ("20061108125645")

-


Checked TPSQLSTD.OUT log

/usr/sap/put/log# more TPSQLSTD.OUT

BLOCKED SIGNALS: ''

SAPup> Starting subprocess 97258 at 20061108125644

ENV <0x2ff22d14>: dbms_type=ORA

ENV <0x2ff22d22>: dbs_ora_tnsname=BB1

ENV <0x2011c290>: dbs_ora_schema=SAPR3

ENV <0x2ff22d4b>: ORACLE_PSRV=BB1

ENV <0x2ff22d5b>: ORACLE_SID=BB1

ENV <0x2ff22d75>: ORACLE_HOME=/oracle/BB1/102_64

ENV <0x2ff22d94>: ORACLE_BASE=/oracle

ENV <0x2ff22da8>: ORA_NLS33=/oracle/client/92x_64/ocommon/nls/admin/data

ENV <0x2ff22ddf>: NLS_LANG=AMERICAN_AMERICA.US7ASCII

ENV <0x20147368>: DIR_LIBRARY=/usr/sap/put/exe

ENV <0x2014864c>: LIBPATH=/usr/sap/put/exe:/usr/sap/BB1/sapjco:/usr/lib:/lib:/usr/sap/BB1/SYS/exe/run:/usr/java131/j

re/bin:/usr/java131/jre/bin/classic

ENV <0x2011be90>: auth_shadow_upgrade=1

EXECUTING /usr/sap/put/exe/tp (tp) pf=/usr/sap/put/bin/EXDBNEW.TPP execdbscript BB1 -x ALORDC.XQL

This is /usr/sap/put/exe/tp version 370.00.09 (release 700)

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 DBNAME is no longer used.

Warning: Parameter DBHOST 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: 97258

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 97258 terminated with status 200

History : Original problem was related to environment variables for DIR_LIBRARY. Resolved that issue; UaGui was started as root and not the <sid>adm user. UaServer was started as correct user. Killed session and logged on as <sid>adm restarted UaGui as the correct user. Now this error comes up, SAPup won't allow me continue or retry

Replaced tp, r3trans and SAPup tools. Also when I run the cmd /usr/sap/put/exe/tp (tp) pf=/usr/sap/put/bin/EXDBNEW.TPP execdbscript BB1 -x ALORDC.XQL in a seperate session, it completes successfully and creates the necessary views as described in ALORDC.XQL. I checked the ALORDC.LOG to confirm this.

Kind Regards,

Ricky Padayachee