This post is machine-translated. The original post in german language can be found here.

DuplicateKeyException in table LogisticsLocationRole during data upgrade from AX 2012 to Dynamics 365 for Finance and Operations

During the data upgrade of an AX 2012 R2 to Dynamics 365 for Finance and Operations I had the following errors when running the "DataUpgrade-Package" at step 8:

Infolog diagnostic message: 'Cannot create a record in Roles (LogisticsLocationRole). Role: Stabile Organisation, Stable organization. The record already exists.' on category 'Error'. 08/20/2019 14:52:12: Application configuration sync failed.

This was caused by two records in the LogisticsLocationRole table that were created in the source environment (AX 2012 R2) by hotfix KB4048614. Interestingly, this hotfix is exactly the one that should be applied before upgrading from AX 2012 R2 to D365.

In my scenario, I was able to use the statement below to delete the records and successfully restart step 8.

delete from LOGISTICSLOCATIONROLE
where type = 104 or type = 105

Tablebrowser LogisticsLocationRole

These post applies to following version:
Dynamics 365 for Finance and Operations

Add comment
 
 

 

 
 
 
Posts of the actual month
Juni 2020
MoTuWeThFrSaSu
1234567
891011121314
15161718192021
22232425262728
2930 
 
© 2006-2020 Heinz Schweda | Imprint | Contact | German version | Mobile version
In order to provide you with better service, this site uses cookies. By continuing to browse the site, you are agreeing to our use of cookies.