In AE 12.3.9, or AE 21.0.x when a WP database session is killed in Oracle, this WP is unable to open again a new connection to the database with the errors below:
Eventually, this could even cause the user to be locked at Oracle with an error like:
20220818/150300.035 - 28 U00003590 UCUDB - DB error: '99999', 'ORA-28000: the account is locked
Release : 12.3.9 and 21.0.x
Component : AUTOMATION ENGINE
This a bug was introduced in version 12.3.9/21.0.3 of the Automation Engine.
Correction done on the product: A problem has been fixed where WPs were unable to reconnect after losing the connection to Oracle database.
Use a plaintext password for the DB user in ucsrv.ini
Update to a fix version listed below or a newer version if available.
Component(s): Automation Engine
Automation.Engine 12.3.9HF1 - Available
Automation.Engine 12.3.9HF2 - Available
Automation.Engine 21.0.4 - Available
Under special circumstances the problem can be worked around by restarting the process whose session had been killed.
But very often, the Oracle account for the AE system can get locked rapidly after a certain number of re-connection attempts or hence the PWP and the impacted WP can freeze and must be killed to be able to restart the system.
In this case the Oracle user account must be unlocked before the Engine can be restarted.
A problem has been fixed where a WP did not reconnect with the correct credentials to the database when a connection was lost.
This happened on Oracle databases if the password of the DB user is encrypted in ucsrv.ini