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

book

Article ID: 207235

calendar_today

Updated On:

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.

Cause

Error within the SQL Form Builder

Environment

Release : 12.3

Component : AUTOMATION ENGINE

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