Error Message :
U00003590 UCUDB - DB error: '23000', 'ORA-00001: Unique Constraint (UC4.PK_OH) violated', '1', 'java.sql.SQLIntegrityConstraintViolationException'
or similar for other Databases
After the system name has been changed, i.e. for an update installation, the JWP stops processing right after startup. From an OS perspective the process stays idle. The last lines within the log file show a database error message regarding primary key violation. Example for Oracle (similar message on other DB):
20170922/152502.690 - JWP/JCP registered as WO121 VWGSUP12 192.168.0.49
20170922/152502.700 - U00003488 Server 'JWP VWGSUP12 192.168.0.49 ' was started as instance '9'.
20170922/152502.750 - U00003490 Connection to '192.168.0.49:14270' initiated, client connection '1'
20170922/152502.954 - U00003489 Server 'WO121#WP001' logged on (Client connection='1').
20170922/152502.956 - U00003490 Connection to '192.168.0.49:14217' initiated, client connection '2'
20170922/152502.964 - U00003490 Connection to '192.168.0.49:14219' initiated, client connection '3'
20170922/152502.974 - U00003489 Server 'WO121#CP001' logged on (Client connection='2').
20170922/152502.979 - U00003489 Server 'WO121#CP003' logged on (Client connection='3').
20170922/152502.980 - U00003491 There is a time difference of '0/00:00:00' or '0' seconds to the Primary Server.
20170922/152502.987 - U00003475 Server 'WO121#WP001' is the primary server of the system 'WO121'.
20170922/152503.315 - U00003590 UCUDB - DB error: '23000', 'ORA-00001: Unique Constraint (UC4.PK_OH) verletzt
', '1', 'java.sql.SQLIntegrityConstraintViolationException'
As a primary key violation can have many different root causes a trace (database=2, tcp=4) needs to be created for verification:
<Please see attached file for image>
Root Cause: The issue was caused in the ID cache management for OH_IDNRs.
Release: AUTWAB99000-12.0-Automic Workload Automation-Base Edition
Update to a fix version listed below or a newer version if available.
Fix Status: Released
Component(s): Automation.Engine & Initialdata
Automation Engine 12.1.1 - Available
Restart the JWP. It might be necessary to restart multiple times until the JWP passes the erroneous part of the initialization.