Spectrum data source sync failure

Products

• CA Performance Management
• Spectrum
• Network Observability

Issue/Introduction

After adding Spectrum to the NetOps Portal as a data source, synchronization fails

Environment

All supported releases

Cause

The localID field for a Global Collection is greater than 32 characters.  The following error can be seen in the DMService.log:

ON DUPLICATE KEY UPDATE UpdatedOn=1646667634, `ItemTypeName`=VALUES(`ItemTypeName`), `ItemSubTypeName`=VALUES(`ItemSubTypeName`), `LocalID`=VALUES(`LocalID`), `ItemFlags`=VALUES(`ItemFlags`)]; Data truncation: Data too long for column 'LocalID' at row 73; nested exception is com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Data too long for column 'LocalID' at row 73

Caused by: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Data too long for column 'LocalID' at row 73

Resolution

Check the list of Global Collections above the error message for any of them that are greater than 32 characters, for example:

(10,1646666861,'group','automatic','This id is greater than 32 characters long',0),

Once the Global Collection is found, you will need to delete the Global Collection and create it new so it has an id of something like: 5bc7620002e910001e63c0a80007004a