Share
Report
10Update: I have been able to get the file to be found by Management Reporter, bu the object reference error still occurs. I verified the security permissions allow the service user to access the remote directory, and that the server has the directory mapped to the location defined and that the file shows up there. I then tried to copy the workbook to the server local disk and ran the process again. I then receive the following error within Management Reporter: Report Queue Status:
An unknown error has occurred while processing report SVCG_I_S.
I also receive the following error in the MMC Computer Management log:
Timestamp: 3/22/2012 2:32:32 PM Message: System.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.Dynamics.Performance.Reporting.Engine.Server.WorksheetLinkAdapter.PopulateReportCellFromWorksheet(String workSheetName, ExcelWorkbook workBook, RowCriterion reportRowCriteria, ValueColumn reportValueColumn, WorksheetModifierType offset) at Microsoft.Dynamics.Performance.Reporting.Engine.Server.WorksheetLinkAdapter.GetOneRowWorksheetData(String workSheetName, ExcelWorkbook workBook, RowCriterion reportRowCriteria, WorksheetModifierType offset) at Microsoft.Dynamics.Performance.Reporting.Engine.Server.WorksheetLinkAdapter.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) at Microsoft.Dynamics.Performance.Reporting.Engine.Server.EngineController.GenerateReport(Action`1 resultHandler) at Microsoft.Dynamics.Performance.Reporting.Engine.Server.EngineController.Run(NativeReport repositoryReport, Definition definition) at Microsoft.Dynamics.Performance.Reporting.Engine.Server.QueueHandler.WatchQueue()
I can get quite a few other reports to run, just not any that reference an Excel workbook. I have also had Excel 2010 installed on the machine. I see references to frameworks but have no way of looking up the methods or what is actually being sent at run time.
- Have any clues about the error message?
- Is there any specific format the Excel sheet must be in for the link adapter to work?
- Is there any way I can test the link adapter, through an API or SDK?
- Suggested resources for research?
Thanks!
*This post is locked for comments
All responses (
Answers (
