If you are unable to create a new account, please email support@bspsoftware.com

Author Topic: Reports getting stuck in Pending Status  (Read 4392 times)

Offline adam_mc

  • Statesman
  • ******
  • Join Date: Mar 2012
  • Posts: 319
  • Forum Citizenship: +15/-0
Reports getting stuck in Pending Status
« on: 18 Feb 2020 10:38:21 am »
CA 11.0.13

Since, we upgraded to CA 11.0.13 from Cognos BI 10.2.2, we have encountered periodic problems where large numbers of reports go to a Pending Status (rather than Executing or Waiting).
There may only a be a few (1 -5) reports actually Executing, but as many as 50+ in a Pending Status.

This situation is almost immediately rectified by "nudging" the Batch Report Services on each of the dispatchers.

Cognos Adinistration Console > System > All Servers > Services > Batch Report Service > Start on each dispatcher.

As soon as this is done, reports seem to almost immediately start running and/or complete.

Has anyone else seen this behavior and how did you prevent this from re-occurring?
Are there any preventative or monitoring methodologies that we can put into place?

Any thoughts would be gratefully appreciated.

Offline CognosAdmn

  • Community Leader
  • *****
  • Join Date: Oct 2009
  • Posts: 87
  • Forum Citizenship: +1/-0
Re: Reports getting stuck in Pending Status
« Reply #1 on: 21 Feb 2020 11:15:51 pm »
We've experienced the same issue after we migrated from Cognos 11.0.7 to 11.1.1, mostly during the first few days of the month.

Initially, we tried "nudging" the Batch Report Service as well, which only resolved the issue temporarily. After a few hours the reports started pending again. We involved IBM Support and they have suggested the following:
Have a separate Notification Store DB.
Increased the "Maximum number of processes for the batch report service during peak period".
Increase "Maximum memory for Websphere Liberty Profile in MB"

Additionally, we noticed the reports and jobs in pending state were triggered after one or more reports or jobs were running for a long time. Improving report run times helped. Also, several jobs were running reports concurrently. Those have been asked to run sequentially.
After about three months of tweaking and testing, we've not encountered the issue during the last two months. (knock on wood)

I hope this helps.

Offline sdf

  • Statesman
  • ******
  • Join Date: Feb 2014
  • Posts: 539
  • Forum Citizenship: +4/-0
Re: Reports getting stuck in Pending Status
« Reply #2 on: 24 Feb 2020 10:15:36 am »
we moved from 11.0.7 to 11.0.13.
I noticed the same behavior but the reports/jobs that went rouge are actually reports that were ran from a long time ago. All of them does not even have the PID.
Even when you explicitly cancel them, they'll just comeback as pending.
I guess i'll try "nudging" as well and the steps above.