Cognos Analytics

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