Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Crystal Server Instances Aborted

Posted on 2012-08-14
7
Medium Priority
?
403 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
0
Comment
Question by:lcallah93
  • 4
  • 3
7 Comments
 
LVL 101

Expert Comment

by:mlmcc
ID: 38292430
Check your timeouts on BOE.

Have passwords changed recently?


mlmcc
0
 

Author Comment

by:lcallah93
ID: 38292670
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
 
LVL 101

Expert Comment

by:mlmcc
ID: 38292955
Does time of day matter?

Do you have a lot of reports scheduled?

mlmcc
0
Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

 

Author Comment

by:lcallah93
ID: 38293004
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
 
LVL 101

Expert Comment

by:mlmcc
ID: 38293288
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
 

Accepted Solution

by:
lcallah93 earned 0 total points
ID: 38346878
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
 

Author Closing Comment

by:lcallah93
ID: 38360347
It's a workaround - not the actual answer to the question.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question