Symptoms

Cannot deploy package to Production Server, no problem when deploying to UAT server.

Error:
Error 2601: Level 14, State 1, Procedure aDeploy, Line 888 Cannot insert duplicate key row in object ' Form.EventInstance_Design' with unique index 'UX_Form_EventInstance_Design_ContextID_EventID_StateID_InstanceID_SubFormID"
 

Diagnoses

N/A
 

Resolution

Resolution:
Remove the impacted Form, View and SmartObject from the impacted server and the package can be deployed.