Error in MR Management Console and Event Viewer when generating a report with Reporting Tree with multi-company rollups: "Object reference not set to an instance of an object"
Reproduction Environment
MR 2012 RU6 / GP2013 SP1 / Win Server 2008 R2 / SQL 2012 with AlwaysOn Availability Group
Scenario
When generating a report using multi-company rollups it fails.
Expected Result
Report will generate and complete.
Actual Result
You see an error in MR Management Console: "Object reference not set to an instance of an object".
Error in Event Viewer
System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.Dynamics.Performance.Reporting.Engine.Server.GLLinkAdapter.ProcessOverrideRows()
at Microsoft.Dynamics.Performance.Reporting.Engine.Server.GLLinkAdapter.GetData()
at Microsoft.Dynamics.Performance.Reporting.Engine.Server.ReportUnitProcessor.RetrieveLinkData()
at Microsoft.Dynamics.Performance.Reporting.Engine.Server.ReportUnitProcessor.RetrieveData()
at Microsoft.Dynamics.Performance.Reporting.Engine.Server.ReportProcessor.RunAllUnitProcessors()
at Microsoft.Dynamics.Performance.Reporting.Engine.Server.ReportGenerator.ProcessReport(Definition definition, Action`1 resultHandler)
Cause
Bug 377572: Unknown Error using Row Modifier, Reporting Unit restrictions on all FD columns and Consolidated Tree with one Unit (Company) not linked to a Column
Workarounds
Add a non-printing FD column to the column definition. Another way is to make sure that all units (company units) in the reporting tree definition are linked to a column in the column definition.