SAP Knowledge Base Article - Preview

3668093 - SSFS Root Keys and Master Keys Are Inconsistent

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

SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0

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.