Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Management Reporter 20...
Microsoft Dynamics GP (Archived)

Management Reporter 2012 "Operation is not valid due to the current state of the object."

(0) ShareShare
ReportReport
Posted on by RHarper5 770

I have an issue in MR with one report that fails to run saying the "an error occurred while retrieving balances from the source provider" and the following shows in the event viewer:

Log Name:      Application

Source:        Management Reporter 2012 Services

Date:          1/7/2014 9:59:34 AM

Event ID:      0

Task Category: None

Level:         Error

Keywords:      Classic

User:          N/A

Computer:      Computername

Description:bryan

System.InvalidOperationException: Operation is not valid due to the current state of the object.

  at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.DataMart.Data.MultiMap`2.FindValue(Int64 id)

  at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.DataMart.Data.DataMartReader.ReadDimensions()

  at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.DataMart.Data.DataMartAccountBalanceReader.get_AccountCode()

  at Microsoft.Dynamics.Performance.Reporting.Engine.Server.GLDataProcessor.CreateAccountDetailKey(PostedGrouping postedGrouping, IGLAccountBalance accountBalance)

  at Microsoft.Dynamics.Performance.Reporting.Engine.Server.GLDataProcessor.ProcessOneAccountBalanceRecord(FRxUnitRowIdentifier frxUnitRowIdentifier, IGLDataReader balanceReader, ReportUnitResult unitResult, ReportDetailLevels detailLevel)

  at Microsoft.Dynamics.Performance.Reporting.Engine.Server.GLDataProcessor.ProcessOneReaderRecord(FRxUnitRowIdentifier frxUnitRowIdentifier, ReportDetailLevels detailLevel, IGLDataReader balanceReader)

  at Microsoft.Dynamics.Performance.Reporting.Engine.Server.GLDataProcessor.ProcessOneReaderRecord(IGLDataReader balanceReader)

  at Microsoft.Dynamics.Performance.Reporting.Engine.Server.GLDataProcessor.ProcessOneBalanceRecord(IGLDataReader balanceReader)

  at Microsoft.Dynamics.Performance.Reporting.Engine.Server.GLDataProcessor.ProcessOneBalanceReader(IGLDataReader balanceReader)

Event Xml:

<Event xmlns="schemas.microsoft.com/.../event">

 <System>

   <Provider Name="Management Reporter 2012 Services" />

   <EventID Qualifiers="0">0</EventID>

   <Level>2</Level>

   <Task>0</Task>

   <Keywords>0x80000000000000</Keywords>

   <TimeCreated SystemTime="2014-01-07T15:59:34.000000000Z" />

   <EventRecordID>91283</EventRecordID>

   <Channel>Application</Channel>

   <Computer>ComputerName</Computer>

   <Security />

 </System>

 <EventData>

   <Data>System.InvalidOperationException: Operation is not valid due to the current state of the object.

  at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.DataMart.Data.MultiMap`2.FindValue(Int64 id)

  at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.DataMart.Data.DataMartReader.ReadDimensions()

  at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.DataMart.Data.DataMartAccountBalanceReader.get_AccountCode()

  at Microsoft.Dynamics.Performance.Reporting.Engine.Server.GLDataProcessor.CreateAccountDetailKey(PostedGrouping postedGrouping, IGLAccountBalance accountBalance)

  at Microsoft.Dynamics.Performance.Reporting.Engine.Server.GLDataProcessor.ProcessOneAccountBalanceRecord(FRxUnitRowIdentifier frxUnitRowIdentifier, IGLDataReader balanceReader, ReportUnitResult unitResult, ReportDetailLevels detailLevel)

  at Microsoft.Dynamics.Performance.Reporting.Engine.Server.GLDataProcessor.ProcessOneReaderRecord(FRxUnitRowIdentifier frxUnitRowIdentifier, ReportDetailLevels detailLevel, IGLDataReader balanceReader)

  at Microsoft.Dynamics.Performance.Reporting.Engine.Server.GLDataProcessor.ProcessOneReaderRecord(IGLDataReader balanceReader)

  at Microsoft.Dynamics.Performance.Reporting.Engine.Server.GLDataProcessor.ProcessOneBalanceRecord(IGLDataReader balanceReader)

  at Microsoft.Dynamics.Performance.Reporting.Engine.Server.GLDataProcessor.ProcessOneBalanceReader(IGLDataReader balanceReader)</Data>

 </EventData>

