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

[Former Member]

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.

[r_samal]

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

[Former Member]

Hi Beate Ries, did you find a solution?  I have same issue

[ruidesousa]

Hi Beate,

Were you able to sort this problem?

Best regards

Rui

[ajay_kalra2]

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

[stefanthomann]

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

[ruidesousa]

Hi Stefan,

Are you facing the same issue for this particular key or another one? If you run R3trans -d what is the result?

Best regards

Rui

[Former Member]

Hello Stefan have you found a solution for this?  I  have the same issue

[raviraj_sap]

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