CDA: Receiving Primary Key constraint errors when running a deployment workflow

Products

• CA Continuous Delivery Automation - Automation Engine

Issue/Introduction

When running a workflow, the DBA may see errors similar to the below:

Violation of PRIMARY KEY constraint 'PK_EV'. Cannot insert duplicate key in object 'dbo.EV'. The duplicate key value is (2149709,
Violation of PRIMARY KEY constraint 'PK_EV'. Cannot insert duplicate key in object 'dbo.EV'. The duplicate key value is (2166114,
Violation of PRIMARY KEY constraint 'PK_EV'. Cannot insert duplicate key in object 'dbo.EV'. The duplicate key value is (2160999,

 

Cause

As designed; this is a timing component that confirms that the values are entered.

Environment

Release : 12.2, 12.3

Component : AUTOMATION ENGINE

Resolution

This is confirmed to have no impact and is functioning as designed.