Hi guys,
I am developing a Plugin for CRM 2011 and I am getting The given key was not present in the dictionary on update. The create works fine. My plugin sums a field on child records to another field on the parent.
Parent Entity (v1_simontest), field containing summed child values (v1_totalfundingallocated)
Child Entity (v1_simontestsub) field that is being summed (v1_amountallocated)
See my code below. I have a create and an update step registered, both on Post Operation. Would really appreciate any help on this.
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Microsoft.Xrm.Sdk;
using System.ServiceModel;
using Microsoft.Xrm.Sdk.Query;
namespace SimonTestDttas
{
public class SimonTest : IPlugin
{
public void Execute(IServiceProvider serviceProvider)
{
// Get the IPlugin Context
IPluginExecutionContext context = (IPluginExecutionContext)serviceProvider.GetService(typeof(IPluginExecutionContext));
//Get a IOrganizationService
IOrganizationServiceFactory serviceFactory = (IOrganizationServiceFactory)serviceProvider.GetService(typeof(IOrganizationServiceFactory));
IOrganizationService service = serviceFactory.CreateOrganizationService(context.UserId);
// The InputParameters collection contains all the data passed in the message request.
if (context.InputParameters.Contains("Target") && context.InputParameters["Target"] is Entity)
{
// Obtain the target entity from the input parmameters.
Entity entity = (Entity)context.InputParameters["Target"];
//get the customerid
EntityReference a = (EntityReference)entity.Attributes["v1_simontestparent"];
decimal totalAmount = 0;
try
{
//fetchxml to get the sum total of estimatedvalue
string amountallocated_sum = string.Format(@"
<fetch distinct='false' mapping='logical' aggregate='true'>
<entity name='v1_simontestsub'>
<attribute name='v1_amountallocated' alias='amountallocated_sum' aggregate='sum' />
<filter type='and'>
<condition attribute='statecode' operator='eq' value='0' />
<condition attribute='v1_simontestparent' operator='eq' value='{0}' uiname='' uitype='' />
</filter></entity>
</fetch>", a.Id);
EntityCollection amountallocated_sum_result = service.RetrieveMultiple(new FetchExpression(amountallocated_sum));
foreach (var c in amountallocated_sum_result.Entities)
{
totalAmount = ((Money)((AliasedValue)c["amountallocated_sum"]).Value).Value;
}
//updating the field on the account
Entity acc = new Entity("v1_simontest");
acc.Id = a.Id;
acc.Attributes.Add("v1_totalfundingallocated", new Money(totalAmount));
service.Update(acc);
}
catch (FaultException ex)
{
throw new InvalidPluginExecutionException("An error occurred in the plug-in.", ex);
}
}
}
}
}
