Issue Description

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.

Error Message

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.”

Resolution

  1. Ensure you have K2 Five (5.2) installed.
  2. Download the K2 Five (5.2) FP2 from K2 Partner and Customer Portal.
  3. Install the K2 Five (5.2) FP2 to apply the fix.
  4. It is recommended to refresh the browser cache.