How to resolve error Disconnected from the AOS for Microsoft Dynamics AX 2012 and Visual Studio .Net

Why you get error "Disconnected from the AOS" when you open Visual Studio and try to see Application Explorer tool box to customize something for Microsoft Dynamics AX Enterprise Portal or SSRS Reports?

Reason:

The Visual Studio instance you open does not refer the configuration which is configured. Such error you will encounter when you have different client and AOS system. For example; Server 1 is having Application Object Server (AOS) and System 1 is having AX client so you have AX client and server on different machines. Other way your Visual Studio instance is not connected to target Microsoft Dynamics AX AOS configuration.

Applied on: Dynamics AX 2012 R2

Prerequisite: Basic Dynamics AX 2012 knowledge
Target audience: AX programmers
Assumption: You are familiar with Dynamics AX 2012 and Visual Studio .Net


Solution:
Option 1: You should have AX client and server on the same machine. In general development server with multi users is not configured with single machine based.

Option 2: If your AX client and server are on different machines, you need to launch your Visual Studio instance using a shortcut from AX client machine and that shortcut should have target AOS configuration. E.g. You have an AX configuration file called VAR_DEV.AXC to launch the correct AOS. Get a shortcut of your Visual Studio on AX client machine right click on it. You will see the property dialog as shown below.

 

You will see the Visual Studio instance common IDE path [see above]. This is the default path. The depends based on installation.

The Target field should have path "C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\devenv.exe". This is the default path.

The action you need to perform is to add target for AOS configuration file to it. To achieve this replace the path with "C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\devenv.exe" /AXConfig \\[File location]\DEV04_VAR.AXC


After modifying this value click on Apply button. Now you launch your Visual Studio by double clicking this Visual Studio Icon. It will allow you to see AOT objects as shown below.

  

Option 3: On AX client machine configuration utility you can upload configuration file DEV04_VAR.AXC. To do this, open Microsoft Dynamics AX 2012 Configuration Utility from Administrative Tools. Click on Manage button then Set Configuration Stone.

Click on Apply button then OK.

Now you can launch your Visual Studio on AX client machine from Start button > All Programs > Microsoft Visual Studio 2010 folder > Microsoft Visual Studio 2010.

Hope this was useful for you. You may leave your comments below.

 

Microsoft Dynamics AX 2012 Cubes or Role center BI report error

Microsoft Dynamics AX 2012 Cubes or Role center BI report error.

In Microsoft Dynamics AX 2012 you might face problem with BI reports for role center or reports where Cubes are involve.

There can be number of reasons for this and you will get number of errors. Like permission not granted, access denied, related data missing, cubes not processed etc.

Two main reasons are (1) data missing in respective tables and (2) insufficient license.

In most of the places data is interrelated among the tables. If you are missing related data in tables, it will give some errors.

Secondly, by default Microsoft provides cubes for all the tables and assumption is you have 100% license. But when there is a limited license and you apply it to your application, based on limited license system drops few tables for which you do not have license. In such a scenario your queries for cubes are not updated and they are still using 100% tables but you don’t have 100% tables now because of limited license.

Here the option for you is to update the queries but it’s a huge task. For Microsoft Dynamics AX 2009 you have to do it manually but to help you Microsoft published a tool to generate an excel sheet which tells you what are the areas you need to work.
In case of Dynamics AX 2012, Microsoft provided few options in the form of a wizard from where you can do it by clicking a button as shown below:
Path: Tools Business Intelligence (BI) Tools  SQL Server Analysis Services project wizard.

In the above wizard if you select Update option and follow the wizard it resolve your problem.

Microsoft Dynamics Ax 2009 SRS Reports Deployment error (AL.EXE) not found

This article explains how to resolve AL.EXE error or exception during Microsoft Dynamics Ax 2009 SRS reports deployment.

Applied on:
Windows Server 2008 SP1
SQL Server 2008
Microsoft Dynamics Ax 2009 SP1

When attempting to deploy Microsoft Dynamics Ax SRS reports, you may have received the following error message:

Unable to load one or more of the requested types.
Retrieve the LoaderExceptions property for more information.
Error: The following components have not been installed or are not configured correctly:
AL.exe
Please consult your administrator or the documentation.
System.InvalidOperationException: The following components have not been installed or are not configured correctly:
AL.exe
Please consult your administrator or the documentation.



This error message indicates that the following software components are not installed:

• Windows SDK for Windows Server 2008 and .NET Framework 3.5
• Microsoft Visual Studio 2008 Shell (isolated mode)

You can download above prerequisites from following links:
Windows SDK for Windows Server 2008 and .NET Framework 3.5
Microsoft Visual Studio 2008 Shell (isolated mode)

The above link can be changed without any notice.

Note: Use at your own risk. There is no warranty on this article.

How to grant User Access to a SSRS Report Server (Report Manager)

How to grant User Access to a SSRS Report Server (Report Manager)

This article describes:

• How to give access of report server (report manager) to user or grant user access to a report server (report manager).
• How to get solution for SSRS report access denied exception / error in Microsoft Dynamics Ax 2009 Role Center (Enterprise Portal).
• How to solve the insufficient permission exception as shown below:
  

Applied on: SQL Server 2005 SP2 and Microsoft Dynamics Ax 2009 SP1.

Reporting Services use role-based security to grant user access to a report server. On a new report server installation, only users who are members of the local Administrators group have permissions to report server content and operations. To make the report server available to other users, you have to create role assignments that map user or group accounts to a predefined role that specifies a collection of tasks.



To add a user or group to a system role

1. Start Report Manager.

2. Click Site Settings.

3. Click Security.

4. Click New Role Assignment.

5. In Group or user, enter a Windows domain user or group account in this format: [domain name]\[account]. If you are using forms authentication or custom security, specify the user or group account in the format that is correct for your deployment.

6. Select a system role, and then click OK.

If you select both System Administrator and System User, a user or group will be able to perform the tasks in both roles.




To add a user or group to an Role

1. Open Report Manager.


2. Click the Properties tab.

3. Click the Security tab.

4. Click New Role Assignment.

5. In Group or user, enter a Windows domain user or group account in this format: [domain]\[account].

6. Select one or more role definitions that describe how the user or group should access the item, and then click OK.

Note: Use at your own risk. There is no warranty on this article.

Other related article: Resolution for Microsoft Dynamics Ax 2009 Role Center & Enterprise Portal (EP) Access Denied error /exception.