System Security Duty V2 Entity shows/export stale data even after creating new roles and duties.

 Issue:

System Security Duty V2 (SystemSecurityDutyV2Entity) is showing same export even after creating new roles and duties

Resolution:

You need to batch SecurityRoleDutyPrivilegeExplodedGraphController class. At backend it will run a stored procedure that will refresh with new data. This batch will take very minimal time so admin can schedule the same as per business need. 

Installing and Configuring Load balancer AOS - Dynamics AX 2012

Step to install Load balancer 

• Install ‘n’-number of AOS required using product CD.
• In my case I have installed 3 AOS – (2 will be a normal AOS and 1 AOS will act as Load balancer).
• Important thing to remember is that 1 AOS always be act as Load balancer. Also there will be no license consumed by Load balancer
• Below image shows list of services I have configured.

• Have configured client configuration as listed below
• After exporting the config file you will find all the AOS. Also remember to install the same config on all client systems

.

• Go to System administration and do cluster configuration

Once the user get login you can see they are equally divided between AOS

AX 2012 Client crash: System.Runtime.InteropServices.SEHException

Issue


When ever tried to open client got below error:

Application: Ax32.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: System.Runtime.InteropServices.SEHException
Stack:
   at <Module>._wWinMainCRTStartup()

Resolution

Re-install the client

TFS integration with AX 2012 R3 CU8

Hi

For any issue with TFS integration with AX 2012 R3 CU8 refer below link

http://blogs.msdn.com/b/axsa/archive/2014/12/02/visual-studio-and-tfs-support-in-ax-2012-r3-cu8.aspx?CommentPosted=true#commentmessage

Happy day :)

AX 2012: Failed to create a session; confirm that the user has the proper privileges to log on to Microsoft Dynamics

 Issue: When i try to do full db sych i get following error:

"Failed to create a session; confirm that the user has the proper privileges to log on to Microsoft Dynamics"


Resolution:

Run below script on MicrosoftDyanmicsAX transaction db (not model db).

DECLARE @NetworkDomain nvarchar(300);

DECLARE @NetworkAlias nvarchar(300);

DECLARE @SID nvarchar(124);

DECLARE @InitialPartition BIGINT;

SELECT @InitialPartition=Recid FROM PARTITIONS WHERE PARTITIONKEY=N'Initial'

SELECT @NetworkAlias=NETWORKALIAS,@NetworkDomain=NETWORKDOMAIN,@SID=SID

FROM USERINFO

WHERE PARTITION=@InitialPartition AND ID = N'Admin'

UPDATE USERINFO

SET

NETWORKDOMAIN=@NetworkDomain,

NETWORKALIAS=@NetworkAlias,

SID=@SID

WHERE PARTITION != @InitialPartition AND ID = N'Admin'

AX 2012 DMF Issue - Could not load file or assembly 'Microsoft.SqlServer.ManagedDTS, Version=11.0.0.0

Hi

Recently i have done upgrade to CU8. Before import all the DMF imports where working fine. But once migrated to CU8 i was getting below error

Error:

Could not load file or assembly 'Microsoft.SqlServer.ManagedDTS, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.


Reason:

CU8 upgrade require Sql server 2014 and once you install SQL Server 2014 on you DB environment (Note: Previous version of my DMF install was working with SQL Server 2012 and it was working fine and prior to installing 2014 i have removed SQL 2012 version) the previous version of Microsoft Dynamics AX Data Import/Export Framework Service on SQL box was integrated with Microsoft.SqlServer.ManagedDTS, Version=11.0.0.0 Which is already removed from my system. Now you have to make Microsoft Dynamics AX Data Import/Export Framework Service to point Microsoft.SqlServer.ManagedDTS, Version=12.0.0.0.

Resolution

Reinstall "Microsoft Dynamics AX Data Import/Export Framework Service" on SQL Server box.


Happy day :)

EXPORT AX model - "Login failed for user '******'.,Microsoft.Dynamics.AX.Framework.Tools.ModelManagement.PowerShell.ExportAXModelCommand

While exporting AX model using Dynamics AX cmdlet following issue came

Resolution:

You dont have access to SQL DB. Provide an access to perform this operation