Symptoms

When you change Dynamics AX companies in Management Reporter and the companies are on different AOS servers, you receive the following error message:

The operation could not be completed due to a problem in the data provider



In the Application Event Viewer on the Application Server, you receive the following error messages:

Source: Management Reporter Services

Message: Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.AX.Common.DataAccessException: AOS connection failed.  
Message: Microsoft.Dynamics.Performance.Reporting.DataProvider.Service.DirectLinkException: The operation could not be completed due to a problem in the data provider.


This can occur when you sign in to a different company than what you are currently logged into, or when you select a dimension in the reporting tree for a different company than what you are logged in as.




Cause

Management Reporter uses the .NET Business Connector to connect through to Microsoft Dynamics AX 2009. The .NET Business Connector can only connect to a single instance of Microsoft Dynamics AX 2009. You can run into this error because of different situations:

  • Management Reporter has companies setup for multiple Dynamics AX instances for testing reports against different data sets or environments, such as development, QA, and production.

  • You are trying to consolidate data from multiple AOS instances.



Resolution

  • Unless reports are data specific, it is suggested to point Management Reporter at a single instance of Dynamics AX 2009. Pointing Management Reporter to a new instance will affect all users. During the implementation phase of Dynamics AX it may be acceptable to use a single instance of Management Reporter against a test environment, and then later point that environment to you production environment.

  • A single Dynamics AX AOS can contain multiple companies. To report on multiple companies you can utilize the Dynamics AX 2009 consolidation or import/export features to import/export between instances or companies. See the Dynamics AX2009 training or online help for more information on how to perform these steps.

  • You can also utilize the link to data in Microsoft Excel to consolidate additional data from Dynamics AX or any other data source that supports exporting.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×