Sage 200 BI - Problem updating cubes for company... (Errors in the encryption library)
Description

Internal only: *** Do not amend this article via KCS ***.

When updating a BI cube, you may see the error message:

Problem updating cubes for company 'XXX':

Errors in the encryption library: Failed to encrypt sensitive data. Possibly the encryption key is inaccessible because of improper service account change.

Cause
Resolution

This is due to the database settings on Analysis Services on SQL Server. The message will appear of something has changed on the database so that it no longer allows overwrites. If the Logon account for the SQL Server Analysis Services instance is changed after creating the database, the stored key is unusable for encrypting your cube data.

To solve this, you must delete the company and Analysis services database and create a new data warehouse, or:

  1. Stop the SQL Server Analysis Service.

  2. Take a backup of the project: C:\Program Files\Microsoft SQL Server\MSAS10.MSSQLSERVER\OLAP\Data\MyProject.0.db

  3. Delete the Analysis Services database, i.e. delete the contents of C:\Program Files\Microsoft SQL Server\MSAS10.MSSQLSERVER\OLAP\Data\MyProject.0.db directory.

  4. Copy 0.CryptKey.bin file from your backup, to C:\Program Files\Microsoft SQL Server\MSAS10.MSSQLSERVER\OLAP\Data\MyProject.0.db

  5. Start SQL Server Analysis Services.

You will be able to process your BI cubes from the BI System Administrator.

Steps to duplicate
Related Solutions