AnsweredAssumed Answered

Unable to terminate suspended process

Question asked by peshi77 on Dec 9, 2015
Latest reply on Dec 14, 2015 by vasile.dirla
When trying to terminate a process instance, we get the exception below. We use Oracle 11.2.0.4 database.  Any idea what is this related to and how to overcome it?

[] Dec 08, 2015 9:57:03 AM org.activiti.engine.impl.bpmn.deployer.BpmnDeployer deploy
         [] INFO: Processing resource RunReportRequests_RecurringExecution.RunReportRequests_RecurringExecution.png
         [] Dec 08, 2015 9:57:03 AM org.activiti.engine.impl.bpmn.deployer.BpmnDeployer deploy
         [] INFO: Processing resource RunReportRequests_RecurringExecution.bpmn
         [] Dec 08, 2015 9:57:07 AM org.activiti.engine.impl.interceptor.CommandContext close
         [] SEVERE: Error while closing command context
         [] org.apache.ibatis.exceptions.PersistenceException:
         [] ### Error updating database.  Cause: java.sql.SQLException: ORA-03120: two-task conversion routine: integer overflow
         []
         [] ### The error may involve org.activiti.engine.impl.persistence.entity.HistoricActivityInstanceEntity.updateHistoricActivityInstance-Inline
         [] ### The error occurred while setting parameters
         [] ### SQL: update ACT_HI_ACTINST set       EXECUTION_ID_ = ?,       ASSIGNEE_ = ?,       END_TIME_ = ?,       DURATION_ = ?     where ID_ = ?
         [] ### Cause: java.sql.SQLException: ORA-03120: two-task conversion routine: integer overflow
         []
         []     at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23)
         []     at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:150)
         []     at org.activiti.engine.impl.db.DbSqlSession.flushUpdates(DbSqlSession.java:560)
         []     at org.activiti.engine.impl.db.DbSqlSession.flush(DbSqlSession.java:444)
         []     at org.activiti.engine.impl.interceptor.CommandContext.flushSessions(CommandContext.java:170)
         []     at org.activiti.engine.impl.interceptor.CommandContext.close(CommandContext.java:117)
         []     at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:66)
         []     at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:31)
         []     at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:40)
         []     at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:35)
         []     at org.activiti.engine.impl.RuntimeServiceImpl.deleteProcessInstance(RuntimeServiceImpl.java:88)
         []     at org.activiti.engine.impl.ant.DeleteProcessInstance.execute(DeleteProcessInstance.java:26)
         []     at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
         []     at sun.reflect.GeneratedMethodAccessor1.invoke(Unknown Source)
         []     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
         []     at java.lang.reflect.Method.invoke(Method.java:497)
         []     at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
         []     at org.apache.tools.ant.Task.perform(Task.java:348)
         []     at ise.antelope.tasks.IfTask.doIf(IfTask.java:298)
         []     at ise.antelope.tasks.IfTask.execute(IfTask.java:272)
         []     at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
         []     at sun.reflect.GeneratedMethodAccessor1.invoke(Unknown Source)
         []     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
         []     at java.lang.reflect.Method.invoke(Method.java:497)
         []     at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
         []     at org.apache.tools.ant.Task.perform(Task.java:348)
         []     at org.apache.tools.ant.taskdefs.Sequential.execute(Sequential.java:62)
         []     at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
         []     at sun.reflect.GeneratedMethodAccessor1.invoke(Unknown Source)
         []     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
         []     at java.lang.reflect.Method.invoke(Method.java:497)
         []     at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
         []     at org.apache.tools.ant.Task.perform(Task.java:348)
         []     at org.apache.tools.ant.taskdefs.MacroInstance.execute(MacroInstance.java:394)
         []     at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
         []     at sun.reflect.GeneratedMethodAccessor1.invoke(Unknown Source)
         []     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
         []     at java.lang.reflect.Method.invoke(Method.java:497)
         []     at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
         []     at org.apache.tools.ant.Task.perform(Task.java:348)
         []     at org.apache.tools.ant.taskdefs.Sequential.execute(Sequential.java:62)
         []     at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
         []     at sun.reflect.GeneratedMethodAccessor1.invoke(Unknown Source)
         []     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
         []     at java.lang.reflect.Method.invoke(Method.java:497)
         []     at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
         []     at org.apache.tools.ant.Task.perform(Task.java:348)
         []     at org.apache.tools.ant.taskdefs.MacroInstance.execute(MacroInstance.java:394)
         []     at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
         []     at sun.reflect.GeneratedMethodAccessor1.invoke(Unknown Source)
         []     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
         []     at java.lang.reflect.Method.invoke(Method.java:497)
         []     at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
         []     at org.apache.tools.ant.Task.perform(Task.java:348)
         []     at ise.antelope.tasks.Case.execute(Case.java:151)
         []     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
         []     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
         []     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
         []     at java.lang.reflect.Method.invoke(Method.java:497)
         []     at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
         []     at org.apache.tools.ant.Task.perform(Task.java:348)
         []     at ise.antelope.tasks.SwitchTask.execute(SwitchTask.java:127)
         []     at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
         []     at sun.reflect.GeneratedMethodAccessor1.invoke(Unknown Source)
         []     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
         []     at java.lang.reflect.Method.invoke(Method.java:497)
         []     at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
         []     at org.apache.tools.ant.Task.perform(Task.java:348)
         []     at ise.antelope.tasks.Repeat.repeatTasks(Repeat.java:305)
         []     at ise.antelope.tasks.Repeat.execute(Repeat.java:268)
         []     at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
         []     at sun.reflect.GeneratedMethodAccessor1.invoke(Unknown Source)
         []     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
         []     at java.lang.reflect.Method.invoke(Method.java:497)
         []     at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
         []     at org.apache.tools.ant.Task.perform(Task.java:348)
         []     at org.apache.tools.ant.Target.execute(Target.java:357)
         []     at org.apache.tools.ant.Target.performTasks(Target.java:385)
         []     at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337)
         []     at org.apache.tools.ant.Project.executeTarget(Project.java:1306)
         []     at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
         []     at org.apache.tools.ant.Project.executeTargets(Project.java:1189)
         []     at org.apache.tools.ant.Main.runBuild(Main.java:758)
         []     at org.apache.tools.ant.Main.startAnt(Main.java:217)
         []     at org.apache.tools.ant.launch.Launcher.run(Launcher.java:257)
         []     at org.apache.tools.ant.launch.Launcher.main(Launcher.java:104)
         [] Caused by: java.sql.SQLException: ORA-03120: two-task conversion routine: integer overflow
         []
         []     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
         []     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
         []     at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
         []     at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
         []     at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
         []     at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
         []     at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
         []     at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1009)
         []     at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315)
         []     at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)
         []     at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3677)
         []     at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
         []     at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:41)
         []     at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:66)
         []     at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:45)
         []     at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:100)
         []     at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:75)
         []     at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:148)
         []     … 84 more

Outcomes