Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Suggested answer

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?

  • 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.

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,252 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,089 Super User 2024 Season 2

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans