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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / Cannot add members int...
Customer experience | Sales, Customer Insights,...
Suggested Answer

Cannot add members into a static marketing list using Kingswaysoft SSIS

(0) ShareShare
ReportReport
Posted on by Ben CRM Support 20

[Dynamics CRM Destination [2]] Error: An error occurred with the following error message: "KingswaySoft.IntegrationToolkit.DynamicsCrm.CrmServiceException: CRM service call returned an error: Error in AddMemberList plugin, System.ServiceModel.Security.SecurityNegotiationException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #33452146Message:System.ServiceModel.Security.SecurityNegotiationException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #33452146Stack:
Server stack trace:
at Microsoft.Crm.Sandbox.SandboxOrganizationService.Execute(String operation, Byte[] serializedRequest, Object sandboxTraceSettingsObj)
at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Object[]& outArgs)
at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg)

Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at Microsoft.Crm.Sandbox.ISandboxOrganizationService.Execute(String operation, Byte[] serializedRequest, Object traceSettings)
at Microsoft.Crm.Sandbox.SandboxOrganizationServiceWrapper.ExecuteInternal(OrganizationRequest request)
at Microsoft.Crm.Sandbox.SandboxOrganizationServiceWrapper.RetrieveMultipleInternal(QueryBase query)
at ClickDimensions.Crm.MsCrm2011Plugins.Common.GetSetting(IOrganizationService service, String keyName)
at ClickDimensions.Crm.MsCrm2011Plugins.AddMemberListPlugin.SendAddToListTriggerRequest(IOrganizationService service, ITracingService tracer, Guid listId, List`1 recipients, List`1 duplicateList, String entityTypeFromContext)
at ClickDimensions.Crm.MsCrm2011Plugins.AddMemberListPlugin.Execute(IServiceProvider serviceProvider)
Server stack trace:
at Microsoft.Crm.Sandbox.SandboxOrganizationService.Execute(String operation, Byte[] serializedRequest, Object sandboxTraceSettingsObj)
at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Object[]& outArgs)
at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg)

Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at Microsoft.Crm.Sandbox.ISandboxOrganizationService.Execute(String operation, Byte[] serializedRequest, Object traceSettings)
at Microsoft.Crm.Sandbox.SandboxOrganizationServiceWrapper.ExecuteInternal(OrganizationRequest request)
at Microsoft.Crm.Sandbox.SandboxOrganizationServiceWrapper.RetrieveMultipleInternal(QueryBase query)
at ClickDimensions.Crm.MsCrm2011Plugins.Common.GetSetting(IOrganizationService service, String keyName)
at ClickDimensions.Crm.MsCrm2011Plugins.AddMemberListPlugin.SendAddToListTriggerRequest(IOrganizationService service, ITracingService tracer, Guid listId, List`1 recipients, List`1 duplicateList, String entityTypeFromContext)
at ClickDimensions.Crm.MsCrm2011Plugins.AddMemberListPlugin.Execute(IServiceProvider serviceProvider)CONTEXT INFORMATION: ----------
UserId: 66d8c23a-24b1-eb11-a315-00155d66540a
OrganizationId: 4b24c908-72bc-e811-a2ce-00155d6e8a01
OrganizationName: live
MessageName: AddListMembers
Stage: 40
Mode: 0
PrimaryEntityName: list
SecondaryEntityName: none
BusinessUnitId: 2e4efd11-72bc-e811-a2ce-00155d6e8a01
CorrelationId: b31f1332-253c-4c41-8491-bf3d97eca754
Depth: 1
InitiatingUserId: 66d8c23a-24b1-eb11-a315-00155d66540a
IsExecutingOffline: False
IsInTransaction: True
IsolationMode: 2
Mode: 0
OperationCreatedOn: 17/10/2022 12:08:50 AM
OperationId: 00000000-0000-0000-0000-000000000000
PrimaryEntityId: 00000000-0000-0000-0000-000000000000
OwningExtension LogicalName: sdkmessageprocessingstep
OwningExtension Name: ClickDimensions.Crm.MsCrm2011Plugins.AddMemberListPlugin: AddListMembers of list
OwningExtension Id: 12b011b3-7e60-e111-b398-1cc1dee8ea01
SharedVariables: ChangedEntityTypes: System.Collections.Generic.Dictionary`2[System.String,System.String];
InputParameters: ListId: a0795f45-ec19-ed11-a346-00155d8fe507; MemberIds: System.Guid[];
OutputParameters:
PreEntityImages:
PostEntityImages:
----------
(Error Code: -2147220891, Detail Message: Error in AddMemberList plugin, System.ServiceModel.Security.SecurityNegotiationException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #33452146Message:System.ServiceModel.Security.SecurityNegotiationException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #33452146Stack:
Server stack trace:
at Microsoft.Crm.Sandbox.SandboxOrganizationService.Execute(String operation, Byte[] serializedRequest, Object sandboxTraceSettingsObj)
at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Object[]& outArgs)
at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg)

Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at Microsoft.Crm.Sandbox.ISandboxOrganizationService.Execute(String operation, Byte[] serializedRequest, Object traceSettings)
at Microsoft.Crm.Sandbox.SandboxOrganizationServiceWrapper.ExecuteInternal(OrganizationRequest request)
at Microsoft.Crm.Sandbox.SandboxOrganizationServiceWrapper.RetrieveMultipleInternal(QueryBase query)
at ClickDimensions.Crm.MsCrm2011Plugins.Common.GetSetting(IOrganizationService service, String keyName)
at ClickDimensions.Crm.MsCrm2011Plugins.AddMemberListPlugin.SendAddToListTriggerRequest(IOrganizationService service, ITracingService tracer, Guid listId, List`1 recipients, List`1 duplicateList, String entityTypeFromContext)
at ClickDimensions.Crm.MsCrm2011Plugins.AddMemberListPlugin.Execute(IServiceProvider serviceProvider)
Server stack trace:
at Microsoft.Crm.Sandbox.SandboxOrganizationService.Execute(String operation, Byte[] serializedRequest, Object sandboxTraceSettingsObj)
at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Object[]& outArgs)
at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg)

Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at Microsoft.Crm.Sandbox.ISandboxOrganizationService.Execute(String operation, Byte[] serializedRequest, Object traceSettings)
at Microsoft.Crm.Sandbox.SandboxOrganizationServiceWrapper.ExecuteInternal(OrganizationRequest request)
at Microsoft.Crm.Sandbox.SandboxOrganizationServiceWrapper.RetrieveMultipleInternal(QueryBase query)
at ClickDimensions.Crm.MsCrm2011Plugins.Common.GetSetting(IOrganizationService service, String keyName)
at ClickDimensions.Crm.MsCrm2011Plugins.AddMemberListPlugin.SendAddToListTriggerRequest(IOrganizationService service, ITracingService tracer, Guid listId, List`1 recipients, List`1 duplicateList, String entityTypeFromContext)
at ClickDimensions.Crm.MsCrm2011Plugins.AddMemberListPlugin.Execute(IServiceProvider serviceProvider)CONTEXT INFORMATION: ----------
UserId: 66d8c23a-24b1-eb11-a315-00155d66540a
OrganizationId: 4b24c908-72bc-e811-a2ce-00155d6e8a01
OrganizationName: live
MessageName: AddListMembers
Stage: 40
Mode: 0
PrimaryEntityName: list
SecondaryEntityName: none
BusinessUnitId: 2e4efd11-72bc-e811-a2ce-00155d6e8a01
CorrelationId: b31f1332-253c-4c41-8491-bf3d97eca754
Depth: 1
InitiatingUserId: 66d8c23a-24b1-eb11-a315-00155d66540a
IsExecutingOffline: False
IsInTransaction: True
IsolationMode: 2
Mode: 0
OperationCreatedOn: 17/10/2022 12:08:50 AM
OperationId: 00000000-0000-0000-0000-000000000000
PrimaryEntityId: 00000000-0000-0000-0000-000000000000
OwningExtension LogicalName: sdkmessageprocessingstep
OwningExtension Name: ClickDimensions.Crm.MsCrm2011Plugins.AddMemberListPlugin: AddListMembers of list
OwningExtension Id: 12b011b3-7e60-e111-b398-1cc1dee8ea01
SharedVariables: ChangedEntityTypes: System.Collections.Generic.Dictionary`2[System.String,System.String];
InputParameters: ListId: a0795f45-ec19-ed11-a346-00155d8fe507; MemberIds: System.Guid[];
OutputParameters:
PreEntityImages:
PostEntityImages:
----------
) (SSIS Integration Toolkit for Microsoft Dynamics 365, v21.2.0.31501 - DtsDebugHost, v15.0.2000.234)System.ServiceModel.FaultException<KingswaySoft.DynamicsCrmServices.Soap2011.OrganizationService.OrganizationServiceFault>

