Microsoft Dynamics 365 | Integration, Dataverse...

I am creating a clone of records but getting an error.

(0) Share

Report

Posted on by Ravi Fulani

836

I am creating a clone of records but getting an error.

Cannot insert duplicate key, although i am using these 2 lines. But still getting error. --> cannot insert duplicate key

entity.Attributes.Remove(entity.LogicalName + "id");
entity.Attributes.Remove("msdyn_name");

service.Create(entity);

Once I use, this additional command no error is coming and all is working good.

entity.Id = Guid.NewGuid();

I just don't understand why is that, also I have read somewhere that creating own guid via code is not good in D365. If i continue with this will it create aproblem in future in my search or any activity in Dynamics.

I have the same question (0)

All responses (5)

Answers (0)

meelamri 13,218 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

Hi,

Would you please share your code? Thanks !

Was this reply helpful? Yes No
Ravi Fulani 836 on at

Like (0)

Report
Copy link

Link copied!

Hi There,

From JS I am calling Action... below is the code of my action.

Below is the code

string entityID = (string)context.InputParameters["SelectedId"];

Entity entity = service.Retrieve("msdyn_workorder", new Guid(entityID), new ColumnSet(true));

entity.EntityState = null;

entity.Attributes.Remove(entity.LogicalName + "id");

entity.Attributes.Remove("msdyn_name");

entity.Id = Guid.NewGuid();

trace.Trace(entity.Id.ToString());

Guid createdWorkOrderID = service.Create(entity);

without this line-> entity.Id = Guid.NewGuid(); my code is not running. and it is suggested that we should not create our own GUID as that impacts the system performance.

service.Create(entity); is the line which will create GUID in system automatically once record get created.

Was this reply helpful? Yes No
Suggested answer

Wahaj Rashid 11,321 on at

Like (0)

Report
Copy link

Link copied!

Hi,

You need to remove GUID of the cloned object.

For example:

entity.Attributes.Remove("msdyn_workorderid");

Then, it should create a unique ID for you (when you create the record).

Was this reply helpful? Yes No
Suggested answer

meelamri 13,218 User Group Leader on at

Like (0)

Report
Copy link

Link copied!
Hi,

Please refer to my sample code. I use it in Production for a long time.

IOrganizationService service = crmWorkflowContext.OrganizationService; ITracingService tracing = crmWorkflowContext.TracingService; EntityReference leadToCloneRef = executionContext.GetValue(this.Lead); Entity leadToClone = service.Retrieve(leadToCloneRef.LogicalName, leadToCloneRef.Id, new ColumnSet(true)); Entity clonedLead = new Entity("lead"); foreach (var att in leadToClone.Attributes){ //The fields I don't want to copy if (att.Key != "ownerid" && att.Key != "statuscode" && att.Key != "statecode" && att.Key!= "leadid" && att.Key != "address1_addressid" && att.Key != "address2_addressid"){ clonedLead[att.Key] = att.Value; } } service.Create(clonedLead);

Was this reply helpful? Yes No
Ravi Fulani 836 on at

Like (0)

Report
Copy link

Link copied!

I resolved the problem by

entity.Id = Guid.Empty;

now i am not getting any error, i was already doing entity.Attributes.Remove("msdyn_workorderid");

but with this entity.Id = Guid.Empty; problem got resolved

But I am stuck with problem as with copy of record which is work order, associated quotes are getting created which i want to stop. Any Ideas??

Was this reply helpful? Yes No