Skip to Content
0
Former Member
Mar 27, 2016 at 11:45 AM

no connection data found for key (UPGSHDKEY) in HANA secure store

1099 Views

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.