When doing Download replication why are we getting ca_query_version errors ?

Document ID : KB000012240
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

In Ca Client Automation when you create a Query and run it,  it gives you the option to save the results.

If the Query is created on the Enterprise then it will get automatically replicated to the DM and it will also replicate the saved results. 

Question:

When doing Download replication why are we getting ca_query_version errors ?

Environment:
CA Client Automation - All Versions
Answer:

When you create a Query on the Enterprise that Query will be replicated down to the Domain Manager.

Sometimes customers will run a preview on a Query and save the results.

When replication tries to replicate these results down to the Domain Manager you can get the following error:

 

Error replicating ca_query_version.

 

The best way to resolve this is to go to the Enterprise and delete all saved Query previews.

If you don't know where they are you can do a:

use mdb 

select qd.label as Query_Name, qv.label as Query_Version_Name from ca_query_version qv, ca_query_def qd

where qv.query_uuid = qd.query_uuid

 and it will list all the Queries and the name of the Saved results, so you can find them and delete them in the GUI.