Client Automation - Database Synchronization job in Error

Products

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

Issue/Introduction

Database Synchronization job is in error.
There are some SQL Error in Engine logs for Engine which executes the synchronization job.
There are some missing Computers on the target mdb database.

How to correct this ?
 

Environment

Client Automation - All Versions

Resolution

1- Unzip the attached file repair_sync.zip in a temp directory (ex: c:\temp\repair_sync) on the Domain Manager or on SQL Server machine.

2- Open a cmd prompt and execute this :

cd /D c:\temp\repair_sync

repair_sync_install.bat I TargetSQLServer\InstanceName NOT_changedR11 SourceSQLServer\InstanceName sa pwdsa

or only this if we are logged on source SQL Server with a user which has sysadmin rights on source SQL Server

repair_sync_install.bat I TargetSQLServer\InstanceName NOT_changedR11

Remarks: 

• Replace TargetSQLServer\InstanceName by name and instancename of Target SQL Server hosting the target mdb
• Replace NOT_changedR11 by the correct password for ca_itrm account on target SQL Server
• Replace SourceSQLServer\InstanceName by name and instancename of Target SQL Server hosting the source mdb 
• Replace sa and pwdsa by a SQL User sa and its password of source SQL Server (or another SQL Login with sysadmin role)

 

3- Execute this to view if there is something to repair: 

repair_sync.bat VIEW TargetSQLServer\InstanceName SourceSQLServer\InstanceName ca_itrm NOT_changedR11
 

or only this if we are logged on source SQL Server with a user which has enough rights on source SQL Server

repair_sync.bat VIEW TargetSQLServer\InstanceName

 

Remarks: 

• Replace TargetSQLServer\InstanceName by name and instancename of Target SQL Server hosting the target mdb
• Replace SourceSQLServer\InstanceName by name and instancename of Target SQL Server hosting the source mdb 
• Replace NOT_changedR11 by the correct password for ca_itrm account on source SQL Server

 

4- If a corruption is found, execute the same command with REPAIR parameter :

 

repair_sync.bat REPAIR TargetSQLServer\InstanceName SourceSQLServer\InstanceName ca_itrm NOT_changedR11 

or only this if we are logged on source SQL Server with a user which has enough rights on source SQL Server

repair_sync.bat REPAIR TargetSQLServer\InstanceName

5- Then remove the link between 2 SQL Servers : 

 

repair_sync_install.bat R TargetSQLServer\InstanceName NOT_changedR11 SourceSQLServer\InstanceName sa pwdsa

or only this if we are logged on SQL Server with a user which has sysadmin rights on source SQL Server

repair_sync_install.bat R TargetSQLServer\InstanceName