Load Report Failed error sporadically shows up

[Former Member]

Hi all,

I have written an asp.net web site (CR2008 sp2.5, .net3.5, VS2008, vb.net running on winServ2003 hitting an Oracle 10g database) that does nothing but dish out reports for users. I built in the asp.net member/role security, which works fine, and different sections have a "frmReportViewer.aspx" file that has a crystal report viewer control in it.

Based on a querystring parameter, the report will load the correct rpt to the control on the page.

here's the problem.: sometimes when loading a report, it instantly comes back with "LOAD REPORT FAILED". Sometimes, you can close the window, click the link again, and it will work fine. Sometimes, if the report does load, then if i try to drill down into a group, it will tell me "no valid report source is available" in a little ajax-style dialog box in the report.

My main question is....why does this work sometimes? this instability will make this project go down the tubes (along with my job perhaps)....I showed my company what CAN be done, now i need to make it RUN LIKE IT SHOULD!

THANKS IN ADVANCE!

GEORGE

Edited by: george hardy on Mar 25, 2010 7:58 PM

[former_member183750 · Accepted solution]

Make sure you are disposing and closing the report object;

repdoc.close

repdoc.dispose

once you are done with it.

Also, search the kbase for the error:

https://www.sdn.sap.com/irj/scn/advancedsearch?cat=sdn_ossnotes&query=&adv=true

Kbases / Notes 1218766, 1217643 would be a sampling of what you'll find there.

From your description, it is not clear if this occurs under heavier loads. If it is, increasing the allowed print job count may help. For more details see [this|https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/f053713e-3e3d-2c10-2a81-f79259e54023] article.

Ludek

Follow us on Twitter http://twitter.com/SAPCRNetSup

[Former Member · Accepted solution]

well, this is a problem that cascades from another problem

i would love to do this:

rptdoc.close

rptdoc.dispose

but my page_unload gets fired even when the page is loading, when clicking on a group tree for drilldown, and more...

so if i put that in the page_unload, it will get set as soon as i come into the page, and report wont load.

chicken and egg