ERROR: duplicate key value violates unique constraint "pk

Products

CA Automic One Automation

Issue/Introduction

This kind of message sequence can appear in WP logs pointing on constraint violation error.

20230620/111809.965 - U00011006 Job 'LIST_Haricots_MAILS' (RunID '0001004006' / Workflow-RunID: '0001004005') on Host 'WIN01' ended normally. Remote ID=19044 
20230620/111809.986 - U00003590 UCUDB - DB error: 'ERROR:  duplicate key value violates unique constraint "pk_ev" DETAIL:  Key (ev_ah_idnr, ev_vname)=(1004006, &START#) already exists.', '', '', ''
20230620/111809.986 - U00003594 UCUDB Ret: '6' opcode: 'INSR' SQL Stmnt: 'INSERT INTO EV (EV_AH_Idnr, EV_VName, EV_Source, EV_SortOrder, EV_ERTUsage) VALUES (?, ?, ?, ?, ?)'
20230620/111809.988 - U00011801 Error in Server routine 'UCGENX_R', Server: 'AUTOMIC#WP005' AE system: 'AUTOMIC'.
20230620/111809.989 - U00000006 DEADLOCK or Connection to database lost - Rollback handling initiated. See previous messages.
20230620/111810.008 - U00003590 UCUDB - DB error: 'ERROR:  duplicate key value violates unique constraint "pk_ev" DETAIL:  Key (ev_ah_idnr, ev_vname)=(1004006, &START#) already exists.', '', '', ''
20230620/111810.631 - U00015006 System forced memory trace dump.
20230620/111810.632 - U00015006 System forced memory trace dump.
20230620/111810.632 - U00003631 Dump caused by: 

and

20230620/112525.719 - U00011006 Job 'LIST_Haricots_MAILS' (RunID '0001004016' / Workflow-RunID: '0001004015') on Host 'WIN01' ended normally. Remote ID=23308 
20230620/112525.741 - U00003590 UCUDB - DB error: 'ERROR:  duplicate key value violates unique constraint "pk_ev" DETAIL:  Key (ev_ah_idnr, ev_vname)=(1004016, &START#) already exists.', '', '', ''
20230620/112525.741 - U00003594 UCUDB Ret: '6' opcode: 'INSR' SQL Stmnt: 'INSERT INTO EV (EV_AH_Idnr, EV_VName, EV_Source, EV_SortOrder, EV_ERTUsage) VALUES (?, ?, ?, ?, ?)'
20230620/112525.743 - U00011801 Error in Server routine 'UCGENX_R', Server: 'AUTOMIC#WP005' AE system: 'AUTOMIC'.
20230620/112525.744 - U00000006 DEADLOCK or Connection to database lost - Rollback handling initiated. See previous messages.
20230620/112525.765 - U00003590 UCUDB - DB error: 'ERROR:  duplicate key value violates unique constraint "pk_ev" DETAIL:  Key (ev_ah_idnr, ev_vname)=(1004016, &START#) already exists.', '', '', ''
20230620/112526.485 - U00015006 System forced memory trace dump.
20230620/112526.485 - U00015006 System forced memory trace dump.

No impact on the production only a significant flooding and throwing of forced traces.

Environment

Affected components: Automation Engine 21.0.5 on PostgreSQL Database

Cause

This is defect the Automation Engine that can show up in AE on PostgreSQL when executing a job with post conditions.

Resolution

Resolution;

A problem has been fixed where writing a new value to a variable or a new record to an activation report could cause "duplicate key value violates unique constraint" error in PostgreSQL database.

This bug will is fixed in version 21.0.8 of the One Automation Engine, which will be available shortly.

Additional Information

Bug ID: AE-32768
Bug Title: ERROR: duplicate key value violates unique constraint "pk_ev" (10232) in PostgreSQL-Log