Views:

Applies to Product - Dynamics 365 Commerce

What’s happening?
Customers are experiencing failures during DMF (Data Management Framework) imports, receiving errors indicating that specific assemblies cannot be loaded. Common error messages include "Could not load file or assembly 'Microsoft.SqlServer.Diagnostics.S{NAMEPII}, Version={ALPHANUMERICPII}' or one of its dependencies. The system cannot find the file specified."


Reason:
This is often related to missing assembly files or incorrect configurations in the environment, particularly when using SQL Server versions that are not compatible with the required assemblies for DMF operations.


Resolution:

  1. Install SQL Server 2019 Developer Edition: Download and install SQL Server 2019 Developer Edition, ensuring to include all features related to SDK and connectivity components. This can be obtained from the official Microsoft website.
  2. Set Target Server Version: When configuring the environment, ensure that the Target Server Version is set to SQL Server 2019.
  3. Check for Incremental Updates: On the environments page in Lifecycle Services (LCS), check for any incremental updates for SQL Server 2019. If available, apply these updates.
  4. Reinstall Assemblies: If the issue persists, uninstall and reinstall the affected assembly files located in the AOSService/PackageLocalDirectory path.
  5. Redeployment Consideration: If the above steps do not resolve the issue, consider redeploying the environment as a potential solution.
  6. Follow-Up: Ensure to follow up with the support team for any additional assistance or if further issues arise after implementing the above steps.

If the problem continues after these actions, please provide detailed feedback to support for further investigation.