Knowledge Base » Can not delete object, because instance of type SerialGroup has reference to it.

Author name: 
Product: EzData Editing Tools
Version: (release notes)

Problem: 

While deleting a node in the tree in EzData, the error message appears:

Solution: 

To solve this problem and delete a node in the tree, follow the steps below:

 1) Copy the reference of the node in the Navigation Tree.
 2) Paste the copied reference into the Notepad.
 3) In the Notepad copy the last 14-digit number specified after " / ".
 4) In MSSQL Management Studio run the query to check the node label:

         select * from NodeLocalization where Node_Ptr = 14_digit_number

     where 14_digit_number - number copied on step 3.

 5) Delete possible serial numbers tied to the node:

        delete from SerialGroup where Node_Ptr = 14_digit_number

     where 14_digit_number - number copied on step 3.

 6) Delete the node itself:

        delete from Node where Ptr = 14_digit_number

     where 14_digit_number - number copied on step 3.

 7) Right click the Navigation Tree and select Refresh from the context menu.

Modified on: 10/07/2021