Skip to Content

BO BI Scheduled Report Queue Order

Nov 15, 2016 at 04:23 PM


avatar image

We have several hundred reports that run the weekend of period end. Someone in our finance department schedules a set of reports, in a specific order, so that he can start working on period end activities after the first one completes. One of the reports is run multiple times, with different parameter values, and the scheduled start times are staggered. Before the first one is set to run, there are many other reports already pending, while waiting for spots on the job servers to open up. The reports are not running in order of when they were scheduled to run. For example, one instance was scheduled for 6:00 AM, and another for 11:00 AM. However, the 6:00 instance actually started running at 2:59 PM, while the 11:00 instance started running at 12:06 PM. Even if we separate the instances by the job server that was used, they are still way out of order. Has anyone else run into this, knows what could be causing it, and/or how to correct it?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Nov 15, 2016 at 05:39 PM

How many Job server do you have?

What is number in "Maximum Concurrent Jobs" section in JOB server properties?

How many reports are scheduled in a day and what is the average refresh time for each report?

Based on the number of reports per day and average time make a gap between the reports schedule so that your reports will not be in the pending state.

From your post it look like many reports are scheduled in limited time period and that is the reason reports are going in the pending state.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

We have 3 job servers (for Crystal Reports 2013 processing) and each have 10 maximum concurrent jobs. There are several hundred scheduled instances that run for period end, and the refresh times vary (some take a few minutes, and some take a few hours). Currently, most of the reports connect directly to our SAP ECC system, and there is a cap on the number of connections that can be made to that system. I believe that cap is 16; so even if 30 reports can run at a time in BusinessObjects, if they are all pulling from ECC, then only 16 of them are actively pulling data. So I don't think it will help much to increase the number of maximum concurrent jobs. The reports going into the pending state is not an issue; we are ok with that. The issue is that they are not processing in the order that they were scheduled to process. For example; A scheduled for 1:00, B for 1:05, C for 1:10, and D for 1:15. If the job servers are backed up, these reports wait for an open spot; but for some reason, we may see that C actually starts running at 1:30, then B at 1:40, D at 1:45, and A at 1:55. There doesn't seem to be any rhyme or reason that we can see.

Manikandan Elumalai Nov 15, 2016 at 07:20 PM

This is the place where you need to tune your Job servers, Sessions and Most importantly tagging Server groups to report schedules.

- Identify reports and their average execution times

- Identify the Off business Hours

- Identify the Nature of the report

- Analyse the Nature of the data for the scheduled report

- If you have dependent scheduled reports try considering Scheduled events (Events section).



10 |10000 characters needed characters left characters exceeded
Sushil Padhye Nov 16, 2016 at 09:41 AM

Hello Nick,

Are these reports made "Event Based"??

You can create file based event so that second report will wait till the time First report gets Success and so on.

Also If Reports are event based (i.e. waiting for some Data loads to be completed) then make sure you schedule the Report time well ahead of event file getting generated (i.e If loads get complete on or after 4 AM then schedule Report for 3 AM).

I had personal Experiance in above, If we have Report schedule time after evet time then Reports are not getting triggered (please correct if i am wrong).

10 |10000 characters needed characters left characters exceeded
Nick VanLent Nov 18, 2016 at 03:52 PM

The reports are not event based. However, the users work with some of the reports in a specific order. So it wouldn't do any good for them to have report C ready before report A is.

Unfortunately, we don't want to use file based events, because we don't need one report to wait until another finishes; we just need one to start after another one starts. For example, if three reports each take an hour to run, we'd like them to start at 4:00, 4:10, and 4:20; so that all three are done by 5:20. If we used file based events to make sure they run in order, then the reports would start at 4:00, 5:00, and 6:00; and they would all be done by 7:00, almost 2 hours later.

10 |10000 characters needed characters left characters exceeded