Applies to Product - Dynamics 365 Supply Chain Management
What’s happening?
The system is taking an excessive amount of time to load bulk data, specifically when importing a large number of records (e.g., 75000+ release products) into a new legal entity.
Reason:
The slow performance during the data import process is primarily due to the configuration of the import job, specifically the use of a single batch thread for the import. Additionally, transient database connection issues may occur during the import process.
Resolution:
- Optimize Thread Configuration:
- Configure multiple threads for the data import process to enhance performance. Follow the guidelines provided in the documentation for optimizing data migration for finance and operations apps.
- Clear Previous Imports:
- If there are issues with previously imported data, clear the imported data in the staging table and the relevant entities before re-importing.
- To clear the imported data, write a runnable class as per the instructions in the documentation for running custom X++ scripts with zero downtime.
- Re-import Data:
- After clearing the previous imports, re-import the data and monitor the performance to ensure that the changes have improved the import speed.
- Monitor for Errors:
- Keep an eye on any transient database connection errors that may arise during the import process. Transient errors will be retried automatically.