CRM Plugin: "Entity Id must be the same as the value set in the property bag" and "Cannot insert duplicate key"

(0) Share

Report

Posted on by user123

147

I am creating a clone of record on it's create. Plugin is registered on post-create of the record.

 QueryExpression qe = new QueryExpression("contact")
            {
                ColumnSet =  new ColumnSet("firstname", "lastname")
            };
            EntityCollection entityCollection = _organizationService.RetrieveMultiple(qe);
            foreach (Entity entity in entityCollection.Entities)
            {                
                if (!entity.Attributes.Contains("firstname"))
                {
                    entity.Attributes.Add("firstname", "");
                }
                entity["firstname"] = (entity.GetAttributeValue<string>("firstname") ?? "") + "(Copy)";

                _organizationService.Create(entity);
            }

If I do not Entity.Id = Guid newGuid() for the clone record, it gives me "Cannot insert duplicate key"

If I add Entity.Id = Guid newGuid(), it gives me "Entity Id must be the same as the value set in the property bag.

Can you help please?

Thanks
Arj

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Arun Vinoth 11,615 Moderator on at

Like (0)

Report

1. If you are creating a clone copy of just created record from plugin, you dont need another RetrieveMultiple. Simply take the values from target entity.

2. The below line will create a new record and assign a new GUID as per sequence without duplicate values. So dont assign a new Guid() for that record.

_organizationService.Create(entity);

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

just do entity.Attributes.Remove("contactid")

but as it stands you will be causing an infinite chain. When does it NOT .Create(entity)?

Was this reply helpful? Yes No
Suggested answer

Pawar Pravin 5,237 on at

Like (0)

Report

You could create clone record without retrieving data in plugin. Please refer below url for reference:

www.briteglobal.com/.../

Was this reply helpful? Yes No
Suggested answer

Temmy Wahyu Raharjo 2,916 on at

Like (0)

Report
Hi,

Just want to give you information. In Microsoft Code Review. There is one section that inform to never use the same object to be put in Service.Create / Service.Update.

The correct way is:

var entityCollection = _organizationService.RetrieveMultiple(qe); foreach(var entity in entityCollection.Entities) { var firstName = entity.GetAttributeValue("firstname") ?? ""; var newEntity = new Entity("contact"); newEntity["firstname"] = firstName "(Copy)"; _organizationService.Create(newEntity); }

Was this reply helpful? Yes No
Suggested answer

Martin Donnelly 1,030 on at

Like (0)

Report

this new Entity("contact") is not a solution. the OP wants to clone NOT just make a new record with a similar firstname; this code misses all the other attributes. this will work if you iterate through entity.Attributes and newEntity.Attributes.Add() everything EXCEPT Attribute["contactid"] -- that's the attribute causing the duplicate key error.

Was this reply helpful? Yes No
Martin Donnelly 1,030 on at

Like (0)

Report

the second error about the difference between the entity.Id and the property bag is because the contactid exists in two places -- the "header" (Entity.id) AND the property bag (Entity.Attributes["contactid"]. to get past this error set the header to GUID.Empty and remove the attribute (CRM will assign a new GUID on its own.)

Was this reply helpful? Yes No
Suggested answer

Martin Donnelly 1,030 on at

Like (0)

Report

and, finally, if you want a "business" clone, copy the original Attributes["createdon"] and add it as Attributes["overriddencreatedon"]

!

Was this reply helpful? Yes No