This blog explains the steps to make the Secure store File system ( SSFS ) consistent with database, if it is inconsistent in a fresh HANA One instance.
How to check if your HANA system has inconsistent SSFS
Check the view M_SECURESTORE for IS_CONSISTENT column for persistence and DPAPI
Select * from SYS.M_SECURESTORE
KEY_TYPE | IS_CONSISTENT | RESET_COUNT |
+---------------+---------------+-------------+
| | | |
| "PERSISTENCE" | "FALSE" | 0 |
| | | |
| "DPAPI" | "FALSE" | 0 |
Symptoms:
1. The data backup fails with error " Inconsistent SSFS"
2. M_SECURESTORE view shows SSFS is inconsistent.
Prerequisites :
Below steps can be followed only if no data is encrypted so far.
Remedy:
(Be ready to run sql as soon as first step is executed)
1. Run command as root
/root/hanaone/scripts/resetSSFSConsistency.sh
2. Immediately run following sql (Before restart of HANA)
“ALTER SYSTEM SAVEPOINT”
