Scheduled report remain in pending status

scheduling XI Scheduler
1

Hi all

Can anyone help with a problem I have when scheduling reports?

In some cases when a report is scheduled to run “Now” it stays in instance manager as pending. Currently my job server is set to allow 25 jobs, there are no jobs running but two are pending, and show no signs of attempting to run. There are no problems logged in the event viewer.

Does anyone else have this problem?

These are webi reports

annewilkinson :uk: (BOB member since 2006-06-13)

2

On your job servers, try using the switch ‘-type outproc’ before the -restart. I had this issue - starting with either 10 or XI (I forget now) they changed it so that instead of spawning a new jobserverchild process for each report and killing when the report is complete, they changed it so one process runs x number of reports (I think 1000) - they said they didn’t want to go higher ‘in case there was a memory leak’ - changing the switch will cause it to work the way it did before and it’s resolved the issues my clients have had like that

charlottecraig (BOB member since 2006-06-20)

3

I just thought of another thing it could be - had this one too and since you mention events. If there are reports in pending waiting on an event and there are so many pending that they can’t fire because the event can’t fire but the event is behind them (hope that makes sense) you get into a deadlock. If these reports depend on a report event. Create a separate job server(s) and run your events just off them (using server groups) then run all else off another server group - I created for one client a server group called ‘reports’ and one called ‘events’ and they have had no issues with that since

charlottecraig (BOB member since 2006-06-20)

4

If the Webi Job server is stopped or disabled, you’ll also see a “Pending” status. We had a situation where the Webi Job Server didn’t register correctly with the CMS after a reboot, and it was showing up as disabled through CMC → Servers, even though it looked like it was enabled and running when we checked it out via the CCM on the host server.

HTH -

DJ

DJ06482 :us: (BOB member since 2002-11-22)

5

I have exactly the same problem, except my is a Crystal Report. I couldn’t find out what’s happening either… Every servers are running and there were no other job is on the que… :hb:
I had to re-start the CMS to get them running again… pretty please shown light on this issue for me too… Thanks a bunch…

WizardofCR (BOB member since 2006-08-10)

6

Hi,

I encountered similar (if not the same) problem. Strangely, i can still run a schedule report via CMC but not Infoview during that black-out period.
After 1 hour, the Infoview resume it’s operation (can run scheduled reports).
Anyone has any idea if there’s any background processing running that prevent Infoview of executing the scheduled reports.
Anything, this black-out period happens to me during 12am-1am every day.

Please advise. Thanks,

widjajac (BOB member since 2006-08-20)

7

What else is going on during that time frame? Server reboot, database backup, etc? I’d recommend starting by checking your Application Event Log on the machine that hosts the scheduler to see if you can narrow down what’s occuring from 12AM - 1AM.

DJ

DJ06482 :us: (BOB member since 2002-11-22)

8

Have you found what was going on between 12 - 1AM that would stop the webi job services from processing - is it a server backup? A microsoft patch, recently applied ? We had the same thing happen recently.

Project (BOB member since 2002-09-04)

9

We discovered this problem with a SDK application that was automating scheduled reports. The reports always went to pending during that hour and never come out of pending status. We tested with Infoview and found the same result. It always works correctly at 11:59 but always goes pending at 12:00.

BO Support told us that there is a “tombstone” process running during that hour for cleaning up “orphan” jobs. The workaround is to schedule the report to run Once at the current date/time instead of Run Now.

paulfischer :us: (BOB member since 2002-09-08)

10

HI
this is the command parameter i am currently using can someone help where i can apply the suggested parameters

-loggingPath “D:/Business Objects/BusinessObjects Enterprise 12.0/logging/” -jsTypeDescription “Crystal Reports Job Server” -objectType CrystalEnterprise.Report -maxDesktops 0 -maxChildReqs 1 -childProcTimeOut 30

regards,
Patel

mpatel01 (BOB member since 2010-01-29)