Solved

Crystal Reports 8.5: Error: Too many open files

Posted on 2009-04-08
2
1,379 Views
Last Modified: 2013-12-12
Hi,
I have a windows service which opens crystal reports, creates the reports and then exports it to pdf.  based on certain data.
We had a release recently in which there are multiple reports that can be generated at once.
After this, sometimes we get an error that says " too many open files" causing the application to fail. The reports are generated one after the other, but still there could be multiple threads doing this.
We are not sure if there is a limit in crystal to create files, or why this issue is occurring.

Could anyone help us in letting us know why this could be occurring and also how this could be resolved.

Thanks in advance.
0
Comment
Question by:girishnayaks
2 Comments
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 24101011
THere is a limit in Crystal of having 5 connections open at any time.  A report may actually open multiple connections.

Since you are using CR8.5 I suspect you can't get a license for more connections anymore.

Unless you explicitly close and release the connections in the application they can remain open for up to 15-30 minutes after the report is rendered and printed/exported.

mlmcc
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Let’s list some of the technologies that enable smooth teleworking. 
The article will include the best Data Recovery Tools along with their Features, Capabilities, and their Download Links. Hope you’ll enjoy it and will choose the one as required by you.
The viewer will learn common shortcuts with easy ways to remember them. The viewer will then learn where to find all of the keyboard shortcuts, how to create/change them, and how to speed up their workflow.
Using Adobe Premiere Pro, the viewer will learn how to set up a sequence with proper settings, importing pictures, rendering, and exporting the finished product.

760 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now