AWA: Jobs failing iwith UC4 FAULT_POST_PROCESSING - error in post processing after V12.3 upgrade

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

After upgrading AE from 12.0 to 12.3 some Jobs are randomly getting "FAULT_POST_PROCESSING - error in post processing"

The Job runs every hour and Ends Ok 2 or 3 times and then fails 2 or 3 times with this error:
U00010038 Runtime error: Could not create data sequence 'FILETRANSFER'. Status: '0000001820', return code: '0000000000'.

The Post Process script looks like this:

:PSET &SOURCE_RUN# = &$RUNID#
:PSET &RUNID# = GET_STATISTIC_DETAIL(,RUNID,LOGIN_OBJECT)
:PSET &HND# = PREP_PROCESS_REPORTLIST(&RUNID#)
:PROCESS &HND#
:PSET &FILENAME# = GET_PROCESS_LINE(&HND#, 6)
: IF  &FILENAME# = ""
: ELSE
: PRINT  "File name  => '&FILENAME#'"

: ENDIF
:ENDPROCESS

: PSET &SCP# = PREP_PROCESS("AGENT_LINUX","UNIXCMD",,"CMD=cp -pr &FILENAME# /files/activity_window/message.txt",,"UC_LOGIN=LOGIN_OBJECT")

 

Environment

Release : 12.3

Component : AUTOMATION ENGINE

Cause

Unknown, most likely a concurrency/timing issue in the database as the issue could not be reproduced at will.

Resolution

In order to avoid timing issues that could provoke the POST Processing Script to fail, add a WAIT in the POST Processing script inside the Loop of the Script (PROCESS) so that a Database Commit is forced:
https://docs.automic.com/documentation/webhelp/english/AA/12.3/DOCU/12.3/Automic%20Automation%20Guides/help.htm#Script/Writing/Script_Processing_Order.htm%3FTocPath%3DUsing%7CDesigning%7CFunctional%2520Logic%2520with%2520Scripts%7C_____1

On this case, a WAIT 10 was added and fixed the problem after the :ENDIF line