Ax 2012 Management reporter - Installation Check Points

1. Run setup.exe from AX 2012 CU7 installation folder, and select components "Management reporter" and "Management reporter report designer"

2. Enter the AOS server and port numbers (Normally 2712 and 8201) which the management reporter would connect to.

3.Enter the database server name and select the Ax 2012 database (Not model database)

4. Enter AOS service account and password. This account should have "sysadmin" role in the database server

5. Enter Management report service port, configuration database name and data mart database name.
    Note 1: Make sure the port would not be blocked by firewall
    Note 2: Make sure the database names are not existing in database server
    Note 3: Make sure the database server has enough space for these two new databases

6. (Important) Enter integration account and password, and then enter the AX user id linked to this integration account.
     Note 1: Integration account must has "sysadmin" role in the database server
     Note 2: Integration account mush has a Ax user id created. And the Ax user id must have roles of "System administrator" and "Security administrator"

7. After the installation, we should be able to see the services are created and one Ax data mart is connected.

Possible error: There is no company is imported.
Reason: No company in the AX has ledger setup.
Solution: Configure the ledger setting for AX company

Possible error: The integration account does not have permissions.
Reason: 1. Management reporter only allow 4 free accounts without license. 2. Ax user (linked to integration account) does not have "security administrator" role
Diagnostic: Look at the "securtyUser" table in Management reporter configuration database.

Solution: Load the license from management reporter client and make sure ax integration user has "security administrator" role


 

Ax 2012 TFS - Client crash with error "AccessViolationException"

After TFS is configured for Ax 2012, occupationally, the Ax client would crash when we try to check out or get latest objects.

Solution:

1.  Delete the .AUC files under c:\users\username\AppData\Local
2.  Reset usage data  under Tools -> options
3.  Go to Version control -> synchronization log. And process the lines are not completed.

AX 2012 TFS - Temporary label files

After TFS is setup for AX coding version control, we would see a weird label id (like @$A) while we try to create a new label.

That's because the real label Id would not be assigned until the label is checked in.

Instead, there are temporary label files created with weird name. 

The files can be found under server application folder.

In conclusion, if we see the weird label Id, it would be alright. No panic :-)

Ax 2012 Enterprise Portal - How to create EP proxies

In Ax 2012, a proxy need to be generated to call a table method from Enterprise portal.

Here, we are going to talk about how to create a proxy for the static method "webLookupItemidQuery" in "InventTable".

1. Open Visual Studio, and create new project

2. Select project template "Class Library"

3. After creating the project, right click the project to open the property panel and then change namespace to "Microsoft.Dynamics.Portal.Application.Proxy"

4. Right click the project again to select "Add XXXX to AOT" (XXXX is the project name)

The project would be able to be found under AOT -> Visual Studio Projects -> C Sharp Projects

5. Add the table to the project

6. Finally, don't forget to set the project to be EP Proxy Project

Once the proxy is created, the method can be called from EP pages.