Senthil Viswanathan

Hi buddies,

Our application is running in production which developed in Asp.net 1.1.4.2 and reports are in crystal Report 11. the back end is sql server 2005. but we are constanly facing the problem that 'Load Report Failed'. Once we restart the IIS, the problem is rectified. we are unable to identify whether this problem due to application bug or missing configuration in any IIS setting. Could any one help us to reslove this problem



Re: Crystal Reports for Visual Studio Crystal Report Load Report Failed

MonteJEllis

Did you find a solution for this yet I have a very similar issue with Crystal 11 and C#



Re: Crystal Reports for Visual Studio Crystal Report Load Report Failed

Pbhadauria

Need solution desp. Facing similiar problem.

Only IISRestart resolves it until we hit the Load Report Failed error again. Please help.





Re: Crystal Reports for Visual Studio Crystal Report Load Report Failed

MonteJEllis

We had to do a few things and have finally resolved the issue.

First, create a Page_Unload event and Dispose of the Crystal Viewer and set to null. I found this on the web and tried it first, but it didn¡¯t help. I then changed my Report Document to be a public variable and then closed, disposed and set to null in the Page_Unload event. This alone didn¡¯t fix the issue.

Here is a snippet of my code:

public static ReportDocument CrystalRpt;
protected void Page_UnLoad(object sender, EventArgs e)
{
this.CrystalReportViewer1.Dispose();
this.CrystalReportViewer1 = null;
CrystalRpt.Close();
CrystalRpt.Dispose();
GC.Collect();
}
protected void Page_Load(object sender, EventArgs e)
{

CrystalRpt = new ReportDocument();
ConnectionInfo CrystalConn = new ConnectionInfo();

.....

I then created a tech support case with Business Objects and in the end they had me change the PrintJobLimit registry key from ¡®75¡¯ to ¡®-1¡¯

¡®HKEY_LOCAL_MACHINE\SOFTWARE\BUSINESS OBJECTS\SUITE 11.5\REPORT APPLICATION SERVER\SERVER\PrintJobLimit¡¯

Then I restarted IIS and haven¡¯t had the issue with Crystal since. I was worried about there being adverse affects to the system by changing this, but haven¡¯t had any and we print a ton of reports from the web server.

Hope this helps. Let me know if you need anything else.





Re: Crystal Reports for Visual Studio Crystal Report Load Report Failed

bkshyam

Hi,

can you please let me know how you are invocking reports that are developed in version 11.0 in ASP.Net.

Are they standalone ie like the user interface generated by crystal tool.I am having a issue here in my project, I am new to CR and my project manager had assigned me a new task. There are reports that has been develped in version 11 and the user interface is crystal build when we select the input paremeters, I need to develop the same front end and pass the parameters with but use the same report.

Can I achive this, if so How

Thanks

SHyam





Re: Crystal Reports for Visual Studio Crystal Report Load Report Failed

Zeeshan Umar

This seems a resource avilability issue. i.e. you are not properly releasing all the resources which you have captured while loading reports.

I have deployed several applications on web using CR 11 but did not find such problem.






Re: Crystal Reports for Visual Studio Crystal Report Load Report Failed

MonteJEllis

sorry, didn't see this post. Yes, all of our reports were developed in v11. But my success was short lived. I am still looking for a solution.





Re: Crystal Reports for Visual Studio Crystal Report Load Report Failed

Rami Reddy

Guys, I have been working on this issue for the past one week. I searched google and really collected 100's of reasons from different forums/tech articles and believe me, i tried all the options but still getting the same error. It really sucks. And I believe Even business objects can not pinpoint why this happens. And I really feel for all issues( whatever they can not handle ) in crystal we have only one generic error " LOAD REPORT FAILED"... .

Our energies are down and we are really thinking scrap crystal and build our own web reports.






Re: Crystal Reports for Visual Studio Crystal Report Load Report Failed

Manish Joisar

have you tried with solution given by MonteJEllis

have you tried doing same in different machine

Can you empty your c:\Documents and Settings\currentuser\local settings\temp folder

have you passed logon info at runtime

Hope this helps






Re: Crystal Reports for Visual Studio Crystal Report Load Report Failed

Joe Beam


You probably tried these suggestions already but here is what I would check for the error "Load Report Failed".

1. If your loading the report from a file be positive the filepath is correct.
2. ASPNET account needs access to the TEMP directory on the server.
3. Make sure to set the reportviewer's reportsource in page_init.


Also, you can handle the reportviewers error event and see if a different exception is available there.




Re: Crystal Reports for Visual Studio Crystal Report Load Report Failed

Monte Ellis

Do I feel your pain. I totally agree with you. If we weren't so embedded with Crystal in other parts of our business, I would scrap it today. The web stuff is VERY buggy. Let me know if you find something that works.... Because I have tried "everything"

I think the people that say it works only load a few reports a day. We have on average about 300 reports loaded off our web server every day. We have found that if we restart the server every evening and restart IIS at noon and 5pm, we have eliminated the issue. But what a cheesy way to work around it.






Re: Crystal Reports for Visual Studio Crystal Report Load Report Failed

Adagio

I've been searching for a long time, but so far haven't been able to find any solution either Sad


My project is a vb.net 2005 application where the .rpt files are inside the application, not as standalone files. The problem happens on two computers 80% of the times the SetDataSource method is called and has happened a few times on a few other computers
I don't believe it can be a permission problem since the problem doesn't happen all the time




Re: Crystal Reports for Visual Studio Crystal Report Load Report Failed

MonteJEllis

I tottlaly agree it isn't a permissions issue. I believe Crystal isn't releasing all of it's resources after the report is loaded even though I am doing everything you are supposed to do. I think it is either a bug in Crystal or I am still missing a resource to be freed up. The main problem is Business Objects has no idea what to do either. When I called them, they just grabbed at straws. I am going to try something I read yesterday, I will let you know if it helps.





Re: Crystal Reports for Visual Studio Crystal Report Load Report Failed

Joe Beam


Do you think it's just too much of a load on the server when they fail to load

Or...once one report fails, all requests after that fail







Re: Crystal Reports for Visual Studio Crystal Report Load Report Failed

MonteJEllis

I think Crystal slowly eats up the server resources and then when a report fails, they all fail after that until IIS is restarted or sometimes in our case, we have to restart the server.