IT Community - Software Programming, Web Development and Technical Support

Crystal Reports for VS .NET Frequently Asked Questions

This is a discussion on Crystal Reports for VS .NET Frequently Asked Questions within the C# Programming forums, part of the Software Development category; Hi All, Maximum Processing jobs limit error message..Please help!!! I'm using VB.NET 2003 and SQL Server 2000 ...


Go Back   IT Community - Software Programming, Web Development and Technical Support > Software Development > C# Programming

Register FAQ Members List Calendar Mark Forums Read
  #1 (permalink)  
Old 03-05-2008, 11:00 PM
Mramesh Mramesh is offline
D-Web Sr.Programmer
 
Join Date: Sep 2007
Location: Chennai
Posts: 106
Mramesh is on a distinguished road
Send a message via MSN to Mramesh
Default Crystal Reports for VS .NET Frequently Asked Questions

Hi All,

Maximum Processing jobs limit error message..Please help!!!


I'm using VB.NET 2003 and SQL Server 2000 with Crystal Report XI.

My clients when constantly will get this error message,

System.Runtime.Interop.Services.COMException (0x80041016): The maximum report processing jobs limit configured by your system administrator has been reached
at CrystalDecisions.ReportAppServer.ClientDoc.ReportC lientDocumentClass.Open .....

After this message, they cannot print any report that is called from Crystal. Anyone happen to encounter this error and solved this issue?

Please help...Urgently to resolve this issue.

Thanx in Advance
__________________
M.Ramesh Kumar
Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 03-05-2008, 11:02 PM
Sundaram Sundaram is offline
D-Web Sr.Programmer
 
Join Date: Mar 2007
Location: chennai
Posts: 117
Sundaram is on a distinguished road
Send a message via MSN to Sundaram Send a message via Yahoo to Sundaram
Default Re: Crystal Reports for VS .NET Frequently Asked Questions

hi Ramesh,

This has happened to me and here is how I fixed it. There are actually two different things that you could do, or even do both.

1 - Increase the limit of allowable reports by editing this registry key. Be careful how high you raise this. The higher the number, the more potential memory will be used.

HKEY_LOCAL_MACHINE;SOFTWARE;Crystal Decisions;11.xx;Report Application
Server;InprocServer;PrintJobLimit(default 75)

2 - Close the report connection when the user exits the page by using ReportDocument.Close() in a Page_Unload event. More info about this can be found on the MSDN site at:

Use the Close() Method to free up the report

good luck!
Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 03-05-2008, 11:05 PM
Mramesh Mramesh is offline
D-Web Sr.Programmer
 
Join Date: Sep 2007
Location: Chennai
Posts: 106
Mramesh is on a distinguished road
Send a message via MSN to Mramesh
Default Re: Crystal Reports for VS .NET Frequently Asked Questions

hi sundaram,

if we keep the browser open and keep executing the same report with different parameters the close event does not seem to trigger and we still fail.

any suggestions.

thnx in advance..
__________________
M.Ramesh Kumar
Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 03-05-2008, 11:10 PM
a.deeban a.deeban is offline
D-Web Analyst
 
Join Date: May 2007
Posts: 279
a.deeban is on a distinguished road
Default Re: Crystal Reports for VS .NET Frequently Asked Questions

hi,

I have the trouble too,but after
using reportDocument.Dispose() in Page_UnLoad event,the app working smooth.
Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #5 (permalink)  
Old 03-05-2008, 11:13 PM
Sathish Kumar Sathish Kumar is offline
D-Web Analyst
 
Join Date: Feb 2007
Posts: 304
Sathish Kumar is on a distinguished road
Default Re: Crystal Reports for VS .NET Frequently Asked Questions

HI,

I have done all the Dispose, Changed the Registery and even checking for an existing report. How can I reset to release the Memory so I can get the reports working again without a reboot?
__________________
Sathish Kumar.R
Knowledge is meant to SHARE
Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #6 (permalink)  
Old 03-05-2008, 11:15 PM
SaravananJ SaravananJ is offline
D-Web Programmer
 
Join Date: Aug 2007
Posts: 79
SaravananJ is on a distinguished road
Default Re: Crystal Reports for VS .NET Frequently Asked Questions

hi

I did like this..solved my problem

Code:
ReportDocument rptDoc = (ReportDocument)Session["rptDoc"];
if (rptDoc == null)
{
rptDoc = new ReportDocument();
}
else
{
rptDoc .Close();
}
///write your code here.
But at the end of your code or after assiging rptDoc to report viewer keep that object in Session like

Code:
Session["rptDoc"] = rptDoc ;
__________________
J.Saravanan
Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
.Net3.0 framework Frequently Asked Questions Mramesh ASP and ASP.NET Programming 0 03-18-2008 10:07 PM
C#.Net, ASP.Net Data Grid Frequently Asked Questions a.deeban C# Programming 51 02-27-2008 08:49 AM
crystal reports dips ASP and ASP.NET Programming 0 10-07-2007 06:00 AM
Object reference not set to an instance of an object for crystal reports in .net KiruthikaSambandam Database Support 1 08-03-2007 03:26 AM
Crystal Report in Vb.net ewriter VB.NET Programming 1 04-24-2007 08:01 AM


All times are GMT -7. The time now is 02:15 PM.


Copyright ©2004 - 2007, DiscussWeb. All Rights Reserved.

SEO by vBSEO 3.0.0