Hello,
we have Cognos 8.4 with Fix Pack 1 running on Windows Server 2003, Enterprise Edition. The Content Store and the source database run on a Oracle 10.2, on a separate server.
The production servers hang (freeze) quite often, even once or twice a day.
When they hang the system does not respond to any query.
This issue seems to be caused by some BiBusTkServerMain processes that use the 100 % of a CPU.
To fix the problem we have to manually kill the BiBusTkServerMain processes. Immediately new BiBusTkServerMain processes are created, and the system works again.
Please note that the production servers are quite large (2 application servers, each with 8 CPU and 16 GB of RAM), and the workload is very low (less than 10 users, testing the frameworks with Query Studio).
We have already reviewed the IBM Cognos Configuration, reviewed all the configuration settings, enabled additional logging and tracing, together with the IBM Cognos technical support.
We also enabled the DISP.InteractiveProcessUseLimit parameter, to force the reset of BiBusTkServerMain every n (500) requests.
We also dumped the freezed BiBusTkServerMain processes with the Microsoft ADPlus tool, as requested by the IBM Cognos support.
We get the same hang on the quality assurance server, which has the same software on a single server installation.
I searched the Internet for this problem, without finding a real solution.
Any suggestion ?
Thanks.
Danilo