NPC data source (0) is missing from the data_sources2 table

Products

• CA Application Delivery Analysis MTP (NetQoS / ADA)
• CA eHealth

Issue/Introduction

Customer is seeing the following error in the NPC Device Manager Service logs:

  - Data Source Poller - : The NPC data source (0) is missing from the data_sources2 table  

Solution:

CusSolution:tomer is seeing the following error in the NPC Device Manager Service logs:

  - Data Source Poller - : The NPC data source (0) is missing from the data_sources2 table  

 

Environment

Release: PCSTAS99000-6.2-NetQoS-Performance Center-Stand-Alone-Server
Component:

Resolution

Solution:

RESOLUTION

You can check what the Source ID for NPC is currently with this command:

   mysql -P3308 netqosportal
       select sourceid, sourcetype, consolename, consolehost, mode, deleted, enabled, removable from data_sources2;  

output should be something like this:

<Please see attached file for image>

src="/servlet/servlet.FileDownload?file=0150c000004AKScAAO" alt="Figure 1" width="650" height="108">

NPC should be set to a sourceID of 0. If not, update it with this command:

   Update data_sources2 set sourceID=0 where sourcetype=16;  

Restart the NetQoS Device Manager Service, and the error should clear.