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#)
:PSET &FILENAME# = GET_PROCESS_LINE(&HND#, 6)
: IF &FILENAME# = ""
: PRINT "File name => '&FILENAME#'"
: PSET &SCP# = PREP_PROCESS("AGENT_LINUX","UNIXCMD",,"CMD=cp -pr &FILENAME# /files/activity_window/message.txt",,"UC_LOGIN=LOGIN_OBJECT")
Release : 12.3
Component : AUTOMATION ENGINE
Unknown, most likely a concurrency/timing issue in the database as the issue could not be reproduced at will.
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:
On this case, a WAIT 10 was added and fixed the problem after the :ENDIF line