BMC Helix CMDB -The operation violates the cardinality constraint of the relationship. : 1-Many cardinality will be violated.

Knowledge Article

Article Number

000330349

Old Article Number

000085984

Article Type

Solutions to a Product Problem

Title

BMC Helix CMDB -The operation violates the cardinality constraint of the relationship. : 1-Many cardinality will be violated.

Summary

Error in Portal log: The operation violates the cardinality constraint of the relationship. : 1-Many cardinality will be violated.

Product

BMC Atrium Core - CMDB

Component

BMC Helix CMDB

Applies to

CMDB

Problem

The following error appears in the UDM:JobLog
Error- 2024/06/04 01:21:28 - SCCMIntegration_Memory - TID:3 [SCCMIntegration_Memory] :CMDB findObjects for 500 CI: 156.0 seconds
2024/06/04 01:22:04 - CMDBOutput HostedSystemComponents.0 - TID:0 [SCCMIntegration_Memory] :Cache Read for - 500 Keys: 3 milliseconds
2024/06/04 01:22:33 - SCCMIntegration_Memory - ERROR (version 6.0.1.0-386, build 1 from 2023-07-31 16.12.31 by buildadm) : CMDB API Error:1:ERROR (120039): The operation violates the cardinality constraint of the relationship.; 1-Many cardinality will be violatedCannot create relationship instance because right endpoint is already in another relationship.Relationship Instance Id: OI-2817c3b94ab448ba85c7d8262d9c721d
2024/06/04 01:22:33 - Error Logging 2.0 - ERROR (version 6.0.1.0-386, build 1 from 2023-07-31 16.12.31 by buildadm) : Unexpected error
2024/06/04 01:22:33 - Error Logging 2.0 - ERROR (version 6.0.1.0-386, build 1 from 2023-07-31 16.12.31 by buildadm) : org.pentaho.di.core.exception.KettleStepException:

Cause

There is an asset record already between the Computer system and Memory with instance id OI-D1A92A58FD5711E79C713502635243FF

Solution

The existing CI detail as per logs in BMC.CORE:BMC_BaseRelationship
with instance id OI-2817c3b94ab448ba85c7d8262d9c721d

There is an asset record already between the Computer system and Memory with recon id OI-D1A92A58FD5711E79C713502635243FF

SCCM job is trying to relate again as per logs.

Either the existing record needs to be cleaned up or the source needs to be corrected.

Attachment(s):