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

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.

Komal Sahu 311

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

Komal Sahu 311

This has resolved automatically after restarting the SSAS Server

Lukas Yu -MSFT 5,796 Reputation points

2020-08-26T08:27:51.38+00:00

It could be messed by some cached metadata. Thanks for the feedback.

Answer 2

Lukas Yu -MSFT 5,796

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

Komal Sahu 311 Reputation points

2020-08-18T05:31:58.597+00:00

Hi Lukas, Thanks for your response,

xmla script is very simple and general as below. Also it was running since long /years and did not change anything recently. If you can please help?
Komal Sahu 311 Reputation points

2020-08-18T05:34:32.243+00:00

Not able to post script
Komal Sahu 311 Reputation points

2020-08-18T05:36:47.967+00:00

<Synchronize xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<Source>
Komal Sahu 311 Reputation points

2020-08-18T05:37:01.6+00:00

<ConnectionString>Provider=MSOLAP.6;Data Source=XXXXXXSOURCESXX;Integrated Security=SSPI;Initial Catalog=ESS MOLAP ISSJMT</ConnectionString>
<Object>
<DatabaseID>ESS MOLAP ISSJMT</DatabaseID>
</Object>
</Source>
<SynchronizeSecurity>CopyAll</SynchronizeSecurity>
<ApplyCompression>true</ApplyCompression>
</Synchronize>
Lukas Yu -MSFT 5,796 Reputation points

2020-08-21T07:02:04.73+00:00

I think there should be some trigger event that makes this happen. Have you recently change account permission or install any updates ?

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.

1 additional answer

Activity