CA Infrastructure Management, CA Performance Management - Usage and Administration
A processing failure occurred on the data source during synchronization. Errors in log file.
Nov 18, 2019 11:52:57.678 - ThreadPool: exception thrown from ThreadTask: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [SELECT value from registry where attribute = ? ]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'netqos_integ.registry' doesn't exist
Spectrum 10.x integrated with CAPM 3.6 or later
The netqos_integ database is removed or corrupted. You Need to remove the Spectrum Data source from CAPC and then wait till it is fully deleted and then re-add the Spectrum data source.