Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Management Reporter data provider framework error

Posted on by 820

When I click on the report wizard in Management Reporter, I get "The operation could not be completed due to a problem in the data provider framework."  I also get this error when I try to create a row.

Any suggestions?

*This post is locked for comments

  • Suggested answer
    GF-09081432-0 Profile Picture
    GF-09081432-0 5 on at
    Management Reporter data provider framework error
    Yes this resolved the issue after setting up a test database copy of the live had to go in and set the access for multi currency that worked got rid of the framework m r error  Multicurrency setting.  Once this was set and configured correctly the MR worked as expected.
  • Esakkiraja Profile Picture
    Esakkiraja 5 on at
    RE: Management Reporter data provider framework error

    Cause

    This error can be caused if you do not have any accounts created in the general ledger or you have not posted anything yet.

    Resolution

    Make sure accounts have been created in the general ledger and that there is at least one transaction posted.

  • Alvaidas Gedminas Profile Picture
    Alvaidas Gedminas 120 on at
    RE: Management Reporter data provider framework error

    Thanks for the quick response, but after running the query it returned 0 rows. And im still having same problems with the Management Reporter 2012 CU 12

    Thanks

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Management Reporter data provider framework error

    You need to run a query against the company db:

    select * from GL00200 where budgetid=''

    if there are results, then do

    delete GL00200 where budgetid=''

  • Alvaidas Gedminas Profile Picture
    Alvaidas Gedminas 120 on at
    RE: Management Reporter data provider framework error

    Im having same issues with Management Reporter CU12. I can find the table GL002000 but the Budget ID is a primary key how do i delete it ?

    Thanks

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Management Reporter data provider framework error

    Hi Karlie:

    You would need to connect to SQL Server Management Studio and then log into the correct Database server. Expand the 'Databases' >Expand your 'company' > double click the 'Tables' > find 'GL00200'. Find the offending Line and delete it.

    ***Warning***Working directly within SQL always poses a danger that you might accidentally damage your system beyond repair. If you are not comfortable working with SQL, please have someone knowledgeable help you.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Management Reporter data provider framework error

    Hi everyone, I'm having the same issue and I'm wondering how can I get to the GL00200 table of my GP company - the one David mentioned? Thanks in advance!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Management Reporter data provider framework error

    Some times there is some problem in the dimensions. In my case there was '0' and '  0' in one dimension.

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Management Reporter data provider framework error

    I am not sure if it is different in v2.0 and v2.1 CU10 - but the solution that worked for me was the Multicurrency setting.  Once this was set and configured correctly the MR worked as expected.

  • olegvi Profile Picture
    olegvi 769 on at
    RE: Management Reporter data provider framework error

    Server reboot fixed it for me.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans