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 :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / The required data encr...
Finance | Project Operations, Human Resources, ...
Unanswered

The required data encryption certificate was not found when trying to edit the Source data formats table and the EntityStoreConnectionString field

(0) ShareShare
ReportReport
Posted on by joaoasilva11 55

We recently created a new Data Entity (with the respective Staging Tables, Views and Queries) for BYOD Export purposes.

Even though everything was working fine on a development environment, I get an error on my test / QA environment, like the one below:

The required data encryption certificate was not found when trying to edit the Source data formats table and the EntityStoreConnectionString field. Please add a valid certificate.

Microsoft.Dynamics.Ax.Xpp.Security.CryptoEncryptionException: Encryption error occured with exception: Microsoft.Dynamics.AX.Configuration.CertificateHandler.NoCertificateFoundException: No certificate found for id '7F275EBD1B329EAD4EF1A83B3DD8CF17C617F9F1'.

I tried to search online but most certification errors are caused by Database issues, not because of newly created entities.

Is there a way to refresh the certificates online (via D365) in order to fix this problem?

I have the same question (0)
  • NawazAkhtar Profile Picture
    NawazAkhtar on at
    RE: The required data encryption certificate was not found when trying to edit the Source data formats table and the EntityStoreConnectionString field

    Error "NoCertificateFoundException: No certificate found for id" is usually cause because database was copied to UAT from production and connection string was encrypted with a cert not on UAT.

    Unable to decrypt is an error that comes from copying a database.  Any data encrypted on the old environment is unreadable on the new one. You should be able to delete this record (connection string in QA/TST) and then add it again, in which case it should be encrypted with the local encryption cert.

  • Ambanna Profile Picture
    Ambanna 20 on at
    RE: The required data encryption certificate was not found when trying to edit the Source data formats table and the EntityStoreConnectionString field

    Hi,

    I am getting same error. It is occuring while posting approval journal after restoring DB from UAT.

    Please can you tell me where and how to change the connection string (Path to 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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

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

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,167

#2
André Arnaud de Calavon Profile Picture

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

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 617 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans