The synchronization failure between CAPC an CA Spectrum.
The CAPC DMService.log file shows the following error:
CAPC encountered an error while trying to sync with data source Spectrum Infrastructure
[email protected] The problem is in CAPC, not the data source.
The following stack trace shows the invalid SQL statement in CAPC: org.springframework.dao.DataIntegrityViolationException: StatementCallback; SQL [INSERT INTO dst_device (SourceID, UpdatedOn, `ItemSubTypeName`, `LocalID`, `ItemName`, `ItemDesc`, `Address`, `DomainID`, `SnmpReadID`, `SnmpWriteID`) VALUES (7,1531516102,'switches','0x21052b0','ABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDAB','Huawei AR1220E Huawei Versatile Routing Platform Software VRP (R) software,Version 5.160 (AR1220E V200R007C00SPC900) Copyright (C) 2011-2016 Huawei Technologies Co., Ltd',0x00000000000000000000ffff0afdfa68,3,NULL,NULL) ON DUPLICATE KEY UPDATE UpdatedOn=1531516102, `ItemSubTypeName`=VALUES(`ItemSubTypeName`), `LocalID`=VALUES(`LocalID`), `ItemName`=VALUES(`ItemName`), `ItemDesc`=VALUES(`ItemDesc`), `Address`=VALUES(`Address`), `DomainID`=VALUES(`DomainID`), `SnmpReadID`=VALUES(`SnmpReadID`), `SnmpWriteID`=VALUES(`SnmpWriteID`)]; Data truncation: Data too long for column 'ItemName' at row 1; nested exception is com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'ItemName' at row 1 . . .