web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Supply chain | Supply Chain Management, Commerce / The required data encr...
Supply chain | Supply Chain Management, Commerce
Suggested Answer

The required data encryption certificate was not found when trying to edit the Database

(1) ShareShare
ReportReport
Posted on by AR-01121610-0 4,967 Moderator

We have deployed a Database Backup (bak) from one environment to another without using the detailed description we found later here

As we download retail data with distribution plan to channel we get this error:   

<Data Name="errorMessage">Microsoft.Dynamics.Ax.Xpp.ErrorException: The required data encryption certificate was not found when trying to edit the Database connection profile table and the ConnectionString field. Please add a valid certificate. Microsoft.Dynamics.Ax.Xpp.Security.CryptoEncryptionException: Encryption error occured with exception: Microsoft.Dynamics.Ax.Xpp.Security.CryptoEncryptionException: Encryption error occured with exception: Microsoft.Dynamics.AX.Configuration.CertificateHandler.NoCertificateFoundException: No certificate found for id 'BE78AE7782EBBAC00EC65C5652557D0D251F8A31'. at Microsoft.Dynamics.AX.Configuration.CertificateHandler.CertificateHandlerBase.GetCertificateFromLocalStore(X509FindType findType, String findValue) at Microsoft.Dynamics.AX.Configuration.CertificateHandler.CertificateHandlerBase.GetFirstCertificateForId(String id) at Microsoft.Dynamics.Ax.Xpp.Security.CryptoEncryptionEngine.GetCryptoServiceProviderByThumbprintBuffer(String idList, Byte[] thumbprint) ---> Microsoft.Dynamics.AX.Configuration.CertificateHandler.NoCertificateFoundException: No certificate found for id 'BE78AE7782EBBAC00EC65C5652557D0D251F8A31'. at ...

In the target envioronment where the error occurs a data encryption certificate is present, but the thumbprint is another one than this one is used here from D365Retail. 

How to get this running again ?

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,194 Super User 2025 Season 2 on at

    Hi Andreas,

    I have moved your question to the Commerce forum. Not sure if the documentation can help you with the post steps: docs.microsoft.com/.../import-database

  • Suggested answer
    Ramune Profile Picture
    Ramune on at

    Hi Andreas,

    I will leave this for the community to answer. Let's see if anybody has experienced the same and can advise for you anything. If you will not get any feedback, please create a support ticket for us.

  • Peter Ramer Profile Picture
    Peter Ramer 65 on at

    After you deploy a databack backup you need to apply an update in lcs called 'Environment Reprovisioning Tool'.  To do this, login to lcs.dynamics.com, click on the hamburger (three lines) at the top and select 'asset library'.  Go to the 'Software deployable package' tab.  Click on the Import button.  Then select the 'Environment Reprovisioning Tool' from the list, and click ok to bring it into the Asset Library.

    Next, navigate in lcs to your environments full details page.  Click 'apply updates', and select the 'Environment Reprovisioning tool' from the list.  You may need to wait a minute, but eventually the 'apply' button will become enabled.  Apply this package.

    This package should fix this certificate error.  It essentially replaces anything that was 'environment specific' in the recently restored database, with values that are correct for the current environment.

  • Suggested answer
    tprogrammer Profile Picture
    tprogrammer 10 on at

    hi, i just deleted and recreated the Azure Data Source, and that fixed the problem!!!

    Worksppaces--> Data Management--> Configure Data Source

  • VRD Profile Picture
    VRD on at

    Hi Experts,

    I somehow not able to get rid of this error. Can someone please throw some light what could be the issue?

    I have my development box db restored from another development box.

    I performed below steps.

    1. Restored DB and Did DB synchronizatoin.

    2. Ran the script to create new db users  such as axretailruntimeuser etc.  as per the MS document Import Database on Tier 1 box

    3. Applied 'Environment Provisioning Tool'.

    I am still getting the error on channel database screen.

    pastedimage1649117335856v1.png

    I did restart of VM and did 'Environment Provisioning Tool' again and still no change.

    I also tried repeating all the steps mentioned above with another fresh db restore on the same environment but that too didn't work.

    What am I missing here? Please help. Thanks.

  • VRD Profile Picture
    VRD on at

    Did anyone face this ? any suggestion for the fix?

  • Rudra dynamics AX Profile Picture
    Rudra dynamics AX 5 on at

    HI,

    I am also facing the same issue, below shows the error data, i was refreshed the D365 Dev DB with UAT DB, i applied all the steps which are on the article but no resolution.

    Data encryption/decryption failed when trying to edit the Database connection profile table and the ConnectionString field. System.FormatException: The input is not a valid Base-64 string as it contains a non-base 64 character, more than two padding characters, or an illegal character among the padding characters. at System.Convert.FromBase64_ComputeResultLength(Char* inputPtr, Int32 inputLength) at System.Convert.FromBase64CharPtr(Char* inputPtr, Int32 inputLength) at System.Convert.FromBase64String(String s) at Microsoft.Dynamics.Ax.Xpp.xApplication.DecryptFromStringForPurpose(String _cipher, String _purpose) at Dynamics.AX.Application.Global.`editEncryptedStringField(Common _common, String value, Int32 _fieldId, Boolean _set) in xppSource://Source/ApplicationPlatform\AxClass_Global.xpp:line 9984

    Anyone can Help?

    Thanks in Advance.

    Rudramurthy

  • Andreas Skjold Fick Profile Picture
    Andreas Skjold Fick 5 on at

    I had this issue, and I solved it putting in the connection string under my DB connection. After I did that it worked fine.

  • Haris Rajpoot Profile Picture
    Haris Rajpoot 10 on at

    I am having the same issue, please suggest to me the best solution.

  • Ambanna Profile Picture
    Ambanna 20 on at

    Hi Andreas,

    Please can you tell us how you did it. Where do I find connection under my db connection?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
Laurens vd Tang Profile Picture

Laurens vd Tang 307 Super User 2025 Season 2

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 123 Super User 2025 Season 2

#3
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 67 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Quality order uses default receipt location instead of actual physical receipt location

Product updates

Dynamics 365 release plans