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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Dynamics 365 Online latest version - workflow trying to send email encountering SQL Encryption Symmetric Key does not exist error

(0) ShareShare
ReportReport
Posted on by

I have a user A running a workflow which sends an email as User B.  User A has "SendAs" privilege and her personal Options are enabled to send as.  However, we're encountering this error.  

Sync workflow failed with error message - Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=8.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: Cannot open Sql Encryption Symmetric Key because Symmetric Key password does not exist in Config DB.Detail:
<OrganizationServiceFault xmlns:i="www.w3.org/.../XMLSchema-instance" xmlns="schemas.microsoft.com/.../Contracts">
<ActivityId>1d52c4dd-c2e3-493f-a14f-15dbe30f6870</ActivityId>
<ErrorCode>-2147187410</ErrorCode>
<ErrorDetails xmlns:d2p1="schemas.datacontract.org/.../System.Collections.Generic" />
<Message>Cannot open Sql Encryption Symmetric Key because Symmetric Key password does not exist in Config DB.</Message>
<Timestamp>2017-03-28T16:01:07.6072752Z</Timestamp>
<ExceptionSource i:nil="true" />
<InnerFault>
<ActivityId>1d52c4dd-c2e3-493f-a14f-15dbe30f6870</ActivityId>
<ErrorCode>-2147187410</ErrorCode>
<ErrorDetails xmlns:d3p1="schemas.datacontract.org/.../System.Collections.Generic" />
<Message>Cannot open Sql Encryption Symmetric Key because Symmetric Key password does not exist in Config DB.</Message>
<Timestamp>2017-03-28T16:01:07.6072752Z</Timestamp>
<ExceptionSource i:nil="true" />
<InnerFault i:nil="true" />
<OriginalException i:nil="true" />
<TraceText i:nil="true" />
</InnerFault>
<OriginalException i:nil="true" />
<TraceText i:nil="true" />
</OrganizationServiceFault>
at Microsoft.Crm.Extensibility.OrganizationSdkServiceInternal.Execute(OrganizationRequest request, CorrelationToken correlationToken, CallerOriginToken callerOriginToken, WebServiceType serviceType, Boolean checkAdminMode, ExecutionContext executionContext)
at Microsoft.Crm.Extensibility.InprocessServiceProxy.ExecuteCore(OrganizationRequest request)
at Microsoft.Crm.Workflow.Services.SendEmailActivityService.<>c__DisplayClass1.<SendEmailInternal>b__0(IOrganizationService sdkService)
at Microsoft.Crm.Workflow.Services.ActivityServiceBase.ExecuteInTransactedContext(ActivityDelegate activityDelegate)
at Microsoft.Crm.Workflow.Services.SendEmailActivityService.SendEmailInternal(Entity emailEntity, String stepId)
at Microsoft.Crm.Workflow.Services.SendEmailActivityService.Execute(ActivityContext executionContext, SendEmail sendEmail)
, error code - -2147187410

*This post is locked for comments

I have the same question (0)
  • Verified answer
    MihirShah Profile Picture
    4,038 on at

    Looks like you may need to enter or reset the data encryption key.

    In CRM > Settings > Data Management > Data encryption.

    Make sure the key is there and the status is active.

    technet.microsoft.com/.../dn531199.aspx

  • Verified answer
    Dynamics_Alok Profile Picture
    1,746 on at

    Similar thread

    community.dynamics.com/.../151217

    community.dynamics.com/.../196519

  • Cyclefitness Profile Picture
    on at

    Thank you!  That's exactly the problem.  I discovered this last night and was just coming back to update with the answer.

  • Community Member Profile Picture
    on at

    Hi Debra

    Tenfold can help in integrating MS Dynamics 365 and enabling click to dial in Outlook. Our click to dial also works on webpages opened in Chrome.  They also support MS Dynamics integration www.tenfold.com/.../dynamics

  • Community Member Profile Picture
    on at

    Hi Debra

    Tenfold just recently added MS office to their integrations list. Tenfold offers features such as click to dial, automatic call logging, easy note taking and task creation, screen pops on inbound and outbound calls, new lead/contact creation when no matching records, support for cases/opportunities and advanced analytics on the backend. They support MS Dynamics integration also.

    www.tenfold.com/.../microsoft-office-365

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
JS-09031509-0 Profile Picture

JS-09031509-0 3

#2
AS-17030037-0 Profile Picture

AS-17030037-0 2

#2
Mark Eckert Profile Picture

Mark Eckert 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans