2460799 - no connection data found for key (DEFAULT) in HANA secure store in wp traces but R3trans -d works

In your WP traces you find errors like:

C  Loading SQLDBC client runtime (pid=53932)...
C  SQLDBC Module  : /usr/sap/SID/D00/exe/hdbclient/libSQLDBCHDB.so
C  SQLDBC Runtime : libSQLDBCHDB 1.00.112.04 Build 1467296086-1530
C  SQLDBC client runtime is 1.00.112.04.1467296086
C
C  Try to connect via secure store (DEFAULT) on connection 0 ...
C  no connection data found for key (DEFAULT) in HANA secure store
C
C  Try to connect via environment (localhost:7878) on connection 0 ...
C  *** ERROR => Connect to database failed, rc=1, rcSQL=-10709
 [dbhdbsql.cpp 419]

But R3trans -d shows no error:

4 ETW000  [     dev trc,00000]  Loading SQLDBC client runtime (pid=54917)...
4 ETW000  [     dev trc,00000]  SQLDBC Module  : /usr/sap/SID/SYS/exe/uc/linuxx86_64/hdbclient/libSQLDBCHDB.so 
4 ETW000  [     dev trc,00000]  SQLDBC Runtime : libSQLDBCHDB 1.00.112.04 Build 1467296086-1530
4 ETW000  [     dev trc,00000]  SQLDBC client runtime is 1.00.112.04.1467296086
4 ETW000  [     dev trc,00000]  Try to connect via secure store (DEFAULT) on connection 0 ...
4 ETW000  [     dev trc,00000]  Attach to HDB : 1.00.112.04.1467296086 (fa/newdb100_rel)
4 ETW000  [     dev trc,00000]  fa/newdb100_rel : build_weekstone=0000.00.0
4 ETW000  [     dev trc,00000]  fa/newdb100_rel : build_time=2016-06-30 16:38:54
4 ETW000  [     dev trc,00000]  Database release is HDB 1.00.112.04.1467296086
4 ETW000  [     dev trc,00000]  INFO : Database 'SID/02' instance is running on 'swushows4h1'
4 ETW000  [     dev trc,00000]  INFO : Connect to DB as 'SAPHANADB', connection_id=349827
4 ETW000  [     dev trc,00000]  INFO : DATA AGING feature is supported by HANA
4 ETW000  [     dev trc,00000]  INFO : FDA feature is supported by HANA
4 ETW000  [     dev trc,00000]  INFO : FAE with FDA feature is supported by HANA
4 ETW000  [     dev trc,00000]  INFO : CACHEDVIEWTS feature is supported by HANA
4 ETW000  [     dev trc,00000]  INFO : DEFERRED LOB WRITING is activated
4 ETW000  [     dev trc,00000]  DB max. input host variables  : 32767
4 ETW000  [     dev trc,00000]  DB max. statement length      : 1000000000
4 ETW000  [     dev trc,00000]  DB max. array size            : 100000
4 ETW000  [     dev trc,00000]  use decimal precision as length
4 ETW000  [     dev trc,00000]  ABAPVARCHARMODE is used
4 ETW000  [     dev trc,00000]  use DBSL marker map
4 ETW000  [     dev trc,00000]  INFO : DBSL buffer size = 1048576
4 ETW000  [     dev trc,00000]  Command info enabled
4 ETW000  [     dev trc,00000]  Now I'm connected to HDB

also the check via hdbuserstore LIST shows an valid DEFAULT entry like:

hdbuserstore LIST
DATA FILE       : /home/sidadm/.hdb/hostname/SSFS_HDB.DAT
KEY FILE        : /home/sidadm/.hdb/hostname/SSFS_HDB.KEY

KEY DEFAULT
  ENV : hostname:30215
  USER: SAPHANADB

• Database: SAP HANA 112.04
• Product: S/4HANA 1610 (fully-activated)

hana, client, trans.log, R3trans -d, R3trans -x , KBA , HAN-DB-CLI , SAP HANA Clients (JDBC, ODBC) , HAN-DB , SAP HANA Database , Problem