Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


ASP.NET : Maximum Report Limit Exceeded

Posted on 2017-09-12
High Priority
Last Modified: 2017-09-14
Dear Experts,

Can anyone guide me on the error?

"Maximum report processing jobs limit configured has been reached"

I got the following code from the internet but I don't know where to use it. Please guide.

Imports System.Collections
Imports System.Collections.Generic
Imports System.Text
Imports CrystalDecisions
Imports CrystalDecisions.CrystalReports
Imports CrystalDecisions.CrystalReports.Engine

Namespace Test.Utilities
	Public Class ReportFactory
		Protected Shared reportQueue As New Queue()

		Protected Shared Function CreateReport(reportClass As Type) As ReportClass
			Dim report As Object = Activator.CreateInstance(reportClass)
			Return DirectCast(report, ReportClass)
		End Function

		Public Shared Function GetReport(reportClass As Type) As ReportClass

			'75 is my print job limit.
			If reportQueue.Count > 75 Then
				DirectCast(reportQueue.Dequeue(), ReportClass).Dispose()
			End If
			Return CreateReport(reportClass)
		End Function
	End Class
End Namespace

Open in new window

D Patel
Question by:D Patel
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2

Expert Comment

by:Dorababu M
ID: 42290515

Author Comment

by:D Patel
ID: 42290584
That understood...

But how do I write code so that it clears the cache at 75 job reaches.

Where should I write the above code and from when do I call it?

Expert Comment

by:Dorababu M
ID: 42290610
What I see is you need to do the following every time for crystal report

Load report,
Assign it to Viewer Control
Show Report in Viewer Control
Close Viewer Control and Unload (completely)
Then close/dispose/gc.collect outside of any viewer control code

Author Comment

by:D Patel
I have applied the same to all pages where crystal report viewer control lies at Page_Unload event.

But still the issue is not resolved.

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Join & Write a Comment

Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses

721 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question