Friday 11 September 2015

DMF1942 : Access is denied for the user dixf/DMF AX2012


Resolution for the issue

"DMF1942 at Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelperService.Authorization.AuthorizationManager.CheckAccessCore(OperationContext operationContext)"


Doing the following steps:

1.    Added  AOS Service Account and DIXF Service Account (read/write access) to the folder specified in DMF parameters

2. Added  these service accounts to local group “Microsoft Dynamics AX Data Import Export Framework Service”

3.  Restarted the server

4. Restart  "Dynamics AX Data Import/Export framework service.

Wednesday 9 September 2015

AX2012 R2: Failed to create a session


When i install the KB Update in AX 2012 R2 and tried to synchronize DB I get error message:
Failed to create a session; confirm that the user has the proper privileges to log on to Microsoft Dynamics
A closer look into this learned that this is linked to the new partitions feature.
It seems the UserInfo table is not correctly updated and the partition administrator is not updated correctly when you restore an existing DB or the Demo database.
To fix this, you can do the following.
Stop the AOS
Restore the database again
Start the AOS
Start a client and complete the partition initialiasation checklist
Close the client and execute the script below on the SQL database
Restart the client and re import your license (if you were restoring the Microsoft demo data, the demo license is back in there)
Then compile / generate CIL / DB sync and you should be on track again!
The script for updating the UserInfo inforation is as follows:
SELECT TOP 1000 [PARTITIONKEY]
,[RECID]
FROM [MicrosoftDynamicsAX].[dbo].[PARTITIONS]

To manually create the new Admin you will need to have the SID for the user. If you are working in demo then this is Admin you might want to find the SID from the exiting user and copy that for the user you want to use.
SELECT TOP 1000 [ID]
,[NAME]
,[SID]
,[RECVERSION]
,[PARTITION]
,[RECID]
FROM [MicrosoftDynamicsAX].[dbo].[USERINFO]