Client Automation - Why Query Name like USDSYS are created when importing a SD Package ?

Products

• CA Client Automation - IT Client Manager
• CA Client Automation
• CA Client Automation - Software Delivery

Issue/Introduction

When a SD package is imported, Some queries like 

 

USD-<package name><package version>: <procedure name>USDSYS_<number> 

 

are created.

Why ?

 

Example :

 

Environment

Client Automation - 14.0 All Versions

 

Cause

These queries are automatically created if :

 

1- Imported package has a procedure with Query in Prerequisite tab

 

and

 

2- A query with same name already exists in database but the UUID is not the same

In this case, a new query is automatically created with a generic name :

USD-<package name><package version>: <procedure name>USDSYS_<number> 

 

 

Example :

 

- On a Domain A, a package "CMD 4.0" has a procedure inst with the query "UPM-Blacklist" in Prerequisites

 

 

 

- This package is exported and the file reginfo\itemproc.dat contains the query name and its UUID for the procedure inst

 

[Prereq0]
UUID = A36041F6-3618-4EAB-B010-29EC8382C7DF
Title = UPM-Blacklist

 

 

- On Domain B, the query "UPM-Blacklist" already exists but the UUID is not the same.

When package "CMD 4.0" is imported, query "USD-CMD 4.0: instUSDSYS_1" is automatically created and assigned as prerequisites of procedure :

 

 

 

 

Resolution

Manual Method :

 

1- On Domain where SD package should be imported execute following SQL Query to find the new UUID for the Query :

 

SELECT convert(uniqueidentifier,query_uuid) FROM ca_query_def WHERE label='<query_name>'

 

Example :

SELECT convert(uniqueidentifier,query_uuid) FROM ca_query_def WHERE label='UPM-Blacklist'

 

 

 

2- Replace the UUID found in file reginfo\itemproc.dat in section [Prereq*] of procedure

 

 

 

Automatic Method :

1- Copy the attached file Export_package_query.dms on Domain Manager

 

2- Open a command prompt with Administrative privileges and execute this command :

 

START /WAIT dmscript Export_package_query.dms "<path_exported_package"

 

or if logged user has not enough rights in SQL Server

 

START /WAIT dmscript Export_package_query.dms "<path_exported_package" sqluser sqlpassword

 

 

Example :

 

START /WAIT dmscript Export_package_query.dms "C:\TEMP\CMD 4.0"

START /WAIT dmscript Export_package_query.dms "C:\TEMP\CMD 4.0" ca_itrm NOT_changedR11

 

This script generates a log under C:\Program Files (x86)\CA\DSM\logs\Export_package_query.log

Additional Information