Ax 2012 data upgrade in Tier-1 development environments(CHE). Error: System.IO.FileNotFoundException: Could not load file or assembly 'System.ValueTuple, Version=4.0.3.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51' or one of its dependencies.

During the data upgrade from AX2012 to D365FO I got the following error in step 3 on /DataUpgrade/PreReqs/AdditiveDbSync:

System.IO.FileNotFoundException: Could not load file or assembly 'System.ValueTuple, Version=4.0.3.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51' or one of its dependencies. The system cannot find the file specified.

The workaround to solve the error was to copy the System.ValueTuple.dll file from "K:\AosService\PackagesLocalDirectory\bin\ModelUtilDlls" to "K:\AosService\PackagesLocalDirectory\bin"

There is a registered issue 1029905 on the LCS portal regarding this error.

Ax 2012 data upgrade in Tier-1 development environments(CHE). The status is in "In Progress" for a long time.

During the data upgrade from AX2012 to D365FO 10.0.42 version I faced an issue in step 3 (Post Sync\ExecuteScripts). The status was in "In Progress" for more than 12 hours. 

But when I checked the process, there were no pending post-sync scripts to run, and all post-sync script were completed.

I checked the status of the process with a query: select * from DBUPGRADE.SERVICINGSTEP

I decided to change the status of the «ExecuteScripts» step to complete it manually, since there were no pending post-sync scripts to run:

UPDATE DBUPGRADE.SERVICINGSTEP SET STATUS=2 WHERE PATH = '/DataUpgrade/PostSync/ExecuteScripts';

Then I closed the cmd window and re-ran step 3 but I got an error:

I closed the datupgradebatch.exe process using the task manager, re-ran step 3 and the data upgrade process was resumed and completed successfully.

Ax 2012 data upgrade on the self-service environment. The error "There is no row at position 0."

During the Ax 2012 data upgrade, after providing connection details to Ax2012 SQL Server, the migration tool closed and I received the following error message in the log file.

2025-08-17 13:15:09.261 -02:00 [Information] Reading version check query started. 

2025-08-17 13:15:12.199 -02:00 [Information] Executing the version check completed. 

2025-08-07 13:15:12.199 -02:00 [Error] There is no row at position 0. 

System.IndexOutOfRangeException: There is no row at position 0. at System.Data.RBTree`1.GetNodeByIndex(Int32 userIndex) at Microsoft.Dynamics.Servicing.DataUpgrade.AxConsoleApp.MenuHelper.

<EnvironmentSetup>d__17.MoveNext() in C:\__w\1\s\src\Migration.AxConsoleApp\Microsoft.Dynamics.Migration.AxConsoleApp\MenuHelper.

I spent some time understanding what had happened and was able to solve the problem by restarting the SQL and AOS services.

My Performance Resource Page for Microsoft Dynamics AX 2012/Microsoft Dynamics 365 Finance and Operations

A performance issue can have many aspects, so in my opinion there is no universal advice. Below you can find the links I’ve collected, that I use for different cases as a starting point. 

If you face a system performance issue and you are not sure how to deal with it, I would recommend watching the TechTalk Performance Testing in Microsoft Dynamics 365 Series. In my opinion, it can be a good starting point in order to understand the process.

Also, I would recommend a training as another starting point so that you can have a knowledge about the tools: Work with performance and monitoring tools in Finance and Operations apps 

If you need to work with LCS environments:

• Monitoring and diagnostics tools in Lifecycle Services (LCS)
• Optimization advisor 
• How to analyze live performance issues with Dynamics 365 Finance and Operations

In some cases, a data clean-up operation can improve the system’s performance. For example, the “On-hand entries cleanup" operation can improve inventory operations performance. From the list, you can select the appropriate operations and repeat them regularly in order to keep the database size under control.

If the issue can be reproduced in the environment with installed Trace Parser, the links below can be useful as well:

• Take traces by using Trace parser
• Diagnose issues and analyze performance by using Trace parser

The following tips can help to improve the performance of a DMF project:

• 5 Tips to improve the performance in a DMF import project

If you would like to have a performance audit, Denis’ article will be really helpful:

• Dynamics AX performance audit 

If you use AX 2012 version the following links can be helpful:

• Performance Resource Page for Microsoft Dynamics AX 2012
• AX 2012 Performance 

Although the tips are for Ax 2012, some ideas from this page can be relevant for Dynamics 365 Finance and Supply Chain Management.

Ax 2012. Automatic role assignment feature and deactivated users

Automatic role assignment feature and deactivated users

There is a brilliant Ax 2012 system feature - Automatic role assignment. Actually, there is the same feature in Dynamics 365 Finance and Operation as well but I have not tested it yet.

The standard Ax 2012 documentation can be found here:

https://docs.microsoft.com/en-us/dynamicsax-2012/appuser-itpro/assign-users-to-security-roles
Also, you may find great posts related to the Automatic role assignment feature here:
https://dynamicspedia.com/2014/01/automatic-role-assignment-in-ax2012-part-1/
https://dynamicspedia.com/2014/01/automatic-role-assignment-in-ax2012-part-2/

The Automatic role assignment feature was used in one of our Ax 2012 projects and it worked perfectly fine. However, once we faced an issue that in some time after deactivating the user account all its roles were removed except standard one – System user. You can see the example of what we had after roles removing below:

It was really unexpected. Actually, we expected to see the same roles of the deactivated users as these users had had before deactivating their user accounts.

We investigated and discovered that the Automatic role assignment batch job (SysSecurityDynamicRoleAssignment class) removed/revoked all roles for deactivated users except the roles that had been assigned manually.

It seems that the Automatic role assignment feature has one special thing that was mentioned in the standard guide but it has not been explained for deactivated users clearly:
The user is either assigned to the role or removed from the role the next time that the rules for automatic role assignment run.

I would say that for deactivated users the following sentences can be added:

When the user is deactivated in the system, the Automatic role assignment feature will remove all automatic roles assignments except ones that have been done manually.

I am glad if this finding can help someone to save their time.