Error when too many reports are requested.

40 Views

I have a web application, that runs in a web farm environment. Basically the application generates a report available to any employee in our company (approximately 11,000). Users have the option to generate the report in Crystal PDF format for printing. Unfortunately, we went live and on the first day, Crytal PDF access failed miserably....with the following exception

Message: Load report failed.

Inner Source: Analysis Server

Inner Message: The maximum report processing jobs limit configured by your system administrator has been reached.

at CrystalDecisions.ReportAppServer.ClientDoc.ReportClientDocumentClass.Open(Object& DocumentPath, Int32 Options)

at CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.Open(Object& DocumentPath, Int32 Options)

at CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.EnsureDocumentIsOpened()

Some research recommended that I bump up the registry setting for PrintJobLimit from 75.

For now we increase the number on our web servers to 150. Is there a better, long term, more scalable solution to this problem? How high can this number go and what is it's impact on the web server's performance? Please suggest some alternate solutions.