Trying to troubleshoot an SSIS job that first runs a simple select query against two entities . Then a script component is called to update a field on the entities based on the result set .
The job runs fine locally. When placed on our QA SSIS server and still pointed to a developer org it runs fine. However when pointed to a QA organization the "Context not currently tracking the entity ... " is thrown
Below is the code snippet of the method that is failing . It only fails when we have the job run against our QA org.
publicoverridevoidInput0_ProcessInputRow(Input0BufferRow)
{
if(!Row.EntityId_IsNull && !Row.CreatedOn_IsNull)
{
Entityentity =
newEntity();
entity.Id = Row.EntityId;
entity.LogicalName = Row.EntityName;
entity.Attributes =
newAttributeCollection();
entity.Attributes.Add(
newSystem.Collections.Generic.KeyValuePair<string,
object>("aprv_cycletime",
(DateTime.Now - Row.CreatedOn).Days));
//client.Update(entity);
context.Attach(entity);
context.UpdateObject(entity);
context.SaveChanges();
if(!context.IsAttached(entity))
{
context.Attach(entity);
}
}
}
Robert
