I have previously created a thread about this problem. When rendering my reports and the amount of rows are less than +/- 2000 rows the report renders without problem. When the rows are 2000+ the report sometimes render right and sometimes it throws the dreadful "An exception occurred during the operation, making the result invalid. Check InnerException for exception details." exception.
One of the telerik members recommend that I look at the output window in visual studio while in debug mode. But no error appears and the only messages that appear is the following:
*** ReportProcessor.Render STARTED *** *** ReportProcessor.GetRenderer STARTED *** *** ReportProcessor.GetRenderer DONE in 00:00:00.0000277 *** *** ProcessReport #0 STARTED *** The thread '<No Name>' (0x25ac) has exited with code 0 (0x0). The thread '<No Name>' (0x1a90) has exited with code 0 (0x0). The thread '<No Name>' (0x1534) has exited with code 0 (0x0). *** Report Processing STARTED *** *** Report Processing DONE in 00:00:00.3108771 *** *** Measure Report (Horizontal) STARTED *** *** Measure Report (Horizontal) DONE in 00:00:00.0361700 *** *** Measure Report (Vertical) STARTED *** *** Measure Report (Vertical) DONE in 00:00:00.4248685 *** *** ProcessReport #0 DONE in 00:00:58.5183698 *** *** RenderReport #0 STARTED *** 'iexplore.exe' (Silverlight): Loaded 'C:\Program Files\Microsoft Silverlight\4.0.50826.0\en-US\System.ServiceModel.debug.resources.dll' *** RenderReport #0 DONE in 00:00:13.2401077 *** *** ReportProcessor.Render DONE in 00:01:12.1509348 *** The thread '<No Name>' (0xc08) has exited with code 0 (0x0).According to the messages the rendering was successful but in the UI the "An exception occurred" error appears.
This is becoming a critical problem as our clients are getting very irritated.
Please, please help us. We must resolve this no matter what. Either we must establish that Telerik can handle large data in their Silverlight reportViewer and the problem lies somewhere else or we must establish that Telerik can not handle this kind of quantities and we must discard Telerik reporting and use another tool.
1 Answer, 1 is accepted
This seems to be a timeout trouble. How to increase the service's default time out period has been elaborated in the Timeout in Silverlight ReportViewer with WCF ReportService.svc forum thread. Additionally you may find interesting the Using Custom Bindings help article that shows in detail how to implement and use a customIReportServiceClientFactory.
Just to note that there was a problem in our Q3 SP1 release, related to the bindings. That is why we recommend to download and install the latest official release Q1 2011.
About your second question, currently the XAML (used by Silverlight report viewer) rendering extension requires Full Trust and most probably this causes the error. For more information on the topic check out the Medium Trust Support help article.
Peter
the Telerik team