Failed Query errors in App Server regarding very large query

Products

• Autosys Workload Automation

Issue/Introduction

The Application Server is logging a failed query error where the query is very large. It will contain a WHERE clause that contains a lot of repeating strings similar to...

(j.job_name like :I_S_4 escape :I_S_5 and coalesce(j.job_name,:I_S_6) != :I_S_7)

Following the query in the log, a list of the bind variable values is shown and there are a lot of random words that are not job names.

The query typically times out but keeps retrying for a while. It ends up bogging down the application server until it is restarted.

Environment

Release : 12.0

Resolution

This occurs when someone inadvertantly cuts and pastes a long string into the QuickView job search field and clicks "Go". WCC parses each word in the string as a job name and sends that to AutoSys, resulting in the large query. In later WCC versions, when someone adds more than a certain amount of characters to the job search field, WCC will present a warning before proceeding.