CAUAJM_E_18402 ORA-00001: unique constraint (AEDBADMIN.XPKUJO_WAIT_QUE) violated
search cancel

CAUAJM_E_18402 ORA-00001: unique constraint (AEDBADMIN.XPKUJO_WAIT_QUE) violated


Article ID: 145958


Updated On:


CA Workload Automation AE - Scheduler (AutoSys) CA Workload Automation AE


We are see the following Database error  and need to know how we can fix or remove it:

[02/26/2020 07:59:46.5877] CAUAJM_E_18416 Event Server: <WAAEPPDP>  Failed Query: <INSERT INTO ujo_wait_que(joid, wf_joid, job_load, max_load, priority, que_name, stamp) VALUES (191632,1,1,30,2596,'V_12345-loadbalancer.12345-edge01',1582721916)>

[02/26/2020 07:59:46.5883] CAUAJM_E_18402 ORA-00001: unique constraint (AEDBADMIN.XPKUJO_WAIT_QUE) violated

[02/26/2020 07:59:46.5888] CAUAJM_E_18400 An error has occurred while interfacing with ORACLE.

[02/26/2020 07:59:46.5890] CAUAJM_E_18401 Function <doExecute> invoked from <execute> failed <880>


Release : 11.3.6

Component : CA Workload Automation AE (AutoSys)


The latest AutoSys version 11.3.6 sp8 has the latest fixes referencing AEDBADMIN.XPKUJO_WAIT_QUE.
See specifically:
Problem Number: 4757

In the immediate, find out what job has a joid equal to that in the error message.
example: select job_name from aedbadmin.ujo_jobst where joid=191632
See what status it is in (autorep -d -J ) and/or if there has been any manual activity involving it.
You can try adjusting the job's priority to 0 via sendevent so it would be released and run immediately.
See if that then removes it from the ujo_wait_que.
example: sendevent -E CHANGE_PRIORITY -q 0 -J job123
The above is assuming you can/want it to run immediately.