Spectrum Data Source Sync Failed

book

Article ID: 193319

calendar_today

Updated On:

Products

CA Infrastructure Management CA Performance Management - Usage and Administration DX NetOps

Issue/Introduction

Spectrum data source synch is failing and we see this error in the DMService.log

nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'ItemID' cannot be null

Cause

Due to a corrupted data sample, the synch process has tried to populate an attribute value with null in the CAPC mysql database.

We will need to remove the entries with null values.

Environment

Release : 3.7

Component : CA Performance Center

Resolution

On the CAPC host:

Check the DMService.log for ERROR messages and find the affected tables:

..

ERROR | pool-4-thread-1          | 2020-06-17 11:09:59,180 | com.ca.im.portal.dm.productsync.DataSourcePoller                

      | Exception thrown by sync task: org.springframework.dao.DataIntegrityViolationException: StatementCallback; SQL [INSERT INTO temp_items (itemID, sourceID, updatedOn) SELECT dst.ItemID, dst.sourceID, dst.updatedOn FROM dst_slapath dst WHERE UpdatedOn=0]; Column 'ItemID' cannot be null; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'ItemID' cannot be null

..

ERROR | pool-4-thread-1          | 2020-06-17 17:29:36,305 | com.ca.im.portal.dm.productsync.DataSourcePoller                

      | Exception thrown by sync task: org.springframework.dao.DataIntegrityViolationException: StatementCallback; SQL [INSERT INTO temp_items (itemID, sourceID, updatedOn) SELECT dst.ItemID, dst.sourceID, dst.updatedOn FROM dst_tunnel dst WHERE UpdatedOn=0]; Column 'ItemID' cannot be null; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'ItemID' cannot be null

..

Stop CAPC services (not mysql)

Now clear the entries for the listed table(s):

mysql netqosportal -unetqos -pnetqos (your password will vary)

delete d from ds_items d inner join dst_slapath ds on d.sourceid=ds.sourceid and d.localid=ds.sourceid where ds.itemid is null and d.updatedon=0;

delete from dst_slapath where itemid is null and updatedon=0;

delete d from ds_items d inner join dst_tunnel ds on d.sourceid=ds.sourceid and d.localid=ds.sourceid where ds.itemid is null and d.updatedon=0;

delete from dst_tunnel where itemid is null and updatedon=0;

Start CAPC services.

The synch should now complete.

Additional Information

https://ca-broadcom.wolkenservicedesk.com/external/article?articleId=32043