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
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
ASKER
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??
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??
Does time of day matter?
Do you have a lot of reports scheduled?
mlmcc
Do you have a lot of reports scheduled?
mlmcc
ASKER
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.
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
mlmcc
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
It's a workaround - not the actual answer to the question.
Have passwords changed recently?
mlmcc