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.

Error message when you generate a report in Microsoft Management Reporter: “The operation could not be completed due to a problem in the data provider framework”


View products that this article applies to.

Symptoms

When you generate a report in Microsoft Management Reporter that includes Dynamics GP budget information, you receive the following error message:

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

↑ Back to the top


Cause

This error is caused by a blank budget ID in Microsoft Dynamics GP.

↑ Back to the top


Resolution


Note Before you follow the instructions in this article, make sure that you have a complete backup copy of the database that you can restore if a problem occurs.


To resolve this error message, follow these steps:

  1. Open SQL Server Management Studio and log in with the sa credentials.
  2. Run the following query against your GP company database:
    Select * from GL00200
  3. Check the BudgetID column for any blank IDs.
  4. If there are blank IDs, you can run the following query against the GP company database to remove them:
    Delete from GL00200 where budgetid = ' '
You should now be able to generate the report in MR without receiving the error message.

↑ Back to the top


Keywords: kbmbsmigrate, kbmbspartner, kbsurveynew, kb

↑ Back to the top

Article Info
Article ID : 2739480
Revision : 1
Created on : 1/7/2017
Published on : 7/30/2012
Exists online : False
Views : 356