Share via

SSAS : Errors in the metadata file - error trying to update cube in a system table 'DataSource'

Ricardo Castro 0 Reputation points
2023-01-11T19:12:32.4166667+00:00

0

A few days ago, we started having an error with the processing in our cube. The cube is being processed by the job and returns the error:

The following system error occurred: Invalid data. Failed to decrypt sensitive data. Possibly the encryption key does not match or is inaccessible due to improper service account change. The current operation was canceled because another operation on the transaction failed. (Microsoft.AnalysisServices.Core)

In this instance we have other cubes working correctly. We verified that this cube is the only one that does not have credentials. We've already tried to add the credentials by refreshing credentials and via the script, and for the first solution we don't have any errors, but it doesn't continue without changing anything. By the second solution we get the error:

Failed to encrypt sensitive data. Possibly the encryption key is inaccessible due to improper service account change. An error occurred while trying to update a row in a system table 'DataSource' in the metadata database.

Anyone have a similar error?

Thanks in advance.

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,248 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Seeya Xi-MSFT 16,451 Reputation points
    2023-01-12T06:41:55.6166667+00:00

    Hi Ricardo Castro,

    due to improper service account change

    Have you changed your SSAS service account recently?

    The database stores are encrypted using the account info and the same key is used for storing files when you process the cube.

    You can delete the Analysis Services database and re-process it.

    Follow these steps:

    1. Stop SSAS service
    2. Make backup of project: C:\Program Files\Microsoft SQL Server\MSAS10.MSSQLSERVER\OLAP\Data\MyProject.0.db
    3. Delete SSAS database.  So delete contents of C:\Program Files\Microsoft SQL Server\MSAS10.MSSQLSERVER\OLAP\Data\MyProject.0.db directory. 
    4. Copy 0.CryptKey.bin file from backup to C:\Program Files\Microsoft SQL Server\MSAS10.MSSQLSERVER\OLAP\Data\MyProject.0.db
    5. Start SSAS service and deplot/process your cube again using BID

    Here is the related and solved case for your reference:

    [https://social.msdn.microsoft.com/Forums/sqlserver/en-US/afcc5b55-8429-4eed-a3f1-30e735e41359/errors-in-the-encryption-library-failed-to-encrypt-sensitive-data-possibly-the-encryption-key-is?forum=sqldatamining

    Best regards

    Seeya Xi

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".