Dynamics Community Forum Thread Details

plugin speed / efficiency

I have a plugin that I an using to delete opportunity products and its taking forever to run and times out due to the 2min plugin limit.

My Opportunity contains 423 Opportunity Products, is there a better way to delete all products on the opportunity?

I commented out all other transactions in the plugin till only the below remained and was still timing out.

public void DeleteProducts(IOrganizationService dynamicsService, ITracingService tracingService, EntityCollection opp_prod)
{
    tracingService.Trace("DeleteProducts");

    foreach (Entity product in opp_prod.Entities) {
        DeleteRequest deleteReq = new DeleteRequest() { Target = product.ToEntityReference() };
        dynamicsService.Execute(deleteReq);
    }
}

I tried to switch to something like the below, the Action in this example calls a plugin (Async) to process each of the batches, then i was hit with the error "1205 Transaction (Process ID %d) was deadlocked on %.*ls resources with another process and has been chosen as the deadlock victim. Rerun the transaction."

public void DeleteProducts(IOrganizationService dynamicsService, ITracingService tracingService, EntityCollection opp_prod)
{
    tracingService.Trace("DeleteProducts");

    OrganizationRequest req = new OrganizationRequest("c1_RecordCreateOrDeleteAction");
    req["Action"] = "Delete";
    req["Message"] = "Attempted deletion of Opportunity Line Items";


    int batchSize = 20;
    //split the records into batches of defined size to prevent more time outs
    List lstWrapper = new List();

    for (int i = 0; i < (opp_prod.Entities.Count / batchSize)   1; i  )
    {
        EntityCollection batchCollection = new EntityCollection();
        batchCollection.EntityName = "opportunityproduct";


        for (int j = (i * batchSize); (j < (i * batchSize)   batchSize) && j < opp_prod.Entities.Count; j  )
        {
            Entity current = opp_prod.Entities.ElementAt(j);

            batchCollection.Entities.Add(current);
        }
        lstWrapper.Add(batchCollection);
    }

    if (lstWrapper.Any())
    {

        tracingService.Trace("number of batches to process - "   lstWrapper.Count());
        foreach (EntityCollection batchToProcess in lstWrapper)
        {
            req["Records"] = batchToProcess;
            OrganizationResponse response = dynamicsService.Execute(req);
        }
    }
}

Ideally i want the delete to take seconds not minuets or some way to delete a list of opportunity product and create new ones in parallel without locking.

Quick Links

Subscribe to this forum!