Cannot find CONN.SQL objects used in JOBS.SQL objects.

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Error Message :
N/A

The "Search for use" function on a connection object does not work correctly.  When this function is applied to an object of the type CONN.SQL, which is set as the connection object of a JOBS.SQL object, the job object is not found.  As a consequence, the “Replace” function doesn’t work correctly for CONN.SQL objects.

This can easily be reproduced by following these steps:
    1. Create a SQL CONN object, create an SQL job that uses that SQL CONN object. 
    2. Use the "Search for use" function for that SQL CONN object and it will not be found and displayed.

The "Search for use" function should show the results of the SQL jobs which use the SQL CONN object.  This has been fixed and released in the versions listed below.
 

Environment

Release: AUTWAB99000-11.0-Automic Workload Automation-Base Edition
Component:

Cause

Cause type:
Defect
Root Cause: Refer to description

Resolution

This field was added on 30/03/2017. This article has not been updated yet. Refer to the "Description" or "Workaround" sections for solution information.

Fix Status: Released

Fix Version(s):
Automation Engine 11.2.1
Automation Engine 11.1.3
Automation Engine 10.0.7

Components:
• Intialdata
• UserInterface Java

Additional Information

Workaround :
N/A