Missing enterprise object on DOMAIN

Products

• CA Client Automation - IT Client Manager
• CA Client Automation
• CA Client Automation - Asset Management
• CA Client Automation - Asset Management

Issue/Introduction

Some objects (like groups or queries) created on Enterprise are not replicated to some DOMAIN and are missing.

The Download Replication job is in status OK.

Environment

Client Automation - All Versions

Cause

The counter stored in column modified_status of table ca_replication_status on Enterprise server is greater than current counter @@DBTS (last-used timestamp) for some DOMAIN

 

Resolution

Execute following SQL Query :

SELECT *
FROM ca_replication_conf c
INNER JOIN ca_replication_status s ON s.replication_conf_uuid=c.replication_conf_uuid
INNER JOIN ca_manager m ON m.domain_uuid=c.domain_uuid
where c.direction>0 and s.modified_status>@@DBTS

If it returns some rows, execute this SQL Query :

UPDATE ca_replication_status
SET modified_status=0
FROM ca_replication_conf c
INNER JOIN ca_replication_status s ON s.replication_conf_uuid=c.replication_conf_uuid
INNER JOIN ca_manager m ON m.domain_uuid=c.domain_uuid
where c.direction>0 and s.modified_status>@@DBTS