Threshold Alarms Not Generating Due to Database Synchronization Discrepancy

Products

• Network Observability
• CA Performance Management

Issue/Introduction

Threshold alarms fail to generate when the group membership in the EM (Event Manager) database is not in sync with the group membership in the netqosportal database. This discrepancy prevents the Event Manager from correctly evaluating metric data against threshold profiles, resulting in missing events within the UI Dashboard Views.

Environment

DX NetOps Performance Management (all supported releases).

Cause

Group membership mismatch between the netqosportal database and the em database.

Resolution

1. Identify the Portal GroupID for the affected group.
2. Run the following queries against the Portal MySQL database to compare item counts:
   sql

    

   select count(*) from netqosportal.item_members where parentid=<GroupID>;select count(*) from em.item_members where parentid=<GroupID>;

3. If the counts do not match, initiate an EM Data Source (DS) Full Synchronization.
4. Verify group member counts after the synchronization completes. When the databases show the same group member counts, the issue is resolved.

Additional Information

If the issue persists, review the EMService.log for further details. To speak with a customer representative or a Support Engineer, see Contact Broadcom Support. For more information, visit Creating and Managing Broadcom Support Cases.