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
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 ; 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
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:
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.