NetOps Portal user login is very slow and seems to hang

Products

• CA Performance Management - Usage and Administration
• DX NetOps

Issue/Introduction

Logging in to CAPC Console is Hung

When logging into the DX NetOps Performance Management Portal web UI the response is slow. It often takes between 30 and 90 seconds for the user login process to complete. Once logged in the UI responds in a normal time frame.

Portal is integrated with LDAP for SSO. Testing with the SsoConfig LDAP Test option shows a very fast login response which rules out LDAP as a possible bottleneck.

The Portal environment this is observed in is a very large environment. The same issue is not seen in smaller lab/test environments.

Users who report the slow login issue have a Home page configured against a Dashboard that contains Inventory List Views.

Cause

A few possible causes may exist.

1. Users set with Home page configured against a Dashboard that contains Inventory List Views. These are very expensive queries in terms of resources and can take extra time to complete.
2. MySql configurations slowing down the login cycle beyond expected time frames.

Environment

All supported DX NetOps Performance Management releases

Resolution

To resolve this there are two options. The first can be tested independently. The second requires Broadcom Support and Engineering assistance.

1. Set the Home page for a user to a Dashboard that contains only report Views. Ensure the Dashboard contains zero Inventory List Views.
   1. If this works as a solution make the change to any user reporting slow log in times. 
   2. If this does not work as a solution step 2 may be required.
2. Configuration changes to the MySql implementation may help resolve the problem.
   1. Doing so requires caution to ensure the changes fix things rather than making them worse.
   2. Please open a new Support Case referencing this Knowledge Base article for further assistance in resolving this problem.