Hi Everyone,

Since last 15 hours the scheduled reports are not running in our Cognos production environment.

when we run reports manually, they are running but when we schedule the report, schedule is not starting.

could you please provide your suggestions here what might be the issue ?

And will rebooting the dispatchers resolve this issue ?

Thanks,
Lokesh

Maybe the credentials of the user that is used to run the scheule is not longer valid. In this case you do not see anything in past run and also nothing in audit-db (only in some log file). Log on as this uses (and maybe click a renew credentials) should solve this problem.

------------------------------
Michael Haaß
IBM

Original Message:
Sent: Wed September 18, 2024 11:01 AM
From: Lokeswara Yerramreddy
Subject: Cognos Schedules are not Running

Hi Everyone,

Since last 15 hours the scheduled reports are not running in our Cognos production environment.

when we run reports manually, they are running but when we schedule the report, schedule is not starting.

could you please provide your suggestions here what might be the issue ?

And will rebooting the dispatchers resolve this issue ?

Thanks,
Lokesh

------------------------------
Lokeswara Yerramreddy
------------------------------

Hi Everyone,

Since last 15 hours the scheduled reports are not running in our Cognos production environment.

when we run reports manually, they are running but when we schedule the report, schedule is not starting.

could you please provide your suggestions here what might be the issue ?

And will rebooting the dispatchers resolve this issue ?

Thanks,
Lokesh

Hello,

can you please check if the user who is owning the schedule has changed the password. If yes, login as the user who is running the schedule and open the user's personal profile and recreate the credentials. I hope it helps. 

Hi Everyone,

Since last 15 hours the scheduled reports are not running in our Cognos production environment.

when we run reports manually, they are running but when we schedule the report, schedule is not starting.

could you please provide your suggestions here what might be the issue ?

And will rebooting the dispatchers resolve this issue ?

Thanks,
Lokesh

Hello,

can you please check if the user who is owning the schedule has changed the password. If yes, login as the user who is running the schedule and open the user's personal profile and recreate the credentials. I hope it helps. 

Hi Everyone,

Since last 15 hours the scheduled reports are not running in our Cognos production environment.

when we run reports manually, they are running but when we schedule the report, schedule is not starting.

could you please provide your suggestions here what might be the issue ?

And will rebooting the dispatchers resolve this issue ?

Thanks,
Lokesh

Hi Everyone,

Since last 15 hours the scheduled reports are not running in our Cognos production environment.

when we run reports manually, they are running but when we schedule the report, schedule is not starting.

could you please provide your suggestions here what might be the issue ?

And will rebooting the dispatchers resolve this issue ?

Thanks,
Lokesh

This happens to me every year.  I disable and re-enable the scheduler.  That seems to fix things (pre 11.2.4 version).  I would hope this doesn't happen with the newer version.   Also, the credential check is a good suggestion.  We had someone retire and had to reassign all scheduled reports under her access.  

Good Luck

Hi Everyone,

Since last 15 hours the scheduled reports are not running in our Cognos production environment.

when we run reports manually, they are running but when we schedule the report, schedule is not starting.

could you please provide your suggestions here what might be the issue ?

And will rebooting the dispatchers resolve this issue ?

Thanks,
Lokesh

Hi

Jeanie Krieger,

Thank you for your response.

There is no issue with user credentials. Actually, all schedules which are there in our production environment were not started running.

We have stopped Cognos services in dispatchers and content manager and ran NC Drop script in Cognos Notify DB. Then started Cognos services so the problem got resolved.

Thank You,

Lokeswara

This happens to me every year.  I disable and re-enable the scheduler.  That seems to fix things (pre 11.2.4 version).  I would hope this doesn't happen with the newer version.   Also, the credential check is a good suggestion.  We had someone retire and had to reassign all scheduled reports under her access.  

Good Luck

Hi Everyone,

Since last 15 hours the scheduled reports are not running in our Cognos production environment.

when we run reports manually, they are running but when we schedule the report, schedule is not starting.

could you please provide your suggestions here what might be the issue ?

And will rebooting the dispatchers resolve this issue ?

Thanks,
Lokesh

What version of Cognos are you on?  Did you recently upgrade?

We encountered this kind of issue when we were trying to move from 11.1.5 to 11.1.6 and then even to 11.1.7.  IBM changed something starting with 11.1.6 such that in our environment about 8-12 hrs after starting the server up, ALL schedules would simply stop running.  The upcoming schedules would show just fine, but as the time passed, the schedules just didn't run.  A full restart of Cognos would "wake" the schedules up again though nothing that was missed would re-run and the Past Runs was just empty from the last schedule that actually ran to the present time.

We had a support ticket open for nearly 2 years (YES! We were stuck on 11.1.5 for 2 years!) until IBM finally released a fix.  As best they could tell, there'd be an error that would just hang the scheduler so they put a watcher process in the code to "restart" it. Seemed to do the trick though often you could see a schedule started running several minutes past its actual scheduled time.

While we're still running on this fixed version of 11.1.7 we've been testing 11.2.4 FP4 and have not seen this issue with the schedules.

Wayne

Hi

Jeanie Krieger,

Thank you for your response.

There is no issue with user credentials. Actually, all schedules which are there in our production environment were not started running.

