Product:
Cognos Controller 11.0.1200.28
Microsoft Windows 2022 Server
Issue:
Most users get that the Cognos Controller client hang, when they open some selection dialogs. For example – go to Maintain – Account Structure Reports – select codes – and click on the … for the account field, to get a list of all the accounts. Here the Cognos Controller client hang, and you have to stop cognos controller from the task manager.
Possible Solution:
Do a optimize on the database from inside cognos controller client.
- To run the optimization immediately, the system must be in single user mode. Go to and set the system to single mode.
- Select Rebuild Indexes (advanced option).
- Click Run
Other things you can try to solve the issue are:
Clear the cache in cognos controller
Inside Controller Client program, via Maintain > Special Utilities > Clear Local Cache.
Change the cache folder for cognos controller client:
Launch Windows Explorer
4. Open the folder where Controller is installed.
- Default this is here: C:\Program Files\ibm\IBM Cognos Controller Local Client
5. Open the file “CCR.exe.config” inside Notepad++
6. Search for the entry similar to the following:
<add key=”CacheDir” value=””/>
7. Modify this entry appropriately, for example similar to the following:
<add key=”CacheDir” value=”D:\Controller\Cache” />
8. Save and test
Start Cognos Controller client, and try to open the same account list.
There are 3 types of cache folder used by Cognos Controller Client:
(1) Microsoft Internet Explorer cache at C:\Documents and Settings\%USERNAME%\Local Settings\Temporary Internet Files
(2) Microsoft .NET components at C:\Documents and Settings\%username%\Local Settings\Application Data\assembly
(3) Controller user cache files: at C:\Documents and Settings\%appdata%\Application Data\Cognos\ccr\
If there is damage files in this folders, can give strange errors inside Cognos Controller Client program.
More information:
Optimize the Database – IBM Documentation
FAQ – What does an ‘internal’ database optimise do, and how often should I run a database optimize?
https://www.ibm.com/support/pages/how-automatically-clear-local-cache-when-closing-controller
https://www.ibm.com/support/pages/massive-sql-transaction-logs-caused-rebuilding-sql-indexes
You can use Cognos Controller database optimize function to make the following database changes:
- Remove Period Zero Values – clears the value 0 from selected period tables.
- Rebuild Structure Tables – which gives quicker access to data.
- Rebuild Indexes (advanced option) – Rebuilds all indexes in the database to enhance performance and give quicker access to data.
- Analyze Schema (advanced option) – Reanalyzes the schema for Oracle database.