cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Dudditz
Level: Powered On

Integration Job A Record Already exists and creating duplicates

We currently use Dynamics Finance and Operations and would like to Synchronize some fields from the Customers & Projects Entities.  I have created a custom entity from both of these.  Created a connection set, Created an integration project using the Fin and Ops to CDS template.  Created my tasks, see images.

My results,

Project ID works first Sync and than the following,

Precondition Failed {"error":{"code":"0x80060892","message":"A record that has the attribute values Project ID already exists. The entity key Project ID requires that this set of attributes contains unique values. Select unique values and try again.","innererror":{"message":"A record that has the attribute values Project ID already exists. The entity key Project ID requires that this set of attributes contains unique values. Select unique values and try 

 

Customers works every time however is creating a duplicate customer each Sync.

 

We are using the HR Talent Microsoft Pre-Built integration jobs which seem to be working as expected, no duplicates or errors that a record already exists.   When I created my two custom entities Projects & Customers I reviewed the working talent entites and mimicked the Personnel Number settings for the key.  The two fields I used in my configuration for keys, Customer Account & Project ID are both unique on the Dynamics side.  

 

I am not looking to push data back into Finance and Operations and simply looking to syncrhonize a few fields from the Project and Customer entites for consumption in various solutions.

 

Here are some screens of the Key Fields, The last screenshot shows the Execution History, first one failing is Projects, worked first Sync and now every field is a duplicate so all fail, last one that is working is Customer however it creates a duplicate every Sync.  Any guidance on this is appreciated.

2019-04-06_18-19-09.jpg2019-04-06_18-20-04.jpg2019-04-06_18-20-14.jpg2019-04-06_18-21-36.jpg2019-04-06_18-21-51.jpg

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Integration Job A Record Already exists and creating duplicates

1 REPLY 1
Community Support Team
Community Support Team

Re: Integration Job A Record Already exists and creating duplicates