Spectrum Sync failure

book

Article ID: 140424

calendar_today

Updated On:

Products

CA Infrastructure Management CA Performance Management - Usage and Administration

Issue/Introduction

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
 

Environment

Spectrum 10.x integrated with CAPM 3.6 or later

Resolution

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.