</Event>

My thought is to rebuild the datamart database in SQL server and see if this resolves the issue since other reports generate fine. If anyone knows of another solution please offer as sometimes, MR's explanation on errors and events can be a bit ambiguous. thanks.

*This post is locked for comments

  • Marc K Profile Picture
    Marc K 570 on at
    RE: Management Reporter 2012 "Operation is not valid due to the current state of the object."

    Yes, the reliability of the data mart leaves a lot to be desired.  This isn't something good to have in a financial reporting tool.  

    The data mart needs to be a lot more robust.  Management Reporter should proactively find errors in the data mart and either correct them or alert an admin.  The worst thing is for an error to be found by an end user when a figure is incorrect.  

  • Laura Peters Profile Picture
    Laura Peters 505 on at
    RE: Management Reporter 2012 "Operation is not valid due to the current state of the object."

    I agree with the need for more tech notes and information on MR.  I am working on a client that after RU8 the Data Mart is not populating completely.  If you run the reports Posted Only they work BUT if you choose posted/unposted it is not calculating the currency.  It is all over the map.  Working with Microsoft but still no resolution.  I have re-installed and re-built the DDM so many times I can do it blindfolded now!!

  • Windi Epperson CSM Profile Picture
    Windi Epperson CSM on at
    RE: Management Reporter 2012 "Operation is not valid due to the current state of the object."

    Somehow this customer had 4 of 6 currencies with no ISO codes.  I'm wondering if maybe that used to be an optional field in a prior version and they were able to upgrade without it.  

  • Marc K Profile Picture
    Marc K 570 on at
    RE: Management Reporter 2012 "Operation is not valid due to the current state of the object."

    When I go into the Currency Setup screen, ISO Code is flagged as a required field.  I'd expect that, under normal circumstances, this problem should not occur.

  • Windi Epperson CSM Profile Picture
    Windi Epperson CSM on at
    RE: Management Reporter 2012 "Operation is not valid due to the current state of the object."

    FYI - the solution to this one is that all currencies setup in multi-currency have to have an ISO code.  After adding the ISO code, the DataMart had to be rebuilt.   I can't wait til we start getting some published TKs on MR!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Management Reporter 2012 "Operation is not valid due to the current state of the object."

    I have seen this happen 2 times in the last 2 days. Both instances were for Hosted Clients.  Just an interesting coincidence or a pattern?

    We are rebuilding the DDM through the Host.

  • Windi Epperson CSM Profile Picture
    Windi Epperson CSM on at
    RE: Management Reporter 2012 "Operation is not valid due to the current state of the object."

    Laura - thanks for the reply.  I've stopped/started services many times.  I've checked all the mc tables for junk records and check the budget tables for blank budgets.  I've ran check links and reconciles.  I'm sure there is one little setting missing, I just can't come up with what it is.

  • Laura Peters Profile Picture
    Laura Peters 505 on at
    RE: Management Reporter 2012 "Operation is not valid due to the current state of the object."

    Thank you for the replies!  I am finding recently on this same client issue restarting the MR Services clears out errors.  You might try that and see if that helps!!

  • Windi Epperson CSM Profile Picture
    Windi Epperson CSM on at
    RE: Management Reporter 2012 "Operation is not valid due to the current state of the object."

    I have a customer with the same error whenever they try to access a column.  They can't access existing (default) columns or create new ones.  We the message "operation could not be completed due to a problem in the data provider framework".  Then it closes MR completely.  I've checked the user defined fields in GP setup, checked all the multicurrency windows and rebuilt the datamart.  Still no luck.  Anyone seen this variation of the error?

  • Rob Klaproth Profile Picture
    Rob Klaproth 1,730 on at
    RE: Management Reporter 2012 "Operation is not valid due to the current state of the object."

    "You can leave or keep the MR Database" -- ABSOLUTELY NOT!! Do NOT DELETE the ManagementReporter database.  This database contains all the row, column, and tree information, as well as security permissions inside of MR.  If you delete the ManagementReporter database you will essentially have to completely start over, recreating all your reports.  

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans