AWA - Recurring locking on RT table during periods of high activity

Document ID : KB000121640
Last Modified Date : 28/11/2018
Show Technical Document Details
Issue:
The Database is able to do 2 INSERTs and 2 SELECTs, but on the last INSERT, it stops and does not give a return code like:

INSERT INTO RT(RT_AH_Idnr, RT_Type, RT_Lnr, RT_TimeStamp, RT_MsgNr, RT_MsgInsert) VALUES (?, ?, ?, ?, ?, ?)

 
Cause:
This is a bug in the Automation Engine. 
Resolution:
Lower the number of WPs to 5, so that there isn't contention between two 'W' type WPs. 

This issue has been fixed in the following versions:

Automation Engine 12.2.1 (available for download)
Automation Engine 12.1.4 - planned release for January 28. 2019