"The operation could not be completed due to a problem in the data provider" error when changing companies in Management Reporter

  • Article

This article provides a resolution for error The operation could not be completed due to a problem in the data provide that occurs when y ou try to change Dynamics AX companies in Management Reporter that are on different AOS servers.

Applies to:   Microsoft Dynamics AX 2009, Microsoft Dynamics AX 2009 Service Pack 1
Original KB number:   2543350

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 set up for multiple Dynamics AX instances for testing reports against different data sets or environments, such as development, QA, and production.
  • You're trying to consolidate data from multiple AOS instances.

Resolution

  • Unless reports are data-specific, it's 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 your production environment.
  • A single Dynamics AX AOS can contain multiple companies. To report on multiple companies, you can use 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 do 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.