Client Automation - Heuristic Software missing in Query Designer

book

Article ID: 145392

calendar_today

Updated On:

Products

CA Client Automation - Asset Management CA Client Automation - IT Client Manager CA Client Automation CA Client Automation - Software Delivery CA Client Automation - Remote Control

Issue/Introduction

In Query Designer under Software - Discovered Software, some heuristic software are missing.


Example :
Orca release does not appear in Query Designer :




Cause

When a SD Package is created from a MSI package, a heuristic release is created for the MSI package. But associated product is not created.
In table ca_software_def only row for heuristic release is created.

Query Designer displays the products at first level.
As product does not exist for registered MSI package, heuristic release does not appear.

Environment

Client Automation 14.0 SP2, SP3 and 14.5

Resolution

Open a CA Broadcom case requesting the fix
 
T5IZ416 for 14.0 SP2
T5IZ454 for 14.5
 
 
Install this fix on machines with ITCM Console installed (Domain and Enterprise included)
 
With this fix when a SD package is registered from a MSI file, heuristic product and release are created in table ca_software_def
 
To add missing product In table ca_software_def execute following SQL Query on mdb database :
 
SET NOCOUNT ON
DECLARE @I_sw_def_uuid BINARY(16), @I_sw_def_uuid2 BINARY(16)

DECLARE curs1 CURSOR FOR
SELECT sw_def_uuid FROM ca_software_def WHERE source_type_id=3 and software_type_id=3 and sw_def_uuid not in (SELECT secondary_sw_def_uuid FROM ca_link_sw_def)

OPEN curs1 FETCH NEXT FROM curs1 INTO @I_sw_def_uuid

WHILE @@FETCH_STATUS=0
BEGIN
   SELECT @I_sw_def_uuid2=NEWID()
   INSERT INTO ca_software_def
   SELECT @I_sw_def_uuid2, name, sw_version_label, language, creation_user, DATEDIFF(s, '1970-01-01', GETUTCDATE()), last_update_date, DATEDIFF(s, '1970-01-01', GETUTCDATE()),
   version_number, sw_version_number, replication_flag,8, source_type_id, description, NULL, manufacturer_uuid, bit_support_id, chip_set_id, domain_uuid, impact, severity,
   is_active, no_longer_available, family_sw_def_uuid, lang_code, class_id, linear_sequence_number, filter_from_view, drcs_content_type_id, requires_review, unsealed
   FROM ca_software_def WHERE [email protected]_sw_def_uuid

   INSERT INTO ca_link_sw_def VALUES (DATEDIFF(s, '1970-01-01', GETUTCDATE()), 0, @I_sw_def_uuid, @I_sw_def_uuid2, 3, 3, NULL)

   FETCH NEXT FROM curs1 INTO @I_sw_def_uuid
END

CLOSE curs1
DEALLOCATE curs1

Attachments