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
September 2021
MoTuWeThFrSaSu
 12345
6789101112
13141516171819
20212223242526
27282930 
 
© 2006-2021 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.