Symptom
During backup or recovery operations, errors similar to the following are reported:
general error: backup error: Snapshot operation failed for database(s) { 1: Failed to check consistency during readContent: inconsistent SSFS!, 3: Failed to check consistency during readContent: Inconsistent SSFS!}. SQLSTATE: HY000
Querying "SELECT * FROM sys_databases.m_securestore", returns entries with inconsistent root keys, for example:
;DATABASE_NAME;KEY_TYPE ;IS_CONSISTENT;RESET_COUNT;VERSION;IS_CURRENT
1;<DB_NAME> ;PERSISTENCE;FALSE ;0 ;0 ;TRUE
2;<DB_NAME> ;DPAPI ;FALSE ;0 ;0 ;TRUE
3;<DB_NAME> ;BACKUP ;FALSE ;0 ;0 ;TRUE
4;<DB_NAME> ;LOG ;FALSE ;0 ;0 ;TRUE
The command "distribute exec <HOST>:<DB_PORT> crypto ssfs getConsistency" shows:
Status of SSFS
Persistence Encryption:
Key: INCONSISTENT
Current Version: 1
Data Protection API:
Key: INCONSISTENT
Current Version: 1
Backup Encryption:
Key: INCONSISTENT
Current Version: 1
Log Encryption:
Key: INCONSISTENT
Current Version: 1
Root Keys Backup Password:
Root Keys Backup Password: consistent
Password Exists: 1
Read more...
Environment
- SAP HANA, platform edition 1.0
- SAP HANA, platform edition 2.0
Product
Keywords
SSFS, root key, master key, encryption, consistency, backup, recovery, SYSTEMDB, tenant database, hdbcons, resetConsistency, getConsistency , KBA , HAN-DB-SEC , SAP HANA Security & User Management , HAN-DB-BAC , SAP HANA Backup & Recovery , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview