Solved

Crystal Reports 8.5: Error: Too many open files

Posted on 2009-04-08
2
1,432 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
[X]
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 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

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

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

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.
There are many software programs on offer that will claim to magically speed up your computer. The best advice I can give you is to avoid them like the plague, because they will often cause far more problems than they solve. Try some of these "do it…
This video will demonstrate how to find the puppet warp tool from the edit menu and where to put the points to edit.
The viewer will learn how to successfully download and install the SARDU utility on Windows 7, without downloading adware.

739 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