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

Document ID : KB000003949
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

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  

 

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:

Figure 1

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.