Skip to Content

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”

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

Leave a Reply