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

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

No certificate found for id error after database refresh from Prod

(1) ShareShare
ReportReport
Posted on by 245

Hi All,

We have an integration that stores encrypted URL in the database using the method editConnString(boolean _set, String255 _connString) in the related table
and we recently refreshed my development environment and the test environment from Prod using LCS but now the integrations are failing in that environment with the following error : 

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 'FB7C78022FA47E400695F9F9760EE019E9B66592'.

pastedimage1594318683298v1.png

My questions are :

  • How can I fix this? It appears both environments are looking for that thumbprint (from Prod) instead of their respective ones
  • How can we avoid this issue for future database refresh ?

Thanks,

Slim

 

Rq : The full error is below

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 'FB7C78022FA47E400695F9F9760EE019E9B66592'. 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) at Microsoft.Dynamics.Ax.Xpp.Security.CryptoEncryptionEngine.GetCryptoServiceProviderByThumbprintBuffer(String idList, Byte[] thumbprint) at Microsoft.Dynamics.Ax.Xpp.Security.CryptoEncryptionEngine.DecryptionInternal(Byte[] cipher, Boolean validateSignature, String purpose)

 

I have the same question (0)
  • James-Mc Profile Picture
    201 on at
    RE: No certificate found for id error after database refresh from Prod

    Did you get an answer where this has to be re-entered?

  • Dar99 Profile Picture
    5 on at
    RE: No certificate found for id error after database refresh from Prod

    Can you tell us where to re-enter? We have the same issue.

  • Suggested answer
    Slim Rouissi Profile Picture
    245 on at
    RE: No certificate found for id error after database refresh from Prod

    Thanks guys, I was actually able to retrieve the values by decrypting them in another environment that wasn't refreshed yet with a job I wrote that uses the methods in the Global class

    Global::editEncryptedField(Common _common, str value, FieldId _fieldId, boolean _set) and

    Global::editEncryptedStringField(Common _common, str value, FieldId _fieldId, boolean _set)

    by putting _set as flase it actually does the decryption.

    Then as suggested by William's answer the values have to be re-entered manually in the refreshed environments.

  • Verified answer
    William D. Wang Profile Picture
    on at
    RE: No certificate found for id error after database refresh from Prod
  • Mea_ Profile Picture
    60,284 on at
    RE: No certificate found for id error after database refresh from Prod

    I dont think that you can decrypt them, thats the point of encryption, so you have to reenter them. SMTP password uses same method and MS scripts explicitly delete it during DB restore, unfortunately, you have to do the same manually and then reenter it.

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…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Sohaib Cheema Profile Picture

Sohaib Cheema 775 User Group Leader

#2
Martin Dráb Profile Picture

Martin Dráb 634 Most Valuable Professional

#3
André Arnaud de Calavon Profile Picture

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

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans