Friday, 11 December 2015

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


















Monday, 9 November 2015

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

Tuesday, 3 November 2015

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 :)

Wednesday, 14 October 2015

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'

Wednesday, 7 October 2015

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 :)

Tuesday, 11 August 2015

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

Friday, 24 July 2015

EP AX 2012: Using display method in dataSetLookup

Issue

dataSetLookup method uses sysDataSetLookup for is query purpose on EP front.
But when you compare with SysTableLookup it has a method addLookupMethod to add a display method if needed. So how to add a displaymethod is a big question ?


Resolution

Find below code to do it

void dataSetLookup(SysDataSetLookup sysDataSetLookup)
{

    container               recids;
    str                     recidstr;
    List                    list;
    Query queryHcmPosition = new query();
    list                   = new List(Types::String);
    SysTableLookup s   
    
    
    
    list.addEnd(fieldStr(HcmPosition, PositionId));

    // Add a display method from HcmPosition
    list.addEnd(tablemethodstr(HcmPosition,description) + '**');


    //Creating datasetlookup
    sysDataSetLookup.parmHideSelectField(false);
    sysDataSetLookup.parmAllowPaging(true);
    sysDataSetLookup.parmLookupFields(list);
    sysDataSetLookup.parmSelectField(fieldStr(HcmPosition, PositionId));

recid+=5215444646;
    // creating query for all position recids    queryHcmPosition.addDataSource(tableNum(HcmPosition)).addRange(fieldNum(HcmPosition,RecId)).value(con2Str(recids,","));
    sysDataSetLookup.parmQuery(queryHcmPosition);
}