Skip to Content
0
Former Member
Feb 27, 2009 at 10:11 PM

Job Dependancies Problems

21 Views

We have a series of 19 Objects that are all dependant on each other. The first object triggers an event that the second object is dependant on, and the second object triggers an event that the third object depends on, and so on until the 19th object completes (it only depends on the 18th objects event, and does not trigger any event of it's own).

Each object is scheduled to start at the same time on the quarter and 3-quarter hour (7:15 AM, 7:45 AM, 8:15 AM, 8:45 AM...). This schedule allows all 19 objects to start simultaneously, but each one must wait for the previous object to complete before it begins.

This configuration has been working well until this week when we think a new anti-virus program caused the system to stop functioning. It has not been determined what the problem was. But the anti virus program has been disabled for now to ensure it was not the issue. Nothing else new has been done to the server as far as I know.

The result is that my 1st object, which has no dependencies continues to run on schedule. The other 18 objects are all waiting for the 2nd object to complete. The 2nd object is not running.

I tried stopping and then restarting these services in this order (reversed for the start)

Central Management Server

Crystal Reports Cache Server

Crystal Reports Job Server

Crystal Reports Page Server

After the restart the 2nd object showed 5 scheduled instances were now running. After about 90 minutes of waiting none of them ever completed, no Failure no Success just running. The 2nd objects average run time is about 5 minutes.

I repeated the service start and stop procedure, and when I looked again the 2nd object had no more instances in the running state.

The 1st object is continuing to run on schedule but none of the other objects have run since yesterday (2/26/09 @ 11:24 AM PST).

When I look at the Recurring scheduled objects they all indicate the next run time is now in the past.

Can you tell me if the Crystal Report Server will eventually 'time out' all of the objects that did not run on schedule and are now 1 - 2 days old? Will they eventually run again?

Is there a way to clear the 'hung' dependant objects and get the objects to begin running on the configured schedule?

There are 21 scheduled instances of each of the 19 objects and it would be a very large job to recreate them just to get the scheduler to work again.