Finance | Project Operations, Human Resources, ...

Getting error while trying to import UAT database to newly created development environment

(0) Share

Report

Posted on by CU07101257-0

130

Hi All,

Getting below error while trying to import UAT database to newly created development environment

0882.pastedimage1668068213195v1.png

Data plan execution failed with message One or more errors occurred.
(One or more errors occurred. (One or more errors occurred. (Violation of PRIMARY KEY constraint 'I_8281RECID'.
Cannot insert duplicate key in object 'dbo.SYSDATACHANGEDETECTIONEVENTTABLE'. The duplicate key value is (5637144576).
The statement has been terminated.))).

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Komi Siabi 13,107 Most Valuable Professional on at

Like (0)

Report

Hello Sunil,

Kindly check this thread.

Was this reply helpful? Yes No
CU07101257-0 130 on at

Like (0)

Report

Hi Komi,

I have redeploy new environment blank database. After full build and database sync I can see below data in SQL table SYSDATACHANGEDETECTIONEVENTTABLE even before database import . Do we need to delete the row contains REID 5637144576 before start data import. It causes any issue in future. Pls advise

Was this reply helpful? Yes No
Martin Dráb 237,904 Most Valuable Professional on at

Like (0)

Report

How are you importing the DB?

Isn't it actually about F&O?

Was this reply helpful? Yes No
CU07101257-0 130 on at

Like (0)

Report

Yes . I am trying to import database to newly deployed D365 FO development environment

Was this reply helpful? Yes No
Martin Dráb 237,904 Most Valuable Professional on at

Like (0)

Report

Moved from Dynamics AX Forum.

Was this reply helpful? Yes No