Question & Answer > View Question

Process Version Migrator App is throwing error

Confluence User - 12 Jul, 2017

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

process;workflow;apps

2

Confluence User •

13 Jul, 2017 •

confluenceUser •

1 •

confluenceUser •

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

Confluence User •

13 Jul, 2017 •

confluenceUser •

•

confluenceUser •

Thanks Andrew

1

CSV | Excel | XML | PDF

Your answer

Print

Process Version Migrator App is throwing error

2

RELATED QUESTIONS

Your answer

To answer a question you'll need an account.

2.builder-style-ca64b01d-9f40-40bc-9ec2-18fbf409b576{color:#008C60 !important;}

RELATED QUESTIONS

Your answer.builder-style-a93d835c-831e-4a56-b2f6-802fb97daae3{color:#008C60 !important; margin-left:10px !important;}

To answer a question you'll need an account.

2

Your answer