[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.