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

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Can't cancel a job stuck in Waiting status

Started by mrl72, 21 Apr 2023 11:14:07 AM

Previous topic - Next topic

mrl72

We have a job that's been in Waiting status for two months now. Canceling the job in the admin panel doesn't do anything, nor does it throw an error.

I deleted the job and now the name in the current activity queue has changed to "Unknown" but it still can't be cancelled.

Has anyone seen this before? Is there something that can be done at the table level to fix this?

MFGF

Quote from: mrl72 on 21 Apr 2023 11:14:07 AM
We have a job that's been in Waiting status for two months now. Canceling the job in the admin panel doesn't do anything, nor does it throw an error.

I deleted the job and now the name in the current activity queue has changed to "Unknown" but it still can't be cancelled.

Has anyone seen this before? Is there something that can be done at the table level to fix this?

It sounds like some of the data in your nc tables might be corrupt. It's worth considering dropping the nc tables and allowing Cognos to re-create them. Details are in the support document below:

https://www.ibm.com/support/pages/scheduled-cognos-bi-reports-are-stuck-pending-state

Just make sure you have a working backup of the content store (or notification database if you host it separately) before you drop anything.

Cheers!

MF.
Meep!

mrl72

Cheers, will give this a try and report back if it fixes the issue.