[MTP] NqMetricD process failing after ADA configuration and synchronization

Products

• CA Application Delivery Analysis MTP (NetQoS / ADA)

Issue/Introduction

After committing monitoring configurations on the ADA and syncing with the Multi-Port Monitor we are seeing the following:

• The NqMetricD process on the Multi-Port Monitor is stopping and starting
• Data is no longer being processed by the Multi-Port Monitor
• ADA is no longer receiving data in the GUI
• The following error is occurring in the nqMetricReader_XXXXXXXX.log

<Please see attached file for image>

Environment

CentOS

Cause

A duplicate entry for a server/subnet/network has been configured in ADA and is being synced down to the Multi-Port Monitor. The nqMetricD process is unable to handle this duplicate entry, ceases processing data, and crashes.

Resolution

To remedy the issue:

• Log into the ADA console via RDP
• Open a command prompt
• 'myqsql'
• 'use super'
• Run through the attached .txt file