Consider a scenario where you are importing data using DIXF, and you get an error when you try to “Preview source file”.
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.2.1000.4051, time stamp: 0x5272cc67 – Faulting module name: KERNELBASE.dll, version: 6.3.9600.17055
2. Minimum requirements
We support running AX 2012 R3, AX 2012 R2 CU7, and AX 2012 CU7 on SQL Server 2012 SP2 CU2 or higher.
TechNet Blogs » Dynamics AX In-Market Engineering » Announcing Support for SQL Server, SharePoint, and Office 2013 Service Packs as well as Visual Studio Team Foundation Server and Visual Studio Online http://blogs.technet.com/b/dynamicsaxse/archive/2014/10/09/announcing-support-for-sql-server-sharepoint-and-office-2013-service-packs-as-well-as-visual-studio-team-foundation-server-and-visual-studio-online.aspx
Check the system requirements for details:
Microsoft Dynamics AX 2012 System Requirements https://www.microsoft.com/en-gb/download/details.aspx?id=11094
The fix for this SSIS issue is included in SQL Server 2012 SP2 CU2:
Please patch your SQL Server 2012 SP2 components to CU2 or higher. The highest available Cumulative Update (CU) for SQL Server 2012 SP2 is currently CU9, so I would recommend going with that build at this point in time.
Cumulative update package 9 for SQL Server 2012 SP2 https://support.microsoft.com/en-us/kb/3098512
Please implement this in TEST first, before rolling out in PROD, in line with your change management processes.