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.