Error Resolution - CAUAJM_E_18402 ORA-00001: unique constraint

Document ID : KB000004678
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

In the event_demon log, we are getting the following Oracle error messages:

 

[11/08/2016 12:00:00] CAUAJM_E_18416 Event Server: <ATSYS> Failed Query: <BEGIN :RetVal := ujo_batch_move_event (:I_time, :B_count); END; <<1478606400>>> 

[11/08/2016 12:00:00] CAUAJM_E_18402 ORA-00001: unique constraint (AEDBADMIN.XPKUJO_PROC_EVENT) violated 

[11/08/2016 12:00:00] ORA-06512: at "AEDBADMIN.UJO_BATCH_MOVE_EVENT", line 33 

[11/08/2016 12:00:00] ORA-06512: at line 1 

[11/08/2016 12:00:00] CAUAJM_I_18403 Processing OCI function ODEFIN(34) 

[11/08/2016 12:00:00] CAUAJM_E_18400 An error has occurred while interfacing with ORACLE. 

[11/08/2016 12:00:00] CAUAJM_E_18401 Function <doExecute> invoked from <nextRow> failed <873>

Environment:
CA Workload Automation AE r11.3.6+
Cause:

There is an existing event ID (eoid) in the ujo_proc_event table. While processing events, the database is trying to assign an event an eoid that already exists. 

Resolution:

------------------------------------------------------

1. Identify duplicate events in the ujo_proc_event table

------------------------------------------------------

SELECT p.eoid FROM ujo_proc_event p, ujo_event e WHERE e.eoid=p.eoid;

 

------------------------------------------------------

2. Identify the job id from the duplicate events in the ujo_proc_event table

------------------------------------------------------

SELECT eoid, joid FROM ujo_proc_event WHERE eoid = '<actual_eoid>';

 

------------------------------------------------------

3. Find the job name associated with the job id from the ujo_proc_event table

------------------------------------------------------

SELECT job_name FROM ujo_job WHERE joid = '<actual_joid>';

 

------------------------------------------------------

4. Remove duplicate events from the ujo_proc_event table

------------------------------------------------------

 

DELETE FROM ujo_proc_event WHERE eoid='<actual_eoid>;

 

------------------------------------------------------

5. Restart the Scheduler

 ------------------------------------------------------