Solved

Crystal Reports 8.5: Error: Too many open files

Posted on 2009-04-08
2
1,401 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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
Skype is a P2P (Peer to Peer) instant messaging and VOIP (Voice over IP) service – as well as a whole lot more.
This video will demonstrate how to find the puppet warp tool from the edit menu and where to put the points to edit.
XMind Plus helps organize all details/aspects of any project from large to small in an orderly and concise manner. If you are working on a complex project, use this micro tutorial to show you how to make a basic flow chart. The software is free when…

808 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