REPORT MANAGER CONTAINS STALE BUCKETS error and NCM bucket files are growing

Products

• CA Spectrum

Issue/Introduction

Recently upgraded from 10.4.3 to 21.2.8 customer is seeing  "REPORT MANAGER CONTAINS STALE BUCKETS" errors

Reviewing the catalina.out :

Mar 30, 2022 14:16:12.235 (SRM/NCMConfigHandler/bucketReader) (com.aprisma.spectrum.app.repmgr.dc.event.handler.NCMConfigHandler) - (WARN) -  unable retrieve attrID 0x82002f and setting as 0 for host model 0x202c425
Mar 30, 2022 14:16:12.364 (SRM/NCMConfigHandler/bucketReader) (com.aprisma.spectrum.app.repmgr.dc.event.handler.NCMConfigHandler) - (ERROR) - Error occurred while processing NCM event bucket, Record: [email protected]
Caused by: org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [INSERT INTO  ncm_config_text ( prev_config_text_id, config_model_key, prev_config_model_key, create_time, diff_text, config_text) VALUES (?,?,?,?,?,?)]; SQL state [HY000]; error code [1366]; Incorrect string value: '\xF1\xA0\xB5\xA3:1...' for column 'config_text' at row 1; nested exception is java.sql.SQLException: Incorrect string value: '\xF1\xA0\xB5\xA3:1...' for column 'config_text' at row 1
        at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1542)

Environment

Release : 21.2

Component : Spectrum Reporting

Cause

 non-utf chars  in device configuration

Resolution

Spectrum_21.02.08.D70