topic TaskService complete performance issue in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/taskservice-complete-performance-issue/m-p/83843#M56365 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>When we call TaskService 's complete method, its taking about 18 seconds. In our process there is a user task before end. So process ends after our call.</SPAN><BR /><BR /><SPAN>I wondering is this normal?&nbsp; </SPAN><BR /><BR /><SPAN>Thanks </SPAN><BR /><SPAN>Beslan</SPAN><BR /><BR /><SPAN>[size=85]</SPAN><BR /><SPAN>11 Jun 2012 13:33:02,448 http-apr-80-exec-8 DEBUG sql.Connection - ooo Connection Opened</SPAN><BR /><SPAN>11 Jun 2012 13:33:02,449 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_RU_EXECUTION where ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:02,449 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067042(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:02,563 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_RU_VARIABLE where EXECUTION_ID_ = ? and TASK_ID_ is null </SPAN><BR /><SPAN>11 Jun 2012 13:33:02,563 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067042(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:02,794 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_GE_BYTEARRAY where ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:02,794 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067053(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:03,298 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_HI_ACTINST HAI WHERE HAI.EXECUTION_ID_ = ? and HAI.ACT_ID_ = ? and HAI.END_TIME_ is null </SPAN><BR /><SPAN>11 Jun 2012 13:33:03,298 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067042(String), usertaskKISI(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:03,376 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_GE_BYTEARRAY where ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:03,376 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067049(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:03,844 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: insert into ACT_GE_BYTEARRAY(ID_, REV_, NAME_, BYTES_, DEPLOYMENT_ID_) values ( ?, 1, ?, ?, ? ) </SPAN><BR /><SPAN>11 Jun 2012 13:33:03,844 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067063(String), sisAtanacakAdayKullanicilar(String), java.io.ByteArrayInputStream@250970c1(ByteArrayInputStream), null</SPAN><BR /><SPAN>11 Jun 2012 13:33:03,846 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: insert into ACT_HI_DETAIL (ID_, TYPE_, PROC_INST_ID_, EXECUTION_ID_, ACT_INST_ID_, TASK_ID_, NAME_, REV_, VAR_TYPE_, TIME_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_) values ( ?, 'VariableUpdate', ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) </SPAN><BR /><SPAN>11 Jun 2012 13:33:03,847 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067064(String), 2067042(String), 2067042(String), 2067057(String), null, sisAtanacakAdayKullanicilar(String), 1(Integer), serializable(String), 2012-06-11 13:33:03.298(Timestamp), 2067063(String), null, null, null, null</SPAN><BR /><SPAN>11 Jun 2012 13:33:03,849 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: insert into ACT_GE_BYTEARRAY(ID_, REV_, NAME_, BYTES_, DEPLOYMENT_ID_) values ( ?, 1, ?, ?, ? ) </SPAN><BR /><SPAN>11 Jun 2012 13:33:03,849 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067065(String), sisAtanacakAdayGruplar(String), java.io.ByteArrayInputStream@7b119f9e(ByteArrayInputStream), null</SPAN><BR /><SPAN>11 Jun 2012 13:33:03,850 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: insert into ACT_HI_DETAIL (ID_, TYPE_, PROC_INST_ID_, EXECUTION_ID_, ACT_INST_ID_, TASK_ID_, NAME_, REV_, VAR_TYPE_, TIME_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_) values ( ?, 'VariableUpdate', ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) </SPAN><BR /><SPAN>11 Jun 2012 13:33:03,850 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067066(String), 2067042(String), 2067042(String), 2067057(String), null, sisAtanacakAdayGruplar(String), 1(Integer), serializable(String), 2012-06-11 13:33:03.843(Timestamp), 2067065(String), null, null, null, null</SPAN><BR /><SPAN>11 Jun 2012 13:33:03,852 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: update ACT_GE_BYTEARRAY set REV_ = ?, BYTES_ = ? where ID_ = ? and REV_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:03,852 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2(Integer), java.io.ByteArrayInputStream@5edc2a37(ByteArrayInputStream), 2067053(String), 1(Integer)</SPAN><BR /><SPAN>11 Jun 2012 13:33:04,243 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: update ACT_GE_BYTEARRAY set REV_ = ?, BYTES_ = ? where ID_ = ? and REV_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:04,243 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2(Integer), java.io.ByteArrayInputStream@c044ac1(ByteArrayInputStream), 2067049(String), 1(Integer)</SPAN><BR /><SPAN>11 Jun 2012 13:33:04,658 http-apr-80-exec-8 DEBUG sql.Connection - xxx Connection Closed</SPAN><BR /><SPAN>11 Jun 2012 13:33:04,658 http-apr-80-exec-8 DEBUG sql.Connection - ooo Connection Opened</SPAN><BR /><SPAN>11 Jun 2012 13:33:04,658 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_RU_TASK where ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:04,658 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067058(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:04,674 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_RE_PROCDEF where ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:04,674 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: SERBEST_DOLASIM2_TASK_KISI:4:104515(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:04,674 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_RU_TASK where PARENT_TASK_ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:04,674 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067058(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:04,674 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_RU_IDENTITYLINK where TASK_ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:04,674 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067058(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:04,689 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_RU_VARIABLE where TASK_ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:04,689 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067058(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:04,705 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_HI_TASKINST where ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:04,721 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067058(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:04,752 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_RU_EXECUTION where ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:04,752 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067042(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:04,856 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_HI_ACTINST HAI WHERE HAI.EXECUTION_ID_ = ? and HAI.ACT_ID_ = ? and HAI.END_TIME_ is null </SPAN><BR /><SPAN>11 Jun 2012 13:33:04,856 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067042(String), usertaskKISI(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:04,932 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_RU_EXECUTION where PARENT_ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:04,932 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067042(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:05,012 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_RU_VARIABLE where EXECUTION_ID_ = ? and TASK_ID_ is null </SPAN><BR /><SPAN>11 Jun 2012 13:33:05,012 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067067(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:05,327 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_RU_VARIABLE where EXECUTION_ID_ = ? and TASK_ID_ is null </SPAN><BR /><SPAN>11 Jun 2012 13:33:05,327 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067042(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:05,554 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_RE_PROCDEF where KEY_ = ? and VERSION_ = (select max(VERSION_) from ACT_RE_PROCDEF where KEY_ = ?) </SPAN><BR /><SPAN>11 Jun 2012 13:33:05,554 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: SERBEST_DOLASIM2_KARAR(String), SERBEST_DOLASIM2_KARAR(String)</SPAN><BR /><SPAN>1 Jun 2012 13:33:05,557 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_RU_VARIABLE where EXECUTION_ID_ = ? and TASK_ID_ is null </SPAN><BR /><SPAN>11 Jun 2012 13:33:05,557 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067069(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:05,623 JobAcquisitionThread DEBUG sql.Connection - ooo Connection Opened</SPAN><BR /><SPAN>11 Jun 2012 13:33:05,624 JobAcquisitionThread DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_RU_JOB where (RETRIES_ &gt; 0) and (DUEDATE_ is null or DUEDATE_ &lt; ?) and (LOCK_OWNER_ is null or LOCK_EXP_TIME_ &lt; ?) and (RETRIES_ &gt; 0) </SPAN><BR /><SPAN>11 Jun 2012 13:33:05,624 JobAcquisitionThread DEBUG sql.PreparedStatement - ==&gt; Parameters: 2012-06-11 13:33:05.623(Timestamp), 2012-06-11 13:33:05.623(Timestamp)</SPAN><BR /><SPAN>11 Jun 2012 13:33:05,625 JobAcquisitionThread DEBUG sql.Connection - xxx Connection Closed</SPAN><BR /><SPAN>11 Jun 2012 13:33:05,627 JobAcquisitionThread DEBUG sql.Connection - ooo Connection Opened</SPAN><BR /><SPAN>11 Jun 2012 13:33:05,628 JobAcquisitionThread DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_RU_JOB where (TYPE_ = 'timer') and (DUEDATE_ is not null) and (DUEDATE_ &lt; ?) and (LOCK_OWNER_ is null or LOCK_EXP_TIME_ &lt; ?) and (RETRIES_ &gt; 0) order by DUEDATE_ </SPAN><BR /><SPAN>11 Jun 2012 13:33:05,628 JobAcquisitionThread DEBUG sql.PreparedStatement - ==&gt; Parameters: 2012-06-11 13:33:10.627(Timestamp), 2012-06-11 13:33:10.627(Timestamp)</SPAN><BR /><SPAN>11 Jun 2012 13:33:05,629 JobAcquisitionThread DEBUG sql.Connection - xxx Connection Closed</SPAN><BR /><SPAN>11 Jun 2012 13:33:05,802 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_HI_ACTINST HAI WHERE HAI.EXECUTION_ID_ = ? and HAI.END_TIME_ is null </SPAN><BR /><SPAN>11 Jun 2012 13:33:05,802 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067069(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:05,895 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_GE_BYTEARRAY where ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:05,895 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067053(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:06,353 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_GE_BYTEARRAY where ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:06,353 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067049(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:06,801 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_RU_VARIABLE where EXECUTION_ID_ = ? and TASK_ID_ is null </SPAN><BR /><SPAN>11 Jun 2012 13:33:06,801 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067080(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:07,023 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_RU_VARIABLE where EXECUTION_ID_ = ? and TASK_ID_ is null </SPAN><BR /><SPAN>11 Jun 2012 13:33:07,023 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067081(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:07,289 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select distinct T.* from ACT_RU_TASK T WHERE T.EXECUTION_ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:07,289 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067080(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:07,296 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_RU_JOB J WHERE J.EXECUTION_ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:07,296 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067080(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:07,314 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select distinct T.* from ACT_RU_TASK T WHERE T.EXECUTION_ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:07,314 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067081(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:07,333 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_RU_JOB J WHERE J.EXECUTION_ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:07,333 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067081(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:07,351 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select distinct T.* from ACT_RU_TASK T WHERE T.EXECUTION_ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:07,351 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067069(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:07,371 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_RU_JOB J WHERE J.EXECUTION_ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:07,371 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067069(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:07,396 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select distinct T.* from ACT_RU_TASK T WHERE T.EXECUTION_ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:07,396 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067067(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:07,413 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_RU_JOB J WHERE J.EXECUTION_ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:07,413 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067067(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:07,421 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_HI_PROCINST where PROC_INST_ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:07,421 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067042(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:07,516 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_RU_EXECUTION where ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:07,516 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067037(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:07,627 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_RE_PROCDEF where ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:07,627 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: SERBEST_DOLASIM2_KARAR:4:104514(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:07,644 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select distinct T.* from ACT_RU_TASK T WHERE T.EXECUTION_ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:07,645 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067042(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:07,666 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_RU_JOB J WHERE J.EXECUTION_ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:07,666 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067042(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:07,675 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_HI_ACTINST HAI WHERE HAI.EXECUTION_ID_ = ? and HAI.ACT_ID_ = ? and HAI.END_TIME_ is null </SPAN><BR /><SPAN>11 Jun 2012 13:33:07,675 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067037(String), CallActivityKISI(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:07,740 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_RU_EXECUTION where ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:07,740 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067029(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:07,850 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_HI_ACTINST HAI WHERE HAI.EXECUTION_ID_ = ? and HAI.ACT_ID_ = ? and HAI.END_TIME_ is null </SPAN><BR /><SPAN>11 Jun 2012 13:33:07,850 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067029(String), CallActivityKISI(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:07,915 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_RU_VARIABLE where EXECUTION_ID_ = ? and TASK_ID_ is null </SPAN><BR /><SPAN>11 Jun 2012 13:33:07,915 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067037(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:08,136 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_RU_VARIABLE where EXECUTION_ID_ = ? and TASK_ID_ is null </SPAN><BR /><SPAN>11 Jun 2012 13:33:08,136 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067029(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:08,357 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_RU_EXECUTION where ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:08,357 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067026(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:08,467 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_RU_EXECUTION where PARENT_ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:08,467 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067029(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:08,545 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_RU_EXECUTION where PARENT_ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:08,545 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067037(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:08,629 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select distinct T.* from ACT_RU_TASK T WHERE T.EXECUTION_ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:08,629 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067037(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:08,644 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_RU_JOB J WHERE J.EXECUTION_ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:08,644 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067037(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:08,648 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_RU_EXECUTION where PARENT_ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:08,648 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067026(String)</SPAN><BR /><SPAN>1 Jun 2012 13:33:08,739 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select distinct T.* from ACT_RU_TASK T WHERE T.EXECUTION_ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:08,740 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067029(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:08,756 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_RU_JOB J WHERE J.EXECUTION_ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:08,756 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067029(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:08,757 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_RU_EXECUTION where ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:08,757 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067015(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:08,862 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_RU_EXECUTION where PARENT_ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:08,862 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067015(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:08,938 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_RU_EXECUTION where PARENT_ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:08,938 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067027(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:09,014 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_RU_VARIABLE where EXECUTION_ID_ = ? and TASK_ID_ is null </SPAN><BR /><SPAN>11 Jun 2012 13:33:09,014 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067026(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:09,244 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select distinct T.* from ACT_RU_TASK T WHERE T.EXECUTION_ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:09,244 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067026(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:09,263 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_RU_JOB J WHERE J.EXECUTION_ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:09,263 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067026(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:09,264 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_RU_VARIABLE where EXECUTION_ID_ = ? and TASK_ID_ is null </SPAN><BR /><SPAN>11 Jun 2012 13:33:09,264 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067027(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:09,505 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select distinct T.* from ACT_RU_TASK T WHERE T.EXECUTION_ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:09,505 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067027(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:09,521 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_RU_JOB J WHERE J.EXECUTION_ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:09,522 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067027(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:09,523 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_RU_VARIABLE where EXECUTION_ID_ = ? and TASK_ID_ is null </SPAN><BR /><SPAN>11 Jun 2012 13:33:09,523 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067015(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:09,753 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_HI_PROCINST where PROC_INST_ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:09,753 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067015(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:09,829 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_RU_EXECUTION where ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:09,829 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067013(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:09,934 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_RE_PROCDEF where ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:09,934 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: SERBEST_DOLASIM2:9:104517(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:09,935 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_GE_BYTEARRAY where ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:09,935 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067018(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:10,367 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_GE_BYTEARRAY where ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:10,367 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067022(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:10,630 JobAcquisitionThread DEBUG sql.Connection - ooo Connection Opened</SPAN><BR /><SPAN>11 Jun 2012 13:33:10,631 JobAcquisitionThread DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_RU_JOB where (RETRIES_ &gt; 0) and (DUEDATE_ is null or DUEDATE_ &lt; ?) and (LOCK_OWNER_ is null or LOCK_EXP_TIME_ &lt; ?) and (RETRIES_ &gt; 0) </SPAN><BR /><SPAN>11 Jun 2012 13:33:10,631 JobAcquisitionThread DEBUG sql.PreparedStatement - ==&gt; Parameters: 2012-06-11 13:33:10.63(Timestamp), 2012-06-11 13:33:10.63(Timestamp)</SPAN><BR /><SPAN>11 Jun 2012 13:33:10,632 JobAcquisitionThread DEBUG sql.Connection - xxx Connection Closed</SPAN><BR /><SPAN>11 Jun 2012 13:33:10,633 JobAcquisitionThread DEBUG sql.Connection - ooo Connection Opened</SPAN><BR /><SPAN>11 Jun 2012 13:33:10,633 JobAcquisitionThread DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_RU_JOB where (TYPE_ = 'timer') and (DUEDATE_ is not null) and (DUEDATE_ &lt; ?) and (LOCK_OWNER_ is null or LOCK_EXP_TIME_ &lt; ?) and (RETRIES_ &gt; 0) order by DUEDATE_ </SPAN><BR /><SPAN>11 Jun 2012 13:33:10,633 JobAcquisitionThread DEBUG sql.PreparedStatement - ==&gt; Parameters: 2012-06-11 13:33:15.633(Timestamp), 2012-06-11 13:33:15.633(Timestamp)</SPAN><BR /><SPAN>11 Jun 2012 13:33:10,634 JobAcquisitionThread DEBUG sql.Connection - xxx Connection Closed</SPAN><BR /><SPAN>11 Jun 2012 13:33:10,815 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select distinct T.* from ACT_RU_TASK T WHERE T.EXECUTION_ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:10,815 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067015(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:10,831 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_RU_JOB J WHERE J.EXECUTION_ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:10,831 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067015(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:10,846 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_HI_ACTINST HAI WHERE HAI.EXECUTION_ID_ = ? and HAI.ACT_ID_ = ? and HAI.END_TIME_ is null </SPAN><BR /><SPAN>11 Jun 2012 13:33:10,846 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067013(String), callactivity1(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:10,909 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_RU_EXECUTION where ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:10,909 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067001(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:11,018 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_RU_VARIABLE where EXECUTION_ID_ = ? and TASK_ID_ is null </SPAN><BR /><SPAN>11 Jun 2012 13:33:11,018 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067013(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:11,227 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_RU_EXECUTION where PARENT_ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:11,227 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067001(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:11,320 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select distinct T.* from ACT_RU_TASK T WHERE T.EXECUTION_ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:11,320 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067013(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:11,339 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_RU_JOB J WHERE J.EXECUTION_ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:11,339 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067013(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:11,340 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_RU_VARIABLE where EXECUTION_ID_ = ? and TASK_ID_ is null </SPAN><BR /><SPAN>11 Jun 2012 13:33:11,340 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067001(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:11,559 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_HI_PROCINST where PROC_INST_ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:11,559 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067001(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:11,642 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_GE_BYTEARRAY where ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:11,642 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067003(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:12,087 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_GE_BYTEARRAY where ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:12,087 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067007(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:12,531 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select distinct T.* from ACT_RU_TASK T WHERE T.EXECUTION_ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:12,531 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067001(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:12,548 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_RU_JOB J WHERE J.EXECUTION_ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:12,548 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067001(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:12,550 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: insert into ACT_HI_ACTINST ( ID_, PROC_DEF_ID_, PROC_INST_ID_, EXECUTION_ID_, ACT_ID_, ACT_NAME_, ACT_TYPE_, ASSIGNEE_, START_TIME_, END_TIME_, DURATION_ ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) </SPAN><BR /><SPAN>11 Jun 2012 13:33:12,550 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067068(String), SERBEST_DOLASIM2_TASK_KISI:4:104515(String), 2067042(String), 2067067(String), callactivity1(String), Call activity(String), callActivity(String), null, 2012-06-11 13:33:05.011(Timestamp), 2012-06-11 13:33:07.373(Timestamp), 2362(Long)</SPAN><BR /><SPAN>11 Jun 2012 13:33:12,552 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: insert into ACT_HI_PROCINST ( ID_, PROC_INST_ID_, BUSINESS_KEY_, PROC_DEF_ID_, START_TIME_, END_TIME_, DURATION_, START_USER_ID_, START_ACT_ID_, END_ACT_ID_, SUPER_PROCESS_INSTANCE_ID_ ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) </SPAN><BR /><SPAN>11 Jun 2012 13:33:12,552 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067069(String), 2067069(String), null, SERBEST_DOLASIM2_KARAR:4:104514(String), 2012-06-11 13:33:05.556(Timestamp), 2012-06-11 13:33:07.336(Timestamp), 1780(Long), icaglar(String), null, endevent1(String), 2067042(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:12,554 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: insert into ACT_HI_DETAIL (ID_, TYPE_, PROC_INST_ID_, EXECUTION_ID_, ACT_INST_ID_, TASK_ID_, NAME_, REV_, VAR_TYPE_, TIME_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_) values ( ?, 'VariableUpdate', ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) </SPAN><BR /><SPAN>11 Jun 2012 13:33:12,554 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067071(String), 2067069(String), 2067069(String), null, null, sisInbDosyaId(String), 0(Integer), long(String), 2012-06-11 13:33:05.802(Timestamp), null, null, 1305786(Long), 1305786(String), null</SPAN><BR /><SPAN>11 Jun 2012 13:33:12,555 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: insert into ACT_GE_BYTEARRAY(ID_, REV_, NAME_, BYTES_, DEPLOYMENT_ID_) values ( ?, 1, ?, ?, ? ) </SPAN><BR /><SPAN>11 Jun 2012 13:33:12,555 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067074(String), sisAtanacakAdayKullanicilar(String), java.io.ByteArrayInputStream@48ada913(ByteArrayInputStream), null</SPAN><BR /><SPAN>11 Jun 2012 13:33:12,556 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: insert into ACT_HI_DETAIL (ID_, TYPE_, PROC_INST_ID_, EXECUTION_ID_, ACT_INST_ID_, TASK_ID_, NAME_, REV_, VAR_TYPE_, TIME_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_) values ( ?, 'VariableUpdate', ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) </SPAN><BR /><SPAN>11 Jun 2012 13:33:12,556 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067075(String), 2067069(String), 2067069(String), null, null, sisAtanacakAdayKullanicilar(String), 0(Integer), serializable(String), 2012-06-11 13:33:06.351(Timestamp), 2067074(String), null, null, null, null</SPAN><BR /><SPAN>11 Jun 2012 13:33:12,558 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: insert into ACT_GE_BYTEARRAY(ID_, REV_, NAME_, BYTES_, DEPLOYMENT_ID_) values ( ?, 1, ?, ?, ? ) </SPAN><BR /><SPAN>11 Jun 2012 13:33:12,558 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067078(String), sisAtanacakAdayGruplar(String), java.io.ByteArrayInputStream@69197dd8(ByteArrayInputStream), null</SPAN><BR /><SPAN>11 Jun 2012 13:33:12,559 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: insert into ACT_HI_DETAIL (ID_, TYPE_, PROC_INST_ID_, EXECUTION_ID_, ACT_INST_ID_, TASK_ID_, NAME_, REV_, VAR_TYPE_, TIME_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_) values ( ?, 'VariableUpdate', ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) </SPAN><BR /><SPAN>11 Jun 2012 13:33:12,559 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067079(String), 2067069(String), 2067069(String), null, null, sisAtanacakAdayGruplar(String), 0(Integer), serializable(String), 2012-06-11 13:33:06.796(Timestamp), 2067078(String), null, null, null, null</SPAN><BR /><SPAN>11 Jun 2012 13:33:12,561 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: insert into ACT_HI_ACTINST ( ID_, PROC_DEF_ID_, PROC_INST_ID_, EXECUTION_ID_, ACT_ID_, ACT_NAME_, ACT_TYPE_, ASSIGNEE_, START_TIME_, END_TIME_, DURATION_ ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) </SPAN><BR /><SPAN>11 Jun 2012 13:33:12,561 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067082(String), SERBEST_DOLASIM2_KARAR:4:104514(String), 2067069(String), 2067080(String), exclusivegateway9(String), Exclusive Gateway(String), exclusiveGateway(String), null, 2012-06-11 13:33:07.022(Timestamp), 2012-06-11 13:33:07.022(Timestamp), 0(Long)</SPAN><BR /><SPAN>11 Jun 2012 13:33:12,562 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: insert into ACT_HI_ACTINST ( ID_, PROC_DEF_ID_, PROC_INST_ID_, EXECUTION_ID_, ACT_ID_, ACT_NAME_, ACT_TYPE_, ASSIGNEE_, START_TIME_, END_TIME_, DURATION_ ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) </SPAN><BR /><SPAN>11 Jun 2012 13:33:12,562 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067083(String), SERBEST_DOLASIM2_KARAR:4:104514(String), 2067069(String), 2067080(String), exclusivegateway4(String), Exclusive Gateway(String), exclusiveGateway(String), null, 2012-06-11 13:33:07.022(Timestamp), 2012-06-11 13:33:07.022(Timestamp), 0(Long)</SPAN><BR /><SPAN>11 Jun 2012 13:33:12,563 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: insert into ACT_HI_ACTINST ( ID_, PROC_DEF_ID_, PROC_INST_ID_, EXECUTION_ID_, ACT_ID_, ACT_NAME_, ACT_TYPE_, ASSIGNEE_, START_TIME_, END_TIME_, DURATION_ ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) </SPAN><BR /><SPAN>11 Jun 2012 13:33:12,563 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067084(String), SERBEST_DOLASIM2_KARAR:4:104514(String), 2067069(String), 2067081(String), exclusivegateway10(String), Exclusive Gateway(String), exclusiveGateway(String), null, 2012-06-11 13:33:07.273(Timestamp), 2012-06-11 13:33:07.273(Timestamp), 0(Long)</SPAN><BR /><SPAN>11 Jun 2012 13:33:12,565 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: insert into ACT_HI_ACTINST ( ID_, PROC_DEF_ID_, PROC_INST_ID_, EXECUTION_ID_, ACT_ID_, ACT_NAME_, ACT_TYPE_, ASSIGNEE_, START_TIME_, END_TIME_, DURATION_ ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) </SPAN><BR /><SPAN>11 Jun 2012 13:33:12,565 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067085(String), SERBEST_DOLASIM2_KARAR:4:104514(String), 2067069(String), 2067081(String), exclusivegateway3(String), Exclusive Gateway(String), exclusiveGateway(String), null, 2012-06-11 13:33:07.273(Timestamp), 2012-06-11 13:33:07.273(Timestamp), 0(Long)</SPAN><BR /><SPAN>11 Jun 2012 13:33:12,566 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: insert into ACT_HI_DETAIL (ID_, TYPE_, PROC_INST_ID_, EXECUTION_ID_, ACT_INST_ID_, TASK_ID_, NAME_, REV_, VAR_TYPE_, TIME_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_) values ( ?, 'VariableUpdate', ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) </SPAN><BR /><SPAN>11 Jun 2012 13:33:12,566 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067086(String), 2067015(String), 2067029(String), 2067030(String), null, nrOfCompletedInstances(String), 1(Integer), integer(String), 2012-06-11 13:33:08.467(Timestamp), null, null, 1(Long), 1(String), null</SPAN><BR /><SPAN>11 Jun 2012 13:33:12,567 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: insert into ACT_HI_DETAIL (ID_, TYPE_, PROC_INST_ID_, EXECUTION_ID_, ACT_INST_ID_, TASK_ID_, NAME_, REV_, VAR_TYPE_, TIME_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_) values ( ?, 'VariableUpdate', ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) </SPAN><BR /><SPAN>11 Jun 2012 13:33:12,568 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067087(String), 2067015(String), 2067029(String), 2067030(String), null, nrOfActiveInstances(String), 1(Integer), integer(String), 2012-06-11 13:33:08.467(Timestamp), null, null, 0(Long), 0(String), null</SPAN><BR /><SPAN>11 Jun 2012 13:33:12,569 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: insert into ACT_HI_ACTINST ( ID_, PROC_DEF_ID_, PROC_INST_ID_, EXECUTION_ID_, ACT_ID_, ACT_NAME_, ACT_TYPE_, ASSIGNEE_, START_TIME_, END_TIME_, DURATION_ ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) </SPAN><BR /><SPAN>11 Jun 2012 13:33:12,569 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067088(String), SERBEST_DOLASIM2_KARAR:4:104514(String), 2067015(String), 2067026(String), exclusivegateway4(String), Exclusive Gateway(String), exclusiveGateway(String), null, 2012-06-11 13:33:08.757(Timestamp), 2012-06-11 13:33:08.757(Timestamp), 0(Long)</SPAN><BR /><SPAN>11 Jun 2012 13:33:12,570 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: insert into ACT_HI_ACTINST ( ID_, PROC_DEF_ID_, PROC_INST_ID_, EXECUTION_ID_, ACT_ID_, ACT_NAME_, ACT_TYPE_, ASSIGNEE_, START_TIME_, END_TIME_, DURATION_ ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) </SPAN><BR /><SPAN>11 Jun 2012 13:33:12,570 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067089(String), SERBEST_DOLASIM2:9:104517(String), 2067001(String), 2067001(String), servicetask1(String), Dosyayı Kapat(String), serviceTask(String), null, 2012-06-11 13:33:11.34(Timestamp), 2012-06-11 13:33:11.558(Timestamp), 218(Long)</SPAN><BR /><SPAN>11 Jun 2012 13:33:12,573 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: update ACT_HI_ACTINST set EXECUTION_ID_ = ?, ASSIGNEE_ = ?, END_TIME_ = ?, DURATION_ = ? where ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:12,573 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067013(String), null, 2012-06-11 13:33:10.909(Timestamp), 225527(Long), 2067014(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:12,848 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: update ACT_HI_ACTINST set EXECUTION_ID_ = ?, ASSIGNEE_ = ?, END_TIME_ = ?, DURATION_ = ? where ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:12,848 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067029(String), null, 2012-06-11 13:33:08.648(Timestamp), 222511(Long), 2067030(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:13,127 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: update ACT_HI_ACTINST set EXECUTION_ID_ = ?, ASSIGNEE_ = ?, END_TIME_ = ?, DURATION_ = ? where ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:13,127 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067042(String), icaglar(String), 2012-06-11 13:33:04.931(Timestamp), 217964(Long), 2067057(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:13,420 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: update ACT_HI_TASKINST set EXECUTION_ID_ = ?, NAME_ = ?, PARENT_TASK_ID_ = ?, DESCRIPTION_ = ?, OWNER_ = ?, ASSIGNEE_ = ?, END_TIME_ = ?, DURATION_ = ?, DELETE_REASON_ = ?, TASK_DEF_KEY_ = ?, PRIORITY_ = ?, DUE_DATE_ = ? where ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:13,420 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067042(String), User Task KISI(String), null, null, null, icaglar(String), 2012-06-11 13:33:04.752(Timestamp), 217785(Long), completed(String), usertaskKISI(String), 50(Integer), null, 2067058(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:13,452 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: update ACT_HI_PROCINST set START_TIME_ = ?, END_TIME_ = ?, DURATION_ = ?, END_ACT_ID_ = ? where ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:13,452 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2012-06-11 13:29:25.606(Timestamp), 2012-06-11 13:33:09.829(Timestamp), 224223(Long), endevent1(String), 2067015(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:13,545 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: update ACT_HI_PROCINST set START_TIME_ = ?, END_TIME_ = ?, DURATION_ = ?, END_ACT_ID_ = ? where ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:13,545 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2012-06-11 13:29:26.651(Timestamp), 2012-06-11 13:33:07.515(Timestamp), 220864(Long), endevent1(String), 2067042(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:13,622 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: update ACT_HI_PROCINST set START_TIME_ = ?, END_TIME_ = ?, DURATION_ = ?, END_ACT_ID_ = ? where ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:13,622 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2012-06-11 13:29:25.149(Timestamp), 2012-06-11 13:33:11.642(Timestamp), 226493(Long), endevent1(String), 2067001(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:13,713 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: delete from ACT_RU_TASK where ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:13,713 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067058(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:13,723 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: delete from ACT_RU_VARIABLE where ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:13,723 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067054(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:13,937 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: delete from ACT_GE_BYTEARRAY where ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:13,938 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067053(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:14,255 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: delete from ACT_RU_VARIABLE where ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:14,256 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067050(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:14,458 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: delete from ACT_GE_BYTEARRAY where ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:14,459 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067049(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:14,790 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: delete from ACT_RU_VARIABLE where ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:14,790 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067047(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:14,994 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: delete from ACT_RU_VARIABLE where ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:14,995 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067045(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:15,198 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: delete from ACT_RU_VARIABLE where ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:15,198 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067043(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:15,399 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: delete from ACT_RU_EXECUTION where ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:15,399 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067042(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:15,512 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: delete from ACT_RU_VARIABLE where ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:15,512 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067040(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:15,662 JobAcquisitionThread DEBUG sql.Connection - ooo Connection Opened</SPAN><BR /><SPAN>11 Jun 2012 13:33:15,662 JobAcquisitionThread DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_RU_JOB where (RETRIES_ &gt; 0) and (DUEDATE_ is null or DUEDATE_ &lt; ?) and (LOCK_OWNER_ is null or LOCK_EXP_TIME_ &lt; ?) and (RETRIES_ &gt; 0) </SPAN><BR /><SPAN>11 Jun 2012 13:33:15,662 JobAcquisitionThread DEBUG sql.PreparedStatement - ==&gt; Parameters: 2012-06-11 13:33:15.662(Timestamp), 2012-06-11 13:33:15.662(Timestamp)</SPAN><BR /><SPAN>11 Jun 2012 13:33:15,662 JobAcquisitionThread DEBUG sql.Connection - xxx Connection Closed</SPAN><BR /><SPAN>11 Jun 2012 13:33:15,662 JobAcquisitionThread DEBUG sql.Connection - ooo Connection Opened</SPAN><BR /><SPAN>11 Jun 2012 13:33:15,662 JobAcquisitionThread DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: select * from ACT_RU_JOB where (TYPE_ = 'timer') and (DUEDATE_ is not null) and (DUEDATE_ &lt; ?) and (LOCK_OWNER_ is null or LOCK_EXP_TIME_ &lt; ?) and (RETRIES_ &gt; 0) order by DUEDATE_ </SPAN><BR /><SPAN>11 Jun 2012 13:33:15,662 JobAcquisitionThread DEBUG sql.PreparedStatement - ==&gt; Parameters: 2012-06-11 13:33:20.662(Timestamp), 2012-06-11 13:33:20.662(Timestamp)</SPAN><BR /><SPAN>11 Jun 2012 13:33:15,662 JobAcquisitionThread DEBUG sql.Connection - xxx Connection Closed</SPAN><BR /><SPAN>11 Jun 2012 13:33:15,724 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: delete from ACT_RU_VARIABLE where ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:15,724 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067038(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:15,918 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: delete from ACT_RU_EXECUTION where ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:15,918 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067037(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:16,043 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: delete from ACT_RU_VARIABLE where ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:16,043 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067031(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:16,253 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: delete from ACT_RU_VARIABLE where ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:16,253 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067035(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:16,459 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: delete from ACT_RU_VARIABLE where ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:16,459 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067033(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:16,663 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: delete from ACT_RU_EXECUTION where ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:16,663 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067029(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:16,773 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: delete from ACT_RU_EXECUTION where ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:16,773 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067026(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:16,902 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: delete from ACT_RU_EXECUTION where ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:16,902 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067027(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:17,058 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: delete from ACT_RU_VARIABLE where ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:17,058 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067019(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:17,305 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: delete from ACT_GE_BYTEARRAY where ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:17,305 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067018(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:17,626 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: delete from ACT_RU_VARIABLE where ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:17,627 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067023(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:17,911 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: delete from ACT_GE_BYTEARRAY where ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:17,911 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067022(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:18,329 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: delete from ACT_RU_VARIABLE where ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:18,329 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067016(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:18,528 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: delete from ACT_RU_EXECUTION where ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:18,529 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067015(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:18,639 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: delete from ACT_RU_EXECUTION where ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:18,639 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067013(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:18,758 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: delete from ACT_RU_VARIABLE where ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:18,758 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067004(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:18,963 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: delete from ACT_GE_BYTEARRAY where ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:18,963 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067003(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:19,323 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: delete from ACT_RU_VARIABLE where ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:19,323 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067008(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:19,537 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: delete from ACT_GE_BYTEARRAY where ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:19,537 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067007(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:19,851 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: delete from ACT_RU_VARIABLE where ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:19,851 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067011(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:20,050 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt;&nbsp; Executing: delete from ACT_RU_EXECUTION where ID_ = ? </SPAN><BR /><SPAN>11 Jun 2012 13:33:20,050 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==&gt; Parameters: 2067001(String)</SPAN><BR /><SPAN>11 Jun 2012 13:33:20,158 http-apr-80-exec-8 DEBUG sql.Connection - xxx Connection Closed[/size]</SPAN></BODY></HTML> Mon, 11 Jun 2012 13:18:27 GMT bcelikcan 2012-06-11T13:18:27Z TaskService complete performance issue https://connect.hyland.com/t5/alfresco-archive/taskservice-complete-performance-issue/m-p/83843#M56365 Hi,When we call TaskService 's complete method, its taking about 18 seconds. In our process there is a user task before end. So process ends after our call.I wondering is this normal?&nbsp; Thanks Beslan[size=85]11 Jun 2012 13:33:02,448 http-apr-80-exec-8 DEBUG sql.Connection - ooo Connection Opened11 Ju Mon, 11 Jun 2012 13:18:27 GMT https://connect.hyland.com/t5/alfresco-archive/taskservice-complete-performance-issue/m-p/83843#M56365 bcelikcan 2012-06-11T13:18:27Z Re: TaskService complete performance issue https://connect.hyland.com/t5/alfresco-archive/taskservice-complete-performance-issue/m-p/83844#M56366 <HTML><HEAD></HEAD><BODY><SPAN>This is a known issue in activiti 16. Please upgrade to activiti 20…</SPAN><BR /><BR /><SPAN>But seriously… Pleaee create a unit test that demonstrates this problem and provide more info. For all we know, you might do some not optimized queries on a database with 10 billion records.</SPAN><BR /><BR /><SPAN>And next time please use the use forum.</SPAN></BODY></HTML> Mon, 11 Jun 2012 22:22:52 GMT https://connect.hyland.com/t5/alfresco-archive/taskservice-complete-performance-issue/m-p/83844#M56366 ronald_van_kuij 2012-06-11T22:22:52Z Re: TaskService complete performance issue https://connect.hyland.com/t5/alfresco-archive/taskservice-complete-performance-issue/m-p/83845#M56367 <HTML><HEAD></HEAD><BODY><SPAN>Thanks for answer. Next time I'll use User forum.</SPAN></BODY></HTML> Tue, 12 Jun 2012 06:09:02 GMT https://connect.hyland.com/t5/alfresco-archive/taskservice-complete-performance-issue/m-p/83845#M56367 bcelikcan 2012-06-12T06:09:02Z Re: TaskService complete performance issue https://connect.hyland.com/t5/alfresco-archive/taskservice-complete-performance-issue/m-p/83846#M56368 <HTML><HEAD></HEAD><BODY><SPAN><span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></SPAN><BR /><BR /><SPAN>But I am very curious to what you actually do. Lot's of queries etc… Could be a performance bottleneck somewhere</SPAN></BODY></HTML> Tue, 12 Jun 2012 15:30:43 GMT https://connect.hyland.com/t5/alfresco-archive/taskservice-complete-performance-issue/m-p/83846#M56368 ronald_van_kuij 2012-06-12T15:30:43Z