Missing closed bracket on Process Flow prompt results in a Launch Error and PF is stuck in QUEUED status.

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

If a Process Flow header prompt contains a Subvar but incorrectly does not contain a closed bracket (i.e. "{#subvar"  ), the Process Flow immediately throws a Job Launch Error and goes into a QUEUED status.

Once in QUEUED status, no action can be taken on the Process Flow such as Hold, Reset, Delete, etc, and the only way to remove it from the Backlog is using sql.

Below is the error thrown:

ErrorMsg: AwE-5117 Job launch error
Details: String index out of range: 9
[333, Q, SORT_COL1, N, 259, SUBVAR_BUG, 00:00:00, SQLOPER, null, SO_CHAIN_ORDER,
 SO_RESTART, EXPRESS, SUBVAR_BUG, SO_CHAIN_SEQ, 259, QUEUED, JOB_STARTED, null, 
null, 2020-07-23 18:59:00.0, 2020-07-23 18:59:57.0, @, 1, APPWORX_AGENTS, SO_USE
R_SEQ, N, 33, 000, Y, N, 300, SO_PRINTER_TYPE, SO_REF1, null, null, APPLICATIONS
_MANAGER, null, SO_REF2, SO_REF3, SO_REF4, SO_REF5, SO_REF6, SO_REF7, SO_REF8, S
O_REF9, Subvar Bug, null, null, 50, null, N, INTERNAL_USE, SO_CHILD_COUNT, @, nu
ll, 2020-07-23 18:59:00.0, SO_PREDECESSOR_JOBIDS, 1, SO_MAX_RUN_TIME, SO_MIN_RUN
_TIME, null, null, N, null, null, SO_COMMAND_TYPE, null, EXTERNAL_REFS, null]

Environment

Component : APPLICATIONS MANAGER

Resolution

Currently being investigated for a permanent fix.

Workaround:

1. Delete the Process Flow from the database end with the following sql:

SQL> delete from so_job_queue where so_jobid='<jobid>';
SQL> commit;

2. Correct the prompt and add the required closed bracket ( } ).