Skip to main content

Notifications

Customer Service forum

Data Encryption key error in workflow

Posted on by 5

Hi,

i m using crm on-premise 2016 Whenever a new record is created in account entity, an email is  sent regarding the successful completion of form. Also a email is sent whenever a user selects forget password link. Both the workflows are not working and error : "Cannot open Sql Encryption Symmetric Key because Symmetric Key password does not exist in Config DB." is shown. But the encryption key is present in CRM and data encryption is also active.  Please provide a solution for this error.

Categories:
  • Suggested answer
    Adrian Begovich Profile Picture
    Adrian Begovich 21,009 Super User 2024 Season 2 on at
    RE: Data Encryption key error in workflow

    Hi shantanu misra,

    This issue can occur if your instance was set up by taking a database backup from another CRM instance where data encryption was activated. If this is the cause of your problem then you will need to update the encryption key on your CRM instance with the encryption key from the original CRM instance.

    To check your current encryption key and change your encryption key follow these steps:

    1. Sign in to Microsoft Dynamics CRM as a user with the system administrator security role.
    2. Go to Settings > Data Management > Data Encryption.
    3. In the Data Encryption dialog box, select Show Encryption Key, in the Current encryption key box select the encryption key, and copy it to the clipboard.

    However, if the Microsoft Dynamics CRM website is not configured for HTTPS/SSL, the Data Encryption dialog box will not be displayed.

  • shantanu misra Profile Picture
    shantanu misra 5 on at
    RE: Data Encryption key error in workflow

    Hi Adrian,

    Thanks for replying. This is a custom workflow which fires whenever a record is created in account entity and it created a record in login master entity. A email is also sent regarding the login details. The record is created in login entity but the email is never sent and status is always waiting even after resuming the workflow. Here is the image attached of the error.

    capture_5F00_20190411142713.png

  • Suggested answer
    Adrian Begovich Profile Picture
    Adrian Begovich 21,009 Super User 2024 Season 2 on at
    RE: Data Encryption key error in workflow

    Hi shantanu misra,

    We will need to examine your workflow in order to solve this issue.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans