COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Cognos Administration => Topic started by: sunosoft on 09 Apr 2014 07:26:43 AM

Title: Few jobs/reports are getting stuck in executing state
Post by: sunosoft on 09 Apr 2014 07:26:43 AM
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
Title: Re: Few jobs/reports are getting stuck in executing state
Post by: Suraj on 09 Apr 2014 09:31:01 AM
Do they finish if you cancel and re-submit them?
Title: Re: Few jobs/reports are getting stuck in executing state
Post by: sunosoft on 09 Apr 2014 10:22:49 AM
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.
Title: Re: Few jobs/reports are getting stuck in executing state
Post by: Suraj on 09 Apr 2014 11:03:55 AM
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.
Title: Re: Few jobs/reports are getting stuck in executing state
Post by: sunosoft on 10 Apr 2014 08:05:11 AM
Hmmm...

Thanks for your inputs.