I have a SSRS report, MainReport, that basically just calls a series of sub-reports to compile everything into a nice and tidy Excel Document (users love their Excel reports), with each sub-report occupying its own tab. On occasion, one of the sub-reports, Subreport1, will fail displaying Error: Subreport could not be shown within the Excel tab and nothing else. Digging through the various SSRS server and execution logs, I'm able to identify that the sub-report in question encountered an error, but the error description is not exactly useful:
reportrendering!WindowsService_1!1cb4!06/07/2018-01:55:13:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.RenderingObjectModelException: , Microsoft.ReportingServices.ReportProcessing.RenderingObjectModelException: Data retrieval failed for the subreport, 'Subreport1', located at: /Folder/Subreport1. Please check the log files for more information. ;
processing!WindowsService_1!1cb4!06/07/2018-01:55:13:: e ERROR: An error has occurred while processing a sub-report. Details: Data retrieval failed for the subreport, 'Subreport1', located at: /Folder/Subreport1. Please check the log files for more information. Stack trace:
at Microsoft.ReportingServices.OnDemandReportRendering.SubReport.FinalizeErrorMessageAndThrow()
at Microsoft.ReportingServices.OnDemandReportRendering.SubReport.RetrieveSubreport()
I'm trying to figure out what the explicit error code in question is, and so far my efforts to do so have resulted in dead ends.
When reviewing the ExecutionLog3 view for the main report, it shows that it renders without issue:
ItemPath RequestType TimeStart TimeEnd Format Status
/Folder/MainReport Subscription 2018-06-07 01:25:02.397 2018-06-07 01:55:13.537 EXCELOPENXML rsSuccess
I would have expected to see an error code pop for the main report, but because it technically did render, I guess I can understand why a Success is being reported.
When I look for the execution record of the sub-report, there isn't a correlating run-time listed that matches up with the run-time of the main report. The logged executions of the sub-report are no where near the rendering period of the main report, so I suspect SSRS is not logging each sub-report execution individually. Here's all the available records that exist in my logs for the sub-report around the execution time of the main report:
ItemPath RequestType TimeStart TimeEnd Format Status
/Folder/SubReport1 Interactive 2018-06-07 08:04:23.010 2018-06-07 08:08:14.540 RPL rsProcessingAborted
/Folder/SubReport1 Interactive 2018-06-05 09:39:38.620 2018-06-05 09:39:39.557 EXCELOPENXML rsSuccess
I know in this particular example I can infer that the sub-report exceeded the default timeout threshold of 30 minutes, but again, I cannot locate the explicit error that tells me so. So my question is quite simply, is there another log or location I've not come across that would show more details pertaining to the error(s) of the sub-report, or are these just not captured?
