Page 1 of 1

Workflow engine and sql server

PostPosted:Wed May 05, 2021 10:54 am
by MohamadAli
Hi,

Since we migrated from mysql to sql server, workflow engine is acting strangely: I always get the 015006 error code (hibernate commit failed) after a task is done, my queries in workflow are executed twice, and now I cannot access workflow details from admin page and the service (tomcat) is not restarting (I am restarting my whole server).

When I launch a workflow for testing (one task node and one node), the workflow tab in dashboard breaks, I see no tasks, and I cannot change or access any workflow from administration

are there issues working with sql server or is something wrong with my migration?
I dont know where to start debugging.

Re: Workflow engine and sql server

PostPosted:Sat May 08, 2021 5:44 pm
by jllort
Problem may be the manner how data is keep stored in the database of the workflow engine ( if you take a look into will observe data serializen into columns ). I suggest stop all the current workflow ( take note of the process started ), drop all jbpm tables ( with openkm stopped ) and then start openkm in update mode ( Edit OpenKM.cfg and set hibernate.hbm2ddl to update ) to create missing tables. In this manner you will have clean workflow engine tables.

Before doing this action I suggest have a entire backup ( repository and database ) to prevent data lost.