Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. You receive an error when you change Dynamics AX companies in Microsoft Management Reporter that are on different AOS servers: “The operation could not be completed due to a problem in the data provider”

You receive an error when you change Dynamics AX companies in Microsoft Management Reporter that are on different AOS servers: “The operation could not be completed due to a problem in the data provider”

View products that this article applies to.

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.




↑ Back to the top

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.



↑ Back to the top

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. 

↑ Back to the top

Keywords: kbmbsmigrate, kbmbspartner, kbsurveynew, kb

↑ Back to the top

Article Info
Article ID : 2543350
Revision : 1
Created on : 1/7/2017
Published on : 1/4/2012
Exists online : False
Views : 296