DIXF on SQL 2014 – Cannot Preview source file – CommunicationException – An error occurred while receiving the HTTP response from DMFServiceHelper.svc
Consider a scenario where you are importing data using DIXF, and you get an error when you try to “Preview source file” and you are running SQL Server 2014 SP2 CU10 or CU11.
1. The error
The error you see looks something like this:
System.ServiceModel.CommunicationException: An error occurred while receiving the HTTP response to http://servernamehere:7000/DMFService/DMFServiceHelper.svc. This could be due to the service endpoint binding not using the HTTP protocol. This could also be due to an HTTP request context being aborted by the server (possibly due to the service shutting down).
We also see these sorts of events in the Windows Event Log:
Event 1026 – .NET Runtime – Application: Microsoft.Dynamics.AX.DMF.SSISHelperService.exe – The process was terminated due to an unhandled exception – exception code 1
Event 1000 – Application Error – Faulting application name: Microsoft.Dynamics.AX.DMF.SSISHelperService.exe, version:6.3.6000.3667 – Faulting module name: KERNELBASE.dll, version: 6.3.9600.18202
2. Cause
There is a SSIS issue in SQL Server 2104 SP2 CU10 for which a fix will ship in SP2 CU12.
3. Possible workarounds
On AX side, the issue will repro only when “Create error file” is enabled in “Data import/export framework parameters“. Thus, as a workaround, users can un-check this option until the SSIS fix has shipped.
Another option is to uninstall the SQL Server CU that is causing the issue and wait for CU12 to ship.
Please implement this in TEST first, before rolling out in PROD, in line with your change management processes.
