ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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

book

Article ID: 145958

calendar_today

Updated On:

Products

CA Workload Automation AE - Business Agents (AutoSys) CA Workload Automation AE - System Agent (AutoSys) CA Workload Automation AE - Scheduler (AutoSys) Workload Automation Agent CA Workload Automation AE

Issue/Introduction

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_42124-edw-p1-edg-loadbalancer.42124-edw-edg-dcmipvmedg001',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>

Environment

Release : 11.3.6

Component : CA Workload Automation AE (AutoSys)

Resolution

The latest AutoSys version 11.3.6 sp8 has the latest fixes referencing AEDBADMIN.XPKUJO_WAIT_QUE.
https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/intelligent-automation/workload-automation-ae-and-workload-control-center/11-3-6-SP8/release-notes/ae-release-notes/ae-release-11-3-6-sp8/fixed-issues-11-3-6-sp8.html
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.