SQL JOBS error on edit with 'An unexpected error occurred. Further details are available in the logfiles'

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

After upgrading to 12.3, when attempting to view SQL JOBS within the Automic Web Interface, the process tab displays:

'An unexpected error occurred. Further details are available in the logfiles'

This only happens with SQL JOBS utilizing JCL_CONCAT_CHAR.

Environment

Release : 12.3

Component : AUTOMATION ENGINE

Cause

Error within the SQL Form Builder

Resolution

This will be resolved in a future release of the AWI.

Workaround: 

Edit the affected jobs and remove any spacing between JCL_CONCAT_CHAR statements. Such as:

:JCL_CONCAT_CHAR "*"

:JCL_CONCAT_CHAR

To:

:JCL_CONCAT_CHAR "*"
:JCL_CONCAT_CHAR