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