cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper V
Helper V

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
Highlighted
Community Support
Community Support

Re: Integration Job A Record Already exists and creating duplicates

1 REPLY 1
Highlighted
Community Support
Community Support

Re: Integration Job A Record Already exists and creating duplicates

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Users online (5,667)