Blank page in StiWebViewerFx when query runs for more then 20 seconds
Posted: Tue Jun 15, 2010 8:24 am
Hi!
I have a report created with the designer and shown with StiWebViewerFx. The report seems to be fine, but it's returning an empty StiWebViewerFx after about 20 seconds of "Loading".
This is what I have been testing:
- Report is fine in Designer, also preview works perfectly
- When locally run in VS2010 (with the development webserver), the ASPX shows the reportviewer (StiWebViewerFx) just fine and after a while of "Loading" it returns the report
- When deployed on the actual webserver (IIS), the ASPX show the reportviewer, for about 20 seconds "Loading" and then the "Loading" dissapears, but the report stays empty
I have changed the filters (WHERE clause in the SQL Query) a bit to make it run faster (less records to select etc). Now the report works fine on the IIS server.
Script timeout on the server is set to 600 (10 minutes). The query itself has it's commandtimeout set on "300" which is 5 minutes.
I have also tried a normal StiWebViewer. Interestingly that works fine when there is only 1 page shown. When I change viewing method to "Whole report" same thing happens.
It seems as if there is something wrong with the StiWebViewer(Fx), but I can't really debug it. Anyone got any ideas?
I have a report created with the designer and shown with StiWebViewerFx. The report seems to be fine, but it's returning an empty StiWebViewerFx after about 20 seconds of "Loading".
This is what I have been testing:
- Report is fine in Designer, also preview works perfectly
- When locally run in VS2010 (with the development webserver), the ASPX shows the reportviewer (StiWebViewerFx) just fine and after a while of "Loading" it returns the report
- When deployed on the actual webserver (IIS), the ASPX show the reportviewer, for about 20 seconds "Loading" and then the "Loading" dissapears, but the report stays empty
I have changed the filters (WHERE clause in the SQL Query) a bit to make it run faster (less records to select etc). Now the report works fine on the IIS server.
Script timeout on the server is set to 600 (10 minutes). The query itself has it's commandtimeout set on "300" which is 5 minutes.
I have also tried a normal StiWebViewer. Interestingly that works fine when there is only 1 page shown. When I change viewing method to "Whole report" same thing happens.
It seems as if there is something wrong with the StiWebViewer(Fx), but I can't really debug it. Anyone got any ideas?