Hello,
I'm writing a plugin with requirement as follow: When a specific field is updated on a parent account, then it should update that specific field on all of the child accounts as well
The plugin successfully works and update all of the child accounts correctly.
However my problem is for a parent account that has a lot of child accounts (over 1000), this plugin keeps getting timed out.
We register the plugin in sandbox mode so it gets timed out after 2 minutes.
We register the plugin on Asynchronous mode because otherwise the users will have to 'wait' for a long time until the plugin is finished executing. It's for Post-operation stage. I'm using Post Image in this plugin.
Here's my code.
I suspect that the problem comes inside the FOR loop when doing service.Update(property) for each of the child account.
I'm wondering if there's a more efficient way to update all of these child accounts?
Any suggestion is greatly appreciated. Thanks much,
tri
public override void OnExecute(IServiceProvider serviceProvider, IPluginExecutionContext context)
{
var trace = (ITracingService)serviceProvider.GetService(typeof(ITracingService));
// The InputParameters collection contains all the data passed in the message request.
//Make sure were not in an infinite loop
if (context.Depth > 1)
{
return;
}
var targetEntity = context.GetParameterCollection<Entity>(context.InputParameters, "Target");
if (targetEntity == null)
throw new InvalidPluginExecutionException(OperationStatus.Failed, "Target Entity cannot be null");
var postImage = context.PostEntityImages["PostImage"];
if (postImage == null)
throw new InvalidPluginExecutionException(OperationStatus.Failed, "Post Image is required");
var portfolio = context.GenerateCompositeEntity(targetEntity, postImage);
var portCustSatisfaction = (OptionSetValue) portfolio.Attributes[Schema.Account.CustSatisfaction];
Guid portfolioId = (Guid) portfolio.Attributes["accountid"];
var serviceFactory =
(IOrganizationServiceFactory) serviceProvider.GetService(typeof (IOrganizationServiceFactory));
var service = serviceFactory.CreateOrganizationService(context.UserId);
//here run a FetchXML to grab all child accounts
var childProperties =
service.RetrieveMultiple(new FetchExpression(string.Format(RetrieveChildProperties, portfolioId)));
if (childProperties != null && childProperties.Entities.Count >= 1)
{
foreach (Entity property in childProperties.Entities)
{
property[Schema.Account.CustSatisfaction] = new OptionSetValue(portCustSatisfaction.Value);
service.Update(property);
}
}
}
