Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Reports Failing "Failed to open the connection." error

Posted on 2009-07-06
1
Medium Priority
?
1,747 Views
Last Modified: 2013-11-15
I am using BOXIR2 SP2. I am running reports using Crystal Reports against a Universe connected to a SQL Server 2005 database.

I created a report scheduler using the java API that runs infoview reports. When the scheduler runs it schedules 3 batches of 5 concurrently running reports. (So it runs up to 15 reports at a time.)

The first few reports fail with a "failed to open the connection" error (see example below) viewable through the history in infoview, but some of the following reports will run successfully. It is inconsistent as to how many run and fail at a given time. As the scheduler continues to run it will retry the reports that have failed and they will run successfully, but in a batch of 15 about 6 of them generally fail.

Does anyone know what could be the cause of this problem?

Thanks,

Matt

Error Example:
Failed to open the connection. D:\Program Files\Business Objects\BusinessObjects Enterprise 11.5\Data\procSched\myserver.reportjobserver\~tmp1eb85bed6bde626.rpt
0
Comment
Question by:matty1stop
[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
1 Comment
 
LVL 101

Accepted Solution

by:
mlmcc earned 500 total points
ID: 24790741
You probably are trying to run too many reports at the same time.

Crystal has a limit on the number of open connections.  Unless you have purchased additional licenses it is 5.  Can you schedule the reports so there are at most 5 running at a time?  That may still be too many beacuse a report with subreports may open multiple connections.

mlmcc
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

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…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses

636 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