Error in Extraction Phase PREP_INPUT/SQLDB_LIST_AVERS during Ehp6 update
Hello Experts,
I am doing an update of ECC 6.0 from EHP2 to EHP6 in AIX 6.1 with Oracle 11.2.0.3 through SUM Tool (version 01_SP06).
We are getting an error in Extraction Phase PREP_INPUT/SQLDB_LIST_AVERS.
FYI, we have updated the latest version of dboraslib, tp, dw on the source as the kernel is already updated to the latest level 410.
And also we have updated the latest version of tp, sapcpe for target kernel in /usr/sap/MX2/SUM/abap/exe. But still getting the same error.
Error message in SUM is as below.
“Severe error(s) occurred in Phase PREP_INPUT/ SQLDB_LIST_AVERS.
Last error code set: tp failed with return code 249, check /usr/sap/<SID>/SUM/abap/log/TPSQLSTD.OUT”
Please find the below error log.
- TPSQLSTD.OUT log:
Starting subprocess with PID 9109510 at 20130103204939
ENV: DIR_LIBRARY=/usr/sap/<SID>/SYS/exe/run
ENV: JAVA_HOME=/usr/java14_64
ENV: LIBPATH=/usr/sap/<SID>/SYS/exe/run:/usr/sap/<SID>/SUM/jvm/jre/lib/ppc64/server:/usr/sap/<SID>/SUM/jvm/jre/lib/ppc64:/usr/sap/<SID>/SUM/jvm/jre/../lib/ppc64:/usr/sap/<SID>/SUM/jvm/jre/lib/ppc64/jli:/usr/sap/<SID>/SUM/jvm/jre/../lib/ppc64/jli:/usr/lib:/lib:/oracle/client/10x_64/instantclient
ENV: NLS_LANG=AMERICAN_AMERICA.UTF8
ENV: ORACLE_BASE=/oracle
ENV: ORACLE_SID=<SID>
ENV: PATH=/usr/sap/<SID>/SYS/exe/run:/usr/java14_64/bin:/home/<sid>adm:/usr/bin:/etc:/usr/sbin:/usr/ucb:/home/<sid>adm/bin:/usr/bin/X11:/sbin:.
ENV: SAPDATA_HOME=/oracle/<SID>
ENV: SAPSYSTEMNAME=<SID>
ENV: auth_shadow_upgrade=0
ENV: dbms_type=ORA
ENV: dbs_ora_schema=SAPSR3
ENV: dbs_ora_tnsname=<SID>
EXECUTING /usr/sap/<SID>/SYS/exe/run/tp pf=/usr/sap/<SID>/SUM/abap/var/DEFAULT.TPP execdbscript <SID> -x ../var/SQLDBSCRIPT.TQL
This is tp version 380.04.12 (release 720, unicode enabled)
Warning: Parameter DBCONFPATH is no longer used.
tp finished with return code: 0
meaning:
Everything OK
SAPup> Starting subprocess with PID 9109514 at 20130103204946
ENV: DIR_LIBRARY=/usr/sap/<SID>/SYS/exe/run
ENV: JAVA_HOME=/usr/java14_64
ENV: LIBPATH=/usr/sap/<SID>/SYS/exe/run:/usr/sap/<SID>/SUM/jvm/jre/lib/ppc64/server:/usr/sap/<SID>/SUM/jvm/jre/lib/ppc64:/usr/sap/<SID>/SUM/jvm/jre/../lib/ppc64:/usr/sap/<SID>/SUM/jvm/jre/lib/ppc64/jli:/usr/sap/<SID>/SUM/jvm/jre/../lib/ppc64/jli:/usr/lib:/lib:/oracle/client/10x_64/instantclient
ENV: NLS_LANG=AMERICAN_AMERICA.UTF8
ENV: ORACLE_BASE=/oracle
ENV: ORACLE_SID=<SID>
ENV: PATH=/usr/sap/<SID>/SYS/exe/run:/usr/java14_64/bin:/home/<sid>adm:/usr/bin:/etc:/usr/sbin:/usr/ucb:/home/<sid>adm/bin:/usr/bin/X11:/sbin:.
ENV: SAPDATA_HOME=/oracle/<SID>
ENV: SAPSYSTEMNAME=<SID>
ENV: auth_shadow_upgrade=0
ENV: dbms_type=ORA
ENV: dbs_ora_schema=SAPSR3
ENV: dbs_ora_tnsname=<SID>
EXECUTING /usr/sap/<SID>/SYS/exe/run/tp pf=/usr/sap/<SID>/SUM/abap/var/DEFAULT.TPP execdbscript <SID> -x ../var/CVERSDUMP.TQL
This is tp version 380.04.12 (release 720, unicode enabled)
Warning: Parameter DBCONFPATH is no longer used.
tp finished with return code: 0
meaning:
Everything OK
SAPup> Starting subprocess with PID 7929910 at 20130103211755
ENV: DIR_LIBRARY=/usr/sap/<SID>/SUM/abap/exe
ENV: JAVA_HOME=/usr/java14_64
ENV: LIBPATH=/usr/sap/<SID>/SUM/abap/exe:/usr/sap/<SID>/SUM/jvm/jre/lib/ppc64/server:/usr/sap/<SID>/SUM/jvm/jre/lib/ppc64:/usr/sap/<SID>/SUM/jvm/jre/../lib/ppc64:/usr/sap/<SID>/SUM/jvm/jre/lib/ppc64/jli:/usr/sap/<SID>/SUM/jvm/jre/../lib/ppc64/jli:/usr/lib:/lib:/usr/sap/<SID>/SYS/exe/run:/oracle/client/10x_64/instantclient
ENV: NLS_LANG=AMERICAN_AMERICA.UTF8
ENV: ORACLE_BASE=/oracle
ENV: ORACLE_SID=<SID>
ENV: PATH=/usr/sap/<SID>/SUM/abap/exe:/usr/java14_64/bin:/home/<sid>adm:/usr/sap/<SID>/SYS/exe/run:/usr/bin:/etc:/usr/sbin:/usr/ucb:/home/<sid>adm/bin:/usr/bin/X11:/sbin:.
ENV: SAPDATA_HOME=/oracle/<SID>
ENV: SAPSYSTEMNAME=<SID>
ENV: auth_shadow_upgrade=0
ENV: dbms_type=ORA
ENV: dbs_ora_schema=SAPSR3
ENV: dbs_ora_tnsname=<SID>
EXECUTING /usr/sap/<SID>/SUM/abap/exe/tp pf=/usr/sap/<SID>/SUM/abap/var/DEFAULT.TPP execdbscript <SID> -x ../var/SQLDBSCRIPT.TQL
This is tp version 380.04.12 (release 720, unicode enabled)
ERROR: No connect due to DbSl Load Lib Failure
ERROR: The values set for DIR_LIBRARY ('/usr/sap/<SID>/SUM/abap/exe') or dbms_type ('ORA') are invalid.
ERROR: Connect to <SID> failed (20130103211755).
Warning: Parameter DBCONFPATH is no longer used.
TRACE-INFO: 1: [ dev trc,00000] Thu Jan 3 21:17:55 2013 87306 0.087306
TRACE-INFO: 2: [ dlux.c ,00000] *** ERROR => DlLoadLib()==DLENOACCESS - dlopen("/usr/sap/<SID>/SUM/abap/exe/dboraslib.o") FAILED
TRACE-INFO: 3: " 0509-130 Symbol resolution failed for /usr/sap/<SID>/SUM/abap/exe/dboraslib.o because:
TRACE-INFO: 4: 0509-136 Symbol strcat (number 175) is not exported from 26 0.087332
TRACE-INFO: 5: dependent module /oracle/client/10x_64/instantcli" (errno=8,Exec format error)
tp returncode summary:
TOOLS: Highest return code of single steps was: 0
ERRORS: Highest tp internal error was: 0249
tp finished with return code: 249
meaning:
connect failed due to DbSL load lib failure
SAPup> Process with PID 7929910 terminated with status 249 at 20130103211755!
SAPup> Starting subprocess with PID 12583040 at 20130103211804
ENV: DIR_LIBRARY=/usr/sap/<SID>/SUM/abap/exe
ENV: JAVA_HOME=/usr/java14_64
ENV: LIBPATH=/usr/sap/<SID>/SUM/abap/exe:/usr/sap/<SID>/SUM/jvm/jre/lib/ppc64/server:/usr/sap/<SID>/SUM/jvm/jre/lib/ppc64:/usr/sap/<SID>/SUM/jvm/jre/../lib/ppc64:/usr/sap/<SID>/SUM/jvm/jre/lib/ppc64/jli:/usr/sap/<SID>/SUM/jvm/jre/../lib/ppc64/jli:/usr/lib:/lib:/usr/sap/<SID>/SYS/exe/run:/oracle/client/10x_64/instantclient
ENV: NLS_LANG=AMERICAN_AMERICA.UTF8
ENV: ORACLE_BASE=/oracle
ENV: ORACLE_SID=<SID>
ENV: PATH=/usr/sap/<SID>/SUM/abap/exe:/usr/java14_64/bin:/home/<sid>adm:/usr/sap/<SID>/SYS/exe/run:/usr/bin:/etc:/usr/sbin:/usr/ucb:/home/<sid>adm/bin:/usr/bin/X11:/sbin:.
ENV: SAPDATA_HOME=/oracle/<SID>
ENV: SAPSYSTEMNAME=<SID>
ENV: auth_shadow_upgrade=0
ENV: dbms_type=ORA
ENV: dbs_ora_schema=SAPSR3
ENV: dbs_ora_tnsname=<SID>
EXECUTING /usr/sap/<SID>/SUM/abap/exe/tp pf=/usr/sap/<SID>/SUM/abap/var/DEFAULT.TPP execdbscript <SID> -x ../var/SQLDBSCRIPT.TQL
This is tp version 380.04.12 (release 720, unicode enabled)
ERROR: No connect due to DbSl Load Lib Failure
ERROR: The values set for DIR_LIBRARY ('/usr/sap/<SID>/SUM/abap/exe') or dbms_type ('ORA') are invalid.
ERROR: Connect to <SID> failed (20130103211804).
Warning: Parameter DBCONFPATH is no longer used.
TRACE-INFO: 1: [ dev trc,00000] Thu Jan 3 21:18:04 2013 6543 0.006543
TRACE-INFO: 2: [ dlux.c ,00000] *** ERROR => DlLoadLib()==DLENOACCESS - dlopen("/usr/sap/<SID>/SUM/abap/exe/dboraslib.o") FAILED
TRACE-INFO: 3: " 0509-130 Symbol resolution failed for /usr/sap/<SID>/SUM/abap/exe/dboraslib.o because:
TRACE-INFO: 4: 0509-136 Symbol strcat (number 175) is not exported from 24 0.006567
TRACE-INFO: 5: dependent module /oracle/client/10x_64/instantcli" (errno=8,Exec format error)
tp returncode summary:
TOOLS: Highest return code of single steps was: 0
ERRORS: Highest tp internal error was: 0249
tp finished with return code: 249
meaning:
connect failed due to DbSL load lib failure
SAPup> Process with PID 12583040 terminated with status 249 at 20130103211804!
Best Regards,
Shashanka