Vistas:

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.

  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.

Este artículo es válido para las versiones de DocuWare: 6.5 6.6 6.7 6.8 6.9 6.10 | cannot delete delete cannot delete or update parent row foreign key Cannot delete or update a parent row #FAQID_4532