Symptom
1. Application server throws an ST22 dump "DBSQL_CONNECTION_NO_METADATA".
dump_full_EN.txt:
"
Category External Error
Runtime Errors DBSQL_CONNECTION_NO_METADATA
Date and Time 00.00.0000 00:00:00
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
|Short Text |
| No metadata found for database connection "R/3*USAGE". |
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
|What happened? |
| The metadata for database connection "R/3*USAGE" could not be found due to |
| error 99 in the Database Shared Library (DBSL). |
----------------------------------------------------------------------------------------------------
...
----------------------------------------------------------------------------------------------------
|Database Interface Information |
----------------------------------------------------------------------------------------------------
|C|1|Try to connect via secure store (SERVICE) on connection 1 ... [/bas/785_REL/src/dbs/hdb/dbhdbs|
|C|1|connect property [APPLICATION = ABAP:***] [/bas/785_REL/src/dbs/hdb/dbhdbsql.cpp#1336] |
|C|1|connect property [APPLICATIONVERSION = 785 PL 50] [/bas/785_REL/src/dbs/hdb/dbhdbsql.cpp#1340]|
|C|1|connect property [APPLICATION_SERVER_INSTANCE_NAME = ***] [/bas/785_REL/src/dbs|
|C|1|connect property [APPLICATION_SERVER_WORKPROCESS_INDEX = 127] [/bas/785_REL/src/dbs/hdb/dbhdbs|
|C|1|connect property [KEY = DEFAULT] [/bas/785_REL/src/dbs/hdb/dbhdbsql.cpp#963] |
|C|1|connect property [UNICODE = 1] [/bas/785_REL/src/dbs/hdb/dbhdbsql.cpp#957] |
|C|1|connect property [SQLMODE = SAPR3] [/bas/785_REL/src/dbs/hdb/dbhdbsql.cpp#957] |
|C|1|connect property [VARCHARMODE = ABAP] [/bas/785_REL/src/dbs/hdb/dbhdbsql.cpp#957] |
|C|1|connect property [PACKETSIZE = 1048576] [/bas/785_REL/src/dbs/hdb/dbhdbsql.cpp#957] |
|C|1|connect property [COMPLETEARRAYEXECUTION = 1] [/bas/785_REL/src/dbs/hdb/dbhdbsql.cpp#957] |
|C|1|connect property [CACHEDVIEWTS = 1] [/bas/785_REL/src/dbs/hdb/dbhdbsql.cpp#957] |
|C|1|connect property [EMPTYTIMESTAMPISNULL = false] [/bas/785_REL/src/dbs/hdb/dbhdbsql.cpp#957] |
|C|1|connect property [SPATIALTYPES = 1] [/bas/785_REL/src/dbs/hdb/dbhdbsql.cpp#957] |
|C|1|connect property [STATEMENTROUTINGWARNINGS = TRUE] [/bas/785_REL/src/dbs/hdb/dbhdbsql.cpp#957]|
|C|E|Connect to database failed, rc=1, rcSQL=-10757 [/bas/785_REL/src/dbs/hdb/dbhdbsql.cpp#612] |
|C|1|SQLCODE : -10757 [/bas/785_REL/src/dbs/hdb/dbsdbtrc.cpp#617] |
|C|1|SQLERRTEXT : Secure store error: Interfaces/SecureStore/impl/SecureStore.cpp:536 - (91014) Fai|
|C|1| ure store. Failure reason: Unable to open "/home/<WRONGUSER>/.hdb/<HOSTNAME>/SSFS_HDB|
----------------------------------------------------------------------------------------------------
"
dump_raw.txt:
"
...
DB CEConnect to database failed, rc=1, rcSQL=-10757 [/bas/785_REL/src/dbs/hdb/dbhdbsql.cpp#612]
DB C1SQLCODE : -10757 [/bas/785_REL/src/dbs/hdb/dbsdbtrc.cpp#617]
DB C1SQLERRTEXT : Secure store error: Interfaces/SecureStore/impl/SecureStore.cpp:536 - (91014) Failed locking the sec\ [/bas/785_REL/src/dbs/hdb/dbsdbtrc.cpp#621]
DB C1 ure store. Failure reason: Unable to open "/home/<WRONGUSER>/.hdb/<HOSTNAME>/SSFS_HDB.LOC" for write [/bas/785_REL/src/dbs/hdb/dbsdbtrc.cpp#624]
"
2. In the error message, the username <WRONGUSER> in the path to the SAP HANA User Store (SAP KBA 3158257) is different from the <sid>adm Linux user, under which the SAP Application is running.
"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."
Read more...
Environment
- OS Linux
- SAP HANA, platform edition 1.0
- SAP HANA, platform edition 2.0
- SAP HANA Client
Product
Keywords
DBSQL_CONNECTION_NO_METADATA, -10757 , KBA , HAN-DB-CLI , SAP HANA Clients (JDBC, ODBC) , BC-OP-LNX , Linux , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.