1
0
-1

Hi,

 

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
at org.enhydra.shark.instancepersistence.data.ActivityQuery._runQuery(ActivityQuery.java:681)
at org.enhydra.shark.instancepersistence.data.ActivityQuery.runQuery(ActivityQuery.java:632)

 

 

Regards,

Touqeer

    CommentAdd your comment...

    2 answers

    1.  
      1
      0
      -1

      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".

        CommentAdd your comment...
      1.  
        1
        0
        -1

        Thanks Andrew

          CommentAdd your comment...