3554571 - Schema User Deactivated and System Errors Following Tenant DB Restore

Post-restore of the Tenant DB system, the following issues are observed:

• USERNAME-PASSWORD and SYS_XS_RUNTIME users are frequently locked permanently, as indicated in system traces:
  [2676218]{-1}[20/63012603318] 2024-12-13 21:51:22.271218 e Authentication catalog_authmgr.cc(00903) : user SYS_XS_RUNTIME is locked forever [2676081]{-1}[23/63012613600] 2024-12-13 21:51:22.661839 e Authentication catalog_authmgr.cc(00903) : user SYS_XS_RUNTIME is locked forever
• Missing or inconsistent Secure Store File System (SSFS) keys:
  [2601419]{-1}[12/-1] 2024-12-13 21:51:19.028011 w Crypto RootKeyStoreConsistencyChecker.cpp(00164) : SSFS key of type/version Redo log/0 is inconsistent
• Errors preventing recovery of logs during the system start:
  [2677042]{-1}[-1/-1] 2024-12-13 21:50:50.025659 e Logger RecoveryHandlerImpl.cpp(02673) : Missing log, cannot recover starting from 0x75a15764ec3, restart pos 0x75a15764f00
• Services like xscontroller, xsexecagent, and asusaaserver are stopped.

SAP HANA DB Version 2.0

Tenant DB, Restore, Schema, User Lock, SSFS Inconsistencies , KBA , HAN-DB-BAC , SAP HANA Backup & Recovery , HAN-DB-SEC , SAP HANA Security & User Management , Problem