New devices being discovered do not show in CAPC

Products

• CA Infrastructure Management
• CA Infrastructure Management
• CA Performance Management - Usage and Administration
• CA Performance Management - Data Polling

Issue/Introduction

Newly discovered devices are not being added to collections and when we click on the name of a device it brings us to a page with the error: You no longer have access to this Router

Cause

Global synchronization is failing due to crashed MySql tables.  Errors like the below are seen in the /opt/CA/PerformanceCenter/DM/logs/DMService.log:

Caused by: org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [SELECT count(*) from ds_item_combo_members WHERE UpdatedOn>=1528798602 or UpdatedOn=0]; SQL state [HY000]; error code [145]; Table './netqosportal/ds_item_combo_members' is marked as crashed and should be repaired; nested exception is java.sql.SQLException: Table './netqosportal/ds_item_combo_members' is marked as crashed and should be repaired

Environment

Release:
Component: IMADMN

Resolution

• If there is any concern or doubt about executing the below steps without assistance, please do not hesitate to open a new support case to request assistance.
• None of the below processes require the MySql service to be stopped or restarted.
• Before starting to fix the database, shut down all CA Performance Manager services to prevent DB access during the fix process. See KB article kb000032043 for instructions on stopping and starting these services.

After shutting down the four CA Performance Manager services, but leaving the MySql service running, the first step is to determine how extensive the problem is. To do so:

1. Log into the CA Performance Manager server at the command line as the root user
2. Change directories to the /opt/CA/MySql/bin directory.
3. Run the following command to begin the repair of the tables: mysqlcheck -uroot -pnetqos --repair --all-databases
4. Run the following command to list the status of all tables in all databases present: mysqlcheck --all-databases

When the "mysqlcheck --all-databases" command is run and all tables are returned as OK, the corruption has been resolved. It is now safe to restart the four CA Performance Manager services. After this the web UI and log in should work. If it does not, please open a new support case for further investigation and resolution.