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

book

Article ID: 193296

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine CA Automic One Automation CA Automic Operations Manager CA Automic Oracle

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")

 

Cause

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

Environment

Release : 12.3

Component : AUTOMATION ENGINE

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