Resolving Error: Exception of type 'Microsoft.Dynamics.Nav.Types.Exceptions.Encryption.NavEncryptionKeyNotFoundException' was thrown

Introduction: 

In this blog, I will be sharing my experience with the error Exception of type 'Microsoft.Dynamics.Nav.Types.Exceptions.Encryption.NavEncryptionKeyNotFoundException' was thrown.

Exception of type 'Microsoft.Dynamics.Nav.Types.Exceptions.Encryption.NavEncryptionKeyNotFoundException' was thrown. Page Customers has to close.

Pre-requisites: 

• Microsoft Dynamics 365 Business Central
• Basic Understanding of BC- CDS(Dataverse)Integration

Books & References: 

• https://www.olisterr.tech/2022/05/setup-dataverse-connectivity-with.html

Demonstration: 

When I would open Customers, Vendors, or Contacts, on the list page I would get the error message

Exception of type 'Microsoft.Dynamics.Nav.Types.Exceptions.Encryption.NavEncryptionKeyNotFoundException' was thrown.

On any other pages if we open they would normally.

After checking the Event Log it was clear that this was possibly caused by CDS

Updated the CDS Connection setup ( Dataverse Connection Setup) using SSMS where I changed Is Enabled field from 1 to 0

Once this change is done, I restarted the Server Instance and opened the Customer, Vendor and Contact pages again to confirm.

The issue is finally resolved.

Conclusion:

This issue seems to have been caused by Dataverse Setup in BC. Typically when you move a DB from one server to another, there is a chance that the link will break and the paired data sources will have issues.

I hope this helps!!