WP ghost process left in AWI

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Occasionnaly, a Worker Process process may stop its activity at a certain time, a new Worker Process starts with a new number. The number of active is maintained according to the configuration. 
However the stopped Worker Process remains visible in AWI as an inactive "Ghost Process" in AWI visible. No technical impact on production is notified for this period.

In the log of the stopped Worker Process can be found messages similar :

=======================================================================

U00003591 UCUDB - DB error info: OPC: 'OCIStmtExecute' Return code: 'ERROR'
U00003592 UCUDB - Status: '' Native error: '60' Msg: 'ORA-00060: deadlock detected while waiting for resource'
U00000006 DEADLOCK or Connection to database lost - Rollback handling initiated. See previous messages.
U00003594 UCUDB Ret: '6' opcode: 'EXEC' SQL Stmnt: 'UPDATE OH SET OH_ModUserIdnr = ?, OH_ModDate = ?, OH_ModCnt = OH_ModCnt + 1 WHERE OH_Idnr = ?'
U00003524 UCUDB: ===> Time critical DB call! OPC: 'EXEC' time: '10:941.397.999'
U00003525 UCUDB: ===> 'UPDATE OH SET OH_ModUserIdnr = ?, OH_ModDate = ?, OH_ModCnt = OH_ModCnt + 1 WHERE OH_Idnr = ?'
U00000006 DEADLOCK or Connection to database lost - Rollback handling initiated. See previous messages.

=======================================================================

in Service Manager Log file for the same process similar can be found around the same time :

=======================================================================

U00022012 Process 'UC4T WP23/UC4 WP-Server [UC4T#WP010] - 7 Connections' (ID '337') ended.
U00022022 Process 'UC4T WP23/UC4 WP-Server [UC4T#WP010] - 7 Connections' ended, exit code='0(6)'.
U00022038 Service 'UC4T WP23' automatically starts in '60' seconds.
U00022004 Starting process 'UC4T WP23' ...

=======================================================================

 

Environment

Release : 12.3.1 Component : AUTOMATION ENGINE

Linux Systems

Cause

This is bug of the Automation Engine up to AE 12.3.4.

It is fixed with Versions 12.2.7 and 12.3.5

Resolution

A problem has been fixed where a deadlock caused a WP crash.
This problem was reproduced only with a Linux version of the Automation Engine.

Upgrade AE to either to 12.2.7 or to 12.3.5 or to a higher Service Pack of these versions.