Skip to Content
author's profile photo Michael Gaynor
0
Michael Gaynor

Crystal Reports slow to move from pending to running

Posted on Dec 17, 2018 at 09:18 PM 114 Views Last edit Dec 17, 2018 at 09:30 PM 2 rev.

BI Platform 4.2.4

We sometimes have Crystal Reports that sit in a pending state for a quite awhile even though there are no jobs actively running. They do eventually run successfully. What would be the cause of such a delay?

Could it be Idle Job Timeout settings in the various Crystal Servers (Processing, RAS, Cache)?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Dell Stinnett-Christy
    Dell Stinnett-Christy
    Posted on Dec 18, 2018 at 02:37 PM
    0

    Crystal for Enterprise or "classic" Crystal?

    For classic Crystal, I believe that all of the processing for a schedule still happens in the job server - unlike Webi where it gets passed to the processing server.

    Do your reports have saved data in them? If so, the delay might be caused while the report is being opened (reports with data take longer to open) or while the data is removed from it. And if I'm wrong about this, I'm sure someone else will chime in here...

    -Dell

    Add a comment
    10|10000 characters needed characters exceeded

    • Dell Stinnett-Christy
      Dec 20, 2018 at 06:23 PM

      That would definitely cause delays if there are lots of reports that are scheduled at the same time. However, it can be challenging to find the "sweet spot" for number of concurrent jobs that won't overload your server resources. The default value is 5, I wouldn't increase it to more than 15, possibly less if your server doesn't have a lot of RAM or disk space. The disk space is because Crystal can do a lot of swapping to disk if a report is large or if it has to join or filter tables in memory instead of passing the join or filter to the database.

      -Dell

    Comment on This Answer
  • author's profile photo Sandhya Gowravajhala
    Sandhya Gowravajhala
    Posted on Dec 20, 2018 at 05:28 PM
    0

    Hi Michael,

    Iam having a similar issue-but weirdly it goes away on its own.

    How /where did you change the setting?

    Thanks

    Sandy

    Add a comment
    10|10000 characters needed characters exceeded

    • Michael Gaynor
      Dec 20, 2018 at 05:37 PM

      I'm not sure if it's the solution but in the CMC >> Servers >> Adaptive Job Server properties there are a number of configurable settings for scheduling services. You can set the Maximum Number of Concurrent Jobs for each of the services. Your own usage patterns/needs and system resources would dictate how high or low you set the number of jobs. In my situation I have two servers clustered together but one had CR set to 15 concurrent and the other was only 2. I THINK that contributed to the unpredictable behavior/delays.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.