When you create a data access policy on SmartBox SmartObjects in K2 Management, where “Include this SmartBox object” is disabled, and you then switch between the options “secure by another object” and “secure by itself” an exception occurs.
The following exception occurs: “Error 547, Level 16, State 0, Procedure Smartbox.SetSecuredByObjectToNone, Line 49The DELETE statement conflicted with the SAME TABLE REFERENCE constraint
“FK_Smartbox_PolicySmartObject_Smartbox_PolicySmartObject”. The conflict occurred in database “[DB]”, table “Smartbox.PolicySmartObject”, column ‘ParentID’. Uncommittable transaction is detected at the end of the batch. The transaction is rolled back.”