USM is not loading after upgrading to UMP 8.51

Document ID:  TEC1247717
Last Modified Date:  06/16/2017
{{active ? 'Hide' : 'Show'}} Technical Document Details

Products

  • CA Unified Infrastructure Management

Releases

  • CA Unified Infrastructure Management:Release:8.51

Components

  • UIM - UMP:UIMUMP
Symptoms:

After upgrading to UMP 8.51, the UMP USM portlet hangs in a loading state for very long periods of time the first time a user logs in.  This can take from 20 minutes to an hour for the portlet to load.  A query similar to the following is seen running on the MySQL database server:

SELECT dev.cs_id,
meci.master_id,
cim.ci_metric_id,
dev.dev_id
FROM CM_DEVICE dev
JOIN
CM_CONFIGURATION_ITEM ci ON ci.dev_id = dev.dev_id
JOIN
CM_CONFIGURATION_ITEM_METRIC cim ON cim.ci_id = ci.ci_id
LEFT JOIN
CM_CONFIG_ITEM_TO_MASTER meci ON meci.ci_id = ci.ci_id
WHERE 1=1
and (dev.dev_id IN ( 'D043BA3B5CB3B253453AA98BD717FF42A','D5323bd4bb84c2502a8ff28336cdb2710'.,<.....>);

This occurs when there are groups defined in USM with a large number of devices.  The list of devices contained in the IN () group in the above query is very large (500+ in this instance).

Environment:
UIM/UMP 8.51 upgrade with MySQL 5.6 database manager hosting the UIM database
Cause:

A non-unique index for the column name ‘ci_id’ for the table ‘CM_CONFIG_ITEM_TO_MASTER’ table was missing after the upgrade.

Resolution:

Add the missing index to the 'CM_CONFIGURE_ITEM_TO_MASTER' table:

create index cm_config_item_to_master_idx01 on cm_config_item_to_master(ci_id);

Additional Information:

There is no need to restart the UMP wasp probe after making the change to the table in the MySQL database.

Please help us improve!

Will this information enable you to resolve your issue?

Please tell us what we can do better.

{{feedbackText.length ? feedbackText.length : '0'}}/255

{{status}}

Not what you were looking for?

Search Again >

Product Information

Support by Product >

Communities

Join a Community >

Chat with CA

Just give us some brief information and we'll connect you to the right CA ExpertCA sales representative.

Our hours of availability are 8AM - 5PM CST.

All Fields Required

connecting

We're matching your request.

Unfortunately, we can't connect you to an agent. If you are not automatically redirected please click here.

  • {{message.agentProfile.name}} will be helping you today.

    View Profile


  • Transfered to {{message.agentProfile.name}}

    {{message.agentProfile.name}} joined the conversation

    {{message.agentProfile.name}} left the conversation

  • Your chat with {{$storage.chatSession.messages[$index - 1].agentProfile.name}} has ended.
    Thank you for your interest in CA.


    Rate Your Chat Experience.

    {{chat.statusMsg}}

agent is typing