We help IT Professionals succeed at work.

Crystal Server Instances Aborted

lcallah93
lcallah93 asked
on
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
Comment
Watch Question

Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013

Commented:
Check your timeouts on BOE.

Have passwords changed recently?


mlmcc

Author

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??
Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013

Commented:
Does time of day matter?

Do you have a lot of reports scheduled?

mlmcc

Author

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.
Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013

Commented:
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
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.

Author

Commented:
It's a workaround - not the actual answer to the question.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.