Solved

Reports Failing "Failed to open the connection." error

Posted on 2009-07-06
1
1,740 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
1 Comment
 
LVL 100

Accepted Solution

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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Hi, I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY. Actually there are lot of other tools available in the market for Reporting Such as Co…
I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

776 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