Upload replication of table ca_link_dis_hw_user failing

Products

• CA Client Automation - IT Client Manager

Issue/Introduction

Upload replication of table ca_link_dis_hw_user. 39 rows could not be uploaded to enterprise server:

2025-04-24 13:58:34 Performing Job:<DM_Name> Upload Replication
...
2025-04-24 13:58:36 Table: ca_link_dis_hw_user (8 of 42), Update records to process: 39
2025-04-24 13:58:36 Warning: A database constraint violation error occurred for table: ca_link_dis_hw_user
2025-04-24 13:58:36 Table: ca_link_dis_hw_user (8 of 42), Records updated: 0, Elapsed time: 00:00:00

Cause

They could not be replicated because the linked user_uuid does not exist on the Enterprise database :

240425-13:58:36.2436049L|006156|00000214|SystemEngi|DbImplAdo       |DbImpl_Ado.cpp      |002345|NOTIFY | evalSQLInfo description: The INSERT statement conflicted with the FOREIGN KEY constraint "$ca_li_r0000037100000000". The conflict occurred in database "mdb", table "dbo.ca_discovered_user", column 'user_uuid'. source: Microsoft SQL Server Native Client 11.0

Resolution

Please do a full upload replication of table ca_discovered_user on Domain Manager which is mentioned in the above error to resolve this problem.

 

This could be done by executing following SQL Query on mdb database of Domain Manager :

Note: Please take a full backup of MDB before executing below query:

 

UPDATE ca_replication_status
SET modified_status=0
WHERE replication_conf_uuid=

(SELECT replication_conf_uuid FROM ca_replication_conf WHERE table_name='ca_discovered_user' and direction=50000 and domain_uuid=(SELECT set_val_uuid FROM ca_settings WHERE set_id=1))