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

(0) Share

Report

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:

<Channel>Application</Channel>

<Computer>ComputerName</Computer>

</System>

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

I have the same question (0)

All responses (18)

Answers (1)

Sort by

Suggested answer

babubaskaran@outloo... 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Have you tried to stop and start the application and process service on the MR Configuration Console.

Was this reply helpful? Yes No
Verified answer

RHarper5 770 on at

Like
a
(0)

Report
Copy link

Link copied!

I did. Eventually rebuilding the datamart has fixed the issue. It's just a bit frustrating to do this for a client with no real reason why the datamart had failed.

Was this reply helpful? Yes No
babubaskaran@outloo... 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Thats Good to know thanks for the update.

Was this reply helpful? Yes No
Laura Peters 507 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello

I have a client with the 'an error occurred while retrieving balances from the source system provider' and I have restarted the services but has not resolved. You have mentioned rebuilding the data mart in SQL Server. Do you mind sharing how you did that? Many thanks.

Was this reply helpful? Yes No
RHarper5 770 on at

Like
a
(0)

Report
Copy link

Link copied!

To rebuild, first (make a backup of the DDM and management reporter db).

Go into Management Reporter(MR) configuration and remove the integration and stop both the services running. Go into SQL Management Studio and delete the DDM database. Once you deleted the DDM (you can leave or keep the MR database), go back into MR Configuration and reconfigure so that MR rebuilds the DDM database.

If you are on Legacy, you shouldn't have this problem in legacy but if you are, delete the MR database and reconfigure it.

This is what I did for the DDM database..hope it helps please let me know if you have any questions.

-Ryan

Was this reply helpful? Yes No
Laura Peters 507 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Ryan

Thank you for the quick reply. I rebuilt the Data Mart and it corrected the error. Difficult to explain to the client because I don't know why MR does this. Is it particular to MR or my client's environment...I don't know.

Have a good day.

Was this reply helpful? Yes No
RHarper5 770 on at

Like
a
(0)

Report
Copy link

Link copied!

No problem Laura,

From the conversations I've had with Microsoft, there is not clear reason why this is happening beyond the standard message of "the data mart got out of sync or corrupted".

Its something I heard is being worked on by Microsoft in the CU8 (im still not very confident this is the case). I personally have been steering clients away from Data mart because this doesn't happen in Legacy, Microsoft is still working out the bugs with the data mart db.

Have a great day!

Was this reply helpful? Yes No
Marc K 576 on at

Like
a
(0)

Report
Copy link

Link copied!

After recreating the data mart, you may also want to delete all of the saved reports out of the report library. The last time I recreated a data mart, I found that previously created reports were showing incorrect figures.

Was this reply helpful? Yes No
Rob Klaproth 1,730 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Windi Epperson CSM on at

Like
a
(0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No