Unable to log the exception to the database Please create a master key in the database or open the master key in the session before performing this operation.

(0) Share

Report

Posted on by AngelAX

245

Good Day

I am trying to rebuild the data mart and receive this error during configuration of AX Data mart

Unable to log the exception to the database Please create a master key in the database or open the master key in the session before performing this operation.

The 'DecryptData' procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead. Originating procedure: DecryptData.
Unable to log the exception to the database
Machine: Servername

I know the key and I have run the following command to open:

OPEN MASTER KEY DECRYPTION BY PASSWORD = 'password'

and ran the config process again, only to receive the same message.

Please assist.

Regards

AngelAX

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello AngelAX,

Please have a look at the following post and the solution suggested there

sdhruva.wordpress.com/.../management-reporter-the-operation-could-not-be-completed-due-to-a-failure-on-the-server

Would be great if you could check this and let us know if this fixes your issue.

Best regards,

Ludwig

Was this reply helpful? Yes No