AnsweredAssumed Answered

Activiti engine got stuck while completing workflow stage

Question asked by prathameshj@vrhythmstech.com on Oct 6, 2016
Latest reply on Oct 7, 2016 by faizal-manan
Hi all,
I am using Activiti 5.18 with Oracle 11 g. I am having  a issue where it seems like process engine is getting stuck for infinite time while performing
taskService.complete()
operation.It hangs up while updating <b>ACT_HI_TASKINST</b> table. Hence I am unable to approve my stage. It doesn't even show any error log.
Following are my logs while generated by 
taskService.complete()
operation.


DEBUG [http-8080-6] DEBUG org.activiti.engine.impl.persistence.entity.JobEntity.insertTimer:132 -<==    Updates: 1
DEBUG [http-8080-6] DEBUG org.activiti.engine.impl.db.DbSqlSession:869 -updating: org.activiti.engine.impl.persistence.entity.HistoricTaskInstanceEntity@63b6a56e
DEBUG [http-8080-6] DEBUG org.activiti.engine.impl.persistence.entity.HistoricTaskInstanceEntity.updateHistoricTaskInstance:132 -ooo Using Connection [Transaction-aware proxy for target Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@3589c3ef]]
DEBUG [http-8080-6] DEBUG org.activiti.engine.impl.persistence.entity.HistoricTaskInstanceEntity.updateHistoricTaskInstance:132 -==>  Preparing: update ACT_HI_TASKINST set EXECUTION_ID_ = ?, NAME_ = ?, PARENT_TASK_ID_ = ?, DESCRIPTION_ = ?, OWNER_ = ?, ASSIGNEE_ = ?, CLAIM_TIME_ = ?, END_TIME_ = ?, DURATION_ = ?, DELETE_REASON_ = ?, TASK_DEF_KEY_ = ?, FORM_KEY_ = ?, PRIORITY_ = ?, DUE_DATE_ = ?, CATEGORY_ = ? where ID_ = ?
DEBUG [http-8080-6] DEBUG org.activiti.engine.impl.persistence.entity.HistoricTaskInstanceEntity.updateHistoricTaskInstance:132 -==> Parameters: 502507(String), Pending Risk(String), null, null, null, pankaj(String), 2016-10-06 17:07:55.404(Timestamp), 2016-10-06 19:12:50.978(Timestamp), 7511456(Long), completed(String), PendingRisk(String), null, 50(Integer), null, null, 502510(String)



Any help will be appreciated.
Thanks.

Outcomes