3495702 - Secure store error: (91014) Failed locking the secure store. Failure reason: Unable to open SSFS_HDB.LOC for write.

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."

• OS Linux
• SAP HANA, platform edition 1.0
• SAP HANA, platform edition 2.0
• SAP HANA Client

DBSQL_CONNECTION_NO_METADATA, -10757 , KBA , HAN-DB-CLI , SAP HANA Clients (JDBC, ODBC) , BC-OP-LNX , Linux , Problem