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]
Component : APPLICATIONS MANAGER
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 ( } ).