Troubleshooting
Problem
A single user ("User1") performs an action in Controller. This action takes a measurable amount of time (e.g. 2 minutes) to run. During this time, all other user's sessions of Controller hang (for example they may see the words "Not Responding" in the title bar).
Symptom
There are many different possible triggers:
- Example #1 - In one case, the problem was triggered by User1 ran an Excel-link spreadsheet (F9)
- Example #2 - In another case, User1 clicked "Transfer - Publish data and structures - Publish Data Mart", and selected the template and ran the data mart publish.
- Example #3 - In further case, User1 clicked "Company - Copy - Reported Values Between Periods", and selected the template and ran the data mart publish.
Cause
There are several possible causes for similar symptoms.
- For more examples of causes, see separate IBM Technotes 1611547, 1410876.
This IBM Technote specifically relates to the scenario where the Controller application server's COM+ subsystem becomes overloaded. Again, there are other examples of causes, such as:
- Scenario #1 - Consolidation COM+ components have not been split into separate COM+ application (by convention typically named "COGNOSVFP" or "IBMCOGNOSVFP")
- For more information, see separate IBM Technote #1367965.
- Scenarios #2 & #3 - Controller application server's COM+ subsystem has synchronization issues when exposed to long running processes in Controller.
- This is caused by a known limitation in the underlying third-party architecture (Microsoft COM+) that Controller uses.
- For more information, see separate IBM Technote #1621584.
Resolving The Problem
Scenario #1
Split the consolidation COM+ components into a separate COM+ application (by convention typically named "COGNOSVFP" or "IBMCOGNOSVFP")
- For more information, see separate IBM Technote #1367965.
Scenario #2
Modify the Controller application server so that its COM+ threading model is changed so that each of its COM+ activities has its own thread.
- For more information, see separate IBM Technote #1621584.
Related Information
[{"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.1;10.1.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21631457