Upload replication job in error - health check error was encountered

Products

• CA Client Automation - IT Client Manager
• CA Client Automation

Issue/Introduction

Upload Replication job is in status ERROR.
In <enginename>.log file there are following messages :

2025-04-30 15:47:46 Upload - Completed processing updates on the target database, Elapsed Time: 00:00:02
2025-04-30 15:47:46 Warning: A health check error was encountered
2025-04-30 15:47:46 Upload - Replication Job Done. Warning: though the job was completed, an error occurred: A health check error was encountered. Please examine the log file for more details
2025-04-30 15:47:46 Upload - Replication Job Done, Elapsed Time: 00:00:04

And in TRC_<enginename>.log we could see this

300425-15:47:46.9462602L|005268|00003888|SystemEngi|cmEngine        |Upload::GenerateHeal|000000|DETAIL | Health check enterprise manager MDB tables
300425-15:47:46.9463892L|005268|00003888|SystemEngi|CDb             |CDb.cpp             |000738|DETAIL | Create Recordset
300425-15:47:46.9465275L|005268|00003888|SystemEngi|RecImpl_Ado     |RecImpl_Ado.cpp     |000205|INFO   | CRecImpl_AdoCreate() enter - (select tree_name_id from inv_tree_name_id where domain_uuid=<uuid> and tree_name='$40GeneralInventory$') (3 3 3)
300425-15:47:46.9485541L|005268|00003888|SystemEngi|RecImpl_Ado     |RecImpl_Ado.cpp     |000262|INFO   | CRecImpl_AdoCreate() terminated successfully
300425-15:47:46.9487416L|005268|00003888|SystemEngi|CDb             |CDb.cpp             |000765|DETAIL | Destroy Recordset
300425-15:47:46.9493810L|005268|00003888|SystemEngi|amLog           |                    |000000|ERROR  | cReplicationJob::GenerateHealthStatus() - Unable to retrieve GeneralInventory Root Name ID from EM inv_tree_name_id table
300425-15:47:46.9494848L|005268|00003888|SystemEngi|amLog           |                    |000000|ERROR  | cReplicationJob::HealthCheck() - Unable to create Enterprise Health Table Status on Domain Level
300425-15:47:46.9495742L|005268|00003888|SystemEngi|amLog           |                    |000000|ERROR  | cReplicationJob::Run() - HealthCheck Failed
300425-15:47:46.9496804L|005268|00003888|SystemEngi|amLog           |                    |000000|ERROR  | SetIntermediateStatus1: Upload: A health check error was encountered
300425-15:47:46.9510906L|005268|00003888|SystemEngi|amLogAndNotify  |cAmoLog.h           |000387|ERROR  | Warning: A health check error was encountered
300425-15:47:46.9512508L|005268|00003888|SystemEngi|CDb             |CDb.cpp             |000333|DETAIL | Close a connection

Environment

Client Automation - All Versions

Cause

Some rows in tables inv_tree_name_id and/or inv_item_name_id of DOMAIN database are not present in Enterprise database.

Resolution

Execute following SQL Queries on DOMAIN mdb database to do a full Upload replication of tables inv_tree_name_id and inv_item_name_id

UPDATE ca_replication_status
SET modified_status=0
WHERE replication_conf_uuid=
(SELECT replication_conf_uuid FROM ca_replication_conf WHERE table_name='inv_tree_name_id' and direction=50000 and domain_uuid=(SELECT set_val_uuid FROM ca_settings WHERE set_id=1))

UPDATE ca_replication_status
SET modified_status=0
WHERE replication_conf_uuid=
(SELECT replication_conf_uuid FROM ca_replication_conf WHERE table_name='inv_item_name_id' and direction=50000 and domain_uuid=(SELECT set_val_uuid FROM ca_settings WHERE set_id=1))