Views:

Behavior:
After upgrading to DocuWare version 7 or higher, you are receiving Deadlock errors in the Web Client such as:

Transaction (Process ID 154) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

Along with the error message it, there are also many Fulltext tasks in the DWTasks table located in the DWSystem database. Some of these tasks have a "TRYCOUNT" number greater than 3.

Solution:
This occurs when Fulltext starts some indexing processes after the upgrade, and fails upon executing some of the tasks.

***Please create a backup of the DWSystem database before proceeding.***

These are considered "stuck" tasks and should be removed from the database. Once these have been removed, you will no longer receive these errors.

Example queries:
MYSQL: delete from dwsystem.dwtasks where ID = '46C8AE56-3D36-20FF-2CBB-39F7C3710E17'

MSSQL: delete from [dwsystem].[dbo].[DWTasks] where ID = '46C8AE56-3D36-20FF-2CBB-39F7C3710E17'

Note: These are example queries that can remove these stuck task based on example depicted above, please replace the = values in accordance to the values displayed in your database.

Comments (0)