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. Investigation
The following error messages can be seen in the $AW_HOME/log/RmiServer log.
08:37:06.617 Timer-3: .AxOptions: NoErrorMsgProperties=false
ErrorMsg: AwE-5001 Database Query Error (12/21/16 8:37 AM)
0 name: IN:VARCHAR2:java.lang.String:PRODCORP
1 progname: IN:VARCHAR2:java.lang.String:RMIMASTER
2 sessionId: IN:NUMERIC:java.math.BigDecimal:9750571
3 command: IN:OUT:VARCHAR2:java.lang.String:HEARTBEAT
4 cpuUsage: IN:OUT:NUMERIC:java.lang.Integer:0
java.sql.SQLException: ORA-00001: unique constraint (AWPD.SO_JOB_QUEUE_IDX) violated
We are still researching the cause of the unique constraint violation. If you should face this issue please contact Automic Support for assistance.