Crystal Server Instances Aborted

Does anybody have any experience with scheduled reports being aborted after running for a short period of time?

Here is my scenario:

The report is very complex and includes a sub report, multiple groups, formulas, and everything that makes a report slow.  It has been running fine until a few days ago.  When I pull it into Crystal Reports and click refresh, it takes about 10 minutes, but it eventually refreshes.  When I run it on the server it runs for about 5 minutes and then gets kicked back with a 'Database Connector' of 'Failed to Retrieve Data from Database' error.  I know it was processing the data prior to getting kicked back since it did run for 5 minutes.

Both the sub report and the main report pull the data using two different SQL commands.

We are running Business Objects version 12.

I would appreciate any and all assistance with this one.  I do not want to manually run the report every morning!!

Lisa
lcallah93Asked:
Who is Participating?
 
lcallah93Author Commented:
I cannot find an answer for this question but did find a workaround.  I downloaded Visual Cut from Millet Software and am have scheduled the reports via a task scheduler and a batch file.
0
 
mlmccCommented:
Check your timeouts on BOE.

Have passwords changed recently?


mlmcc
0
 
lcallah93Author Commented:
Passwords have not changed.

Timeout settings:

Crystal Reports Cache server - 120 minutes
Crystal Reports Processing server - 120 minutes
Report Application server - 120 minutes

I also just found a check box on both the Crystal Reports Processing server and the Report Application server that says - 'Allow Report Jobs to Stay Connected to the Database until the Report Job is Closed' that is not checked.  I checked it - that seems like it would kick something out if it appears to be idling.

It is just odd that it's happening all of a sudden.  The reports actually ran at the end of the fiscal year for just under an hour without any problems.  However, I have been scheduling instances like a mad woman - maybe the server load is just too high??
0
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

 
mlmccCommented:
Does time of day matter?

Do you have a lot of reports scheduled?

mlmcc
0
 
lcallah93Author Commented:
I have an abundance of reports scheduled and the work load is just going to increase.  There are over 1,200 instances objects scheduled to run, most of them run every night, including the above two reports.  I am actually looking at the APOS administrator tool tomorrow to see if I can figure out how to manage everything.
0
 
mlmccCommented:
CR Server does have a limit on how many reports can run simultaneously so you may be running into those limits.  I thought a report was supposed to queue and wait for available resources (CR Server session) then run but you may be running into an instance where a report sits waiting then when it starts to run it times out since it sat waiting so long

mlmcc
0
 
lcallah93Author Commented:
It's a workaround - not the actual answer to the question.
0
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.

All Courses

From novice to tech pro — start learning today.