Table '.\netqosportal\data_source_log' is marked as crashed and should be repaired

Products

• CA Network Flow Analysis (NetQos / NFA)

Issue/Introduction

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

Environment

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