An SAP S/4HANA server experienced an operating system crash and was subsequently forced to reboot. Following the restart, the HANA database instance was online and accessible via HANA Studio and the hdbsql command-line tool. However, exectuing R3trans -d resulted in a connection error, preventing the application layer from starting.

Diagnostic Steps

1. Attempting to start the SAP system using startsap indicated that the database was not reachable.

   erpqas:qasadm 77> startsap -c
   

2. Running the transport check tool revealed specific connection parameters were missing.

   erpqas:qasadm 58> R3trans -d
   

   Error Output:

   This is R3trans version 6.26 (release 773 - 02.05.19 - 20:19:01). unicode enabled version 2EETW169 no connect possible: "DBMS = HDB --- SERVER = '' PORT = ''" R3trans finished (0012).

3. Analyzing the trans.log (located in /home/qasadm) indicated that the secure user store could not be read and the connection attempt defaulted to localhost:7878, which was refused.

   4 ETW000 Try to connect via secure store (DEFAULT) on connection 0 ... 4 ETW000 no connection data found for key (DEFAULT) in HANA secure store 4 ETW000 Try to connect via environment (localhost:7878) on connection 0 ... 4 ETW000 SQLERRTEXT : Connection failed (RTE:[89006] System call 'connect' failed, rc=111:Connection refused (localhost:7878))

4. Checking the contents of the secure store confirmed the configuration was missing or corrupted.

   erpqas:qasadm 63> hdbuserstore list
   

   Error Output:

   Error 91009: Timeout acquiring the secure store access lock.

   A healthy output should resemble:

   KEY DEFAULT ENV : erpqas:31013 USER: SAPHANADB DATABASE: HAQ

Resolution

1. Remove Lock File: The error 91009 suggests a stale lock file. Remove it to regain access to the secure store.

   rm /home/qasadm/.hdb/erpqas/SSFS_HDB.LCK
   

2. Reconfigure Connection Key: Repopulate the secure store with the correct hostname, port, and credentials. Note that 31013 is the standard SQL port for the tenant and QHA is the tenant database name.

   erpqas:qasadm 68> hdbuserstore set DEFAULT erpqas:31013@QHA SAPHANADB Mypassword
   

3. Verify: Execute the transport check again to confirm the connection is established.

   erpqas:qasadm 70> R3trans -d
   

   Success Output:

   This is R3trans version 6.26 (release 773 - 02.05.19 - 20:19:01). unicode enabled version R3trans finished (0000).