We help IT Professionals succeed at work.
Get Started

Crystal Server Instances Aborted

lcallah93
lcallah93 asked
on
424 Views
Last Modified: 2012-09-03
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
This problem has been solved!
Unlock 1 Answer and 7 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE