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

Article Id: 144862

Status: Published

Updated On: 11-02-2020 09:50

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.