Share
ReportHello:
We're on Management Reporter 2012 CU13. We're not on the Data Mart. We're on the Legacy Adapter and reports have been running fine, for over a year.
Yesterday, the "sa" password was changed. Corporate policy dictates that this password be changed every sixty days. Today, none of our financial statements will generate!
Upon trying to generate the statements, we receive the error stating "Bad or missing data was encountered while loading the report and its building blocks. Report generation has been cancelled."
Normally, after changing the "sa" password, any issues in MR are resolved by stopping and restarting the two MR services. Doing so this time, however, did not work.
Also, I made sure that the current month's fiscal period is open in GP for all companies that we're reporting on.
Below is the full error, as shown in Event Viewer.
If you have a solution, please let me know. Thank you! Much appreciated!
John
Log Name: Application
Source: Management Reporter Report Designer
Date: 4/11/2017 10:16:48 AM
Event ID: 0
Task Category: None
Level: Error
Keywords: Classic
User: N/A
Computer: BNAPRDINT-TRM02.data.hireright.com
Description:
System.Data.DeletedRowInaccessibleException: Deleted row information cannot be accessed through the row.
at System.Data.DataRow.GetDefaultRecord()
at Microsoft.Dynamics.Performance.Reporting.DataAccess.Design.ReportDataSet.FRxReportLocationRow.get_RepositoryFolderID()
at Microsoft.Dynamics.Performance.Reporting.Engine.Client.Job.RunAsync(Guid companyID, IEnumerable`1 companyCredential, ReportDataSet reportDataSet, ReportSettings settings, Int32 baseYear, Int32 basePeriod)
at Microsoft.Dynamics.Performance.Reporting.ReportDesigner.GenerateHelper.PrepareAndRunReport(ReportDataSet reportDataSet, FiscalPeriod basePeriodOverride, Guid& repositoryId)
at Microsoft.Dynamics.Performance.Reporting.ReportDesigner.ReportControl.GenerateReportLocally()
Event Xml:
<Event xmlns="schemas.microsoft.com/.../event">
<System>
<Provider Name="Management Reporter Report Designer" />
<EventID Qualifiers="0">0</EventID>
<Level>2</Level>
<Task>0</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2017-04-11T15:16:48.000000000Z" />
<EventRecordID>341409</EventRecordID>
<Channel>Application</Channel>
<Computer>BNAPRDINT-TRM02.data.hireright.com</Computer>
<Security />
</System>
<EventData>
<Data>System.Data.DeletedRowInaccessibleException: Deleted row information cannot be accessed through the row.
at System.Data.DataRow.GetDefaultRecord()
at Microsoft.Dynamics.Performance.Reporting.DataAccess.Design.ReportDataSet.FRxReportLocationRow.get_RepositoryFolderID()
at Microsoft.Dynamics.Performance.Reporting.Engine.Client.Job.RunAsync(Guid companyID, IEnumerable`1 companyCredential, ReportDataSet reportDataSet, ReportSettings settings, Int32 baseYear, Int32 basePeriod)
at Microsoft.Dynamics.Performance.Reporting.ReportDesigner.GenerateHelper.PrepareAndRunReport(ReportDataSet reportDataSet, FiscalPeriod basePeriodOverride, Guid& repositoryId)
at Microsoft.Dynamics.Performance.Reporting.ReportDesigner.ReportControl.GenerateReportLocally()</Data>
</EventData>
</Event>
*This post is locked for comments
I have the same question (0)
All responses (
Answers (
1