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!!