Symptoms

SQL Error when deleting a view
 

Diagnoses

I get the following error when I attempt to delete a view:
Error 547, Level 16, State 0, Procedure mDeleteContexts, Line 234The DELETE statement conflicted with the REFERENCE constraint "FK_Form_ActionInstance_ActionItem". The conflict occurred in database "K2", table "Form.ActionInstance", column 'ActionID'.
 

Resolution

The issue is orphaned items and the validation that validates referenced items hence the stored proc erroring out when run. Labs provided a coldfix that when implemented alleviated the issue.