Problem / Solution: ERROR the delete statement conflicted with reference constraint "fkey$lc_action_value$action" in Process Designer

Version 3

    Verified Product Versions

    LANDESK Service Desk 7.7.xLANDESK Service Desk 7.8.xLANDESK Service Desk 2016.x

    Environment:

    ServiceDesk 7.x

    ServiceDesk 2016.x

     

    Error message:

    The delete statement conflicted with reference constraint "fkey$lc_action_value$action"

     

    Problem:

    When trying to delete Automatic Action that has some Action Value applied (Calculations/Placeholders etc) from the Process Designer and save changes you will get the above error message.

     

    Cause:

    The error comes from the fact that the action you try to delete (in table lc_action) is present as a reference attribute in table lc_action_value, hence the error about constraint.

     

    Solution / Workaround:

    Make sure you delete all modifications done on the Automatic Action first, save it, and then try to delete the Action itself.