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

Article Id: 37243

Status: Published

Updated On: 14-02-2018 07:36

Legacy Id: TEC1867516

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: