[D365] Import export projects fail without clear error DMFExecutePackage unhandled exception

We recently upgraded to PU39 and restored a database from a UAT environment to a Test environment (DevTest).

After that import and export projects failed without a clear error message.
The eventlog stated the following:

Application: DMFExecutePackage.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: System.ArgumentException
   at System.Data.SqlClient.SqlConnectionStringBuilder.GetIndex(System.String)
   at System.Data.SqlClient.SqlConnectionStringBuilder.set_Item(System.String, System.Object)
   at System.Data.Common.DbConnectionStringBuilder.set_ConnectionString(System.String)
   at System.Data.SqlClient.SqlConnectionStringBuilder..ctor(System.String)
   at DMFExecutePackage.Program.sanitizeConnectionString(System.String)
   at DMFExecutePackage.Program.Main(System.String[])

Faulting application name: DMFExecutePackage.exe, version: 7.0.5816.35651, time stamp: 0xefb20dcc
Faulting module name: KERNELBASE.dll, version: 10.0.14393.3986, time stamp: 0x5f77fd5b
Exception code: 0xe0434352
Fault offset: 0x0000000000034f38
Faulting process id: 0x3c08
Faulting application start time: 0x01d70435db7ae546
Faulting application path: C:\Program Files (x86)\Microsoft Dynamics AX\70\DataImportExportFramework\DMFExecutePackage.exe
Faulting module path: C:\windows\System32\KERNELBASE.dll
Report Id: aabc9443-191c-4d74-8495-214b8d345a00
Faulting package full name: 
Faulting package-relative application ID: 

Solution

It looks ugly and we can't explain why, but this is what worked for us:

Note the value from Data Management Workspace > Data import/export framework parameters > Service connection url.
Open the file C:\Program Files (x86)\Microsoft Dynamics AX\70\DataImportExportFramework\Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelperService.exe.config and make sure the attribute baseAddress has the same value:

<configuration>
...
  <system.serviceModel>
    <services>
      <service>
        ...
        <host>
          <baseAddress>
            <add baseAddress="http://localhost:7000/DMFService/DMFServiceHelper.svc"/>
            ...

And now comes the part that we can't explain:

The file DMFExecutePackage.exe existed in two places:

  • C:\AOSService\webroot\bin
  • C:\Program Files (x86)\Microsoft Dynamics AX\70\DataImportExportFramework

From the eventlog we saw that the second one was used. On other environments we compared this one to we could only find it in C:\AOSService\webroot\bin.

Go ahead and delete the one from C:\Program Files (x86)\Microsoft Dynamics AX\70\DataImportExportFramework (maybe move it somewhere else first to be sure).

Restart the service Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelperService.exe and try again.