Error Message :
ErrorMsg: AwE-5001 Database Query Error
ava.sql.SQLException: ORA-00001: unique constraint (AWPD.SO_JOB_QUEUE_IDX) violated
Agents initially not connecting and a “java.net.ConnectException: Connection refused” error is displayed. The Applications Manager (AM) processes were stopped and restarted including both the Master and Remote Agent processes. After all the Remote Agent connections were restored all newly launched jobs remain in a "QUEUED" status.
The following error messages can be seen in the $AW_HOME/log/RmiServer log.
Root Cause: The cause of this unique constraint on jobid is still under investigation.
Release: AAMOS499000-8.0-Automic Applications Manager-OS400 Agent
The following information may be beneficial to further troubleshoot the issue. Please ensure the following table backups are kept from the time when the issue occurs.
Please contact Automic Support for assistance.