Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Crystal Reports 8.5: Error: Too many open files

Posted on 2009-04-08
2
Medium Priority
?
1,553 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
1 Comment
 
LVL 101

Accepted Solution

by:
mlmcc earned 2000 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this tutorial, we’re going to learn how to convert Youtube to mp3 for Free. We'll show you how easy it is to make an mp3 from your video clips so that you can enjoy them offline.
In today’s time where quality is an essential factor all over the world, software testing and effective QA (Quality Assurance) is an all-important element for any business to ensure less risk for an end product. A good software testing company deliv…
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.
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Suggested Courses

581 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