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

SAP Knowledge Base Article - Preview

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

Symptom

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


Read more...

Environment

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

Product

SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0

Keywords

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.