Issue/Problem/Symptoms:
Customer has some problem on the server that hosts the NPC software and the server had to be rebooted and after the reboot the DeviceManagerServerLog file keeps on reporting the following problem:
11:10:55 6 - Data Source Poller: ------------------>>> Polling Data Sources <<<------------------
11:10:55 5 - Data Source Poller: Starting Global Synchronization
11:10:55 1 - Data Source Poller - :
NetQoS.Core.Database.DBException: Table '.\netqosportal\data_source_log' is marked as crashed and should be repaired
Environment:
NPC 6.1 or 6.2
Cause:
Database corruption
Resolution/Workaround:
1) Remote desktop to the NPC server
2) Stop the NetQoS Device Manager service
3) Run the following commands:
mysql -P 3308 netqosportal
repair table data_source_log;
4) Restart the NetQoS Device Manager service