on 07-29-2014 7:00 AM
Hi ,
while performing the EHP7 upgrade during the extraction phase I faced below error.
Severe error(s) occurred in phase PREP_INPUT/SUMCHK!
Last error code set: tp failed with return code 232, check G:\SUM\abap\log\TPSQLSTD.OUT
I have tried implementing the below parameter disp+work is stopped
Env variable rsdb_ssfs_connect = 1
rsdb/ssfs_connect = 0
I have attached the TPSQLSTD log file below,Kindly share your inputs to fix above error.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
switch back to 721 kernel DISP+work is stopped , below was the trans.log details
Please share complete trans.log file for analysis.
Thanks,
Gaurav
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Gaurav,
I have tired above suggested option but it gives me error as shown below .
4 ETW000 [ D:/depot,00000] *** ERROR => Connect via SAPUSER not supported for kernel >= 740. 34 0.042353
4 ETW000 [ dev trc,00000] Only Secure Connect method possible. 16 0.042369
4 ETW000 [ dev trc,00000] DbSlConnect(con=-1) -> orc=0, 15=DBSL_ERR_UNSUPPORTED 40 0.042409
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=41=DBSL_CMD_RELINFO_GET) 30 0.042439
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=14=DBSL_CMD_VERSION_GET) 25 0.042464
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-
Hi Mohan,
If you want to use older version.
1905775 - SSFS connection is not working
For newer.
1904826 - Upgrade error "Connect via SAPUSER not supported for kernel >= 740"
Add env variable and parameter to profile.
Divyanshu
Hi Krishan,
Have a close look with logs
SAPup> Starting subprocess in phase 'SUMCHK' at 20140727092403
ENV: DBMS_TYPE=ora
ENV: NLS_LANG=AMERICAN_AMERICA.UTF8
ENV: ORACLE_HOME=C:\oracle\QEC\11203
ENV: ORACLE_SID=QEC
ENV: PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
ENV: PATH=D:\usr\sap\QEC\DVEBMGS00\exe;C:\oracle\QEC\11203\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;D:\usr\sap\QEC\SYS\exe\uc\NTAMD64
ENV: SAPDATA_HOME=F:\ORACLE\QEC
ENV: SAPSYSTEMNAME=QEC
ENV: dbs_ora_schema=SAPSR3
ENV: dbs_ora_tnsname=QEC
ENV: rsdb_ssfs_connect=1
EXECUTING D:\usr\sap\QEC\DVEBMGS00\exe\tp.EXE "pf=J:\SUM\abap\var\DEFAULT.TPP" execdbscript QEC -x ..\var\SMODILOGCHECK.XQL
This is D:\usr\sap\QEC\DVEBMGS00\exe\tp.EXE version 380.04.07 (release 720, unicode enabled)
TRACE-INFO: 1: [ dev trc,00000] Sun Jul 27 09:24:03 2014 2967 0.002967
TRACE-INFO: 2: [ dev trc,00000] DlLoadLib success: LoadLibrary("dboraslib.dll"), hdl 0, addr 000007FEE71F0000
TRACE-INFO: 3: 19 0.002986
TRACE-INFO: 4: [ dev trc,00000] using "D:\usr\sap\QEC\DVEBMGS00\exe\dboraslib.dll" 8 0.002994
TRACE-INFO: 5: [ dev trc,00000] -->DbSlControl(con=-1,cmd=47=DBSL_CMD_IMP_FUNS_SET) -> changed=30, tagset=1 350 0.003344
TRACE-INFO: 6: [ dev trc,00000] -->DbSlControl(con=-1,cmd=39=DBSL_CMD_SET_SINGLETASK) 13 0.003357
TRACE-INFO: 7: [ dev trc,00000] -->DbSlControl(con=-1,cmd=10=DBSL_CMD_DBCA_PTR_GET) 11 0.003368
TRACE-INFO: 8: [ dev trc,00000] -->DbSlControl(con=-1,cmd=10=DBSL_CMD_DBCA_PTR_GET) 12 0.003380
TRACE-INFO: 9: [ dev trc,00000] -->DbSlControl(con=-1,cmd=74=DBSL_CMD_CON_INFO_EXT_SUPPORT) -> rc=0=DBSL_ERR_OK, con_vers=0
TRACE-INFO: 10: 36 0.003416
As you are using kernel release 720.Parameter rsdb_ssfs_connect =1 will play role if you'll use kernel release higher than current.For use of SSFS try to upgrade kernel with the latest 740 or 741 and retry the phase again.
Regards,
Gaurav
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Gaurav,
I tried updating the 740 kernel D:\usr\sap\SID\SYS\exe\uc\NTAMD64 MMC shows red .
I switch back to 721 kernel DISP+work is stopped , below was the trans.log details
4 ETW000 [ dev trc,00000] read_ssfs_record(): deregister callback ssfs_dbi_trace 20 0.003100
4 ETW000 [dbcon.c ,00000] *** ERROR => Connect to R/3 failed. USERID and/or PASSWD could not be retrieved from SSFS
4 ETW000 35 0.003135
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=41=DBSL_CMD_RELINFO_GET) 31 0.003166
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=14=DBSL_CMD_VERSION_GET) 22 0.003188
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=50=DBSL_CMD_GET_PATCH_INFO) 22 0.003210
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=13=DBSL_CMD_VENDOR_NAME_GET) 36 0.003246
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=52=DBSL_CMD_GET_DBLIB_VERSION) 25 0.003271
4 ETW000 [ dev trc,00000] -> 'OCI_10201_SHARE, ' 32 0.003303
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'QEC'"
Hello
Do not put kernel 740 for the main system.
You need to setup SSFS by following the procedure mentioned in this SAP note
1639578 - SSFS as password storage for primary database connect
Once done restart the system and start the upgrade.
Regards
RB
Hi Mohan,
Under logs error
ORA-00942: table or view does not exist
is happening on .For the resolution please follow SAP Note 662644 - Composite SAP Note: ORA-00942
Regards,
Gaurav
Hi Mohan,
ORA-00942: table or view does not exist and rc=103=DBSL_ERR_DBOBJECT_UNKNOWN
Issue related with OPS$ users.For this please refer SAP Note 400241 - Problems with ops$ or sapr3 connect to Oracle
In addition try to update kernel 721 with the latest patch available.
Regards,
Gaurav
Hello Krishna
4 ETW000 [ dev trc,00000] Client NLS setting (by OCINlsGetInfo(con=0)): 'AMERICAN_AMERICA.UTF16'
4 ETW000 31 0.078499
4 ETW000 [ dev trc,00000] charset='UTF16', ncharset='AL16UTF16', UNI_ASC=FALSE 20 0.078519
4 ETW000 [ dev trc,00000] Connecting as SYSTEM/<pwd>@QEC on connection 0 (nls 0) ... (dbsl 721 140314, UNICODE[2])
Why is your SAP system trying to connect the database with the SYSTEM user ?
It should be connecting with the schema user which is SAPSR3 for your system.
Again, setup the SSFS as suggested in the SAP note.
Regards
RB
Hi Krishna,
Can you execute R3trans -d and share trans.log file.
Also, are you using SSFS?
Can you share more traces from log and temp folder.
Divyanshu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
7 | |
7 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.