Scenario:
After upgrading to DocuWare version 7.8 and attempting to delete a document from a File Cabinet or Document Tray, the following error is displayed:
"The INSERT permission was denied on the object 'DWTB_jG6UD1wKNkmDkIX6V8FSaA'"
After upgrading to DocuWare version 7.8 and attempting to delete a document from a File Cabinet or Document Tray, the following error is displayed:
"The INSERT permission was denied on the object 'DWTB_jG6UD1wKNkmDkIX6V8FSaA'"
Solution:
Commencing in DocuWare 7.8, the Trash Bin function was introduced to recover recently deleted documents. During the upgrade to DocuWare 7.8, the system may have chosen the incorrect database connection to use with the Trash Bin.
Commencing in DocuWare 7.8, the Trash Bin function was introduced to recover recently deleted documents. During the upgrade to DocuWare 7.8, the system may have chosen the incorrect database connection to use with the Trash Bin.
The connection is chosen following this algorithm:
- If there is a database connection assigned to the currently updated organization which has enabled both "used for index entries" as well as "used for document trays", it will use this one.
- Otherwise, if there is a database connection assigned to the currently updated organization which has enabled "used for index entries", it will use this one.
- Otherwise, if there is a database connection assigned to the currently updated organization which has enabled "used for document trays", it will use this one.
- Otherwise, the upgrader will fail.
To resolve this behavior, the database connection used by the Trash Bin must be manually altered. Further information can be found in the following article: KBA-37258 - How to change the trashbin database connection
KBA is applicable to On-premise Organizations ONLY.