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 |
1. The data backup fails with error ” Inconsistent SSFS”
2. M_SECURESTORE view shows SSFS is inconsistent.
Below steps can be followed only if no data is encrypted so far.
(Be ready to run sql as soon as first step is executed)
1. Run command as root
2. Immediately run following sql (Before restart of HANA)
“ALTER SYSTEM SAVEPOINT”