Global Sync Fails with "ItemID cannot be null" in DMService.log

Products

• Network Observability
• CA Performance Management

Issue/Introduction

Global synchronization fails intermittently or consistently in DX NetOps Performance Management. The following error is observed in the DMService.log: Exception thrown by sync task: org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; ... Column 'ItemID' cannot be null

Symptoms include:

• Spectrum data is not viewable in the Portal.
• Errors reference network_path, web_path, or dst_network_path.
• Global sync does not complete successfully.

Environment

NetOps Portal releases prior to 25.4.9

Cause

A product defect causes the Global Sync process to attempt inserting NULL values into database columns (e.g., ItemID or ItemSubType) that have strict NOT NULL constraints. This typically occurs when synchronization records for network or web paths become orphaned or corrupted.

Resolution

• 25.4.9 contains a workaround to prevent sync from overtly failing through defect DE181724
• 25.4.10 will contain the complete resolution
  • • If necessary, a one time cleanup can be accomplished through KB Article 388797.  However, this issue will likely continue to reoccur unless you upgrade to a fixed release