Join us on May 14-15, 2019 at Forrester Digital Transformation & Innovation 2019 in Chicago, USA.
I am facing following error while migrating my processes, I have changes in process workflow and did not changed the version. Following error appear on screen and in log
ERROR 12 Jul 2017 10:59:52 org.joget.workflow.model.service.WorkflowManagerImpl - org.enhydra.shark.api.internal.instancepersistence.PersistenceException: Couldn't write transaction: java.sql.SQLException: Delete failed, but Table SHKAssignmentsTable id=1658278 does exist with version=0
com.lutris.dods.builder.generator.query.DataObjectException: Couldn't write transaction: java.sql.SQLException: Delete failed, but Table SHKAssignmentsTable id=1658278 does exist with version=0
Hi Touqeer Khan
You received the error "JTA transaction unexpectedly rolled back (maybe due to a timeout);" likely due to too many processes to migrate and the processing time exceeded the database transaction timeout max limit.
You can change the beanshell code for the process migrator form to perform batch by batch. In the "Migration" form bean shell store binder, change the last argument of "workflowManager.getRunningProcessList" on line 31 to the rows number you want, example "100".