Few jobs/reports are getting stuck in executing state

[sunosoft]

Hi All,

Got a small issue. We are having many schedules in our environment out which few are getting stuck in executing state intermittently. Its not a case that always same schedules are in executing state. Report/job which reamins in executing state it normally completes within 1 or 2 mins.

When I checked servers for this issue there were no BiBus process stuck into task manager. Also i am not able to find any erros in log file. But for some of those reports i found status as finished in log file. But no output generated on cognos connection and no email has been sent. Just executing executing executing............

version 10.2

[Suraj]

Do they finish if you cancel and re-submit them?

[sunosoft]

Thanks for your response.

Yes they are executing fine if we re-run or reschedule. Even if we do not cancel the current executing instance of job/report and reschedule or execute the same then its getting completed as expected.

[Suraj]

Looks like Cognos server ran out of threads and submitted reports hung.
We had similar situation when using an external scheduler that sent too many reports to Cognos server.
I increased the number of connections in Cognos and it was resolved.
You can try and see if that resolves the issue.

[sunosoft]

Hmmm...

Thanks for your inputs.