: Error in AddMemberList plugin, System.ServiceModel.Security.SecurityNegotiationException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #33452146Message:System.ServiceModel.Security.SecurityNegotiationException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #33452146Stack:
Server stack trace:
at Microsoft.Crm.Sandbox.SandboxOrganizationService.Execute(String operation, Byte[] serializedRequest, Object sandboxTraceSettingsObj)
at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Object[]& outArgs)
at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg)

Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at Microsoft.Crm.Sandbox.ISandboxOrganizationService.Execute(String operation, Byte[] serializedRequest, Object traceSettings)
at Microsoft.Crm.Sandbox.SandboxOrganizationServiceWrapper.ExecuteInternal(OrganizationRequest request)
at Microsoft.Crm.Sandbox.SandboxOrganizationServiceWrapper.RetrieveMultipleInternal(QueryBase query)
at ClickDimensions.Crm.MsCrm2011Plugins.Common.GetSetting(IOrganizationService service, String keyName)
at ClickDimensions.Crm.MsCrm2011Plugins.AddMemberListPlugin.SendAddToListTriggerRequest(IOrganizationService service, ITracingService tracer, Guid listId, List`1 recipients, List`1 duplicateList, String entityTypeFromContext)
at ClickDimensions.Crm.MsCrm2011Plugins.AddMemberListPlugin.Execute(IServiceProvider serviceProvider)
Server stack trace:
at Microsoft.Crm.Sandbox.SandboxOrganizationService.Execute(String operation, Byte[] serializedRequest, Object sandboxTraceSettingsObj)
at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Object[]& outArgs)
at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg)

Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at Microsoft.Crm.Sandbox.ISandboxOrganizationService.Execute(String operation, Byte[] serializedRequest, Object traceSettings)
at Microsoft.Crm.Sandbox.SandboxOrganizationServiceWrapper.ExecuteInternal(OrganizationRequest request)
at Microsoft.Crm.Sandbox.SandboxOrganizationServiceWrapper.RetrieveMultipleInternal(QueryBase query)
at ClickDimensions.Crm.MsCrm2011Plugins.Common.GetSetting(IOrganizationService service, String keyName)
at ClickDimensions.Crm.MsCrm2011Plugins.AddMemberListPlugin.SendAddToListTriggerRequest(IOrganizationService service, ITracingService tracer, Guid listId, List`1 recipients, List`1 duplicateList, String entityTypeFromContext)
at ClickDimensions.Crm.MsCrm2011Plugins.AddMemberListPlugin.Execute(IServiceProvider serviceProvider)CONTEXT INFORMATION: ----------
UserId: 66d8c23a-24b1-eb11-a315-00155d66540a
OrganizationId: 4b24c908-72bc-e811-a2ce-00155d6e8a01
OrganizationName: live
MessageName: AddListMembers
Stage: 40
Mode: 0
PrimaryEntityName: list
SecondaryEntityName: none
BusinessUnitId: 2e4efd11-72bc-e811-a2ce-00155d6e8a01
CorrelationId: b31f1332-253c-4c41-8491-bf3d97eca754
Depth: 1
InitiatingUserId: 66d8c23a-24b1-eb11-a315-00155d66540a
IsExecutingOffline: False
IsInTransaction: True
IsolationMode: 2
Mode: 0
OperationCreatedOn: 17/10/2022 12:08:50 AM
OperationId: 00000000-0000-0000-0000-000000000000
PrimaryEntityId: 00000000-0000-0000-0000-000000000000
OwningExtension LogicalName: sdkmessageprocessingstep
OwningExtension Name: ClickDimensions.Crm.MsCrm2011Plugins.AddMemberListPlugin: AddListMembers of list
OwningExtension Id: 12b011b3-7e60-e111-b398-1cc1dee8ea01
SharedVariables: ChangedEntityTypes: System.Collections.Generic.Dictionary`2[System.String,System.String];
InputParameters: ListId: a0795f45-ec19-ed11-a346-00155d8fe507; MemberIds: System.Guid[];
OutputParameters:
PreEntityImages:
PostEntityImages:
----------
".

I have the same question (0)
  • Ben CRM Support Profile Picture
    Ben CRM Support 20 on at

    I have been stucked on uploading list members into a static marketing list for one month, it will be greatly appreciated if anyone can help me.

    Thanks in advance,

    Ben

  • Suggested answer
    a33ik Profile Picture
    a33ik 84,331 Most Valuable Professional on at

    Hello Ben,

    According to your logs, something is wrong with the ClickDimensions plugins. The following log line points to that fact:

    at ClickDimensions.Crm.MsCrm2011Plugins.Common.GetSetting(IOrganizationService service, String keyName)

    at ClickDimensions.Crm.MsCrm2011Plugins.AddMemberListPlugin.SendAddToListTriggerRequest(IOrganizationService service, ITracingService tracer, Guid listId, List`1 recipients, List`1 duplicateList, String entityTypeFromContext)

    at ClickDimensions.Crm.MsCrm2011Plugins.AddMemberListPlugin.Execute(IServiceProvider serviceProvider)

    There are few ways to resolve that issue:

    1. Open the ticket with ClickDimensions and ask them to explain why their code causes issues.

    2. Turn off the mentioned plugin for the time of the data import.

    3. Use the "Bypass Custom Business Logic" setting in the "CRM Destination" component - that will use the platform feature that won't cause the triggering of plugins.

    4. Using XrmToolBox and AssemblyRecovery plugin download ClickDimensions assembly and use the ILSpy tool to decompile the code of the assembly to figure out why your data import could cause issues.

  • Steve Coleman Profile Picture
    Steve Coleman 30 on at

    Ben, could you share some screenshots of how you started the process within Kingswaysoft? This task has fallen onto my lap and I have no prior experience and this as been an elusive topic to find answers on. Anything would help. Thanks!

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 70 Super User 2025 Season 2

#2
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 43 Most Valuable Professional

#3
Daniyal Khaleel Profile Picture

Daniyal Khaleel 32 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans