AIF Activation Error

After installing AX 2012 CU6 on an environment I got the following error after trying to reactivate the AIF inbound ports:

Faulted: System.OperationCanceledException: AIF service group not activated.  Service group: AifGDS.  Error: There is already a listener on IP endpoint 0.0.0.0:8201.  Make sure that you are not trying to use this endpoint multiple times in your application and that there are no other applications listening on this endpoint. ---> System.ServiceModel.AddressAlreadyInUseException: There is already a listener on IP endpoint 0.0.0.0:8201.  Make sure that you are not trying to use this endpoint multiple times in your application and that there are no other applications listening on this endpoint. ---> System.Net.Sockets.SocketException: Only one usage of each socket address (protocol/network address/port) is normally permitted

I was confused about the wrong WSDL Port in the error cause the port of the AOS where I was working on was 8103. After some research in the WorldWideWeb I found a solution that solved this issue for me:

1. navigate to server bin folder:
   C:\Program Files\Microsoft Dynamics AX\60\Server\DAX2012\bin
2. open Ax32Serv.exe.config file in an editor
3. replace 8101 with your WSDL Port
4. replace 8201 with your servicePort

Getting access to SQL Server

Everyone of us knows the problem that after a SQL Server Installation you suddenly recognize that you have forgotten to grant your user access to the SQL Server instance.
Due to the fact that the NT AUTHORITY\SYSTEM account alwas has access to the SQL server a simple workaround is using PsExec. It allows you to run programs as the SYSTEM user.

1. download PsExec and extract it somewhere
2. open CMD and navigate to PsExec folder
3. start SQL Server Manager with the following command:
   PsExec -s -i "C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\Ssms.exe"

Add your user in the Security settings :)

For me this worked fine with SQL Server 2008 but seems to be not working with SQL Server 2012. You can get access to the SQL Server but you are not allowed to change Security settings or add users.

AX2012 Export / Import Error

When the following error occurs during data import via DAT/DEF then the following could help:

Cannot execute the required database operation. The SQL database has issued an error.
An error occured during data import

First of all this message does not tell where the error came from. So I checked the error log of the SQL Server and found this message:

Object Server 03: The database reported (session 3 ()): [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'DBO.[AX2012_model] .[dbo].SECURITYROLE'.. The SQL statement was: "UPDATE "DBO"."T073473B435914AF595C2B7075BD5D7D6" SET "CONFLICTS" = 1, "NEWRECID" = "DBO".SYSOLD2NEWRECID.IDREF FROM "DBO"."[AX2012_model].[dbo].SECURITYROLE","DBO".SYSOLD2NEWRECID WHERE "DBO"."T073473B435914AF595C2B7075BD5D7D6"."CONFLICTS" = 0 AND "DBO"."T073473B435914AF595C2B7075BD5D7D6".RECID = "DBO".SYSOLD2NEWRECID.ID AND "DBO"."[AX2012_model].[dbo].SECURITYROLE".RECID = "DBO".SYSOLD2NEWRECID.IDREF AND "DBO".SYSOLD2NEWRECID.TABLEREF = 65491 AND "DBO".SYSOLD2NEWRECID.SOURCEGUID = '{F20E9748-9070-4138-8546-38B382154E08}' AND "DBO".SYSOLD2NEWRECID.TARGETVIRTUALCOMPANY = '""' AND "DBO".SYSOLD2NEWRECID.PARTITION = 5637144576"

This message indicates that there is a problem with the table SecurityRole. So I tried to find out why the system want's to import records from this table even though it was not included in the tablegroup. After exporting into a comma seperated file i could find records with this table in the exported DAT File. Searching for the RecID of these records I found a refernce from the DirExternalRole table.

After removing this Table from the tableGroup I exported the data again and nowthe import is not throwing this error anymore :)

AX 2012 Shortcut to view details

If you want to view details in AX 2012 the standard way is using the mouse -> Right click -> click on view details. But you can get there evan faster and without using the mouse.

The ShortCut to open the context menu is SHIFT + F10 or the ContextMenu Key between ALT GR and STRG. Clicking this followed by the key V will open the View details.

SHIFT + F10 -> V

or

 -> V

This also works with other letters. If you use F for example then you need to press enter if you want to Filter by Field or use the down arrow and press enter.

Get a list of users in a Windows Active Directory group

Because I always forget this short and important command I post it here. It is the shortest command line prompt to get a list of users in an AD Group:

net group /domain

Microsoft Product Lifecycle - Mainstream and extended support end dates

Products Released	Lifecycle Start Date	Mainstream Support End Date	Extended Support End Date	Service Pack Support End Date
Dynamics AX 2009	8/14/2008	10/8/2013	10/9/2018	1/11/2011
Dynamics AX 2009 Service Pack 1	11/3/2008	Support ends 24 months after the next service pack releases or at the end of the product's support lifecycle, whichever comes first
Dynamics AX 2012	9/25/2011	10/11/2016	10/12/2021
Dynamics AX 2012 R2	2/19/2013	10/11/2016	10/12/2021

Microsoft SQL Server build numbers

Here is a wonderful list of all the build numbers from the SQL Server versions:

Microsoft SQL Server 2012, 2008R2, 2008, 2005, 2000 and 7.0 Builds