COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => ReportNet Administration => Topic started by: dbamgr on 14 Jan 2010 12:06:12 PM

Title: How to kill executing report in Cognos Connection -7.3
Post by: dbamgr on 14 Jan 2010 12:06:12 PM
Hi,

We have an issue. our report team ran report and which mostly take 1 hour. but it hung up yesterday and it is still executing and when we try to cancel it in the Cognos Connection nothing is happening and it cannot let us cancel/kill the report.

We are on Cognos 7.3 version and report net 1.1.


Thanks in advance
MS



Title: Re: How to kill executing report in Cognos Connection -7.3
Post by: MFGF on 15 Jan 2010 05:09:35 AM
Hi,

You need to kill the appropriate BIBusTKServerMain process from your Operating System.  The trick is in knowing which one to kill, though (you may have multiple processes if other reports are running currently). I'd guess it will be the one consuming most memory?

MF.
Title: Re: How to kill executing report in Cognos Connection -7.3
Post by: dbamgr on 15 Jan 2010 10:01:08 AM
Hi,

Thank you for the information. I see couple of BIBusTKServerMain connections in the Window Task manager.  Currently all of them are using the CPU.
I think I have to wait until all other reports are done and then kill the last one are using the CPU & Memory.


Thanks
MS
Title: Re: How to kill executing report in Cognos Connection -7.3
Post by: dbamgr on 15 Jan 2010 02:34:43 PM
HI MF,

OK, I have killed BIBusTKServerMain process in window task manager and when I went in cognos connection it is still showing me the report is pending.
I try to cancel it still nothing happen. I restart the report service only nothing happen.  Still in panding mode.
Please can you let me know what will be the next step.


Thanks In Advance
Title: Re: How to kill executing report in Cognos Connection -7.3
Post by: MFGF on 18 Jan 2010 03:08:35 AM
Hmmm - sounds like the server is getting confused somewhere.  You may need to try restarting the ReportNet service.
Title: Re: How to kill executing report in Cognos Connection -7.3
Post by: vasudev_chavan on 07 Nov 2012 06:12:10 AM
user processexplorer.exe application.

find the process id from Cognos application.
Using process Id we can find out the BIBUS process in use for that report and kill the process.

Note: Process explorer.exe application is free no need to pay  ;)

URL:http://technet.microsoft.com/en-in/sysinternals/bb896653.aspx