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

Document ID : KB000121640
Last Modified Date : 28/11/2018
Show Technical Document Details
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 (?, ?, ?, ?, ?, ?)

This is a bug in the Automation Engine. 
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