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

Document ID : KB000087548
Last Modified Date : 14/04/2018
Show Technical Document Details
Error Message :

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 type:
Root Cause: Refer to description
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

• Intialdata
• UserInterface Java
Additional Information:
Workaround :