Problem:
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”
Solution:
Database constraints have been changed which prevents the user from deleting or updating the rows in the database.
- Take a full backup of DWData.
- Open DWData > File Cabinet (The one you are having problems updating) > select table for FILECABINET_NAME_sect
- Right click on table and select “Edit Table”
-> MySQL editor will open.
- Select Foreign keys
- On Delete and On update use the drop down list and select “Cascade”
- 6.Apply changes
Repeat steps 2 & 3 in the MySQL editor if you are experiencing the same error in more than one file cabinet.