Environment

UCMDB to UCMDB integration (applicable for other integrations.)
 

Situation

Multiple different CIs get the same internal_id during delta push (see jobs "communication.log" for integration)
As a result only one of the CIs with duplicated internal_id gets pushed from UCMDB to the target.
 

Cause

Incorrect Data Store records in SYNC_ID_MAPPING tables.
 

Resolution

!!!Caution: It is recommended to do a DB backup before proceeding!!!
1. Get the name of the integration point.
2. It is best if you clear all the CIs from this integration in the destination to avoid any duplication.
3. (Warning: Only do this if you have confirmed from the logs that there are CIs with duplicated internal_id) Invoke removeIdMappingsOfDataStore from the JMX console, enter the integration point name in dataStore field.

4. Rerun integration. (it might take more time as without the data store the integration will push the full list of CIs)

Additional Information

https://docs.microfocus.com/doc/UCMDB/2022.11/ClearDatastore
https://docs.microfocus.com/doc/UCMDB/2022.11/SAJmxConsl

Access UCMDB article on support portal