File System Error - Errors in the metadata manager. Processing for the database will be disabled because an error occurred while loading the cube-user database cryptography key.

Question

SSAS DB Synchronization job is scheduled to synch using a XMLA script via SSIS. This synch the SSAS DB 'ESSJMT' from process server ( Source ) to Query Server(Destination). When it failed , server logged below error. And when I tried to run profiler traces, it captured only this error and nothing else.

"File system error: The following error occurred while opening the file '\?\F:\OLAP\Data\Credit-User-Cube.74.db\0.CryptKey.bin': The system cannot find the path specified. . Errors in the metadata manager. Processing for the database will be disabled because an error occurred while loading the 'Credit-Cube-User' database cryptography key. One possible reason for this error is that the service account has changed."

• The synch job which is throwing error is for SSAS DB 'ESSJMT'. And 'Credit User' cube ( shown in the error) is different cube under different SSAS DB 'Credit'. ESSJMT and Credit DB are under same SSAS instance/server. Even it is giving error , not sure why it is referring to another cube of other ssas DB.

Can someone please highlight why this issue may have been occurred or where I can check to understand this further?
Any help, comment , suggestion will be much appreciated.

Many Thanks

Answer 1

This has resolved automatically after restarting the SSAS Server

Answer 2

Hi,
What is the code in you xmla script ? Could it be something wrong within the script, that the other cube is mistakenly involved.