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

book

Article ID: 87548

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine AUTOMIC WORKLOAD AUTOMATION

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.

 

Cause

Cause type:
Defect
Root Cause: Refer to description

Environment

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

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