Client Automation - Heuristic Software missing in Query Designer

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 :

Environment

Client Automation 14.0 SP2, SP3 and 14.5

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.

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 sw_def_uuid=@I_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