Hdbuserstore Set Hana 2.0
Feb 02, 2018 To address this, you can set the hostname with which HANA registers to the SLD using the parameter SLDSYSTEMHOME in the SAP HANA DEFAULT.PFL. For case 1: The recommended value is the external HANA hostname as known by the ABAP system that is using this HANA DB This parameter is the SAPDBHOST parameter in ABAP. The connexion will fail if the sap hana user attached to that secured-key has been dropped. The Secured-key is not valid anymore. The hana user has to be recreated as well as the user secured-key.
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
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
Hdbuserstore Set Hana 2.0 2017
Visit SAP Support Portal's SAP Notes and KBA Search.