• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1578
  • Last Modified:

Crystal Reports 8.5: Error: Too many open files

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.
1 Solution
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.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now