on 03-27-2016 12:45 PM
Hello, I am updating a SAP System (SAP EWM 9.2 - NW 7.40) with SUM SP16 - PL6. HDB Rev. 112.
In the Phase "PREP_INSTALL/DBCONNCHK_SHD" take this ERROR:
"
4 ETW000 R3trans version 6.25 (release 745 - 27.11.15 - 20:15:12).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 27.03.2016 - 13:30:22
4 ETW000 control file: <no ctrlfile>
4 ETW000 R3trans was called as follows: R3trans -x -w /SAPINST/fmv/ewx/SUM/abap/log/DBCONNCHKSHD.LOG
4 ETW000 trace at level 1 opened for a given file pointer
4 ETW000 [ dev trc,00000] Sun Mar 27 13:30:22 2016
4 ETW000 [ dev trc,00000] Loading DB library '/SAPINST/fmv/ewx/SUM/abap/exe/dbhdbslib.so' ...
4 ETW000 [ dev trc,00000] Library '/SAPINST/fmv/ewx/SUM/abap/exe/dbhdbslib.so' loaded
4 ETW000 [ dev trc,00000] Version of '/SAPINST/fmv/ewx/SUM/abap/exe/dbhdbslib.so' is "745.04", patchlevel (0.100)
4 ETW000 [ dev trc,00000] switch DBSL TRACE LEVEL from 3 to 1
4 ETW000 [ dev trc,00000] DBHDBSLIB : version 745.04, patch 0.100 (Make PL 0.100)
4 ETW000 [ dev trc,00000] HDB shared library (dbhdbslib) patchlevels (last 10)
4 ETW000 [ dev trc,00000] (0.100) SAP Support Package Stack Kernel 7.45 Patch Level 100 (note 2276394)
4 ETW000 [ dev trc,00000] (0.018) Describe on a decimal datatype with a large scale value (note 2220646)
4 ETW000 [ dev trc,00000] (0.013) Use connection variables instead of table M_CONNECTIONS (note 2207349)
4 ETW000 [ dev trc,00000] (0.008) Session variables processing via dbsl (note 2182777)
4 ETW000 [ dev trc,00000] (0.005) Substitute literals in select list (note 2182777)
4 ETW000 [ dev trc,00000] (0.004) Cancel FDA SQL statement (note 2177669)
4 ETW000 [ dev trc,00000]
4 ETW000 [ dev trc,00000] Loading SQLDBC client runtime ...
4 ETW000 [ dev trc,00000] SQLDBC Module : /usr/sap/EW1/hdbclient/libSQLDBCHDB.so
4 ETW000 [ dev trc,00000] SQLDBC Runtime : libSQLDBCHDB 1.00.112.00 Build 1457615240-1530
4 ETW000 [ dev trc,00000] SQLDBC client runtime is 1.00.112.00.1457615240
4 ETW000 [ dev trc,00000] Try to connect via secure store (UPGSHDKEY) on connection 0 ...
4 ETW000 [ dev trc,00000] no connection data found for key (UPGSHDKEY) in HANA secure store
4 ETW000 [ dev trc,00000] Try to connect via environment (localhost:7878) on connection 0 ...
4 ETW000 [dbhdbsql.cpp,00000] *** ERROR => Connect to database failed, rc=1, rcSQL=-10709
4 ETW000 [ dev trc,00000] SQLCODE : -10709
4 ETW000 [ dev trc,00000] SQLERRTEXT : Connection failed (RTE:[89006] System call 'connect' failed, rc=111:Connection refused (localhost:78\
4 ETW000 [ dev trc,00000] 78))
4 ETW000 [ dblink ,00000] ***LOG BY2=>sql error -10709 performing CON
4 ETW000 [ dblink ,00000] ***LOG BY0=>Connection failed (RTE:[89006] System call 'connect' failed, rc=111:Connection refused (localhost:7878))
2EETW169 no connect possible: "DBMS = HDB --- SERVER = '' PORT = ''"
"
This is the output of "hdbuserstore LIST"
"
DATA FILE : /home/ew1adm/.hdb/?????/SSFS_HDB.DAT
KEY FILE : /home/ew1adm/.hdb/?????/SSFS_HDB.KEY
KEY DEFAULT
ENV : ?????:34615
USER: SAPFRA
KEY UPGSHDKEY
ENV : ?????:34615
USER: SAPFRASHD
"
Can someone help?
Thanks.
Hello All,
I have also faced the same issues during upgrade.
Here is the solution.
Checking “hdbuserstore list” as sidadm will return both the keys for DEFAULT and SHADOW instance.
But running it by providing the full path of hdbclient “ /usr/sap/<SID>/hdbclient/hdbuserstore list” returns only the DEFAULT Key.
Created the SHADOW instance key by the below command.
/usr/sap/<SID>/hdbclient/hdbuserstore SET UPGSHDKEY <hana_instance_name>:3<instnace_nr>15 SAPSR3SHD <Password_that you have already provide for shadow instance>
Click on Next and the issue should get resolved.
Thanks and Regards,
Ramakanta
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Beate Ries, did you find a solution? I have same issue
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Beate,
Were you able to sort this problem?
Best regards
Rui
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi All,
Please see below note if you are moving from kernel lower than 740 to >740:
2154997 - Migration of hdbuserstore entries to ABAP SSFS.
Also see below notes :
1904826 - Upgrade error "Connect via SAPUSER not supported for kernel >=740 and 1639578 - SSFS as password store for primary database connect
Warm Regards,
Ajay Kalra
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Beate
I am facing the same problem during updating with SUM.
Did you solve this issue in the meantime?
Thanks and best regards
stefan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Check for RFC test for system update- ping and login test both.
Else try searching SAP Note with SQL return code 10709, with basis component (BC).
Thanks
Ravi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.