Improve error message for Excel Report

When the input data for Excel report contain an error (in this case a missing float value), the following error message is shown. Improve the message so that it shows where exactly the error happened (row, column).

{
  "ClassName": "System.NullReferenceException",
  "Message": "Object reference not set to an instance of an object.",
  "Data": null,
  "InnerException": null,
  "HelpURL": null,
  "StackTraceString": "   at System.Xml.XmlConvert.ToDouble(String s)\r\n   
at Origam.BI.Excel.ExcelService.SetCellProperties(CellRow sourceCell, ICell cell) in D:\\a\\1\\s\\backend\\Origam.BI.Excel\\ExcelService.cs:line 204\r\n   
at Origam.BI.Excel.ExcelService.ProcessRow(ISheet sheet, RowRow sourceRow) in D:\\a\\1\\s\\backend\\Origam.BI.Excel\\ExcelService.cs:line 145\r\n   
at Origam.BI.Excel.ExcelService.ProcessSheet(IWorkbook wb, SheetRow sourceSheet) in D:\\a\\1\\s\\backend\\Origam.BI.Excel\\ExcelService.cs:line 123\r\n   
at Origam.BI.Excel.ExcelService.GetReport(Guid reportId, IXmlContainer data, String format, Hashtable parameters, String dbTransaction) in D:\\a\\1\\s\\backend\\Origam.BI.Excel\\ExcelService.cs:line 90\r\n   
at Origam.Workflow.ReportServiceAgent.GetReport(Guid reportId, IXmlContainer data, String format, Hashtable parameters) in D:\\a\\1\\s\\backend\\Origam.Workflow\\Service Agents\\ReportServiceAgent.cs:line 56\r\n   
at Origam.Workflow.ReportServiceAgent.Run() in D:\\a\\1\\s\\backend\\Origam.Workflow\\Service Agents\\ReportServiceAgent.cs:line 155\r\n   
at Origam.Workbench.Services.CoreServices.ReportService.GetReport(Guid reportId, XmlDocument data, String format, Hashtable parameters, String transactionId) in D:\\a\\1\\s\\backend\\Origam.Workbench.Services\\CoreServices\\ReportService.cs:line 49\r\n   
at Origam.Server.Controller.ReportController.HandleReport(ReportRequest reportRequest, String reportName) in D:\\a\\1\\s\\backend\\Origam.Server\\Controller\\ReportController.cs:line 110\r\n   
at Origam.Server.Controller.ReportController.Get(Guid reportRequestId) in D:\\a\\1\\s\\backend\\Origam.Server\\Controller\\ReportController.cs:line 91",
  "RemoteStackTraceString": null,
  "RemoteStackIndex": 0,
  "ExceptionMethod": null,
  "HResult": -2147467261,
  "Source": "System.Private.Xml",
  "WatsonBuckets": null
}
1 Like

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.