IBM Support

Slow performance when using User Rights menu with Cognos 8 security enabled

Troubleshooting


Problem

User clicks 'Maintain - Rights - Users'. User performs a range of tasks, inside this menu. All of these are very slow.

Symptom

Inside the 'Maintain - Rights - Users', the user it attempting to perform a task which queries the Cognos 8 BI server's security system. For example:

  1. Press the ellipsis button for the CAM User
  2. Change the value for CAM User (control on the form and tab/click outside of it, which therefore forces Controller to validate)
  3. Click on a user in the list to the left, this will bring up the user information in the controls to the right. Make a change in the user information, but do not change value for the CAM User. For example, change the 'User Group' and press the 'Save' button. The save button will force validation on all controls on the form, including the 'CAM User'

Performance of Controller is slow during the use of the above 3 scenarios

Cause

There are other potential causes for slow performance.

  • For example, see separate IBM Technote #1606662.

This Technote specifically relates to the scenario where the cause is a code production problem (defect) in Controller 8.4 RTM and earlier versions.
  • This causes Controller to (extremely) frequently communicate to the Cognos 8 report server (to update the list of Cognos 8 users) during many different tasks.
  • This can cause slow performance inside complicated Active Directory environments.

Environment

Cognos 8 security enabled (in other words, not using the default 'native' security).

Resolving The Problem

Upgrade to Controller 8.4.119 or later.

In this (and later Controller releases) the menu has been modified so it does not automatically check/query the Cognos 8 Report Server each time a change is made. This increases the speed, but means that the user may have to exit the menu item in order to see any changes to the Cognos 8 user security configuration.

[{"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":"8.4;8.3","Edition":"All Editions","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Historical Number

1042278

Document Information

Modified date:
15 June 2018

UID

swg21362063