Raju's Dynamics AX / Dynamics 365 Finance and Operations Blog

As AX 2012 R2 cu9 setup doesn’t contain DIXF components to Install, we need to follow below link to Install. As microsoft stopped supporting AX 2012 r2 , you cannot go to LCS and download the hotfix file as mentioned on this below blog – as it says page not found.

https://docs.microsoft.com/en-us/dynamicsax-2012/appuser-itpro/install-the-ax-2012-r2-cu7-version-of-the-data-import-export-framework-for-use-with-sql-server-2014-dixf

If you tried to install dixf components from Cu7 hotfix file , you are not able to install service component for DIXF because that doesn’t support SQL Server Integration Services for SQL server 2014 Sp2. So you need to create a ticket with Microsoft to get that hotfix.

So below are the steps we did to install DIXF for AX 2012 R2 Cu9  for SQL SERVER 2014 sp2

We created a ticket with Microsoft and they provided us the Hotfix KB4465169.

Then we tried to install DIXF components using this Hotfix in the server where we had SSIS available. The current SQL Server Integration Services we had is version 12.0 for SQL SERVER 2014.

So with this hotfix, I am able to install DIXF Service Component.  (This blog will help with installation https://systemadmintalk.blogspot.com/2017/10/microsoft-dynamics-ax-2012-data.html)

Now I used Cu7 update package (KB 2885603) and installed AOS and Client DIXF components in the AOS Server and then used the hotfix KB4465169 to update those AOS and Client DIXF Components.

We have to make sure below setups are correct for DIXF to work.

1. As DIXF service component is on the SSIS Server, I need to make sure the Service Connection URL on Data Import Export Framework Parameters is referring to that SSIS Server instead of Local Host.

So I went to C:\Program Files\Microsoft Dynamics AX\60\Server\YourDynamicsAX\bin and edited  the Microsoft.Dynamics.DMF.ServiceProxy.dll (xml config file) and find the Endpoint tag and Change on the address

<endpoint address=http://LocalHost:7000/DMFService/DMFServiceHelper.svc

To

<endpoint address=http://yourSSISServer:7000/DMFService/DMFServiceHelper.svc

                Then Make sure you restart DIXF service, AOS Server etc.

• Make sure there is user group named “Microsoft Dynamics AX Data Import Export Framework Service Users’ in AOS and SSIS Servers

Make sure all the Service accounts that are used for DIXF service, SSIS service, AOS Service are added in this user group in both servers.

Make sure AOS Service account and DIXF service account are same.

Make sure both above accounts are added to user group : Administrators.

• Shared Working directory: I created a folder in SSIS Server and provided security for all above mentioned accounts to this folder.
• Then when I click validate on Data Import Export Framework parameters – it validated fine with Green Tick Mark.

Just as safe side, restart aos server, ssis server , aos service, dixf service, ssis service after doing all these.

After following above all steps, I am able to install and load data using DIXF.

This above steps will work to resolve all of the below errors you face during DIXF Installation for SQL server 2014 sp2 AX 2012 r2 cu9

“SQL SERVER Integration Services are missing ”

”

NAME:
ex
VALUE:
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation.

---> System.Exception: Login failed for user 'domainName\machinename$'.

at Microsoft.Dynamics.AX.DMF.ServiceProxy.DmfEntityProxy.DoWork[T](Func`1 work)
— End of inner exception stack trace —
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at Microsoft.Dynamics.AX.ManagedInterop.ClrBridgeImpl.InvokeClrInstanceMethod(ClrBridgeImpl* , ObjectWrapper* objectWrapper, Char* pszMethodName,
Int32 argsLength, ObjectWrapper** arguments, Boolean* argsAreByRef, Boolean* isException)
TYPE:
System.Reflection.TargetInvocationException

NAME:
ex
VALUE:
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. —>
System.ServiceModel.EndpointNotFoundException: The message with To ‘http://yourssisserver:7000//DMFService/DMFServiceHelper.svc&#8217; cannot be processed at the receiver,
due to an AddressFilter mismatch at the EndpointDispatcher. Check that the sender and receiver’s EndpointAddresses agree.

Server stack trace:
at System.ServiceModel.Channels.ServiceChannel.ThrowIfFaultUnderstood(Message reply, MessageFault fault, String action, MessageVersion version, FaultConverter faultConverter)
at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc)
at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)
at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)
at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)