Symptoms

Post deployment we are getting the below mentioned error, while deploying form 'form_name' Fail form_name Error 2601, Level 14, State 1, Procedure aDeploy, Line 888Cannot insert duplicate key row in object 'Form.EventInstance_Design' with unique index 'UX_Form_EventInstance_Design_ContextID_EventID_StateID_InstanceID_SubFormID'. The duplicate key value is (xxx-xxx-xxxx-xxx). System.Data.SqlClient.SqlException
 

Diagnoses

This issue is usually related to a duplicate record created for the target form in the Database. The package cannot deploy a duplicate value if it's a Primary Key.
 

Resolution

We deleted target Form and views associated with the form. Redeployed the package to target environment to resolve the issue.