We have stopped Cognos services in dispatchers and content manager and ran NC Drop script in Cognos Notify DB. Then started Cognos services so the problem got resolved.

Thank You,

Lokeswara

This happens to me every year.  I disable and re-enable the scheduler.  That seems to fix things (pre 11.2.4 version).  I would hope this doesn't happen with the newer version.   Also, the credential check is a good suggestion.  We had someone retire and had to reassign all scheduled reports under her access.  

Good Luck

Hi Everyone,

Since last 15 hours the scheduled reports are not running in our Cognos production environment.

when we run reports manually, they are running but when we schedule the report, schedule is not starting.

could you please provide your suggestions here what might be the issue ?

And will rebooting the dispatchers resolve this issue ?

Thanks,
Lokesh

Three weeks ago, we encountered an issue after I changed my password-the scheduler stopped running reports.

The following day, when I noticed the problem, I manually ran the critical reports using the "Run Once" option. Shortly after, the scheduled reports began processing normally again.
We'd like to prevent this from happening in the future.

Does anyone know if it's possible to assign a generic user as the Scheduler User? If so, how can that be set up?

Thank you,
Irely

What version of Cognos are you on?  Did you recently upgrade?

We encountered this kind of issue when we were trying to move from 11.1.5 to 11.1.6 and then even to 11.1.7.  IBM changed something starting with 11.1.6 such that in our environment about 8-12 hrs after starting the server up, ALL schedules would simply stop running.  The upcoming schedules would show just fine, but as the time passed, the schedules just didn't run.  A full restart of Cognos would "wake" the schedules up again though nothing that was missed would re-run and the Past Runs was just empty from the last schedule that actually ran to the present time.

We had a support ticket open for nearly 2 years (YES! We were stuck on 11.1.5 for 2 years!) until IBM finally released a fix.  As best they could tell, there'd be an error that would just hang the scheduler so they put a watcher process in the code to "restart" it. Seemed to do the trick though often you could see a schedule started running several minutes past its actual scheduled time.

While we're still running on this fixed version of 11.1.7 we've been testing 11.2.4 FP4 and have not seen this issue with the schedules.

Wayne

Hi

Jeanie Krieger,

Thank you for your response.

There is no issue with user credentials. Actually, all schedules which are there in our production environment were not started running.

We have stopped Cognos services in dispatchers and content manager and ran NC Drop script in Cognos Notify DB. Then started Cognos services so the problem got resolved.

Thank You,

Lokeswara

This happens to me every year.  I disable and re-enable the scheduler.  That seems to fix things (pre 11.2.4 version).  I would hope this doesn't happen with the newer version.   Also, the credential check is a good suggestion.  We had someone retire and had to reassign all scheduled reports under her access.  

Good Luck

Hi Everyone,

Since last 15 hours the scheduled reports are not running in our Cognos production environment.

when we run reports manually, they are running but when we schedule the report, schedule is not starting.

could you please provide your suggestions here what might be the issue ?

And will rebooting the dispatchers resolve this issue ?

Thanks,
Lokesh

Three weeks ago, we encountered an issue after I changed my password-the scheduler stopped running reports.

The following day, when I noticed the problem, I manually ran the critical reports using the "Run Once" option. Shortly after, the scheduled reports began processing normally again.
We'd like to prevent this from happening in the future.

Does anyone know if it's possible to assign a generic user as the Scheduler User? If so, how can that be set up?

Thank you,
Irely

What version of Cognos are you on?  Did you recently upgrade?

We encountered this kind of issue when we were trying to move from 11.1.5 to 11.1.6 and then even to 11.1.7.  IBM changed something starting with 11.1.6 such that in our environment about 8-12 hrs after starting the server up, ALL schedules would simply stop running.  The upcoming schedules would show just fine, but as the time passed, the schedules just didn't run.  A full restart of Cognos would "wake" the schedules up again though nothing that was missed would re-run and the Past Runs was just empty from the last schedule that actually ran to the present time.

We had a support ticket open for nearly 2 years (YES! We were stuck on 11.1.5 for 2 years!) until IBM finally released a fix.  As best they could tell, there'd be an error that would just hang the scheduler so they put a watcher process in the code to "restart" it. Seemed to do the trick though often you could see a schedule started running several minutes past its actual scheduled time.

While we're still running on this fixed version of 11.1.7 we've been testing 11.2.4 FP4 and have not seen this issue with the schedules.

Wayne

Hi

Jeanie Krieger,

Thank you for your response.

There is no issue with user credentials. Actually, all schedules which are there in our production environment were not started running.

We have stopped Cognos services in dispatchers and content manager and ran NC Drop script in Cognos Notify DB. Then started Cognos services so the problem got resolved.

Thank You,

Lokeswara

This happens to me every year.  I disable and re-enable the scheduler.  That seems to fix things (pre 11.2.4 version).  I would hope this doesn't happen with the newer version.   Also, the credential check is a good suggestion.  We had someone retire and had to reassign all scheduled reports under her access.  

Good Luck

Hi Everyone,

Since last 15 hours the scheduled reports are not running in our Cognos production environment.

when we run reports manually, they are running but when we schedule the report, schedule is not starting.

could you please provide your suggestions here what might be the issue ?

And will rebooting the dispatchers resolve this issue ?

Thanks,
Lokesh