Skip to main content

Notifications

Announcements

No record found.

Customer experience | Sales, Customer Insights,...
Suggested answer

Cannot add members into a static marketing list using Kingswaysoft SSIS

Posted on by 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:
----------
".

  • Steve Coleman Profile Picture
    Steve Coleman 30 on at
    RE: Cannot add members into a static marketing list using Kingswaysoft SSIS

    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!

  • Suggested answer
    a33ik Profile Picture
    a33ik 84,323 Most Valuable Professional on at
    RE: Cannot add members into a static marketing list using Kingswaysoft SSIS

    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.

  • Ben CRM Support Profile Picture
    Ben CRM Support 20 on at
    RE: Cannot add members into a static marketing list using Kingswaysoft SSIS

    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

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans