In some instances while attempting to delete some documents or update an index field users may receive following error:
Cannot delete or update a parent row

Database constraints have been changed which prevents the user from deleting or updating the rows in the database.

  1. Take a full backup of DWData.
  2. Open DWData > File Cabinet (The one you are having problems updating) > select table for FILECABINET_NAME_sect
  3. Right click on table and select “Edit Table”


-> MySQL editor will open.

  1. Select Foreign keys
  2. On Delete and On update use the drop down list and select “Cascade”
  3. 6.Apply changes

Repeat steps 2 & 3 in the MySQL editor if you are experiencing the same error in more than one file cabinet.