<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<body link="#355491" alink="#4262a1" vlink="#355491" style="background: #e2e2e2; margin: 0; padding: 20px;">
<div>
<table cellpadding="0" bgcolor="#FFFFFF" border="0" cellspacing="0" style="border: 1px solid #dadada; margin-bottom: 30px; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="border: solid 2px #ccc; background: #dadada; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td bgcolor="#000000" valign="middle" height="58px" style="border-bottom: 1px solid #ccc; padding: 20px; -moz-border-radius-topleft: 3px; -moz-border-radius-topright: 3px; -webkit-border-top-right-radius: 5px; -webkit-border-top-left-radius: 5px;">
<h1 style="color: #333333; font: bold 22px Arial, Helvetica, sans-serif; margin: 0; display: block !important;">
<!-- To have a header image/logo replace the name below with your img tag -->
<!-- Email clients will render the images when the message is read so any image -->
<!-- must be made available on a public server, so that all recipients can load the image. -->
<a href="http://community.jboss.org/index.jspa" style="text-decoration: none; color: #E1E1E1">JBoss Community</a></h1>
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" style="font: normal 12px Arial, Helvetica, sans-serif; color:#333333; padding: 20px; -moz-border-radius-bottomleft: 4px; -moz-border-radius-bottomright: 4px; -webkit-border-bottom-right-radius: 5px; -webkit-border-bottom-left-radius: 5px;"><h3 style="margin: 10px 0 5px; font-size: 17px; font-weight: normal;">
Problem While deleting the Deployed Process Definitation
</h3>
<span style="margin-bottom: 10px;">
created by <a href="http://community.jboss.org/people/sreeni.karnati">sreeni Karnati</a> in <i>jBPM Development</i> - <a href="http://community.jboss.org/docs/DOC-15927">View the full document</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p><br/>Hi i am new to JBPM..Could any one help me in resolving this issue. To set up the JBPM i folloed the instruction from the User's guide. Then i configurd the jbpm4.4/install/ biuld.xml I chanaged database name from hsqldb to mysql.Also changed the mysql.propertie. <br/>After setting up the environment i imported the examples..then i define a sample processDefinitation as show in the document. Then i deployed the process definitation and process instance. Finaly i got a problem while deleting the deployed porcess definitation.</p><p><br/>=== Environment ==============================<br/>- jBPM Version : jbpm-4.4<br/>- Database : MySql:5.5.0<br/>- JDK : jdk1.6.0_21<br/>- Container : jboss-4.2.3.GA<br/>- Configuration : yes jbpm.cfg.xml  using imports from the jbpm.jar</p><p>- Libraries : yes i am  using the exact versions of the libs from inside the jbpm<br/>   distribution of the version that you're using</p><p>=== Process ==================================<br/><?xml version="1.0" encoding="UTF-8"?></p><p><process name="sampleprocess" key="sp" xmlns="<a class="jive-link-external-small" href="http://jbpm.org/4.4/jpdl">http://jbpm.org/4.4/jpdl</a>"></p><p>   <start g="16,18,48,48"><br/>    <transition to="a" /><br/>  </start></p><p>  <state name="a" g="96,16,75,52"><br/>    <transition to="b" /><br/>  </state></p><p>  <state name="b" g="203,16,73,52"><br/>    <br/>  </state><br/></process></p><p>=== API ===================================<br/>I am completely new to this environment. This is my first applictaion.</p><p>public class SampleProcessTest {</p><p> protected static ProcessEngine processEngine;<br/> protected static  RepositoryService repositoryService;<br/> protected static  ExecutionService executionService;<br/> protected static  ManagementService managementService;<br/> protected static  TaskService taskService;<br/> protected static  HistoryService historyService;<br/> protected static IdentityService identityService;<br/> <br/> private static String deploymentId;<br/> <br/> public static void main(String[] args) {<br/>  <br/>  buildConfiguration();--> Working fine<br/>    <br/>  deployProcessDefinitation();--> Working fine<br/>  <br/>  tranceProcessInstance();--> Working fine<br/>  <br/>  deleteProcessDefinitation();--> Exception:could not delete: [org.jbpm.pvm.internal.model.ExecutionImpl#50007]<br/>  <br/> }<br/> private static void deleteProcessDefinitation() {<br/>  <br/>    <br/>  <br/>  if(deploymentId!=null){<br/>   <br/>   repositoryService.deleteDeploymentCascade(deploymentId);<br/>  }<br/>  <br/>  <br/>  System.out.print("Process Definitation with id "+deploymentId+" has been removed");<br/> }<br/> <br/> private static void tranceProcessInstance() {<br/>  <br/>  ProcessInstance processInstance=executionService.startProcessInstanceByKey("sp");<br/>  <br/>  Set<String>  executions=processInstance.findActiveActivityNames();<br/>  <br/>  System.out.println("The No of active executions are :"+executions.size());<br/>  <br/>  Execution executionInA = processInstance.findActiveExecutionIn("a");<br/>  <br/>  System.out.println("Execution is "+executionInA);</p><p>     processInstance = executionService.signalExecutionById(executionInA.getId());<br/>     <br/>     Execution executionInB = processInstance.findActiveExecutionIn("b");<br/>     <br/>     System.out.println("Execution is "+executionInB);<br/> }<br/> private static void deployProcessDefinitation() {</p><p>  deploymentId=repositoryService.createDeployment()<br/>      .addResourceFromClasspath("com/mhgadm/za/sample/sampleprocess.jpdl.xml")<br/>      .deploy();<br/>  <br/>  System.out.println("The porecess id is deployed with id "+deploymentId);<br/>  <br/> }<br/> private static void buildConfiguration() {<br/>  <br/>  processEngine=Configuration.getProcessEngine();<br/>  <br/>  repositoryService=processEngine.getRepositoryService();<br/>  <br/>  executionService=processEngine.getExecutionService();<br/>  <br/>  managementService=processEngine.getManagementService();<br/>  <br/>  taskService=processEngine.getTaskService();<br/>  <br/>  historyService=processEngine.getHistoryService();<br/>  <br/>  identityService=processEngine.getIdentityService();<br/> }</p><p>}</p><p>=== Stacktrace ==============================<br/>11:18:21,532 FST | [StringType] returning 'pdversion' as column: KEY4_1_0_<br/>11:18:21,532 FST | [StringType] returning null as column: STRINGVAL5_1_0_<br/>11:18:21,532 FST | [LongType] returning '2' as column: LONGVAL6_1_0_<br/>11:18:21,532 FST | [LongType] returning '30001' as column: DEPLOYMENT2_1_<br/>11:18:21,532 FST | [LongType] returning '30006' as column: DBID1_1_<br/>11:18:21,532 FIN | [SQL] select deployment0_.DBID_ as DBID1_0_0_, deployment0_.NAME_ as NAME2_0_0_, deployment0_.TIMESTAMP_ as TIMESTAMP3_0_0_, deployment0_.STATE_ as STATE4_0_0_ from JBPM4_DEPLOYMENT deployment0_ where deployment0_.DBID_=?<br/>Hibernate: select deployment0_.DBID_ as DBID1_0_0_, deployment0_.NAME_ as NAME2_0_0_, deployment0_.TIMESTAMP_ as TIMESTAMP3_0_0_, deployment0_.STATE_ as STATE4_0_0_ from JBPM4_DEPLOYMENT deployment0_ where deployment0_.DBID_=?<br/>11:18:21,532 FST | [LongType] binding '40001' to parameter: 1<br/>11:18:21,532 FST | [TextType] returning null as column: NAME2_0_0_<br/>11:18:21,532 FST | [LongType] returning '0' as column: TIMESTAMP3_0_0_<br/>11:18:21,532 FST | [StringType] returning 'active' as column: STATE4_0_0_<br/>11:18:21,532 FIN | [SQL] select resources0_.DEPLOYMENT_ as DEPLOYMENT4_1_, resources0_.DBID_ as DBID1_1_, resources0_.NAME_ as NAME5_1_, resources0_.DBID_ as DBID1_5_0_, resources0_.DBVERSION_ as DBVERSION2_5_0_, resources0_.BLOB_VALUE_ as BLOB3_5_0_ from JBPM4_LOB resources0_ where resources0_.DEPLOYMENT_=?<br/>Hibernate: select resources0_.DEPLOYMENT_ as DEPLOYMENT4_1_, resources0_.DBID_ as DBID1_1_, resources0_.NAME_ as NAME5_1_, resources0_.DBID_ as DBID1_5_0_, resources0_.DBVERSION_ as DBVERSION2_5_0_, resources0_.BLOB_VALUE_ as BLOB3_5_0_ from JBPM4_LOB resources0_ where resources0_.DEPLOYMENT_=?<br/>11:18:21,532 FST | [LongType] binding '40001' to parameter: 1<br/>11:18:21,532 FST | [LongType] returning '40002' as column: DBID1_5_0_<br/>11:18:21,547 FST | [IntegerType] returning '0' as column: DBVERSION2_5_0_<br/>11:18:21,547 FST | [LongType] returning '40001' as column: DEPLOYMENT4_1_<br/>11:18:21,547 FST | [LongType] returning '40002' as column: DBID1_1_<br/>11:18:21,547 FST | [TextType] returning 'com/mhgadm/za/sample/sampleprocess.jpdl.xml' as column: NAME5_1_<br/>11:18:21,594 FIN | [SQL] select objectprop0_.DEPLOYMENT_ as DEPLOYMENT2_1_, objectprop0_.DBID_ as DBID1_1_, objectprop0_.DBID_ as DBID1_1_0_, objectprop0_.DEPLOYMENT_ as DEPLOYMENT2_1_0_, objectprop0_.OBJNAME_ as OBJNAME3_1_0_, objectprop0_.KEY_ as KEY4_1_0_, objectprop0_.STRINGVAL_ as STRINGVAL5_1_0_, objectprop0_.LONGVAL_ as LONGVAL6_1_0_ from JBPM4_DEPLOYPROP objectprop0_ where objectprop0_.DEPLOYMENT_=?<br/>Hibernate: select objectprop0_.DEPLOYMENT_ as DEPLOYMENT2_1_, objectprop0_.DBID_ as DBID1_1_, objectprop0_.DBID_ as DBID1_1_0_, objectprop0_.DEPLOYMENT_ as DEPLOYMENT2_1_0_, objectprop0_.OBJNAME_ as OBJNAME3_1_0_, objectprop0_.KEY_ as KEY4_1_0_, objectprop0_.STRINGVAL_ as STRINGVAL5_1_0_, objectprop0_.LONGVAL_ as LONGVAL6_1_0_ from JBPM4_DEPLOYPROP objectprop0_ where objectprop0_.DEPLOYMENT_=?<br/>11:18:21,594 FST | [LongType] binding '40001' to parameter: 1<br/>11:18:21,610 FST | [LongType] returning '40003' as column: DBID1_1_0_<br/>11:18:21,610 FST | [LongType] returning '40001' as column: DEPLOYMENT2_1_0_<br/>11:18:21,610 FST | [StringType] returning 'sampleprocess' as column: OBJNAME3_1_0_<br/>11:18:21,610 FST | [StringType] returning 'langid' as column: KEY4_1_0_<br/>11:18:21,610 FST | [StringType] returning 'jpdl-4.4' as column: STRINGVAL5_1_0_<br/>11:18:21,610 FST | [LongType] returning null as column: LONGVAL6_1_0_<br/>11:18:21,610 FST | [LongType] returning '40001' as column: DEPLOYMENT2_1_<br/>11:18:21,610 FST | [LongType] returning '40003' as column: DBID1_1_<br/>11:18:21,610 FST | [LongType] returning '40004' as column: DBID1_1_0_<br/>11:18:21,610 FST | [LongType] returning '40001' as column: DEPLOYMENT2_1_0_<br/>11:18:21,610 FST | [StringType] returning 'sampleprocess' as column: OBJNAME3_1_0_<br/>11:18:21,610 FST | [StringType] returning 'pdid' as column: KEY4_1_0_<br/>11:18:21,610 FST | [StringType] returning 'sp-3' as column: STRINGVAL5_1_0_<br/>11:18:21,610 FST | [LongType] returning null as column: LONGVAL6_1_0_<br/>11:18:21,610 FST | [LongType] returning '40001' as column: DEPLOYMENT2_1_<br/>11:18:21,610 FST | [LongType] returning '40004' as column: DBID1_1_<br/>11:18:21,610 FST | [LongType] returning '40005' as column: DBID1_1_0_<br/>11:18:21,610 FST | [LongType] returning '40001' as column: DEPLOYMENT2_1_0_<br/>11:18:21,610 FST | [StringType] returning 'sampleprocess' as column: OBJNAME3_1_0_<br/>11:18:21,610 FST | [StringType] returning 'pdkey' as column: KEY4_1_0_<br/>11:18:21,610 FST | [StringType] returning 'sp' as column: STRINGVAL5_1_0_<br/>11:18:21,610 FST | [LongType] returning null as column: LONGVAL6_1_0_<br/>11:18:21,610 FST | [LongType] returning '40001' as column: DEPLOYMENT2_1_<br/>11:18:21,610 FST | [LongType] returning '40005' as column: DBID1_1_<br/>11:18:21,610 FST | [LongType] returning '40006' as column: DBID1_1_0_<br/>11:18:21,610 FST | [LongType] returning '40001' as column: DEPLOYMENT2_1_0_<br/>11:18:21,610 FST | [StringType] returning 'sampleprocess' as column: OBJNAME3_1_0_<br/>11:18:21,610 FST | [StringType] returning 'pdversion' as column: KEY4_1_0_<br/>11:18:21,610 FST | [StringType] returning null as column: STRINGVAL5_1_0_<br/>11:18:21,610 FST | [LongType] returning '3' as column: LONGVAL6_1_0_<br/>11:18:21,610 FST | [LongType] returning '40001' as column: DEPLOYMENT2_1_<br/>11:18:21,610 FST | [LongType] returning '40006' as column: DBID1_1_<br/>11:18:21,625 FIN | [SQL] select deployment1_.OBJNAME_ as col_0_0_, deployment1_.DEPLOYMENT_ as col_1_0_ from JBPM4_DEPLOYMENT deployment0_, JBPM4_DEPLOYPROP deployment1_, JBPM4_DEPLOYPROP deployment2_, JBPM4_DEPLOYPROP deployment3_ where deployment1_.KEY_='pdid' and deployment1_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.KEY_='pdkey' and deployment2_.OBJNAME_=deployment1_.OBJNAME_ and deployment2_.DEPLOYMENT_=deployment0_.DBID_ and deployment3_.KEY_='pdversion' and deployment3_.OBJNAME_=deployment1_.OBJNAME_ and deployment3_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.STRINGVAL_='sp'<br/>Hibernate: select deployment1_.OBJNAME_ as col_0_0_, deployment1_.DEPLOYMENT_ as col_1_0_ from JBPM4_DEPLOYMENT deployment0_, JBPM4_DEPLOYPROP deployment1_, JBPM4_DEPLOYPROP deployment2_, JBPM4_DEPLOYPROP deployment3_ where deployment1_.KEY_='pdid' and deployment1_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.KEY_='pdkey' and deployment2_.OBJNAME_=deployment1_.OBJNAME_ and deployment2_.DEPLOYMENT_=deployment0_.DBID_ and deployment3_.KEY_='pdversion' and deployment3_.OBJNAME_=deployment1_.OBJNAME_ and deployment3_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.STRINGVAL_='sp'<br/>11:18:21,625 FST | [StringType] returning 'sampleprocess' as column: col_0_0_<br/>11:18:21,625 FST | [LongType] returning '1' as column: col_1_0_<br/>11:18:21,625 FST | [StringType] returning 'sampleprocess' as column: col_0_0_<br/>11:18:21,625 FST | [LongType] returning '30001' as column: col_1_0_<br/>11:18:21,625 FST | [StringType] returning 'sampleprocess' as column: col_0_0_<br/>11:18:21,625 FST | [LongType] returning '40001' as column: col_1_0_<br/>Hibernate: select deployment1_.OBJNAME_ as col_0_0_, deployment1_.DEPLOYMENT_ as col_1_0_ from JBPM4_DEPLOYMENT deployment0_, JBPM4_DEPLOYPROP deployment1_, JBPM4_DEPLOYPROP deployment2_, JBPM4_DEPLOYPROP deployment3_ where deployment1_.KEY_='pdid' and deployment1_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.KEY_='pdkey' and deployment2_.OBJNAME_=deployment1_.OBJNAME_ and deployment2_.DEPLOYMENT_=deployment0_.DBID_ and deployment3_.KEY_='pdversion' and deployment3_.OBJNAME_=deployment1_.OBJNAME_ and deployment3_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.STRINGVAL_='sp' order by deployment3_.LONGVAL_ desc limit ?<br/>11:18:21,641 FIN | [SQL] select deployment1_.OBJNAME_ as col_0_0_, deployment1_.DEPLOYMENT_ as col_1_0_ from JBPM4_DEPLOYMENT deployment0_, JBPM4_DEPLOYPROP deployment1_, JBPM4_DEPLOYPROP deployment2_, JBPM4_DEPLOYPROP deployment3_ where deployment1_.KEY_='pdid' and deployment1_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.KEY_='pdkey' and deployment2_.OBJNAME_=deployment1_.OBJNAME_ and deployment2_.DEPLOYMENT_=deployment0_.DBID_ and deployment3_.KEY_='pdversion' and deployment3_.OBJNAME_=deployment1_.OBJNAME_ and deployment3_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.STRINGVAL_='sp' order by deployment3_.LONGVAL_ desc limit ?<br/>11:18:21,641 FST | [StringType] returning 'sampleprocess' as column: col_0_0_<br/>11:18:21,641 FST | [LongType] returning '40001' as column: col_1_0_<br/>11:18:21,657 FIN | [SQL] select deployment1_.OBJNAME_ as col_0_0_, deployment1_.DEPLOYMENT_ as col_1_0_ from JBPM4_DEPLOYMENT deployment0_, JBPM4_DEPLOYPROP deployment1_, JBPM4_DEPLOYPROP deployment2_, JBPM4_DEPLOYPROP deployment3_ where deployment1_.KEY_='pdid' and deployment1_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.KEY_='pdkey' and deployment2_.OBJNAME_=deployment1_.OBJNAME_ and deployment2_.DEPLOYMENT_=deployment0_.DBID_ and deployment3_.KEY_='pdversion' and deployment3_.OBJNAME_=deployment1_.OBJNAME_ and deployment3_.DEPLOYMENT_=deployment0_.DBID_ and deployment1_.STRINGVAL_='sp-4'<br/>Hibernate: select deployment1_.OBJNAME_ as col_0_0_, deployment1_.DEPLOYMENT_ as col_1_0_ from JBPM4_DEPLOYMENT deployment0_, JBPM4_DEPLOYPROP deployment1_, JBPM4_DEPLOYPROP deployment2_, JBPM4_DEPLOYPROP deployment3_ where deployment1_.KEY_='pdid' and deployment1_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.KEY_='pdkey' and deployment2_.OBJNAME_=deployment1_.OBJNAME_ and deployment2_.DEPLOYMENT_=deployment0_.DBID_ and deployment3_.KEY_='pdversion' and deployment3_.OBJNAME_=deployment1_.OBJNAME_ and deployment3_.DEPLOYMENT_=deployment0_.DBID_ and deployment1_.STRINGVAL_='sp-4'<br/>11:18:21,657 FIN | [SQL] insert into JBPM4_DEPLOYPROP (DEPLOYMENT_, OBJNAME_, KEY_, STRINGVAL_, LONGVAL_, DBID_) values (?, ?, ?, ?, ?, ?)<br/>Hibernate: insert into JBPM4_DEPLOYPROP (DEPLOYMENT_, OBJNAME_, KEY_, STRINGVAL_, LONGVAL_, DBID_) values (?, ?, ?, ?, ?, ?)<br/>11:18:21,657 FST | [LongType] binding null to parameter: 1<br/>11:18:21,657 FST | [StringType] binding null to parameter: 2<br/>11:18:21,657 FST | [StringType] binding null to parameter: 3<br/>11:18:21,657 FST | [StringType] binding null to parameter: 4<br/>11:18:21,657 FST | [LongType] binding null to parameter: 5<br/>11:18:21,657 FST | [LongType] binding '50004' to parameter: 6<br/>11:18:21,657 FIN | [SQL] insert into JBPM4_DEPLOYPROP (DEPLOYMENT_, OBJNAME_, KEY_, STRINGVAL_, LONGVAL_, DBID_) values (?, ?, ?, ?, ?, ?)<br/>Hibernate: insert into JBPM4_DEPLOYPROP (DEPLOYMENT_, OBJNAME_, KEY_, STRINGVAL_, LONGVAL_, DBID_) values (?, ?, ?, ?, ?, ?)<br/>11:18:21,657 FST | [LongType] binding null to parameter: 1<br/>11:18:21,657 FST | [StringType] binding null to parameter: 2<br/>11:18:21,657 FST | [StringType] binding null to parameter: 3<br/>11:18:21,657 FST | [StringType] binding null to parameter: 4<br/>11:18:21,657 FST | [LongType] binding null to parameter: 5<br/>11:18:21,657 FST | [LongType] binding '50005' to parameter: 6<br/>11:18:21,657 FIN | [SQL] insert into JBPM4_DEPLOYPROP (DEPLOYMENT_, OBJNAME_, KEY_, STRINGVAL_, LONGVAL_, DBID_) values (?, ?, ?, ?, ?, ?)<br/>Hibernate: insert into JBPM4_DEPLOYPROP (DEPLOYMENT_, OBJNAME_, KEY_, STRINGVAL_, LONGVAL_, DBID_) values (?, ?, ?, ?, ?, ?)<br/>11:18:21,657 FST | [LongType] binding null to parameter: 1<br/>11:18:21,657 FST | [StringType] binding null to parameter: 2<br/>11:18:21,657 FST | [StringType] binding null to parameter: 3<br/>11:18:21,657 FST | [StringType] binding null to parameter: 4<br/>11:18:21,657 FST | [LongType] binding null to parameter: 5<br/>11:18:21,657 FST | [LongType] binding '50006' to parameter: 6<br/>11:18:21,657 FIN | [SQL] update JBPM4_DEPLOYPROP set DEPLOYMENT_=?, OBJNAME_=?, KEY_=?, STRINGVAL_=?, LONGVAL_=? where DBID_=?<br/>Hibernate: update JBPM4_DEPLOYPROP set DEPLOYMENT_=?, OBJNAME_=?, KEY_=?, STRINGVAL_=?, LONGVAL_=? where DBID_=?<br/>11:18:21,657 FST | [LongType] binding '50001' to parameter: 1<br/>11:18:21,657 FST | [StringType] binding 'sampleprocess' to parameter: 2<br/>11:18:21,657 FST | [StringType] binding 'pdid' to parameter: 3<br/>11:18:21,657 FST | [StringType] binding 'sp-4' to parameter: 4<br/>11:18:21,657 FST | [LongType] binding null to parameter: 5<br/>11:18:21,657 FST | [LongType] binding '50004' to parameter: 6<br/>11:18:21,657 FIN | [SQL] update JBPM4_DEPLOYPROP set DEPLOYMENT_=?, OBJNAME_=?, KEY_=?, STRINGVAL_=?, LONGVAL_=? where DBID_=?<br/>Hibernate: update JBPM4_DEPLOYPROP set DEPLOYMENT_=?, OBJNAME_=?, KEY_=?, STRINGVAL_=?, LONGVAL_=? where DBID_=?<br/>11:18:21,657 FST | [LongType] binding '50001' to parameter: 1<br/>11:18:21,657 FST | [StringType] binding 'sampleprocess' to parameter: 2<br/>11:18:21,657 FST | [StringType] binding 'pdkey' to parameter: 3<br/>11:18:21,657 FST | [StringType] binding 'sp' to parameter: 4<br/>11:18:21,657 FST | [LongType] binding null to parameter: 5<br/>11:18:21,672 FST | [LongType] binding '50005' to parameter: 6<br/>11:18:21,672 FIN | [SQL] update JBPM4_DEPLOYPROP set DEPLOYMENT_=?, OBJNAME_=?, KEY_=?, STRINGVAL_=?, LONGVAL_=? where DBID_=?<br/>Hibernate: update JBPM4_DEPLOYPROP set DEPLOYMENT_=?, OBJNAME_=?, KEY_=?, STRINGVAL_=?, LONGVAL_=? where DBID_=?<br/>11:18:21,672 FST | [LongType] binding '50001' to parameter: 1<br/>11:18:21,672 FST | [StringType] binding 'sampleprocess' to parameter: 2<br/>11:18:21,672 FST | [StringType] binding 'pdversion' to parameter: 3<br/>11:18:21,672 FST | [StringType] binding null to parameter: 4<br/>11:18:21,672 FST | [LongType] binding '4' to parameter: 5<br/>11:18:21,672 FST | [LongType] binding '50006' to parameter: 6<br/>11:18:21,672 FIN | [SQL] update JBPM4_DEPLOYPROP set DEPLOYMENT_=? where DBID_=?<br/>Hibernate: update JBPM4_DEPLOYPROP set DEPLOYMENT_=? where DBID_=?<br/>11:18:21,672 FST | [LongType] binding '50001' to parameter: 1<br/>11:18:21,672 FST | [LongType] binding '50005' to parameter: 2<br/>11:18:21,672 FIN | [SQL] update JBPM4_DEPLOYPROP set DEPLOYMENT_=? where DBID_=?<br/>Hibernate: update JBPM4_DEPLOYPROP set DEPLOYMENT_=? where DBID_=?<br/>11:18:21,672 FST | [LongType] binding '50001' to parameter: 1<br/>11:18:21,672 FST | [LongType] binding '50004' to parameter: 2<br/>11:18:21,672 FIN | [SQL] update JBPM4_DEPLOYPROP set DEPLOYMENT_=? where DBID_=?<br/>Hibernate: update JBPM4_DEPLOYPROP set DEPLOYMENT_=? where DBID_=?<br/>11:18:21,672 FST | [LongType] binding '50001' to parameter: 1<br/>11:18:21,672 FST | [LongType] binding '50006' to parameter: 2<br/>11:18:21,672 FIN | [HibernateSessionResource] ----- committing hibernate tx 81758996 -------------------------------------------------------<br/>The porecess id is deployed with id 50001<br/>11:18:21,672 FIN | [HibernateSessionResource] ----- beginning hibernate tx 878190908 --------------------------------------------------------<br/>11:18:21,672 FIN | [SQL] select deployment1_.OBJNAME_ as col_0_0_, deployment1_.DEPLOYMENT_ as col_1_0_ from JBPM4_DEPLOYMENT deployment0_, JBPM4_DEPLOYPROP deployment1_, JBPM4_DEPLOYPROP deployment2_, JBPM4_DEPLOYPROP deployment3_ where deployment1_.KEY_='pdid' and deployment1_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.KEY_='pdkey' and deployment2_.OBJNAME_=deployment1_.OBJNAME_ and deployment2_.DEPLOYMENT_=deployment0_.DBID_ and deployment3_.KEY_='pdversion' and deployment3_.OBJNAME_=deployment1_.OBJNAME_ and deployment3_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.STRINGVAL_='sp' order by deployment3_.LONGVAL_ desc limit ?<br/>Hibernate: select deployment1_.OBJNAME_ as col_0_0_, deployment1_.DEPLOYMENT_ as col_1_0_ from JBPM4_DEPLOYMENT deployment0_, JBPM4_DEPLOYPROP deployment1_, JBPM4_DEPLOYPROP deployment2_, JBPM4_DEPLOYPROP deployment3_ where deployment1_.KEY_='pdid' and deployment1_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.KEY_='pdkey' and deployment2_.OBJNAME_=deployment1_.OBJNAME_ and deployment2_.DEPLOYMENT_=deployment0_.DBID_ and deployment3_.KEY_='pdversion' and deployment3_.OBJNAME_=deployment1_.OBJNAME_ and deployment3_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.STRINGVAL_='sp' order by deployment3_.LONGVAL_ desc limit ?<br/>11:18:21,672 FST | [StringType] returning 'sampleprocess' as column: col_0_0_<br/>11:18:21,672 FST | [LongType] returning '50001' as column: col_1_0_<br/>11:18:21,672 FIN | [SQL] select deployment0_.DBID_ as DBID1_1_, deployment0_.DEPLOYMENT_ as DEPLOYMENT2_1_, deployment0_.OBJNAME_ as OBJNAME3_1_, deployment0_.KEY_ as KEY4_1_, deployment0_.STRINGVAL_ as STRINGVAL5_1_, deployment0_.LONGVAL_ as LONGVAL6_1_ from JBPM4_DEPLOYPROP deployment0_ where deployment0_.KEY_='pdid' and deployment0_.STRINGVAL_='sp-4' limit ?<br/>Hibernate: select deployment0_.DBID_ as DBID1_1_, deployment0_.DEPLOYMENT_ as DEPLOYMENT2_1_, deployment0_.OBJNAME_ as OBJNAME3_1_, deployment0_.KEY_ as KEY4_1_, deployment0_.STRINGVAL_ as STRINGVAL5_1_, deployment0_.LONGVAL_ as LONGVAL6_1_ from JBPM4_DEPLOYPROP deployment0_ where deployment0_.KEY_='pdid' and deployment0_.STRINGVAL_='sp-4' limit ?<br/>11:18:21,688 FST | [LongType] returning '50004' as column: DBID1_1_<br/>11:18:21,688 FST | [LongType] returning '50001' as column: DEPLOYMENT2_1_<br/>11:18:21,688 FST | [StringType] returning 'sampleprocess' as column: OBJNAME3_1_<br/>11:18:21,688 FST | [StringType] returning 'pdid' as column: KEY4_1_<br/>11:18:21,688 FST | [StringType] returning 'sp-4' as column: STRINGVAL5_1_<br/>11:18:21,688 FST | [LongType] returning null as column: LONGVAL6_1_<br/>11:18:21,688 FIN | [SQL] select deployment0_.DBID_ as DBID1_0_0_, deployment0_.NAME_ as NAME2_0_0_, deployment0_.TIMESTAMP_ as TIMESTAMP3_0_0_, deployment0_.STATE_ as STATE4_0_0_ from JBPM4_DEPLOYMENT deployment0_ where deployment0_.DBID_=?<br/>Hibernate: select deployment0_.DBID_ as DBID1_0_0_, deployment0_.NAME_ as NAME2_0_0_, deployment0_.TIMESTAMP_ as TIMESTAMP3_0_0_, deployment0_.STATE_ as STATE4_0_0_ from JBPM4_DEPLOYMENT deployment0_ where deployment0_.DBID_=?<br/>11:18:21,688 FST | [LongType] binding '50001' to parameter: 1<br/>11:18:21,688 FST | [TextType] returning null as column: NAME2_0_0_<br/>11:18:21,688 FST | [LongType] returning '0' as column: TIMESTAMP3_0_0_<br/>11:18:21,688 FST | [StringType] returning 'active' as column: STATE4_0_0_<br/>11:18:21,688 FIN | [ProcessDefinitionImpl] creating new execution for process 'sampleprocess'<br/>11:18:21,688 FIN | [DatabaseIdComposer] generated execution id sp.50007<br/>11:18:21,703 FIN | [ExecuteActivity] executing activity(175735253)<br/>11:18:21,703 FIN | [ExecuteActivity] executing activity(a)<br/>11:18:21,703 FIN | [SQL] insert into JBPM4_EXECUTION (DBVERSION_, ACTIVITYNAME_, PROCDEFID_, HASVARS_, NAME_, KEY_, ID_, STATE_, SUSPHISTSTATE_, PRIORITY_, HISACTINST_, PARENT_, INSTANCE_, SUPEREXEC_, SUBPROCINST_, CLASS_, DBID_) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'pvm', ?)<br/>Hibernate: insert into JBPM4_EXECUTION (DBVERSION_, ACTIVITYNAME_, PROCDEFID_, HASVARS_, NAME_, KEY_, ID_, STATE_, SUSPHISTSTATE_, PRIORITY_, HISACTINST_, PARENT_, INSTANCE_, SUPEREXEC_, SUBPROCINST_, CLASS_, DBID_) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'pvm', ?)<br/>11:18:21,703 FST | [IntegerType] binding '0' to parameter: 1<br/>11:18:21,703 FST | [StringType] binding null to parameter: 2<br/>11:18:21,703 FST | [StringType] binding 'sp-4' to parameter: 3<br/>11:18:21,703 FST | [BooleanType] binding 'false' to parameter: 4<br/>11:18:21,703 FST | [StringType] binding null to parameter: 5<br/>11:18:21,703 FST | [StringType] binding null to parameter: 6<br/>11:18:21,703 FST | [StringType] binding 'sp.50007' to parameter: 7<br/>11:18:21,703 FST | [StringType] binding 'created' to parameter: 8<br/>11:18:21,703 FST | [StringType] binding null to parameter: 9<br/>11:18:21,703 FST | [IntegerType] binding '0' to parameter: 10<br/>11:18:21,703 FST | [LongType] binding null to parameter: 11<br/>11:18:21,703 FST | [LongType] binding null to parameter: 12<br/>11:18:21,703 FST | [LongType] binding '50007' to parameter: 13<br/>11:18:21,703 FST | [LongType] binding null to parameter: 14<br/>11:18:21,703 FST | [LongType] binding null to parameter: 15<br/>11:18:21,703 FST | [LongType] binding '50007' to parameter: 16<br/>11:18:21,703 FIN | [SQL] insert into JBPM4_HIST_PROCINST (DBVERSION_, ID_, PROCDEFID_, KEY_, START_, END_, DURATION_, STATE_, ENDACTIVITY_, NEXTIDX_, DBID_) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)<br/>Hibernate: insert into JBPM4_HIST_PROCINST (DBVERSION_, ID_, PROCDEFID_, KEY_, START_, END_, DURATION_, STATE_, ENDACTIVITY_, NEXTIDX_, DBID_) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)<br/>11:18:21,703 FST | [IntegerType] binding '0' to parameter: 1<br/>11:18:21,703 FST | [StringType] binding 'sp.50007' to parameter: 2<br/>11:18:21,703 FST | [StringType] binding 'sp-4' to parameter: 3<br/>11:18:21,703 FST | [StringType] binding null to parameter: 4<br/>11:18:21,703 FST | [TimestampType] binding '2010-10-01 11:18:21' to parameter: 5<br/>11:18:21,703 FST | [TimestampType] binding null to parameter: 6<br/>11:18:21,703 FST | [LongType] binding null to parameter: 7<br/>11:18:21,703 FST | [StringType] binding 'active' to parameter: 8<br/>11:18:21,703 FST | [StringType] binding null to parameter: 9<br/>11:18:21,703 FST | [IntegerType] binding '1' to parameter: 10<br/>11:18:21,703 FST | [LongType] binding '50007' to parameter: 11<br/>Hibernate: insert into JBPM4_HIST_ACTINST (DBVERSION_, HPROCI_, TYPE_, EXECUTION_, ACTIVITY_NAME_, START_, END_, DURATION_, TRANSITION_, NEXTIDX_, CLASS_, DBID_) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'act', ?)<br/>11:18:21,719 FIN | [SQL] insert into JBPM4_HIST_ACTINST (DBVERSION_, HPROCI_, TYPE_, EXECUTION_, ACTIVITY_NAME_, START_, END_, DURATION_, TRANSITION_, NEXTIDX_, CLASS_, DBID_) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'act', ?)<br/>11:18:21,719 FST | [IntegerType] binding '0' to parameter: 1<br/>11:18:21,719 FST | [LongType] binding '50007' to parameter: 2<br/>11:18:21,719 FST | [StringType] binding 'state' to parameter: 3<br/>11:18:21,719 FST | [StringType] binding 'sp.50007' to parameter: 4<br/>11:18:21,719 FST | [StringType] binding 'a' to parameter: 5<br/>11:18:21,719 FST | [TimestampType] binding '2010-10-01 11:18:21' to parameter: 6<br/>11:18:21,719 FST | [TimestampType] binding null to parameter: 7<br/>11:18:21,719 FST | [LongType] binding '0' to parameter: 8<br/>11:18:21,719 FST | [StringType] binding null to parameter: 9<br/>11:18:21,719 FST | [IntegerType] binding '1' to parameter: 10<br/>11:18:21,719 FST | [LongType] binding '50008' to parameter: 11<br/>11:18:21,719 FIN | [SQL] update JBPM4_EXECUTION set DBVERSION_=?, ACTIVITYNAME_=?, PROCDEFID_=?, HASVARS_=?, NAME_=?, KEY_=?, ID_=?, STATE_=?, SUSPHISTSTATE_=?, PRIORITY_=?, HISACTINST_=?, PARENT_=?, INSTANCE_=?, SUPEREXEC_=?, SUBPROCINST_=? where DBID_=? and DBVERSION_=?<br/>Hibernate: update JBPM4_EXECUTION set DBVERSION_=?, ACTIVITYNAME_=?, PROCDEFID_=?, HASVARS_=?, NAME_=?, KEY_=?, ID_=?, STATE_=?, SUSPHISTSTATE_=?, PRIORITY_=?, HISACTINST_=?, PARENT_=?, INSTANCE_=?, SUPEREXEC_=?, SUBPROCINST_=? where DBID_=? and DBVERSION_=?<br/>11:18:21,719 FST | [IntegerType] binding '1' to parameter: 1<br/>11:18:21,719 FST | [StringType] binding 'a' to parameter: 2<br/>11:18:21,719 FST | [StringType] binding 'sp-4' to parameter: 3<br/>11:18:21,719 FST | [BooleanType] binding 'false' to parameter: 4<br/>11:18:21,719 FST | [StringType] binding null to parameter: 5<br/>11:18:21,719 FST | [StringType] binding null to parameter: 6<br/>11:18:21,719 FST | [StringType] binding 'sp.50007' to parameter: 7<br/>11:18:21,719 FST | [StringType] binding 'active-root' to parameter: 8<br/>11:18:21,719 FST | [StringType] binding null to parameter: 9<br/>11:18:21,719 FST | [IntegerType] binding '0' to parameter: 10<br/>11:18:21,719 FST | [LongType] binding '50008' to parameter: 11<br/>11:18:21,719 FST | [LongType] binding null to parameter: 12<br/>11:18:21,719 FST | [LongType] binding '50007' to parameter: 13<br/>11:18:21,719 FST | [LongType] binding null to parameter: 14<br/>11:18:21,719 FST | [LongType] binding null to parameter: 15<br/>11:18:21,719 FST | [LongType] binding '50007' to parameter: 16<br/>11:18:21,719 FST | [IntegerType] binding '0' to parameter: 17<br/>11:18:21,719 FIN | [HibernateSessionResource] ----- committing hibernate tx 1253587936 -------------------------------------------------------<br/>The No of active executions are :1<br/>Execution is execution[sp.50007]<br/>11:18:21,719 FIN | [HibernateSessionResource] ----- beginning hibernate tx 1658340521 --------------------------------------------------------<br/>11:18:21,719 FIN | [SQL] select executioni0_.DBID_ as DBID1_3_, executioni0_.DBVERSION_ as DBVERSION3_3_, executioni0_.ACTIVITYNAME_ as ACTIVITY4_3_, executioni0_.PROCDEFID_ as PROCDEFID5_3_, executioni0_.HASVARS_ as HASVARS6_3_, executioni0_.NAME_ as NAME7_3_, executioni0_.KEY_ as KEY8_3_, executioni0_.ID_ as ID9_3_, executioni0_.STATE_ as STATE10_3_, executioni0_.SUSPHISTSTATE_ as SUSPHIS11_3_, executioni0_.PRIORITY_ as PRIORITY12_3_, executioni0_.HISACTINST_ as HISACTINST13_3_, executioni0_.PARENT_ as PARENT14_3_, executioni0_.INSTANCE_ as INSTANCE15_3_, executioni0_.SUPEREXEC_ as SUPEREXEC16_3_, executioni0_.SUBPROCINST_ as SUBPROC17_3_ from JBPM4_EXECUTION executioni0_ where executioni0_.ID_=? limit ?<br/>Hibernate: select executioni0_.DBID_ as DBID1_3_, executioni0_.DBVERSION_ as DBVERSION3_3_, executioni0_.ACTIVITYNAME_ as ACTIVITY4_3_, executioni0_.PROCDEFID_ as PROCDEFID5_3_, executioni0_.HASVARS_ as HASVARS6_3_, executioni0_.NAME_ as NAME7_3_, executioni0_.KEY_ as KEY8_3_, executioni0_.ID_ as ID9_3_, executioni0_.STATE_ as STATE10_3_, executioni0_.SUSPHISTSTATE_ as SUSPHIS11_3_, executioni0_.PRIORITY_ as PRIORITY12_3_, executioni0_.HISACTINST_ as HISACTINST13_3_, executioni0_.PARENT_ as PARENT14_3_, executioni0_.INSTANCE_ as INSTANCE15_3_, executioni0_.SUPEREXEC_ as SUPEREXEC16_3_, executioni0_.SUBPROCINST_ as SUBPROC17_3_ from JBPM4_EXECUTION executioni0_ where executioni0_.ID_=? limit ?<br/>11:18:21,719 FST | [StringType] binding 'sp.50007' to parameter: 1<br/>11:18:21,719 FST | [LongType] returning '50007' as column: DBID1_3_<br/>11:18:21,719 FST | [IntegerType] returning '1' as column: DBVERSION3_3_<br/>11:18:21,719 FST | [StringType] returning 'a' as column: ACTIVITY4_3_<br/>11:18:21,719 FST | [StringType] returning 'sp-4' as column: PROCDEFID5_3_<br/>11:18:21,719 FST | [BooleanType] returning 'false' as column: HASVARS6_3_<br/>11:18:21,719 FST | [StringType] returning null as column: NAME7_3_<br/>11:18:21,719 FST | [StringType] returning null as column: KEY8_3_<br/>11:18:21,719 FST | [StringType] returning 'sp.50007' as column: ID9_3_<br/>11:18:21,719 FST | [StringType] returning 'active-root' as column: STATE10_3_<br/>11:18:21,719 FST | [StringType] returning null as column: SUSPHIS11_3_<br/>11:18:21,719 FST | [IntegerType] returning '0' as column: PRIORITY12_3_<br/>11:18:21,719 FST | [LongType] returning '50008' as column: HISACTINST13_3_<br/>11:18:21,719 FST | [LongType] returning null as column: PARENT14_3_<br/>11:18:21,719 FST | [LongType] returning '50007' as column: INSTANCE15_3_<br/>11:18:21,719 FST | [LongType] returning null as column: SUPEREXEC16_3_<br/>11:18:21,719 FST | [LongType] returning null as column: SUBPROC17_3_<br/>11:18:21,719 FIN | [SQL] select executions0_.PARENT_ as PARENT14_1_, executions0_.DBID_ as DBID1_1_, executions0_.PARENT_IDX_ as PARENT18_1_, executions0_.DBID_ as DBID1_3_0_, executions0_.DBVERSION_ as DBVERSION3_3_0_, executions0_.ACTIVITYNAME_ as ACTIVITY4_3_0_, executions0_.PROCDEFID_ as PROCDEFID5_3_0_, executions0_.HASVARS_ as HASVARS6_3_0_, executions0_.NAME_ as NAME7_3_0_, executions0_.KEY_ as KEY8_3_0_, executions0_.ID_ as ID9_3_0_, executions0_.STATE_ as STATE10_3_0_, executions0_.SUSPHISTSTATE_ as SUSPHIS11_3_0_, executions0_.PRIORITY_ as PRIORITY12_3_0_, executions0_.HISACTINST_ as HISACTINST13_3_0_, executions0_.PARENT_ as PARENT14_3_0_, executions0_.INSTANCE_ as INSTANCE15_3_0_, executions0_.SUPEREXEC_ as SUPEREXEC16_3_0_, executions0_.SUBPROCINST_ as SUBPROC17_3_0_ from JBPM4_EXECUTION executions0_ where executions0_.PARENT_=?<br/>Hibernate: select executions0_.PARENT_ as PARENT14_1_, executions0_.DBID_ as DBID1_1_, executions0_.PARENT_IDX_ as PARENT18_1_, executions0_.DBID_ as DBID1_3_0_, executions0_.DBVERSION_ as DBVERSION3_3_0_, executions0_.ACTIVITYNAME_ as ACTIVITY4_3_0_, executions0_.PROCDEFID_ as PROCDEFID5_3_0_, executions0_.HASVARS_ as HASVARS6_3_0_, executions0_.NAME_ as NAME7_3_0_, executions0_.KEY_ as KEY8_3_0_, executions0_.ID_ as ID9_3_0_, executions0_.STATE_ as STATE10_3_0_, executions0_.SUSPHISTSTATE_ as SUSPHIS11_3_0_, executions0_.PRIORITY_ as PRIORITY12_3_0_, executions0_.HISACTINST_ as HISACTINST13_3_0_, executions0_.PARENT_ as PARENT14_3_0_, executions0_.INSTANCE_ as INSTANCE15_3_0_, executions0_.SUPEREXEC_ as SUPEREXEC16_3_0_, executions0_.SUBPROCINST_ as SUBPROC17_3_0_ from JBPM4_EXECUTION executions0_ where executions0_.PARENT_=?<br/>11:18:21,735 FST | [LongType] binding '50007' to parameter: 1<br/>11:18:21,735 FIN | [SQL] select deployment0_.DBID_ as DBID1_1_, deployment0_.DEPLOYMENT_ as DEPLOYMENT2_1_, deployment0_.OBJNAME_ as OBJNAME3_1_, deployment0_.KEY_ as KEY4_1_, deployment0_.STRINGVAL_ as STRINGVAL5_1_, deployment0_.LONGVAL_ as LONGVAL6_1_ from JBPM4_DEPLOYPROP deployment0_ where deployment0_.KEY_='pdid' and deployment0_.STRINGVAL_='sp-4' limit ?<br/>Hibernate: select deployment0_.DBID_ as DBID1_1_, deployment0_.DEPLOYMENT_ as DEPLOYMENT2_1_, deployment0_.OBJNAME_ as OBJNAME3_1_, deployment0_.KEY_ as KEY4_1_, deployment0_.STRINGVAL_ as STRINGVAL5_1_, deployment0_.LONGVAL_ as LONGVAL6_1_ from JBPM4_DEPLOYPROP deployment0_ where deployment0_.KEY_='pdid' and deployment0_.STRINGVAL_='sp-4' limit ?<br/>11:18:21,735 FST | [LongType] returning '50004' as column: DBID1_1_<br/>11:18:21,735 FST | [LongType] returning '50001' as column: DEPLOYMENT2_1_<br/>11:18:21,735 FST | [StringType] returning 'sampleprocess' as column: OBJNAME3_1_<br/>11:18:21,735 FST | [StringType] returning 'pdid' as column: KEY4_1_<br/>11:18:21,735 FST | [StringType] returning 'sp-4' as column: STRINGVAL5_1_<br/>11:18:21,735 FST | [LongType] returning null as column: LONGVAL6_1_<br/>11:18:21,735 FIN | [SQL] select deployment0_.DBID_ as DBID1_0_0_, deployment0_.NAME_ as NAME2_0_0_, deployment0_.TIMESTAMP_ as TIMESTAMP3_0_0_, deployment0_.STATE_ as STATE4_0_0_ from JBPM4_DEPLOYMENT deployment0_ where deployment0_.DBID_=?<br/>11:18:21,735 FST | [LongType] binding '50001' to parameter: 1<br/>Hibernate: select deployment0_.DBID_ as DBID1_0_0_, deployment0_.NAME_ as NAME2_0_0_, deployment0_.TIMESTAMP_ as TIMESTAMP3_0_0_, deployment0_.STATE_ as STATE4_0_0_ from JBPM4_DEPLOYMENT deployment0_ where deployment0_.DBID_=?<br/>11:18:21,735 FST | [TextType] returning null as column: NAME2_0_0_<br/>11:18:21,735 FST | [LongType] returning '0' as column: TIMESTAMP3_0_0_<br/>11:18:21,735 FST | [StringType] returning 'active' as column: STATE4_0_0_<br/>11:18:21,735 FIN | [Signal] signalling activity(a), signalName=null<br/>11:18:21,735 FIN | [SQL] select historyact0_.DBID_ as DBID1_8_0_, historyact0_.DBVERSION_ as DBVERSION3_8_0_, historyact0_.HPROCI_ as HPROCI4_8_0_, historyact0_.TYPE_ as TYPE5_8_0_, historyact0_.EXECUTION_ as EXECUTION6_8_0_, historyact0_.ACTIVITY_NAME_ as ACTIVITY7_8_0_, historyact0_.START_ as START8_8_0_, historyact0_.END_ as END9_8_0_, historyact0_.DURATION_ as DURATION10_8_0_, historyact0_.TRANSITION_ as TRANSITION11_8_0_, historyact0_.NEXTIDX_ as NEXTIDX12_8_0_, historyact0_.HTASK_ as HTASK13_8_0_, historyact0_.CLASS_ as CLASS2_8_0_ from JBPM4_HIST_ACTINST historyact0_ where historyact0_.DBID_=?<br/>Hibernate: select historyact0_.DBID_ as DBID1_8_0_, historyact0_.DBVERSION_ as DBVERSION3_8_0_, historyact0_.HPROCI_ as HPROCI4_8_0_, historyact0_.TYPE_ as TYPE5_8_0_, historyact0_.EXECUTION_ as EXECUTION6_8_0_, historyact0_.ACTIVITY_NAME_ as ACTIVITY7_8_0_, historyact0_.START_ as START8_8_0_, historyact0_.END_ as END9_8_0_, historyact0_.DURATION_ as DURATION10_8_0_, historyact0_.TRANSITION_ as TRANSITION11_8_0_, historyact0_.NEXTIDX_ as NEXTIDX12_8_0_, historyact0_.HTASK_ as HTASK13_8_0_, historyact0_.CLASS_ as CLASS2_8_0_ from JBPM4_HIST_ACTINST historyact0_ where historyact0_.DBID_=?<br/>11:18:21,735 FST | [LongType] binding '50008' to parameter: 1<br/>11:18:21,735 FST | [StringType] returning 'act' as column: CLASS2_8_0_<br/>11:18:21,735 FST | [IntegerType] returning '0' as column: DBVERSION3_8_0_<br/>11:18:21,735 FST | [LongType] returning '50007' as column: HPROCI4_8_0_<br/>11:18:21,735 FST | [StringType] returning 'state' as column: TYPE5_8_0_<br/>11:18:21,735 FST | [StringType] returning 'sp.50007' as column: EXECUTION6_8_0_<br/>11:18:21,735 FST | [StringType] returning 'a' as column: ACTIVITY7_8_0_<br/>11:18:21,750 FST | [TimestampType] returning '2010-10-01 11:18:21' as column: START8_8_0_<br/>11:18:21,750 FST | [TimestampType] returning null as column: END9_8_0_<br/>11:18:21,750 FST | [LongType] returning '0' as column: DURATION10_8_0_<br/>11:18:21,750 FST | [StringType] returning null as column: TRANSITION11_8_0_<br/>11:18:21,750 FST | [IntegerType] returning '1' as column: NEXTIDX12_8_0_<br/>11:18:21,750 FIN | [ExecuteActivity] executing activity(b)<br/>11:18:21,750 FIN | [SQL] select historypro0_.DBID_ as DBID1_7_0_, historypro0_.DBVERSION_ as DBVERSION2_7_0_, historypro0_.ID_ as ID3_7_0_, historypro0_.PROCDEFID_ as PROCDEFID4_7_0_, historypro0_.KEY_ as KEY5_7_0_, historypro0_.START_ as START6_7_0_, historypro0_.END_ as END7_7_0_, historypro0_.DURATION_ as DURATION8_7_0_, historypro0_.STATE_ as STATE9_7_0_, historypro0_.ENDACTIVITY_ as ENDACTI10_7_0_, historypro0_.NEXTIDX_ as NEXTIDX11_7_0_ from JBPM4_HIST_PROCINST historypro0_ where historypro0_.DBID_=?<br/>11:18:21,750 FST | [LongType] binding '50007' to parameter: 1<br/>Hibernate: select historypro0_.DBID_ as DBID1_7_0_, historypro0_.DBVERSION_ as DBVERSION2_7_0_, historypro0_.ID_ as ID3_7_0_, historypro0_.PROCDEFID_ as PROCDEFID4_7_0_, historypro0_.KEY_ as KEY5_7_0_, historypro0_.START_ as START6_7_0_, historypro0_.END_ as END7_7_0_, historypro0_.DURATION_ as DURATION8_7_0_, historypro0_.STATE_ as STATE9_7_0_, historypro0_.ENDACTIVITY_ as ENDACTI10_7_0_, historypro0_.NEXTIDX_ as NEXTIDX11_7_0_ from JBPM4_HIST_PROCINST historypro0_ where historypro0_.DBID_=?<br/>11:18:21,750 FST | [IntegerType] returning '0' as column: DBVERSION2_7_0_<br/>11:18:21,750 FST | [StringType] returning 'sp.50007' as column: ID3_7_0_<br/>11:18:21,750 FST | [StringType] returning 'sp-4' as column: PROCDEFID4_7_0_<br/>11:18:21,750 FST | [StringType] returning null as column: KEY5_7_0_<br/>11:18:21,750 FST | [TimestampType] returning '2010-10-01 11:18:21' as column: START6_7_0_<br/>11:18:21,750 FST | [TimestampType] returning null as column: END7_7_0_<br/>11:18:21,750 FST | [LongType] returning null as column: DURATION8_7_0_<br/>11:18:21,750 FST | [StringType] returning 'active' as column: STATE9_7_0_<br/>11:18:21,750 FST | [StringType] returning null as column: ENDACTI10_7_0_<br/>11:18:21,750 FST | [IntegerType] returning '1' as column: NEXTIDX11_7_0_<br/>11:18:21,750 FIN | [SQL] insert into JBPM4_HIST_ACTINST (DBVERSION_, HPROCI_, TYPE_, EXECUTION_, ACTIVITY_NAME_, START_, END_, DURATION_, TRANSITION_, NEXTIDX_, CLASS_, DBID_) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'act', ?)<br/>11:18:21,750 FST | [IntegerType] binding '0' to parameter: 1<br/>11:18:21,750 FST | [LongType] binding '50007' to parameter: 2<br/>11:18:21,750 FST | [StringType] binding 'state' to parameter: 3<br/>11:18:21,750 FST | [StringType] binding 'sp.50007' to parameter: 4<br/>Hibernate: insert into JBPM4_HIST_ACTINST (DBVERSION_, HPROCI_, TYPE_, EXECUTION_, ACTIVITY_NAME_, START_, END_, DURATION_, TRANSITION_, NEXTIDX_, CLASS_, DBID_) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'act', ?)<br/>11:18:21,750 FST | [StringType] binding 'b' to parameter: 5<br/>11:18:21,750 FST | [TimestampType] binding '2010-10-01 11:18:21' to parameter: 6<br/>11:18:21,750 FST | [TimestampType] binding null to parameter: 7<br/>11:18:21,750 FST | [LongType] binding '0' to parameter: 8<br/>11:18:21,750 FST | [StringType] binding null to parameter: 9<br/>11:18:21,750 FST | [IntegerType] binding '1' to parameter: 10<br/>11:18:21,766 FST | [LongType] binding '50009' to parameter: 11<br/>11:18:21,766 FIN | [SQL] update JBPM4_EXECUTION set DBVERSION_=?, ACTIVITYNAME_=?, PROCDEFID_=?, HASVARS_=?, NAME_=?, KEY_=?, ID_=?, STATE_=?, SUSPHISTSTATE_=?, PRIORITY_=?, HISACTINST_=?, PARENT_=?, INSTANCE_=?, SUPEREXEC_=?, SUBPROCINST_=? where DBID_=? and DBVERSION_=?<br/>Hibernate: update JBPM4_EXECUTION set DBVERSION_=?, ACTIVITYNAME_=?, PROCDEFID_=?, HASVARS_=?, NAME_=?, KEY_=?, ID_=?, STATE_=?, SUSPHISTSTATE_=?, PRIORITY_=?, HISACTINST_=?, PARENT_=?, INSTANCE_=?, SUPEREXEC_=?, SUBPROCINST_=? where DBID_=? and DBVERSION_=?<br/>11:18:21,766 FST | [IntegerType] binding '2' to parameter: 1<br/>11:18:21,766 FST | [StringType] binding 'b' to parameter: 2<br/>11:18:21,766 FST | [StringType] binding 'sp-4' to parameter: 3<br/>11:18:21,766 FST | [BooleanType] binding 'false' to parameter: 4<br/>11:18:21,766 FST | [StringType] binding null to parameter: 5<br/>11:18:21,766 FST | [StringType] binding null to parameter: 6<br/>11:18:21,766 FST | [StringType] binding 'sp.50007' to parameter: 7<br/>11:18:21,766 FST | [StringType] binding 'active-root' to parameter: 8<br/>11:18:21,766 FST | [StringType] binding null to parameter: 9<br/>11:18:21,766 FST | [IntegerType] binding '0' to parameter: 10<br/>11:18:21,766 FST | [LongType] binding '50009' to parameter: 11<br/>11:18:21,766 FST | [LongType] binding null to parameter: 12<br/>11:18:21,766 FST | [LongType] binding '50007' to parameter: 13<br/>11:18:21,766 FST | [LongType] binding null to parameter: 14<br/>11:18:21,766 FST | [LongType] binding null to parameter: 15<br/>11:18:21,766 FST | [LongType] binding '50007' to parameter: 16<br/>11:18:21,766 FST | [IntegerType] binding '1' to parameter: 17<br/>11:18:21,766 FIN | [SQL] update JBPM4_HIST_ACTINST set DBVERSION_=?, HPROCI_=?, TYPE_=?, EXECUTION_=?, ACTIVITY_NAME_=?, START_=?, END_=?, DURATION_=?, TRANSITION_=?, NEXTIDX_=? where DBID_=? and DBVERSION_=?<br/>Hibernate: update JBPM4_HIST_ACTINST set DBVERSION_=?, HPROCI_=?, TYPE_=?, EXECUTION_=?, ACTIVITY_NAME_=?, START_=?, END_=?, DURATION_=?, TRANSITION_=?, NEXTIDX_=? where DBID_=? and DBVERSION_=?<br/>11:18:21,766 FST | [IntegerType] binding '1' to parameter: 1<br/>11:18:21,766 FST | [LongType] binding '50007' to parameter: 2<br/>11:18:21,766 FST | [StringType] binding 'state' to parameter: 3<br/>11:18:21,766 FST | [StringType] binding 'sp.50007' to parameter: 4<br/>11:18:21,766 FST | [StringType] binding 'a' to parameter: 5<br/>11:18:21,766 FST | [TimestampType] binding '2010-10-01 11:18:21' to parameter: 6<br/>11:18:21,766 FST | [TimestampType] binding '2010-10-01 11:18:21' to parameter: 7<br/>11:18:21,766 FST | [LongType] binding '735' to parameter: 8<br/>11:18:21,766 FST | [StringType] binding null to parameter: 9<br/>11:18:21,766 FST | [IntegerType] binding '1' to parameter: 10<br/>11:18:21,766 FST | [LongType] binding '50008' to parameter: 11<br/>11:18:21,766 FST | [IntegerType] binding '0' to parameter: 12<br/>11:18:21,766 FIN | [HibernateSessionResource] ----- committing hibernate tx 1046388151 -------------------------------------------------------<br/>Execution is execution[sp.50007]<br/>11:18:21,766 FIN | [HibernateSessionResource] ----- beginning hibernate tx 1741604980 --------------------------------------------------------<br/>11:18:21,781 FIN | [SQL] select deployment1_.OBJNAME_ as col_0_0_, deployment1_.DEPLOYMENT_ as col_1_0_ from JBPM4_DEPLOYMENT deployment0_, JBPM4_DEPLOYPROP deployment1_, JBPM4_DEPLOYPROP deployment2_, JBPM4_DEPLOYPROP deployment3_ where deployment1_.KEY_='pdid' and deployment1_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.KEY_='pdkey' and deployment2_.OBJNAME_=deployment1_.OBJNAME_ and deployment2_.DEPLOYMENT_=deployment0_.DBID_ and deployment3_.KEY_='pdversion' and deployment3_.OBJNAME_=deployment1_.OBJNAME_ and deployment3_.DEPLOYMENT_=deployment0_.DBID_ and deployment1_.DEPLOYMENT_=50001<br/>Hibernate: select deployment1_.OBJNAME_ as col_0_0_, deployment1_.DEPLOYMENT_ as col_1_0_ from JBPM4_DEPLOYMENT deployment0_, JBPM4_DEPLOYPROP deployment1_, JBPM4_DEPLOYPROP deployment2_, JBPM4_DEPLOYPROP deployment3_ where deployment1_.KEY_='pdid' and deployment1_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.KEY_='pdkey' and deployment2_.OBJNAME_=deployment1_.OBJNAME_ and deployment2_.DEPLOYMENT_=deployment0_.DBID_ and deployment3_.KEY_='pdversion' and deployment3_.OBJNAME_=deployment1_.OBJNAME_ and deployment3_.DEPLOYMENT_=deployment0_.DBID_ and deployment1_.DEPLOYMENT_=50001<br/>11:18:21,781 FST | [StringType] returning 'sampleprocess' as column: col_0_0_<br/>11:18:21,781 FST | [LongType] returning '50001' as column: col_1_0_<br/>11:18:21,797 FIN | [SQL] select executioni0_.ID_ as col_0_0_ from JBPM4_EXECUTION executioni0_ where executioni0_.PROCDEFID_=? and (executioni0_.PARENT_ is null)<br/>Hibernate: select executioni0_.ID_ as col_0_0_ from JBPM4_EXECUTION executioni0_ where executioni0_.PROCDEFID_=? and (executioni0_.PARENT_ is null)<br/>11:18:21,797 FST | [StringType] binding 'sp-4' to parameter: 1<br/>11:18:21,797 FST | [StringType] returning 'sp.50007' as column: col_0_0_<br/>11:18:21,797 FIN | [SQL] select this_.DBID_ as DBID1_7_0_, this_.DBVERSION_ as DBVERSION2_7_0_, this_.ID_ as ID3_7_0_, this_.PROCDEFID_ as PROCDEFID4_7_0_, this_.KEY_ as KEY5_7_0_, this_.START_ as START6_7_0_, this_.END_ as END7_7_0_, this_.DURATION_ as DURATION8_7_0_, this_.STATE_ as STATE9_7_0_, this_.ENDACTIVITY_ as ENDACTI10_7_0_, this_.NEXTIDX_ as NEXTIDX11_7_0_ from JBPM4_HIST_PROCINST this_ where this_.ID_=?<br/>Hibernate: select this_.DBID_ as DBID1_7_0_, this_.DBVERSION_ as DBVERSION2_7_0_, this_.ID_ as ID3_7_0_, this_.PROCDEFID_ as PROCDEFID4_7_0_, this_.KEY_ as KEY5_7_0_, this_.START_ as START6_7_0_, this_.END_ as END7_7_0_, this_.DURATION_ as DURATION8_7_0_, this_.STATE_ as STATE9_7_0_, this_.ENDACTIVITY_ as ENDACTI10_7_0_, this_.NEXTIDX_ as NEXTIDX11_7_0_ from JBPM4_HIST_PROCINST this_ where this_.ID_=?<br/>11:18:21,797 FST | [StringType] binding 'sp.50007' to parameter: 1<br/>11:18:21,797 FST | [LongType] returning '50007' as column: DBID1_7_0_<br/>11:18:21,797 FST | [IntegerType] returning '0' as column: DBVERSION2_7_0_<br/>11:18:21,797 FST | [StringType] returning 'sp.50007' as column: ID3_7_0_<br/>11:18:21,797 FST | [StringType] returning 'sp-4' as column: PROCDEFID4_7_0_<br/>11:18:21,797 FST | [StringType] returning null as column: KEY5_7_0_<br/>11:18:21,797 FST | [TimestampType] returning '2010-10-01 11:18:21' as column: START6_7_0_<br/>11:18:21,797 FST | [TimestampType] returning null as column: END7_7_0_<br/>11:18:21,797 FST | [LongType] returning null as column: DURATION8_7_0_<br/>11:18:21,797 FST | [StringType] returning 'active' as column: STATE9_7_0_<br/>11:18:21,797 FST | [StringType] returning null as column: ENDACTI10_7_0_<br/>11:18:21,797 FST | [IntegerType] returning '1' as column: NEXTIDX11_7_0_<br/>11:18:21,797 FIN | [DbSessionImpl] deleting history process instance sp.50007<br/>11:18:21,797 FIN | [SQL] select historyact0_.HPROCI_ as HPROCI4_1_, historyact0_.DBID_ as DBID1_1_, historyact0_.DBID_ as DBID1_8_0_, historyact0_.DBVERSION_ as DBVERSION3_8_0_, historyact0_.HPROCI_ as HPROCI4_8_0_, historyact0_.TYPE_ as TYPE5_8_0_, historyact0_.EXECUTION_ as EXECUTION6_8_0_, historyact0_.ACTIVITY_NAME_ as ACTIVITY7_8_0_, historyact0_.START_ as START8_8_0_, historyact0_.END_ as END9_8_0_, historyact0_.DURATION_ as DURATION10_8_0_, historyact0_.TRANSITION_ as TRANSITION11_8_0_, historyact0_.NEXTIDX_ as NEXTIDX12_8_0_, historyact0_.HTASK_ as HTASK13_8_0_, historyact0_.CLASS_ as CLASS2_8_0_ from JBPM4_HIST_ACTINST historyact0_ where historyact0_.HPROCI_=?<br/>Hibernate: select historyact0_.HPROCI_ as HPROCI4_1_, historyact0_.DBID_ as DBID1_1_, historyact0_.DBID_ as DBID1_8_0_, historyact0_.DBVERSION_ as DBVERSION3_8_0_, historyact0_.HPROCI_ as HPROCI4_8_0_, historyact0_.TYPE_ as TYPE5_8_0_, historyact0_.EXECUTION_ as EXECUTION6_8_0_, historyact0_.ACTIVITY_NAME_ as ACTIVITY7_8_0_, historyact0_.START_ as START8_8_0_, historyact0_.END_ as END9_8_0_, historyact0_.DURATION_ as DURATION10_8_0_, historyact0_.TRANSITION_ as TRANSITION11_8_0_, historyact0_.NEXTIDX_ as NEXTIDX12_8_0_, historyact0_.HTASK_ as HTASK13_8_0_, historyact0_.CLASS_ as CLASS2_8_0_ from JBPM4_HIST_ACTINST historyact0_ where historyact0_.HPROCI_=?<br/>11:18:21,797 FST | [LongType] binding '50007' to parameter: 1<br/>11:18:21,797 FST | [LongType] returning '50008' as column: DBID1_8_0_<br/>11:18:21,797 FST | [StringType] returning 'act' as column: CLASS2_8_0_<br/>11:18:21,797 FST | [IntegerType] returning '1' as column: DBVERSION3_8_0_<br/>11:18:21,797 FST | [LongType] returning '50007' as column: HPROCI4_8_0_<br/>11:18:21,797 FST | [StringType] returning 'state' as column: TYPE5_8_0_<br/>11:18:21,797 FST | [StringType] returning 'sp.50007' as column: EXECUTION6_8_0_<br/>11:18:21,797 FST | [StringType] returning 'a' as column: ACTIVITY7_8_0_<br/>11:18:21,797 FST | [TimestampType] returning '2010-10-01 11:18:21' as column: START8_8_0_<br/>11:18:21,797 FST | [TimestampType] returning '2010-10-01 11:18:21' as column: END9_8_0_<br/>11:18:21,797 FST | [LongType] returning '735' as column: DURATION10_8_0_<br/>11:18:21,797 FST | [StringType] returning null as column: TRANSITION11_8_0_<br/>11:18:21,797 FST | [IntegerType] returning '1' as column: NEXTIDX12_8_0_<br/>11:18:21,797 FST | [LongType] returning '50007' as column: HPROCI4_1_<br/>11:18:21,797 FST | [LongType] returning '50008' as column: DBID1_1_<br/>11:18:21,797 FST | [LongType] returning '50009' as column: DBID1_8_0_<br/>11:18:21,797 FST | [StringType] returning 'act' as column: CLASS2_8_0_<br/>11:18:21,797 FST | [IntegerType] returning '0' as column: DBVERSION3_8_0_<br/>11:18:21,797 FST | [LongType] returning '50007' as column: HPROCI4_8_0_<br/>11:18:21,797 FST | [StringType] returning 'state' as column: TYPE5_8_0_<br/>11:18:21,797 FST | [StringType] returning 'sp.50007' as column: EXECUTION6_8_0_<br/>11:18:21,797 FST | [StringType] returning 'b' as column: ACTIVITY7_8_0_<br/>11:18:21,797 FST | [TimestampType] returning '2010-10-01 11:18:21' as column: START8_8_0_<br/>11:18:21,797 FST | [TimestampType] returning null as column: END9_8_0_<br/>11:18:21,797 FST | [LongType] returning '0' as column: DURATION10_8_0_<br/>11:18:21,797 FST | [StringType] returning null as column: TRANSITION11_8_0_<br/>11:18:21,797 FST | [IntegerType] returning '1' as column: NEXTIDX12_8_0_<br/>11:18:21,797 FST | [LongType] returning '50007' as column: HPROCI4_1_<br/>11:18:21,797 FST | [LongType] returning '50009' as column: DBID1_1_<br/>11:18:21,797 FIN | [SQL] select details0_.HACTI_ as HACTI8_1_, details0_.DBID_ as DBID1_1_, details0_.DBID_ as DBID1_11_0_, details0_.DBVERSION_ as DBVERSION3_11_0_, details0_.USERID_ as USERID4_11_0_, details0_.TIME_ as TIME5_11_0_, details0_.HPROCI_ as HPROCI6_11_0_, details0_.HPROCIIDX_ as HPROCIIDX7_11_0_, details0_.HACTI_ as HACTI8_11_0_, details0_.HACTIIDX_ as HACTIIDX9_11_0_, details0_.HTASK_ as HTASK10_11_0_, details0_.HTASKIDX_ as HTASKIDX11_11_0_, details0_.HVAR_ as HVAR12_11_0_, details0_.HVARIDX_ as HVARIDX13_11_0_, details0_.MESSAGE_ as MESSAGE14_11_0_, details0_.OLD_STR_ as OLD15_11_0_, details0_.NEW_STR_ as NEW16_11_0_, details0_.OLD_INT_ as OLD17_11_0_, details0_.NEW_INT_ as NEW18_11_0_, details0_.OLD_TIME_ as OLD19_11_0_, details0_.NEW_TIME_ as NEW20_11_0_, details0_.CLASS_ as CLASS2_11_0_ from JBPM4_HIST_DETAIL details0_ where details0_.HACTI_=?<br/>Hibernate: select details0_.HACTI_ as HACTI8_1_, details0_.DBID_ as DBID1_1_, details0_.DBID_ as DBID1_11_0_, details0_.DBVERSION_ as DBVERSION3_11_0_, details0_.USERID_ as USERID4_11_0_, details0_.TIME_ as TIME5_11_0_, details0_.HPROCI_ as HPROCI6_11_0_, details0_.HPROCIIDX_ as HPROCIIDX7_11_0_, details0_.HACTI_ as HACTI8_11_0_, details0_.HACTIIDX_ as HACTIIDX9_11_0_, details0_.HTASK_ as HTASK10_11_0_, details0_.HTASKIDX_ as HTASKIDX11_11_0_, details0_.HVAR_ as HVAR12_11_0_, details0_.HVARIDX_ as HVARIDX13_11_0_, details0_.MESSAGE_ as MESSAGE14_11_0_, details0_.OLD_STR_ as OLD15_11_0_, details0_.NEW_STR_ as NEW16_11_0_, details0_.OLD_INT_ as OLD17_11_0_, details0_.NEW_INT_ as NEW18_11_0_, details0_.OLD_TIME_ as OLD19_11_0_, details0_.NEW_TIME_ as NEW20_11_0_, details0_.CLASS_ as CLASS2_11_0_ from JBPM4_HIST_DETAIL details0_ where details0_.HACTI_=?<br/>11:18:21,797 FST | [LongType] binding '50008' to parameter: 1<br/>11:18:21,797 FIN | [SQL] select details0_.HACTI_ as HACTI8_1_, details0_.DBID_ as DBID1_1_, details0_.DBID_ as DBID1_11_0_, details0_.DBVERSION_ as DBVERSION3_11_0_, details0_.USERID_ as USERID4_11_0_, details0_.TIME_ as TIME5_11_0_, details0_.HPROCI_ as HPROCI6_11_0_, details0_.HPROCIIDX_ as HPROCIIDX7_11_0_, details0_.HACTI_ as HACTI8_11_0_, details0_.HACTIIDX_ as HACTIIDX9_11_0_, details0_.HTASK_ as HTASK10_11_0_, details0_.HTASKIDX_ as HTASKIDX11_11_0_, details0_.HVAR_ as HVAR12_11_0_, details0_.HVARIDX_ as HVARIDX13_11_0_, details0_.MESSAGE_ as MESSAGE14_11_0_, details0_.OLD_STR_ as OLD15_11_0_, details0_.NEW_STR_ as NEW16_11_0_, details0_.OLD_INT_ as OLD17_11_0_, details0_.NEW_INT_ as NEW18_11_0_, details0_.OLD_TIME_ as OLD19_11_0_, details0_.NEW_TIME_ as NEW20_11_0_, details0_.CLASS_ as CLASS2_11_0_ from JBPM4_HIST_DETAIL details0_ where details0_.HACTI_=?<br/>Hibernate: select details0_.HACTI_ as HACTI8_1_, details0_.DBID_ as DBID1_1_, details0_.DBID_ as DBID1_11_0_, details0_.DBVERSION_ as DBVERSION3_11_0_, details0_.USERID_ as USERID4_11_0_, details0_.TIME_ as TIME5_11_0_, details0_.HPROCI_ as HPROCI6_11_0_, details0_.HPROCIIDX_ as HPROCIIDX7_11_0_, details0_.HACTI_ as HACTI8_11_0_, details0_.HACTIIDX_ as HACTIIDX9_11_0_, details0_.HTASK_ as HTASK10_11_0_, details0_.HTASKIDX_ as HTASKIDX11_11_0_, details0_.HVAR_ as HVAR12_11_0_, details0_.HVARIDX_ as HVARIDX13_11_0_, details0_.MESSAGE_ as MESSAGE14_11_0_, details0_.OLD_STR_ as OLD15_11_0_, details0_.NEW_STR_ as NEW16_11_0_, details0_.OLD_INT_ as OLD17_11_0_, details0_.NEW_INT_ as NEW18_11_0_, details0_.OLD_TIME_ as OLD19_11_0_, details0_.NEW_TIME_ as NEW20_11_0_, details0_.CLASS_ as CLASS2_11_0_ from JBPM4_HIST_DETAIL details0_ where details0_.HACTI_=?<br/>11:18:21,797 FST | [LongType] binding '50009' to parameter: 1<br/>11:18:21,813 FIN | [SQL] select historyvar0_.HPROCI_ as HPROCI7_1_, historyvar0_.DBID_ as DBID1_1_, historyvar0_.DBID_ as DBID1_10_0_, historyvar0_.DBVERSION_ as DBVERSION2_10_0_, historyvar0_.PROCINSTID_ as PROCINSTID3_10_0_, historyvar0_.EXECUTIONID_ as EXECUTIO4_10_0_, historyvar0_.VARNAME_ as VARNAME5_10_0_, historyvar0_.VALUE_ as VALUE6_10_0_, historyvar0_.HPROCI_ as HPROCI7_10_0_, historyvar0_.HTASK_ as HTASK8_10_0_ from JBPM4_HIST_VAR historyvar0_ where historyvar0_.HPROCI_=?<br/>Hibernate: select historyvar0_.HPROCI_ as HPROCI7_1_, historyvar0_.DBID_ as DBID1_1_, historyvar0_.DBID_ as DBID1_10_0_, historyvar0_.DBVERSION_ as DBVERSION2_10_0_, historyvar0_.PROCINSTID_ as PROCINSTID3_10_0_, historyvar0_.EXECUTIONID_ as EXECUTIO4_10_0_, historyvar0_.VARNAME_ as VARNAME5_10_0_, historyvar0_.VALUE_ as VALUE6_10_0_, historyvar0_.HPROCI_ as HPROCI7_10_0_, historyvar0_.HTASK_ as HTASK8_10_0_ from JBPM4_HIST_VAR historyvar0_ where historyvar0_.HPROCI_=?<br/>11:18:21,813 FST | [LongType] binding '50007' to parameter: 1<br/>11:18:21,813 FIN | [SQL] select details0_.HPROCI_ as HPROCI6_1_, details0_.DBID_ as DBID1_1_, details0_.DBID_ as DBID1_11_0_, details0_.DBVERSION_ as DBVERSION3_11_0_, details0_.USERID_ as USERID4_11_0_, details0_.TIME_ as TIME5_11_0_, details0_.HPROCI_ as HPROCI6_11_0_, details0_.HPROCIIDX_ as HPROCIIDX7_11_0_, details0_.HACTI_ as HACTI8_11_0_, details0_.HACTIIDX_ as HACTIIDX9_11_0_, details0_.HTASK_ as HTASK10_11_0_, details0_.HTASKIDX_ as HTASKIDX11_11_0_, details0_.HVAR_ as HVAR12_11_0_, details0_.HVARIDX_ as HVARIDX13_11_0_, details0_.MESSAGE_ as MESSAGE14_11_0_, details0_.OLD_STR_ as OLD15_11_0_, details0_.NEW_STR_ as NEW16_11_0_, details0_.OLD_INT_ as OLD17_11_0_, details0_.NEW_INT_ as NEW18_11_0_, details0_.OLD_TIME_ as OLD19_11_0_, details0_.NEW_TIME_ as NEW20_11_0_, details0_.CLASS_ as CLASS2_11_0_ from JBPM4_HIST_DETAIL details0_ where details0_.HPROCI_=?<br/>Hibernate: select details0_.HPROCI_ as HPROCI6_1_, details0_.DBID_ as DBID1_1_, details0_.DBID_ as DBID1_11_0_, details0_.DBVERSION_ as DBVERSION3_11_0_, details0_.USERID_ as USERID4_11_0_, details0_.TIME_ as TIME5_11_0_, details0_.HPROCI_ as HPROCI6_11_0_, details0_.HPROCIIDX_ as HPROCIIDX7_11_0_, details0_.HACTI_ as HACTI8_11_0_, details0_.HACTIIDX_ as HACTIIDX9_11_0_, details0_.HTASK_ as HTASK10_11_0_, details0_.HTASKIDX_ as HTASKIDX11_11_0_, details0_.HVAR_ as HVAR12_11_0_, details0_.HVARIDX_ as HVARIDX13_11_0_, details0_.MESSAGE_ as MESSAGE14_11_0_, details0_.OLD_STR_ as OLD15_11_0_, details0_.NEW_STR_ as NEW16_11_0_, details0_.OLD_INT_ as OLD17_11_0_, details0_.NEW_INT_ as NEW18_11_0_, details0_.OLD_TIME_ as OLD19_11_0_, details0_.NEW_TIME_ as NEW20_11_0_, details0_.CLASS_ as CLASS2_11_0_ from JBPM4_HIST_DETAIL details0_ where details0_.HPROCI_=?<br/>11:18:21,813 FST | [LongType] binding '50007' to parameter: 1<br/>11:18:21,813 FIN | [SQL] select executioni0_.DBID_ as DBID1_3_, executioni0_.DBVERSION_ as DBVERSION3_3_, executioni0_.ACTIVITYNAME_ as ACTIVITY4_3_, executioni0_.PROCDEFID_ as PROCDEFID5_3_, executioni0_.HASVARS_ as HASVARS6_3_, executioni0_.NAME_ as NAME7_3_, executioni0_.KEY_ as KEY8_3_, executioni0_.ID_ as ID9_3_, executioni0_.STATE_ as STATE10_3_, executioni0_.SUSPHISTSTATE_ as SUSPHIS11_3_, executioni0_.PRIORITY_ as PRIORITY12_3_, executioni0_.HISACTINST_ as HISACTINST13_3_, executioni0_.PARENT_ as PARENT14_3_, executioni0_.INSTANCE_ as INSTANCE15_3_, executioni0_.SUPEREXEC_ as SUPEREXEC16_3_, executioni0_.SUBPROCINST_ as SUBPROC17_3_ from JBPM4_EXECUTION executioni0_ where executioni0_.ID_=? and (executioni0_.PARENT_ is null) limit ?<br/>Hibernate: select executioni0_.DBID_ as DBID1_3_, executioni0_.DBVERSION_ as DBVERSION3_3_, executioni0_.ACTIVITYNAME_ as ACTIVITY4_3_, executioni0_.PROCDEFID_ as PROCDEFID5_3_, executioni0_.HASVARS_ as HASVARS6_3_, executioni0_.NAME_ as NAME7_3_, executioni0_.KEY_ as KEY8_3_, executioni0_.ID_ as ID9_3_, executioni0_.STATE_ as STATE10_3_, executioni0_.SUSPHISTSTATE_ as SUSPHIS11_3_, executioni0_.PRIORITY_ as PRIORITY12_3_, executioni0_.HISACTINST_ as HISACTINST13_3_, executioni0_.PARENT_ as PARENT14_3_, executioni0_.INSTANCE_ as INSTANCE15_3_, executioni0_.SUPEREXEC_ as SUPEREXEC16_3_, executioni0_.SUBPROCINST_ as SUBPROC17_3_ from JBPM4_EXECUTION executioni0_ where executioni0_.ID_=? and (executioni0_.PARENT_ is null) limit ?<br/>11:18:21,813 FST | [StringType] binding 'sp.50007' to parameter: 1<br/>11:18:21,813 FST | [LongType] returning '50007' as column: DBID1_3_<br/>11:18:21,813 FST | [IntegerType] returning '2' as column: DBVERSION3_3_<br/>11:18:21,813 FST | [StringType] returning 'b' as column: ACTIVITY4_3_<br/>11:18:21,813 FST | [StringType] returning 'sp-4' as column: PROCDEFID5_3_<br/>11:18:21,813 FST | [BooleanType] returning 'false' as column: HASVARS6_3_<br/>11:18:21,813 FST | [StringType] returning null as column: NAME7_3_<br/>11:18:21,813 FST | [StringType] returning null as column: KEY8_3_<br/>11:18:21,813 FST | [StringType] returning 'sp.50007' as column: ID9_3_<br/>11:18:21,813 FST | [StringType] returning 'active-root' as column: STATE10_3_<br/>11:18:21,813 FST | [StringType] returning null as column: SUSPHIS11_3_<br/>11:18:21,813 FST | [IntegerType] returning '0' as column: PRIORITY12_3_<br/>11:18:21,813 FST | [LongType] returning '50009' as column: HISACTINST13_3_<br/>11:18:21,813 FST | [LongType] returning null as column: PARENT14_3_<br/>11:18:21,813 FST | [LongType] returning '50007' as column: INSTANCE15_3_<br/>11:18:21,813 FST | [LongType] returning null as column: SUPEREXEC16_3_<br/>11:18:21,813 FST | [LongType] returning null as column: SUBPROC17_3_<br/>11:18:21,813 FIN | [SQL] select executions0_.PARENT_ as PARENT14_1_, executions0_.DBID_ as DBID1_1_, executions0_.PARENT_IDX_ as PARENT18_1_, executions0_.DBID_ as DBID1_3_0_, executions0_.DBVERSION_ as DBVERSION3_3_0_, executions0_.ACTIVITYNAME_ as ACTIVITY4_3_0_, executions0_.PROCDEFID_ as PROCDEFID5_3_0_, executions0_.HASVARS_ as HASVARS6_3_0_, executions0_.NAME_ as NAME7_3_0_, executions0_.KEY_ as KEY8_3_0_, executions0_.ID_ as ID9_3_0_, executions0_.STATE_ as STATE10_3_0_, executions0_.SUSPHISTSTATE_ as SUSPHIS11_3_0_, executions0_.PRIORITY_ as PRIORITY12_3_0_, executions0_.HISACTINST_ as HISACTINST13_3_0_, executions0_.PARENT_ as PARENT14_3_0_, executions0_.INSTANCE_ as INSTANCE15_3_0_, executions0_.SUPEREXEC_ as SUPEREXEC16_3_0_, executions0_.SUBPROCINST_ as SUBPROC17_3_0_ from JBPM4_EXECUTION executions0_ where executions0_.PARENT_=?<br/>Hibernate: select executions0_.PARENT_ as PARENT14_1_, executions0_.DBID_ as DBID1_1_, executions0_.PARENT_IDX_ as PARENT18_1_, executions0_.DBID_ as DBID1_3_0_, executions0_.DBVERSION_ as DBVERSION3_3_0_, executions0_.ACTIVITYNAME_ as ACTIVITY4_3_0_, executions0_.PROCDEFID_ as PROCDEFID5_3_0_, executions0_.HASVARS_ as HASVARS6_3_0_, executions0_.NAME_ as NAME7_3_0_, executions0_.KEY_ as KEY8_3_0_, executions0_.ID_ as ID9_3_0_, executions0_.STATE_ as STATE10_3_0_, executions0_.SUSPHISTSTATE_ as SUSPHIS11_3_0_, executions0_.PRIORITY_ as PRIORITY12_3_0_, executions0_.HISACTINST_ as HISACTINST13_3_0_, executions0_.PARENT_ as PARENT14_3_0_, executions0_.INSTANCE_ as INSTANCE15_3_0_, executions0_.SUPEREXEC_ as SUPEREXEC16_3_0_, executions0_.SUBPROCINST_ as SUBPROC17_3_0_ from JBPM4_EXECUTION executions0_ where executions0_.PARENT_=?<br/>11:18:21,813 FST | [LongType] binding '50007' to parameter: 1<br/>11:18:21,813 FIN | [SQL] select this_.DBID_ as DBID1_12_1_, this_.DBVERSION_ as DBVERSION3_12_1_, this_.NAME_ as NAME4_12_1_, this_.DESCR_ as DESCR5_12_1_, this_.STATE_ as STATE6_12_1_, this_.SUSPHISTSTATE_ as SUSPHIST7_12_1_, this_.ASSIGNEE_ as ASSIGNEE8_12_1_, this_.FORM_ as FORM9_12_1_, this_.PRIORITY_ as PRIORITY10_12_1_, this_.CREATE_ as CREATE11_12_1_, this_.DUEDATE_ as DUEDATE12_12_1_, this_.PROGRESS_ as PROGRESS13_12_1_, this_.SIGNALLING_ as SIGNALLING14_12_1_, this_.EXECUTION_ID_ as EXECUTION15_12_1_, this_.ACTIVITY_NAME_ as ACTIVITY16_12_1_, this_.HASVARS_ as HASVARS17_12_1_, this_.SUPERTASK_ as SUPERTASK18_12_1_, this_.EXECUTION_ as EXECUTION19_12_1_, this_.PROCINST_ as PROCINST20_12_1_, this_.SWIMLANE_ as SWIMLANE21_12_1_, this_.TASKDEFNAME_ as TASKDEF22_12_1_, pi1_.DBID_ as DBID1_3_0_, pi1_.DBVERSION_ as DBVERSION3_3_0_, pi1_.ACTIVITYNAME_ as ACTIVITY4_3_0_, pi1_.PROCDEFID_ as PROCDEFID5_3_0_, pi1_.HASVARS_ as HASVARS6_3_0_, pi1_.NAME_ as NAME7_3_0_, pi1_.KEY_ as KEY8_3_0_, pi1_.ID_ as ID9_3_0_, pi1_.STATE_ as STATE10_3_0_, pi1_.SUSPHISTSTATE_ as SUSPHIS11_3_0_, pi1_.PRIORITY_ as PRIORITY12_3_0_, pi1_.HISACTINST_ as HISACTINST13_3_0_, pi1_.PARENT_ as PARENT14_3_0_, pi1_.INSTANCE_ as INSTANCE15_3_0_, pi1_.SUPEREXEC_ as SUPEREXEC16_3_0_, pi1_.SUBPROCINST_ as SUBPROC17_3_0_ from JBPM4_TASK this_ inner join JBPM4_EXECUTION pi1_ on this_.PROCINST_=pi1_.DBID_ where pi1_.ID_=?<br/>Hibernate: select this_.DBID_ as DBID1_12_1_, this_.DBVERSION_ as DBVERSION3_12_1_, this_.NAME_ as NAME4_12_1_, this_.DESCR_ as DESCR5_12_1_, this_.STATE_ as STATE6_12_1_, this_.SUSPHISTSTATE_ as SUSPHIST7_12_1_, this_.ASSIGNEE_ as ASSIGNEE8_12_1_, this_.FORM_ as FORM9_12_1_, this_.PRIORITY_ as PRIORITY10_12_1_, this_.CREATE_ as CREATE11_12_1_, this_.DUEDATE_ as DUEDATE12_12_1_, this_.PROGRESS_ as PROGRESS13_12_1_, this_.SIGNALLING_ as SIGNALLING14_12_1_, this_.EXECUTION_ID_ as EXECUTION15_12_1_, this_.ACTIVITY_NAME_ as ACTIVITY16_12_1_, this_.HASVARS_ as HASVARS17_12_1_, this_.SUPERTASK_ as SUPERTASK18_12_1_, this_.EXECUTION_ as EXECUTION19_12_1_, this_.PROCINST_ as PROCINST20_12_1_, this_.SWIMLANE_ as SWIMLANE21_12_1_, this_.TASKDEFNAME_ as TASKDEF22_12_1_, pi1_.DBID_ as DBID1_3_0_, pi1_.DBVERSION_ as DBVERSION3_3_0_, pi1_.ACTIVITYNAME_ as ACTIVITY4_3_0_, pi1_.PROCDEFID_ as PROCDEFID5_3_0_, pi1_.HASVARS_ as HASVARS6_3_0_, pi1_.NAME_ as NAME7_3_0_, pi1_.KEY_ as KEY8_3_0_, pi1_.ID_ as ID9_3_0_, pi1_.STATE_ as STATE10_3_0_, pi1_.SUSPHISTSTATE_ as SUSPHIS11_3_0_, pi1_.PRIORITY_ as PRIORITY12_3_0_, pi1_.HISACTINST_ as HISACTINST13_3_0_, pi1_.PARENT_ as PARENT14_3_0_, pi1_.INSTANCE_ as INSTANCE15_3_0_, pi1_.SUPEREXEC_ as SUPEREXEC16_3_0_, pi1_.SUBPROCINST_ as SUBPROC17_3_0_ from JBPM4_TASK this_ inner join JBPM4_EXECUTION pi1_ on this_.PROCINST_=pi1_.DBID_ where pi1_.ID_=?<br/>11:18:21,813 FST | [StringType] binding 'sp.50007' to parameter: 1<br/>11:18:21,813 FIN | [SQL] select this_.DBID_ as DBID1_6_1_, this_.DBVERSION_ as DBVERSION3_6_1_, this_.DUEDATE_ as DUEDATE4_6_1_, this_.STATE_ as STATE5_6_1_, this_.ISEXCLUSIVE_ as ISEXCLUS6_6_1_, this_.LOCKOWNER_ as LOCKOWNER7_6_1_, this_.LOCKEXPTIME_ as LOCKEXPT8_6_1_, this_.EXCEPTION_ as EXCEPTION9_6_1_, this_.RETRIES_ as RETRIES10_6_1_, this_.PROCESSINSTANCE_ as PROCESS11_6_1_, this_.EXECUTION_ as EXECUTION12_6_1_, this_.CFG_ as CFG13_6_1_, this_.SIGNAL_ as SIGNAL14_6_1_, this_.EVENT_ as EVENT15_6_1_, this_.REPEAT_ as REPEAT16_6_1_, this_.CLASS_ as CLASS2_6_1_, pi1_.DBID_ as DBID1_3_0_, pi1_.DBVERSION_ as DBVERSION3_3_0_, pi1_.ACTIVITYNAME_ as ACTIVITY4_3_0_, pi1_.PROCDEFID_ as PROCDEFID5_3_0_, pi1_.HASVARS_ as HASVARS6_3_0_, pi1_.NAME_ as NAME7_3_0_, pi1_.KEY_ as KEY8_3_0_, pi1_.ID_ as ID9_3_0_, pi1_.STATE_ as STATE10_3_0_, pi1_.SUSPHISTSTATE_ as SUSPHIS11_3_0_, pi1_.PRIORITY_ as PRIORITY12_3_0_, pi1_.HISACTINST_ as HISACTINST13_3_0_, pi1_.PARENT_ as PARENT14_3_0_, pi1_.INSTANCE_ as INSTANCE15_3_0_, pi1_.SUPEREXEC_ as SUPEREXEC16_3_0_, pi1_.SUBPROCINST_ as SUBPROC17_3_0_ from JBPM4_JOB this_ inner join JBPM4_EXECUTION pi1_ on this_.PROCESSINSTANCE_=pi1_.DBID_ where pi1_.ID_=?<br/>Hibernate: select this_.DBID_ as DBID1_6_1_, this_.DBVERSION_ as DBVERSION3_6_1_, this_.DUEDATE_ as DUEDATE4_6_1_, this_.STATE_ as STATE5_6_1_, this_.ISEXCLUSIVE_ as ISEXCLUS6_6_1_, this_.LOCKOWNER_ as LOCKOWNER7_6_1_, this_.LOCKEXPTIME_ as LOCKEXPT8_6_1_, this_.EXCEPTION_ as EXCEPTION9_6_1_, this_.RETRIES_ as RETRIES10_6_1_, this_.PROCESSINSTANCE_ as PROCESS11_6_1_, this_.EXECUTION_ as EXECUTION12_6_1_, this_.CFG_ as CFG13_6_1_, this_.SIGNAL_ as SIGNAL14_6_1_, this_.EVENT_ as EVENT15_6_1_, this_.REPEAT_ as REPEAT16_6_1_, this_.CLASS_ as CLASS2_6_1_, pi1_.DBID_ as DBID1_3_0_, pi1_.DBVERSION_ as DBVERSION3_3_0_, pi1_.ACTIVITYNAME_ as ACTIVITY4_3_0_, pi1_.PROCDEFID_ as PROCDEFID5_3_0_, pi1_.HASVARS_ as HASVARS6_3_0_, pi1_.NAME_ as NAME7_3_0_, pi1_.KEY_ as KEY8_3_0_, pi1_.ID_ as ID9_3_0_, pi1_.STATE_ as STATE10_3_0_, pi1_.SUSPHISTSTATE_ as SUSPHIS11_3_0_, pi1_.PRIORITY_ as PRIORITY12_3_0_, pi1_.HISACTINST_ as HISACTINST13_3_0_, pi1_.PARENT_ as PARENT14_3_0_, pi1_.INSTANCE_ as INSTANCE15_3_0_, pi1_.SUPEREXEC_ as SUPEREXEC16_3_0_, pi1_.SUBPROCINST_ as SUBPROC17_3_0_ from JBPM4_JOB this_ inner join JBPM4_EXECUTION pi1_ on this_.PROCESSINSTANCE_=pi1_.DBID_ where pi1_.ID_=?<br/>11:18:21,813 FST | [StringType] binding 'sp.50007' to parameter: 1<br/>11:18:21,828 FIN | [DbSessionImpl] Deleting process instance sp.50007<br/>11:18:21,828 FIN | [SQL] select variables0_.EXECUTION_ as EXECUTION7_1_, variables0_.DBID_ as DBID1_1_, variables0_.KEY_ as KEY4_1_, variables0_.DBID_ as DBID1_4_0_, variables0_.DBVERSION_ as DBVERSION3_4_0_, variables0_.KEY_ as KEY4_4_0_, variables0_.CONVERTER_ as CONVERTER5_4_0_, variables0_.HIST_ as HIST6_4_0_, variables0_.EXECUTION_ as EXECUTION7_4_0_, variables0_.TASK_ as TASK8_4_0_, variables0_.LOB_ as LOB9_4_0_, variables0_.DATE_VALUE_ as DATE10_4_0_, variables0_.DOUBLE_VALUE_ as DOUBLE11_4_0_, variables0_.CLASSNAME_ as CLASSNAME12_4_0_, variables0_.LONG_VALUE_ as LONG13_4_0_, variables0_.STRING_VALUE_ as STRING14_4_0_, variables0_.TEXT_VALUE_ as TEXT15_4_0_, variables0_.CLASS_ as CLASS2_4_0_ from JBPM4_VARIABLE variables0_ where variables0_.EXECUTION_=?<br/>Hibernate: select variables0_.EXECUTION_ as EXECUTION7_1_, variables0_.DBID_ as DBID1_1_, variables0_.KEY_ as KEY4_1_, variables0_.DBID_ as DBID1_4_0_, variables0_.DBVERSION_ as DBVERSION3_4_0_, variables0_.KEY_ as KEY4_4_0_, variables0_.CONVERTER_ as CONVERTER5_4_0_, variables0_.HIST_ as HIST6_4_0_, variables0_.EXECUTION_ as EXECUTION7_4_0_, variables0_.TASK_ as TASK8_4_0_, variables0_.LOB_ as LOB9_4_0_, variables0_.DATE_VALUE_ as DATE10_4_0_, variables0_.DOUBLE_VALUE_ as DOUBLE11_4_0_, variables0_.CLASSNAME_ as CLASSNAME12_4_0_, variables0_.LONG_VALUE_ as LONG13_4_0_, variables0_.STRING_VALUE_ as STRING14_4_0_, variables0_.TEXT_VALUE_ as TEXT15_4_0_, variables0_.CLASS_ as CLASS2_4_0_ from JBPM4_VARIABLE variables0_ where variables0_.EXECUTION_=?<br/>11:18:21,828 FST | [LongType] binding '50007' to parameter: 1<br/>11:18:21,828 FIN | [SQL] select systemvari0_.EXESYS_ as EXESYS16_1_, systemvari0_.DBID_ as DBID1_1_, systemvari0_.KEY_ as KEY4_1_, systemvari0_.DBID_ as DBID1_4_0_, systemvari0_.DBVERSION_ as DBVERSION3_4_0_, systemvari0_.KEY_ as KEY4_4_0_, systemvari0_.CONVERTER_ as CONVERTER5_4_0_, systemvari0_.HIST_ as HIST6_4_0_, systemvari0_.EXECUTION_ as EXECUTION7_4_0_, systemvari0_.TASK_ as TASK8_4_0_, systemvari0_.LOB_ as LOB9_4_0_, systemvari0_.DATE_VALUE_ as DATE10_4_0_, systemvari0_.DOUBLE_VALUE_ as DOUBLE11_4_0_, systemvari0_.CLASSNAME_ as CLASSNAME12_4_0_, systemvari0_.LONG_VALUE_ as LONG13_4_0_, systemvari0_.STRING_VALUE_ as STRING14_4_0_, systemvari0_.TEXT_VALUE_ as TEXT15_4_0_, systemvari0_.CLASS_ as CLASS2_4_0_ from JBPM4_VARIABLE systemvari0_ where systemvari0_.EXESYS_=?<br/>Hibernate: select systemvari0_.EXESYS_ as EXESYS16_1_, systemvari0_.DBID_ as DBID1_1_, systemvari0_.KEY_ as KEY4_1_, systemvari0_.DBID_ as DBID1_4_0_, systemvari0_.DBVERSION_ as DBVERSION3_4_0_, systemvari0_.KEY_ as KEY4_4_0_, systemvari0_.CONVERTER_ as CONVERTER5_4_0_, systemvari0_.HIST_ as HIST6_4_0_, systemvari0_.EXECUTION_ as EXECUTION7_4_0_, systemvari0_.TASK_ as TASK8_4_0_, systemvari0_.LOB_ as LOB9_4_0_, systemvari0_.DATE_VALUE_ as DATE10_4_0_, systemvari0_.DOUBLE_VALUE_ as DOUBLE11_4_0_, systemvari0_.CLASSNAME_ as CLASSNAME12_4_0_, systemvari0_.LONG_VALUE_ as LONG13_4_0_, systemvari0_.STRING_VALUE_ as STRING14_4_0_, systemvari0_.TEXT_VALUE_ as TEXT15_4_0_, systemvari0_.CLASS_ as CLASS2_4_0_ from JBPM4_VARIABLE systemvari0_ where systemvari0_.EXESYS_=?<br/>11:18:21,828 FST | [LongType] binding '50007' to parameter: 1<br/>11:18:21,828 FIN | [SQL] select swimlanes0_.EXECUTION_ as EXECUTION5_1_, swimlanes0_.DBID_ as DBID1_1_, swimlanes0_.NAME_ as NAME3_1_, swimlanes0_.DBID_ as DBID1_14_0_, swimlanes0_.DBVERSION_ as DBVERSION2_14_0_, swimlanes0_.NAME_ as NAME3_14_0_, swimlanes0_.ASSIGNEE_ as ASSIGNEE4_14_0_, swimlanes0_.EXECUTION_ as EXECUTION5_14_0_ from JBPM4_SWIMLANE swimlanes0_ where swimlanes0_.EXECUTION_=?<br/>Hibernate: select swimlanes0_.EXECUTION_ as EXECUTION5_1_, swimlanes0_.DBID_ as DBID1_1_, swimlanes0_.NAME_ as NAME3_1_, swimlanes0_.DBID_ as DBID1_14_0_, swimlanes0_.DBVERSION_ as DBVERSION2_14_0_, swimlanes0_.NAME_ as NAME3_14_0_, swimlanes0_.ASSIGNEE_ as ASSIGNEE4_14_0_, swimlanes0_.EXECUTION_ as EXECUTION5_14_0_ from JBPM4_SWIMLANE swimlanes0_ where swimlanes0_.EXECUTION_=?<br/>11:18:21,828 FST | [LongType] binding '50007' to parameter: 1<br/>11:18:21,828 FIN | [SQL] update JBPM4_HIST_ACTINST set HPROCI_=null where HPROCI_=?<br/>Hibernate: update JBPM4_HIST_ACTINST set HPROCI_=null where HPROCI_=?<br/>11:18:21,828 FST | [LongType] binding '50007' to parameter: 1<br/>11:18:21,828 FIN | [SQL] delete from JBPM4_HIST_ACTINST where DBID_=? and DBVERSION_=?<br/>Hibernate: delete from JBPM4_HIST_ACTINST where DBID_=? and DBVERSION_=?<br/>11:18:21,828 FST | [LongType] binding '50008' to parameter: 1<br/>11:18:21,828 FST | [IntegerType] binding '1' to parameter: 2<br/>11:18:21,828 FIN | [SQL] delete from JBPM4_HIST_ACTINST where DBID_=? and DBVERSION_=?<br/>Hibernate: delete from JBPM4_HIST_ACTINST where DBID_=? and DBVERSION_=?<br/>11:18:21,828 FST | [LongType] binding '50009' to parameter: 1<br/>11:18:21,828 FST | [IntegerType] binding '0' to parameter: 2<br/>11:18:21,828 FIN | [SQL] delete from JBPM4_HIST_PROCINST where DBID_=? and DBVERSION_=?<br/>Hibernate: delete from JBPM4_HIST_PROCINST where DBID_=? and DBVERSION_=?<br/>11:18:21,828 FST | [LongType] binding '50007' to parameter: 1<br/>11:18:21,828 FST | [IntegerType] binding '0' to parameter: 2<br/>11:18:21,828 FIN | [SQL] delete from JBPM4_EXECUTION where DBID_=? and DBVERSION_=?<br/>Hibernate: delete from JBPM4_EXECUTION where DBID_=? and DBVERSION_=?<br/>11:18:21,828 FST | [LongType] binding '50007' to parameter: 1<br/>11:18:21,828 FST | [IntegerType] binding '2' to parameter: 2<br/>11:18:21,844 WRN | [JDBCExceptionReporter] SQL Error: 1451, SQLState: 23000<br/>11:18:21,844 SEV | [JDBCExceptionReporter] Cannot delete or update a parent row: a foreign key constraint fails (`jbpmdb`.`jbpm4_execution`, CONSTRAINT `FK_EXEC_INSTANCE` FOREIGN KEY (`INSTANCE_`) REFERENCES `jbpm4_execution` (`DBID_`))<br/>### EXCEPTION ###########################################<br/>11:18:21,844 SEV | [AbstractFlushingEventListener] Could not synchronize database state with session<br/>org.hibernate.exception.ConstraintViolationException: could not delete: [org.jbpm.pvm.internal.model.ExecutionImpl#50007]<br/> at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)<br/> at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)<br/> at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2569)<br/> at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2725)<br/> at org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:97)<br/> at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)<br/> at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)<br/> at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:172)<br/> at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)<br/> at org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:64)<br/> at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:996)<br/> at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1589)<br/> at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:306)<br/> at org.jbpm.pvm.internal.hibernate.DbSessionImpl.deleteProcessDefinitionHistory(DbSessionImpl.java:113)<br/> at org.jbpm.pvm.internal.cmd.DeleteDeploymentCmd.execute(DeleteDeploymentCmd.java:76)<br/> at org.jbpm.pvm.internal.svc.DefaultCommandService.execute(DefaultCommandService.java:42)<br/> at org.jbpm.pvm.internal.tx.StandardTransactionInterceptor.execute(StandardTransactionInterceptor.java:50)<br/> at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.executeInNewEnvironment(EnvironmentInterceptor.java:53)<br/> at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:40)<br/> at org.jbpm.pvm.internal.svc.RetryInterceptor.execute(RetryInterceptor.java:56)<br/> at org.jbpm.pvm.internal.svc.SkipInterceptor.execute(SkipInterceptor.java:43)<br/> at org.jbpm.pvm.internal.repository.RepositoryServiceImpl.deleteDeploymentCascade(RepositoryServiceImpl.java:71)<br/> at com.mhgadm.za.sample.SampleProcessTest.deleteProcessDefinitation(SampleProcessTest.java:53)<br/> at com.mhgadm.za.sample.SampleProcessTest.main(SampleProcessTest.java:45)<br/>Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (`jbpmdb`.`jbpm4_execution`, CONSTRAINT `FK_EXEC_INSTANCE` FOREIGN KEY (`INSTANCE_`) REFERENCES `jbpm4_execution` (`DBID_`))<br/> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)<br/> at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)<br/> at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)<br/> at java.lang.reflect.Constructor.newInstance(Unknown Source)<br/> at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)<br/> at com.mysql.jdbc.Util.getInstance(Util.java:381)<br/> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015)<br/> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)<br/> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3536)<br/> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3468)<br/> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1957)<br/> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2107)<br/> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2648)<br/> at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2086)<br/> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2371)<br/> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2289)<br/> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2274)<br/> at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2551)<br/> ... 21 more<br/>### EXCEPTION ###########################################<br/>### EXCEPTION ###########################################<br/>11:18:21,844 INF | [DefaultCommandService] exception while executing command <a class="jive-link-external-small" href="mailto:org.jbpm.pvm.internal.cmd.DeleteDeploymentCmd@44a9a32c">org.jbpm.pvm.internal.cmd.DeleteDeploymentCmd@44a9a32c</a><br/>org.hibernate.exception.ConstraintViolationException: could not delete: [org.jbpm.pvm.internal.model.ExecutionImpl#50007]<br/> at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)<br/> at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)<br/> at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2569)<br/> at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2725)<br/> at org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:97)<br/> at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)<br/> at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)<br/> at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:172)<br/> at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)<br/> at org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:64)<br/> at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:996)<br/> at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1589)<br/> at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:306)<br/> at org.jbpm.pvm.internal.hibernate.DbSessionImpl.deleteProcessDefinitionHistory(DbSessionImpl.java:113)<br/> at org.jbpm.pvm.internal.cmd.DeleteDeploymentCmd.execute(DeleteDeploymentCmd.java:76)<br/> at org.jbpm.pvm.internal.svc.DefaultCommandService.execute(DefaultCommandService.java:42)<br/> at org.jbpm.pvm.internal.tx.StandardTransactionInterceptor.execute(StandardTransactionInterceptor.java:50)<br/> at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.executeInNewEnvironment(EnvironmentInterceptor.java:53)<br/> at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:40)<br/> at org.jbpm.pvm.internal.svc.RetryInterceptor.execute(RetryInterceptor.java:56)<br/> at org.jbpm.pvm.internal.svc.SkipInterceptor.execute(SkipInterceptor.java:43)<br/> at org.jbpm.pvm.internal.repository.RepositoryServiceImpl.deleteDeploymentCascade(RepositoryServiceImpl.java:71)<br/> at com.mhgadm.za.sample.SampleProcessTest.deleteProcessDefinitation(SampleProcessTest.java:53)<br/> at com.mhgadm.za.sample.SampleProcessTest.main(SampleProcessTest.java:45)<br/>Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (`jbpmdb`.`jbpm4_execution`, CONSTRAINT `FK_EXEC_INSTANCE` FOREIGN KEY (`INSTANCE_`) REFERENCES `jbpm4_execution` (`DBID_`))<br/> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)<br/> at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)<br/> at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)<br/> at java.lang.reflect.Constructor.newInstance(Unknown Source)<br/> at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)<br/> at com.mysql.jdbc.Util.getInstance(Util.java:381)<br/> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015)<br/> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)<br/> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3536)<br/> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3468)<br/> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1957)<br/> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2107)<br/> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2648)<br/> at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2086)<br/> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2371)<br/> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2289)<br/> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2274)<br/> at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2551)<br/> ... 21 more<br/>### EXCEPTION ###########################################<br/>11:18:21,844 FIN | [HibernateSessionResource] ----- rolling back hibernate tx 1561837803 -----------------------------------------------------<br/>Exception in thread "main" org.hibernate.exception.ConstraintViolationException: could not delete: [org.jbpm.pvm.internal.model.ExecutionImpl#50007]<br/> at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)<br/> at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)<br/> at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2569)<br/> at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2725)<br/> at org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:97)<br/> at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)<br/> at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)<br/> at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:172)<br/> at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)<br/> at org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:64)<br/> at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:996)<br/> at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1589)<br/> at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:306)<br/> at org.jbpm.pvm.internal.hibernate.DbSessionImpl.deleteProcessDefinitionHistory(DbSessionImpl.java:113)<br/> at org.jbpm.pvm.internal.cmd.DeleteDeploymentCmd.execute(DeleteDeploymentCmd.java:76)<br/> at org.jbpm.pvm.internal.svc.DefaultCommandService.execute(DefaultCommandService.java:42)<br/> at org.jbpm.pvm.internal.tx.StandardTransactionInterceptor.execute(StandardTransactionInterceptor.java:50)<br/> at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.executeInNewEnvironment(EnvironmentInterceptor.java:53)<br/> at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:40)<br/> at org.jbpm.pvm.internal.svc.RetryInterceptor.execute(RetryInterceptor.java:56)<br/> at org.jbpm.pvm.internal.svc.SkipInterceptor.execute(SkipInterceptor.java:43)<br/> at org.jbpm.pvm.internal.repository.RepositoryServiceImpl.deleteDeploymentCascade(RepositoryServiceImpl.java:71)<br/> at com.mhgadm.za.sample.SampleProcessTest.deleteProcessDefinitation(SampleProcessTest.java:53)<br/> at com.mhgadm.za.sample.SampleProcessTest.main(SampleProcessTest.java:45)<br/>Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (`jbpmdb`.`jbpm4_execution`, CONSTRAINT `FK_EXEC_INSTANCE` FOREIGN KEY (`INSTANCE_`) REFERENCES `jbpm4_execution` (`DBID_`))<br/> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)<br/> at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)<br/> at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)<br/> at java.lang.reflect.Constructor.newInstance(Unknown Source)<br/> at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)<br/> at com.mysql.jdbc.Util.getInstance(Util.java:381)<br/> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015)<br/> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)<br/> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3536)<br/> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3468)<br/> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1957)<br/> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2107)<br/> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2648)<br/> at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2086)<br/> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2371)<br/> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2289)<br/> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2274)<br/> at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2551)<br/> ... 21 more</p><p>=== Debug logs ==============================<br/>11:20:17,794 FIN | [SQL] select objectprop0_.DEPLOYMENT_ as DEPLOYMENT2_1_, objectprop0_.DBID_ as DBID1_1_, objectprop0_.DBID_ as DBID1_1_0_, objectprop0_.DEPLOYMENT_ as DEPLOYMENT2_1_0_, objectprop0_.OBJNAME_ as OBJNAME3_1_0_, objectprop0_.KEY_ as KEY4_1_0_, objectprop0_.STRINGVAL_ as STRINGVAL5_1_0_, objectprop0_.LONGVAL_ as LONGVAL6_1_0_ from JBPM4_DEPLOYPROP objectprop0_ where objectprop0_.DEPLOYMENT_=?<br/>Hibernate: select objectprop0_.DEPLOYMENT_ as DEPLOYMENT2_1_, objectprop0_.DBID_ as DBID1_1_, objectprop0_.DBID_ as DBID1_1_0_, objectprop0_.DEPLOYMENT_ as DEPLOYMENT2_1_0_, objectprop0_.OBJNAME_ as OBJNAME3_1_0_, objectprop0_.KEY_ as KEY4_1_0_, objectprop0_.STRINGVAL_ as STRINGVAL5_1_0_, objectprop0_.LONGVAL_ as LONGVAL6_1_0_ from JBPM4_DEPLOYPROP objectprop0_ where objectprop0_.DEPLOYMENT_=?<br/>11:20:17,794 FST | [LongType] binding '30001' to parameter: 1<br/>11:20:17,794 FST | [LongType] returning '30003' as column: DBID1_1_0_<br/>11:20:17,794 FST | [LongType] returning '30001' as column: DEPLOYMENT2_1_0_<br/>11:20:17,794 FST | [StringType] returning 'sampleprocess' as column: OBJNAME3_1_0_<br/>11:20:17,794 FST | [StringType] returning 'langid' as column: KEY4_1_0_<br/>11:20:17,794 FST | [StringType] returning 'jpdl-4.4' as column: STRINGVAL5_1_0_<br/>11:20:17,794 FST | [LongType] returning null as column: LONGVAL6_1_0_<br/>11:20:17,794 FST | [LongType] returning '30001' as column: DEPLOYMENT2_1_<br/>11:20:17,794 FST | [LongType] returning '30003' as column: DBID1_1_<br/>11:20:17,794 FST | [LongType] returning '30004' as column: DBID1_1_0_<br/>11:20:17,794 FST | [LongType] returning '30001' as column: DEPLOYMENT2_1_0_<br/>11:20:17,794 FST | [StringType] returning 'sampleprocess' as column: OBJNAME3_1_0_<br/>11:20:17,794 FST | [StringType] returning 'pdid' as column: KEY4_1_0_<br/>11:20:17,794 FST | [StringType] returning 'sp-2' as column: STRINGVAL5_1_0_<br/>11:20:17,794 FST | [LongType] returning null as column: LONGVAL6_1_0_<br/>11:20:17,794 FST | [LongType] returning '30001' as column: DEPLOYMENT2_1_<br/>11:20:17,794 FST | [LongType] returning '30004' as column: DBID1_1_<br/>11:20:17,794 FST | [LongType] returning '30005' as column: DBID1_1_0_<br/>11:20:17,809 FST | [LongType] returning '30001' as column: DEPLOYMENT2_1_0_<br/>11:20:17,809 FST | [StringType] returning 'sampleprocess' as column: OBJNAME3_1_0_<br/>11:20:17,809 FST | [StringType] returning 'pdkey' as column: KEY4_1_0_<br/>11:20:17,809 FST | [StringType] returning 'sp' as column: STRINGVAL5_1_0_<br/>11:20:17,809 FST | [LongType] returning null as column: LONGVAL6_1_0_<br/>11:20:17,809 FST | [LongType] returning '30001' as column: DEPLOYMENT2_1_<br/>11:20:17,809 FST | [LongType] returning '30005' as column: DBID1_1_<br/>11:20:17,809 FST | [LongType] returning '30006' as column: DBID1_1_0_<br/>11:20:17,809 FST | [LongType] returning '30001' as column: DEPLOYMENT2_1_0_<br/>11:20:17,809 FST | [StringType] returning 'sampleprocess' as column: OBJNAME3_1_0_<br/>11:20:17,809 FST | [StringType] returning 'pdversion' as column: KEY4_1_0_<br/>11:20:17,809 FST | [StringType] returning null as column: STRINGVAL5_1_0_<br/>11:20:17,809 FST | [LongType] returning '2' as column: LONGVAL6_1_0_<br/>11:20:17,809 FST | [LongType] returning '30001' as column: DEPLOYMENT2_1_<br/>11:20:17,809 FST | [LongType] returning '30006' as column: DBID1_1_<br/>11:20:17,809 FIN | [SQL] select deployment0_.DBID_ as DBID1_0_0_, deployment0_.NAME_ as NAME2_0_0_, deployment0_.TIMESTAMP_ as TIMESTAMP3_0_0_, deployment0_.STATE_ as STATE4_0_0_ from JBPM4_DEPLOYMENT deployment0_ where deployment0_.DBID_=?<br/>Hibernate: select deployment0_.DBID_ as DBID1_0_0_, deployment0_.NAME_ as NAME2_0_0_, deployment0_.TIMESTAMP_ as TIMESTAMP3_0_0_, deployment0_.STATE_ as STATE4_0_0_ from JBPM4_DEPLOYMENT deployment0_ where deployment0_.DBID_=?<br/>11:20:17,809 FST | [LongType] binding '40001' to parameter: 1<br/>11:20:17,809 FST | [TextType] returning null as column: NAME2_0_0_<br/>11:20:17,809 FST | [LongType] returning '0' as column: TIMESTAMP3_0_0_<br/>11:20:17,809 FST | [StringType] returning 'active' as column: STATE4_0_0_<br/>11:20:17,809 FIN | [SQL] select resources0_.DEPLOYMENT_ as DEPLOYMENT4_1_, resources0_.DBID_ as DBID1_1_, resources0_.NAME_ as NAME5_1_, resources0_.DBID_ as DBID1_5_0_, resources0_.DBVERSION_ as DBVERSION2_5_0_, resources0_.BLOB_VALUE_ as BLOB3_5_0_ from JBPM4_LOB resources0_ where resources0_.DEPLOYMENT_=?<br/>Hibernate: select resources0_.DEPLOYMENT_ as DEPLOYMENT4_1_, resources0_.DBID_ as DBID1_1_, resources0_.NAME_ as NAME5_1_, resources0_.DBID_ as DBID1_5_0_, resources0_.DBVERSION_ as DBVERSION2_5_0_, resources0_.BLOB_VALUE_ as BLOB3_5_0_ from JBPM4_LOB resources0_ where resources0_.DEPLOYMENT_=?<br/>11:20:17,809 FST | [LongType] binding '40001' to parameter: 1<br/>11:20:17,809 FST | [LongType] returning '40002' as column: DBID1_5_0_<br/>11:20:17,809 FST | [IntegerType] returning '0' as column: DBVERSION2_5_0_<br/>11:20:17,809 FST | [LongType] returning '40001' as column: DEPLOYMENT4_1_<br/>11:20:17,809 FST | [LongType] returning '40002' as column: DBID1_1_<br/>11:20:17,809 FST | [TextType] returning 'com/mhgadm/za/sample/sampleprocess.jpdl.xml' as column: NAME5_1_<br/>11:20:17,887 FIN | [SQL] select objectprop0_.DEPLOYMENT_ as DEPLOYMENT2_1_, objectprop0_.DBID_ as DBID1_1_, objectprop0_.DBID_ as DBID1_1_0_, objectprop0_.DEPLOYMENT_ as DEPLOYMENT2_1_0_, objectprop0_.OBJNAME_ as OBJNAME3_1_0_, objectprop0_.KEY_ as KEY4_1_0_, objectprop0_.STRINGVAL_ as STRINGVAL5_1_0_, objectprop0_.LONGVAL_ as LONGVAL6_1_0_ from JBPM4_DEPLOYPROP objectprop0_ where objectprop0_.DEPLOYMENT_=?<br/>Hibernate: select objectprop0_.DEPLOYMENT_ as DEPLOYMENT2_1_, objectprop0_.DBID_ as DBID1_1_, objectprop0_.DBID_ as DBID1_1_0_, objectprop0_.DEPLOYMENT_ as DEPLOYMENT2_1_0_, objectprop0_.OBJNAME_ as OBJNAME3_1_0_, objectprop0_.KEY_ as KEY4_1_0_, objectprop0_.STRINGVAL_ as STRINGVAL5_1_0_, objectprop0_.LONGVAL_ as LONGVAL6_1_0_ from JBPM4_DEPLOYPROP objectprop0_ where objectprop0_.DEPLOYMENT_=?<br/>11:20:17,887 FST | [LongType] binding '40001' to parameter: 1<br/>11:20:17,903 FST | [LongType] returning '40003' as column: DBID1_1_0_<br/>11:20:17,903 FST | [LongType] returning '40001' as column: DEPLOYMENT2_1_0_<br/>11:20:17,903 FST | [StringType] returning 'sampleprocess' as column: OBJNAME3_1_0_<br/>11:20:17,903 FST | [StringType] returning 'langid' as column: KEY4_1_0_<br/>11:20:17,903 FST | [StringType] returning 'jpdl-4.4' as column: STRINGVAL5_1_0_<br/>11:20:17,903 FST | [LongType] returning null as column: LONGVAL6_1_0_<br/>11:20:17,903 FST | [LongType] returning '40001' as column: DEPLOYMENT2_1_<br/>11:20:17,903 FST | [LongType] returning '40003' as column: DBID1_1_<br/>11:20:17,903 FST | [LongType] returning '40004' as column: DBID1_1_0_<br/>11:20:17,903 FST | [LongType] returning '40001' as column: DEPLOYMENT2_1_0_<br/>11:20:17,903 FST | [StringType] returning 'sampleprocess' as column: OBJNAME3_1_0_<br/>11:20:17,903 FST | [StringType] returning 'pdid' as column: KEY4_1_0_<br/>11:20:17,903 FST | [StringType] returning 'sp-3' as column: STRINGVAL5_1_0_<br/>11:20:17,903 FST | [LongType] returning null as column: LONGVAL6_1_0_<br/>11:20:17,903 FST | [LongType] returning '40001' as column: DEPLOYMENT2_1_<br/>11:20:17,903 FST | [LongType] returning '40004' as column: DBID1_1_<br/>11:20:17,903 FST | [LongType] returning '40005' as column: DBID1_1_0_<br/>11:20:17,903 FST | [LongType] returning '40001' as column: DEPLOYMENT2_1_0_<br/>11:20:17,903 FST | [StringType] returning 'sampleprocess' as column: OBJNAME3_1_0_<br/>11:20:17,903 FST | [StringType] returning 'pdkey' as column: KEY4_1_0_<br/>11:20:17,903 FST | [StringType] returning 'sp' as column: STRINGVAL5_1_0_<br/>11:20:17,903 FST | [LongType] returning null as column: LONGVAL6_1_0_<br/>11:20:17,903 FST | [LongType] returning '40001' as column: DEPLOYMENT2_1_<br/>11:20:17,903 FST | [LongType] returning '40005' as column: DBID1_1_<br/>11:20:17,903 FST | [LongType] returning '40006' as column: DBID1_1_0_<br/>11:20:17,903 FST | [LongType] returning '40001' as column: DEPLOYMENT2_1_0_<br/>11:20:17,903 FST | [StringType] returning 'sampleprocess' as column: OBJNAME3_1_0_<br/>11:20:17,903 FST | [StringType] returning 'pdversion' as column: KEY4_1_0_<br/>11:20:17,903 FST | [StringType] returning null as column: STRINGVAL5_1_0_<br/>11:20:17,903 FST | [LongType] returning '3' as column: LONGVAL6_1_0_<br/>11:20:17,903 FST | [LongType] returning '40001' as column: DEPLOYMENT2_1_<br/>11:20:17,903 FST | [LongType] returning '40006' as column: DBID1_1_<br/>11:20:17,903 FIN | [SQL] select deployment0_.DBID_ as DBID1_0_0_, deployment0_.NAME_ as NAME2_0_0_, deployment0_.TIMESTAMP_ as TIMESTAMP3_0_0_, deployment0_.STATE_ as STATE4_0_0_ from JBPM4_DEPLOYMENT deployment0_ where deployment0_.DBID_=?<br/>Hibernate: select deployment0_.DBID_ as DBID1_0_0_, deployment0_.NAME_ as NAME2_0_0_, deployment0_.TIMESTAMP_ as TIMESTAMP3_0_0_, deployment0_.STATE_ as STATE4_0_0_ from JBPM4_DEPLOYMENT deployment0_ where deployment0_.DBID_=?<br/>11:20:17,903 FST | [LongType] binding '50001' to parameter: 1<br/>11:20:17,903 FST | [TextType] returning null as column: NAME2_0_0_<br/>11:20:17,903 FST | [LongType] returning '0' as column: TIMESTAMP3_0_0_<br/>11:20:17,903 FST | [StringType] returning 'active' as column: STATE4_0_0_<br/>11:20:17,903 FIN | [SQL] select resources0_.DEPLOYMENT_ as DEPLOYMENT4_1_, resources0_.DBID_ as DBID1_1_, resources0_.NAME_ as NAME5_1_, resources0_.DBID_ as DBID1_5_0_, resources0_.DBVERSION_ as DBVERSION2_5_0_, resources0_.BLOB_VALUE_ as BLOB3_5_0_ from JBPM4_LOB resources0_ where resources0_.DEPLOYMENT_=?<br/>Hibernate: select resources0_.DEPLOYMENT_ as DEPLOYMENT4_1_, resources0_.DBID_ as DBID1_1_, resources0_.NAME_ as NAME5_1_, resources0_.DBID_ as DBID1_5_0_, resources0_.DBVERSION_ as DBVERSION2_5_0_, resources0_.BLOB_VALUE_ as BLOB3_5_0_ from JBPM4_LOB resources0_ where resources0_.DEPLOYMENT_=?<br/>11:20:17,903 FST | [LongType] binding '50001' to parameter: 1<br/>11:20:17,903 FST | [LongType] returning '50002' as column: DBID1_5_0_<br/>11:20:17,903 FST | [IntegerType] returning '0' as column: DBVERSION2_5_0_<br/>11:20:17,903 FST | [LongType] returning '50001' as column: DEPLOYMENT4_1_<br/>11:20:17,903 FST | [LongType] returning '50002' as column: DBID1_1_<br/>11:20:17,903 FST | [TextType] returning 'com/mhgadm/za/sample/sampleprocess.jpdl.xml' as column: NAME5_1_<br/>11:20:17,981 FIN | [SQL] select objectprop0_.DEPLOYMENT_ as DEPLOYMENT2_1_, objectprop0_.DBID_ as DBID1_1_, objectprop0_.DBID_ as DBID1_1_0_, objectprop0_.DEPLOYMENT_ as DEPLOYMENT2_1_0_, objectprop0_.OBJNAME_ as OBJNAME3_1_0_, objectprop0_.KEY_ as KEY4_1_0_, objectprop0_.STRINGVAL_ as STRINGVAL5_1_0_, objectprop0_.LONGVAL_ as LONGVAL6_1_0_ from JBPM4_DEPLOYPROP objectprop0_ where objectprop0_.DEPLOYMENT_=?<br/>Hibernate: select objectprop0_.DEPLOYMENT_ as DEPLOYMENT2_1_, objectprop0_.DBID_ as DBID1_1_, objectprop0_.DBID_ as DBID1_1_0_, objectprop0_.DEPLOYMENT_ as DEPLOYMENT2_1_0_, objectprop0_.OBJNAME_ as OBJNAME3_1_0_, objectprop0_.KEY_ as KEY4_1_0_, objectprop0_.STRINGVAL_ as STRINGVAL5_1_0_, objectprop0_.LONGVAL_ as LONGVAL6_1_0_ from JBPM4_DEPLOYPROP objectprop0_ where objectprop0_.DEPLOYMENT_=?<br/>11:20:17,981 FST | [LongType] binding '50001' to parameter: 1<br/>11:20:17,981 FST | [LongType] returning '50003' as column: DBID1_1_0_<br/>11:20:17,981 FST | [LongType] returning '50001' as column: DEPLOYMENT2_1_0_<br/>11:20:17,981 FST | [StringType] returning 'sampleprocess' as column: OBJNAME3_1_0_<br/>11:20:17,981 FST | [StringType] returning 'langid' as column: KEY4_1_0_<br/>11:20:17,981 FST | [StringType] returning 'jpdl-4.4' as column: STRINGVAL5_1_0_<br/>11:20:17,981 FST | [LongType] returning null as column: LONGVAL6_1_0_<br/>11:20:17,981 FST | [LongType] returning '50001' as column: DEPLOYMENT2_1_<br/>11:20:17,981 FST | [LongType] returning '50003' as column: DBID1_1_<br/>11:20:17,981 FST | [LongType] returning '50004' as column: DBID1_1_0_<br/>11:20:17,981 FST | [LongType] returning '50001' as column: DEPLOYMENT2_1_0_<br/>11:20:17,981 FST | [StringType] returning 'sampleprocess' as column: OBJNAME3_1_0_<br/>11:20:17,981 FST | [StringType] returning 'pdid' as column: KEY4_1_0_<br/>11:20:17,981 FST | [StringType] returning 'sp-4' as column: STRINGVAL5_1_0_<br/>11:20:17,981 FST | [LongType] returning null as column: LONGVAL6_1_0_<br/>11:20:17,981 FST | [LongType] returning '50001' as column: DEPLOYMENT2_1_<br/>11:20:17,981 FST | [LongType] returning '50004' as column: DBID1_1_<br/>11:20:17,981 FST | [LongType] returning '50005' as column: DBID1_1_0_<br/>11:20:17,981 FST | [LongType] returning '50001' as column: DEPLOYMENT2_1_0_<br/>11:20:17,981 FST | [StringType] returning 'sampleprocess' as column: OBJNAME3_1_0_<br/>11:20:17,981 FST | [StringType] returning 'pdkey' as column: KEY4_1_0_<br/>11:20:17,981 FST | [StringType] returning 'sp' as column: STRINGVAL5_1_0_<br/>11:20:17,981 FST | [LongType] returning null as column: LONGVAL6_1_0_<br/>11:20:17,981 FST | [LongType] returning '50001' as column: DEPLOYMENT2_1_<br/>11:20:17,981 FST | [LongType] returning '50005' as column: DBID1_1_<br/>11:20:17,981 FST | [LongType] returning '50006' as column: DBID1_1_0_<br/>11:20:17,981 FST | [LongType] returning '50001' as column: DEPLOYMENT2_1_0_<br/>11:20:17,981 FST | [StringType] returning 'sampleprocess' as column: OBJNAME3_1_0_<br/>11:20:17,981 FST | [StringType] returning 'pdversion' as column: KEY4_1_0_<br/>11:20:17,981 FST | [StringType] returning null as column: STRINGVAL5_1_0_<br/>11:20:17,981 FST | [LongType] returning '4' as column: LONGVAL6_1_0_<br/>11:20:17,981 FST | [LongType] returning '50001' as column: DEPLOYMENT2_1_<br/>11:20:17,981 FST | [LongType] returning '50006' as column: DBID1_1_<br/>11:20:17,996 FIN | [SQL] select deployment1_.OBJNAME_ as col_0_0_, deployment1_.DEPLOYMENT_ as col_1_0_ from JBPM4_DEPLOYMENT deployment0_, JBPM4_DEPLOYPROP deployment1_, JBPM4_DEPLOYPROP deployment2_, JBPM4_DEPLOYPROP deployment3_ where deployment1_.KEY_='pdid' and deployment1_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.KEY_='pdkey' and deployment2_.OBJNAME_=deployment1_.OBJNAME_ and deployment2_.DEPLOYMENT_=deployment0_.DBID_ and deployment3_.KEY_='pdversion' and deployment3_.OBJNAME_=deployment1_.OBJNAME_ and deployment3_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.STRINGVAL_='sp'<br/>Hibernate: select deployment1_.OBJNAME_ as col_0_0_, deployment1_.DEPLOYMENT_ as col_1_0_ from JBPM4_DEPLOYMENT deployment0_, JBPM4_DEPLOYPROP deployment1_, JBPM4_DEPLOYPROP deployment2_, JBPM4_DEPLOYPROP deployment3_ where deployment1_.KEY_='pdid' and deployment1_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.KEY_='pdkey' and deployment2_.OBJNAME_=deployment1_.OBJNAME_ and deployment2_.DEPLOYMENT_=deployment0_.DBID_ and deployment3_.KEY_='pdversion' and deployment3_.OBJNAME_=deployment1_.OBJNAME_ and deployment3_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.STRINGVAL_='sp'<br/>11:20:18,012 FST | [StringType] returning 'sampleprocess' as column: col_0_0_<br/>11:20:18,012 FST | [LongType] returning '1' as column: col_1_0_<br/>11:20:18,012 FST | [StringType] returning 'sampleprocess' as column: col_0_0_<br/>11:20:18,012 FST | [LongType] returning '30001' as column: col_1_0_<br/>11:20:18,012 FST | [StringType] returning 'sampleprocess' as column: col_0_0_<br/>11:20:18,012 FST | [LongType] returning '40001' as column: col_1_0_<br/>11:20:18,012 FST | [StringType] returning 'sampleprocess' as column: col_0_0_<br/>11:20:18,012 FST | [LongType] returning '50001' as column: col_1_0_<br/>11:20:18,028 FIN | [SQL] select deployment1_.OBJNAME_ as col_0_0_, deployment1_.DEPLOYMENT_ as col_1_0_ from JBPM4_DEPLOYMENT deployment0_, JBPM4_DEPLOYPROP deployment1_, JBPM4_DEPLOYPROP deployment2_, JBPM4_DEPLOYPROP deployment3_ where deployment1_.KEY_='pdid' and deployment1_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.KEY_='pdkey' and deployment2_.OBJNAME_=deployment1_.OBJNAME_ and deployment2_.DEPLOYMENT_=deployment0_.DBID_ and deployment3_.KEY_='pdversion' and deployment3_.OBJNAME_=deployment1_.OBJNAME_ and deployment3_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.STRINGVAL_='sp' order by deployment3_.LONGVAL_ desc limit ?<br/>Hibernate: select deployment1_.OBJNAME_ as col_0_0_, deployment1_.DEPLOYMENT_ as col_1_0_ from JBPM4_DEPLOYMENT deployment0_, JBPM4_DEPLOYPROP deployment1_, JBPM4_DEPLOYPROP deployment2_, JBPM4_DEPLOYPROP deployment3_ where deployment1_.KEY_='pdid' and deployment1_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.KEY_='pdkey' and deployment2_.OBJNAME_=deployment1_.OBJNAME_ and deployment2_.DEPLOYMENT_=deployment0_.DBID_ and deployment3_.KEY_='pdversion' and deployment3_.OBJNAME_=deployment1_.OBJNAME_ and deployment3_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.STRINGVAL_='sp' order by deployment3_.LONGVAL_ desc limit ?<br/>11:20:18,028 FST | [StringType] returning 'sampleprocess' as column: col_0_0_<br/>11:20:18,028 FST | [LongType] returning '50001' as column: col_1_0_<br/>Hibernate: select deployment1_.OBJNAME_ as col_0_0_, deployment1_.DEPLOYMENT_ as col_1_0_ from JBPM4_DEPLOYMENT deployment0_, JBPM4_DEPLOYPROP deployment1_, JBPM4_DEPLOYPROP deployment2_, JBPM4_DEPLOYPROP deployment3_ where deployment1_.KEY_='pdid' and deployment1_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.KEY_='pdkey' and deployment2_.OBJNAME_=deployment1_.OBJNAME_ and deployment2_.DEPLOYMENT_=deployment0_.DBID_ and deployment3_.KEY_='pdversion' and deployment3_.OBJNAME_=deployment1_.OBJNAME_ and deployment3_.DEPLOYMENT_=deployment0_.DBID_ and deployment1_.STRINGVAL_='sp-5'<br/>11:20:18,029 FIN | [SQL] select deployment1_.OBJNAME_ as col_0_0_, deployment1_.DEPLOYMENT_ as col_1_0_ from JBPM4_DEPLOYMENT deployment0_, JBPM4_DEPLOYPROP deployment1_, JBPM4_DEPLOYPROP deployment2_, JBPM4_DEPLOYPROP deployment3_ where deployment1_.KEY_='pdid' and deployment1_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.KEY_='pdkey' and deployment2_.OBJNAME_=deployment1_.OBJNAME_ and deployment2_.DEPLOYMENT_=deployment0_.DBID_ and deployment3_.KEY_='pdversion' and deployment3_.OBJNAME_=deployment1_.OBJNAME_ and deployment3_.DEPLOYMENT_=deployment0_.DBID_ and deployment1_.STRINGVAL_='sp-5'<br/>11:20:18,029 FIN | [SQL] insert into JBPM4_DEPLOYPROP (DEPLOYMENT_, OBJNAME_, KEY_, STRINGVAL_, LONGVAL_, DBID_) values (?, ?, ?, ?, ?, ?)<br/>11:20:18,029 FST | [LongType] binding null to parameter: 1<br/>11:20:18,029 FST | [StringType] binding null to parameter: 2<br/>11:20:18,029 FST | [StringType] binding null to parameter: 3<br/>11:20:18,029 FST | [StringType] binding null to parameter: 4<br/>11:20:18,029 FST | [LongType] binding null to parameter: 5<br/>11:20:18,029 FST | [LongType] binding '60004' to parameter: 6<br/>11:20:18,029 FIN | [SQL] insert into JBPM4_DEPLOYPROP (DEPLOYMENT_, OBJNAME_, KEY_, STRINGVAL_, LONGVAL_, DBID_) values (?, ?, ?, ?, ?, ?)<br/>11:20:18,030 FST | [LongType] binding null to parameter: 1<br/>Hibernate: insert into JBPM4_DEPLOYPROP (DEPLOYMENT_, OBJNAME_, KEY_, STRINGVAL_, LONGVAL_, DBID_) values (?, ?, ?, ?, ?, ?)<br/>Hibernate: insert into JBPM4_DEPLOYPROP (DEPLOYMENT_, OBJNAME_, KEY_, STRINGVAL_, LONGVAL_, DBID_) values (?, ?, ?, ?, ?, ?)<br/>11:20:18,030 FST | [StringType] binding null to parameter: 2<br/>11:20:18,030 FST | [StringType] binding null to parameter: 3<br/>11:20:18,030 FST | [StringType] binding null to parameter: 4<br/>11:20:18,030 FST | [LongType] binding null to parameter: 5<br/>11:20:18,030 FST | [LongType] binding '60005' to parameter: 6<br/>11:20:18,030 FIN | [SQL] insert into JBPM4_DEPLOYPROP (DEPLOYMENT_, OBJNAME_, KEY_, STRINGVAL_, LONGVAL_, DBID_) values (?, ?, ?, ?, ?, ?)<br/>Hibernate: insert into JBPM4_DEPLOYPROP (DEPLOYMENT_, OBJNAME_, KEY_, STRINGVAL_, LONGVAL_, DBID_) values (?, ?, ?, ?, ?, ?)<br/>11:20:18,030 FST | [LongType] binding null to parameter: 1<br/>11:20:18,045 FST | [StringType] binding null to parameter: 2<br/>11:20:18,045 FST | [StringType] binding null to parameter: 3<br/>11:20:18,045 FST | [StringType] binding null to parameter: 4<br/>11:20:18,045 FST | [LongType] binding null to parameter: 5<br/>11:20:18,045 FST | [LongType] binding '60006' to parameter: 6<br/>11:20:18,061 FIN | [SQL] update JBPM4_DEPLOYPROP set DEPLOYMENT_=?, OBJNAME_=?, KEY_=?, STRINGVAL_=?, LONGVAL_=? where DBID_=?<br/>Hibernate: update JBPM4_DEPLOYPROP set DEPLOYMENT_=?, OBJNAME_=?, KEY_=?, STRINGVAL_=?, LONGVAL_=? where DBID_=?<br/>11:20:18,061 FST | [LongType] binding '60001' to parameter: 1<br/>11:20:18,061 FST | [StringType] binding 'sampleprocess' to parameter: 2<br/>11:20:18,061 FST | [StringType] binding 'pdid' to parameter: 3<br/>11:20:18,061 FST | [StringType] binding 'sp-5' to parameter: 4<br/>11:20:18,061 FST | [LongType] binding null to parameter: 5<br/>11:20:18,061 FST | [LongType] binding '60004' to parameter: 6<br/>11:20:18,061 FIN | [SQL] update JBPM4_DEPLOYPROP set DEPLOYMENT_=?, OBJNAME_=?, KEY_=?, STRINGVAL_=?, LONGVAL_=? where DBID_=?<br/>Hibernate: update JBPM4_DEPLOYPROP set DEPLOYMENT_=?, OBJNAME_=?, KEY_=?, STRINGVAL_=?, LONGVAL_=? where DBID_=?<br/>11:20:18,061 FST | [LongType] binding '60001' to parameter: 1<br/>11:20:18,061 FST | [StringType] binding 'sampleprocess' to parameter: 2<br/>11:20:18,061 FST | [StringType] binding 'pdkey' to parameter: 3<br/>11:20:18,061 FST | [StringType] binding 'sp' to parameter: 4<br/>11:20:18,061 FST | [LongType] binding null to parameter: 5<br/>11:20:18,061 FST | [LongType] binding '60005' to parameter: 6<br/>11:20:18,061 FIN | [SQL] update JBPM4_DEPLOYPROP set DEPLOYMENT_=?, OBJNAME_=?, KEY_=?, STRINGVAL_=?, LONGVAL_=? where DBID_=?<br/>Hibernate: update JBPM4_DEPLOYPROP set DEPLOYMENT_=?, OBJNAME_=?, KEY_=?, STRINGVAL_=?, LONGVAL_=? where DBID_=?<br/>11:20:18,061 FST | [LongType] binding '60001' to parameter: 1<br/>11:20:18,061 FST | [StringType] binding 'sampleprocess' to parameter: 2<br/>11:20:18,061 FST | [StringType] binding 'pdversion' to parameter: 3<br/>11:20:18,061 FST | [StringType] binding null to parameter: 4<br/>11:20:18,061 FST | [LongType] binding '5' to parameter: 5<br/>11:20:18,061 FST | [LongType] binding '60006' to parameter: 6<br/>11:20:18,061 FIN | [SQL] update JBPM4_DEPLOYPROP set DEPLOYMENT_=? where DBID_=?<br/>Hibernate: update JBPM4_DEPLOYPROP set DEPLOYMENT_=? where DBID_=?<br/>11:20:18,061 FST | [LongType] binding '60001' to parameter: 1<br/>11:20:18,061 FST | [LongType] binding '60005' to parameter: 2<br/>11:20:18,061 FIN | [SQL] update JBPM4_DEPLOYPROP set DEPLOYMENT_=? where DBID_=?<br/>Hibernate: update JBPM4_DEPLOYPROP set DEPLOYMENT_=? where DBID_=?<br/>11:20:18,061 FST | [LongType] binding '60001' to parameter: 1<br/>11:20:18,061 FST | [LongType] binding '60006' to parameter: 2<br/>11:20:18,061 FIN | [SQL] update JBPM4_DEPLOYPROP set DEPLOYMENT_=? where DBID_=?<br/>Hibernate: update JBPM4_DEPLOYPROP set DEPLOYMENT_=? where DBID_=?<br/>11:20:18,061 FST | [LongType] binding '60001' to parameter: 1<br/>11:20:18,061 FST | [LongType] binding '60004' to parameter: 2<br/>11:20:18,061 FIN | [HibernateSessionResource] ----- committing hibernate tx 785383518 -------------------------------------------------------<br/>The porecess id is deployed with id 60001<br/>11:20:18,061 FIN | [HibernateSessionResource] ----- beginning hibernate tx 1221338506 --------------------------------------------------------<br/>11:20:18,061 FIN | [SQL] select deployment1_.OBJNAME_ as col_0_0_, deployment1_.DEPLOYMENT_ as col_1_0_ from JBPM4_DEPLOYMENT deployment0_, JBPM4_DEPLOYPROP deployment1_, JBPM4_DEPLOYPROP deployment2_, JBPM4_DEPLOYPROP deployment3_ where deployment1_.KEY_='pdid' and deployment1_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.KEY_='pdkey' and deployment2_.OBJNAME_=deployment1_.OBJNAME_ and deployment2_.DEPLOYMENT_=deployment0_.DBID_ and deployment3_.KEY_='pdversion' and deployment3_.OBJNAME_=deployment1_.OBJNAME_ and deployment3_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.STRINGVAL_='sp' order by deployment3_.LONGVAL_ desc limit ?<br/>Hibernate: select deployment1_.OBJNAME_ as col_0_0_, deployment1_.DEPLOYMENT_ as col_1_0_ from JBPM4_DEPLOYMENT deployment0_, JBPM4_DEPLOYPROP deployment1_, JBPM4_DEPLOYPROP deployment2_, JBPM4_DEPLOYPROP deployment3_ where deployment1_.KEY_='pdid' and deployment1_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.KEY_='pdkey' and deployment2_.OBJNAME_=deployment1_.OBJNAME_ and deployment2_.DEPLOYMENT_=deployment0_.DBID_ and deployment3_.KEY_='pdversion' and deployment3_.OBJNAME_=deployment1_.OBJNAME_ and deployment3_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.STRINGVAL_='sp' order by deployment3_.LONGVAL_ desc limit ?<br/>11:20:18,061 FST | [StringType] returning 'sampleprocess' as column: col_0_0_<br/>11:20:18,061 FST | [LongType] returning '60001' as column: col_1_0_<br/>Hibernate: select deployment0_.DBID_ as DBID1_1_, deployment0_.DEPLOYMENT_ as DEPLOYMENT2_1_, deployment0_.OBJNAME_ as OBJNAME3_1_, deployment0_.KEY_ as KEY4_1_, deployment0_.STRINGVAL_ as STRINGVAL5_1_, deployment0_.LONGVAL_ as LONGVAL6_1_ from JBPM4_DEPLOYPROP deployment0_ where deployment0_.KEY_='pdid' and deployment0_.STRINGVAL_='sp-5' limit ?<br/>11:20:18,076 FIN | [SQL] select deployment0_.DBID_ as DBID1_1_, deployment0_.DEPLOYMENT_ as DEPLOYMENT2_1_, deployment0_.OBJNAME_ as OBJNAME3_1_, deployment0_.KEY_ as KEY4_1_, deployment0_.STRINGVAL_ as STRINGVAL5_1_, deployment0_.LONGVAL_ as LONGVAL6_1_ from JBPM4_DEPLOYPROP deployment0_ where deployment0_.KEY_='pdid' and deployment0_.STRINGVAL_='sp-5' limit ?<br/>11:20:18,076 FST | [LongType] returning '60004' as column: DBID1_1_<br/>11:20:18,076 FST | [LongType] returning '60001' as column: DEPLOYMENT2_1_<br/>11:20:18,076 FST | [StringType] returning 'sampleprocess' as column: OBJNAME3_1_<br/>11:20:18,076 FST | [StringType] returning 'pdid' as column: KEY4_1_<br/>11:20:18,076 FST | [StringType] returning 'sp-5' as column: STRINGVAL5_1_<br/>11:20:18,076 FST | [LongType] returning null as column: LONGVAL6_1_<br/>11:20:18,076 FIN | [SQL] select deployment0_.DBID_ as DBID1_0_0_, deployment0_.NAME_ as NAME2_0_0_, deployment0_.TIMESTAMP_ as TIMESTAMP3_0_0_, deployment0_.STATE_ as STATE4_0_0_ from JBPM4_DEPLOYMENT deployment0_ where deployment0_.DBID_=?<br/>Hibernate: select deployment0_.DBID_ as DBID1_0_0_, deployment0_.NAME_ as NAME2_0_0_, deployment0_.TIMESTAMP_ as TIMESTAMP3_0_0_, deployment0_.STATE_ as STATE4_0_0_ from JBPM4_DEPLOYMENT deployment0_ where deployment0_.DBID_=?<br/>11:20:18,076 FST | [LongType] binding '60001' to parameter: 1<br/>11:20:18,076 FST | [TextType] returning null as column: NAME2_0_0_<br/>11:20:18,076 FST | [LongType] returning '0' as column: TIMESTAMP3_0_0_<br/>11:20:18,076 FST | [StringType] returning 'active' as column: STATE4_0_0_<br/>11:20:18,076 FIN | [ProcessDefinitionImpl] creating new execution for process 'sampleprocess'<br/>11:20:18,076 FIN | [DatabaseIdComposer] generated execution id sp.60007<br/>11:20:18,092 FIN | [ExecuteActivity] executing activity(1421269392)<br/>11:20:18,092 FIN | [ExecuteActivity] executing activity(a)<br/>11:20:18,092 FIN | [SQL] insert into JBPM4_EXECUTION (DBVERSION_, ACTIVITYNAME_, PROCDEFID_, HASVARS_, NAME_, KEY_, ID_, STATE_, SUSPHISTSTATE_, PRIORITY_, HISACTINST_, PARENT_, INSTANCE_, SUPEREXEC_, SUBPROCINST_, CLASS_, DBID_) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'pvm', ?)<br/>Hibernate: insert into JBPM4_EXECUTION (DBVERSION_, ACTIVITYNAME_, PROCDEFID_, HASVARS_, NAME_, KEY_, ID_, STATE_, SUSPHISTSTATE_, PRIORITY_, HISACTINST_, PARENT_, INSTANCE_, SUPEREXEC_, SUBPROCINST_, CLASS_, DBID_) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'pvm', ?)<br/>11:20:18,092 FST | [IntegerType] binding '0' to parameter: 1<br/>11:20:18,092 FST | [StringType] binding null to parameter: 2<br/>11:20:18,092 FST | [StringType] binding 'sp-5' to parameter: 3<br/>11:20:18,092 FST | [BooleanType] binding 'false' to parameter: 4<br/>11:20:18,092 FST | [StringType] binding null to parameter: 5<br/>11:20:18,092 FST | [StringType] binding null to parameter: 6<br/>11:20:18,092 FST | [StringType] binding 'sp.60007' to parameter: 7<br/>11:20:18,092 FST | [StringType] binding 'created' to parameter: 8<br/>11:20:18,092 FST | [StringType] binding null to parameter: 9<br/>11:20:18,092 FST | [IntegerType] binding '0' to parameter: 10<br/>11:20:18,092 FST | [LongType] binding null to parameter: 11<br/>11:20:18,092 FST | [LongType] binding null to parameter: 12<br/>11:20:18,092 FST | [LongType] binding '60007' to parameter: 13<br/>11:20:18,092 FST | [LongType] binding null to parameter: 14<br/>11:20:18,092 FST | [LongType] binding null to parameter: 15<br/>11:20:18,092 FST | [LongType] binding '60007' to parameter: 16<br/>11:20:18,092 FIN | [SQL] insert into JBPM4_HIST_PROCINST (DBVERSION_, ID_, PROCDEFID_, KEY_, START_, END_, DURATION_, STATE_, ENDACTIVITY_, NEXTIDX_, DBID_) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)<br/>Hibernate: insert into JBPM4_HIST_PROCINST (DBVERSION_, ID_, PROCDEFID_, KEY_, START_, END_, DURATION_, STATE_, ENDACTIVITY_, NEXTIDX_, DBID_) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)<br/>11:20:18,092 FST | [IntegerType] binding '0' to parameter: 1<br/>11:20:18,092 FST | [StringType] binding 'sp.60007' to parameter: 2<br/>11:20:18,092 FST | [StringType] binding 'sp-5' to parameter: 3<br/>11:20:18,092 FST | [StringType] binding null to parameter: 4<br/>11:20:18,092 FST | [TimestampType] binding '2010-10-01 11:20:18' to parameter: 5<br/>11:20:18,108 FST | [TimestampType] binding null to parameter: 6<br/>11:20:18,108 FST | [LongType] binding null to parameter: 7<br/>11:20:18,108 FST | [StringType] binding 'active' to parameter: 8<br/>11:20:18,108 FST | [StringType] binding null to parameter: 9<br/>11:20:18,108 FST | [IntegerType] binding '1' to parameter: 10<br/>11:20:18,108 FST | [LongType] binding '60007' to parameter: 11<br/>11:20:18,108 FIN | [SQL] insert into JBPM4_HIST_ACTINST (DBVERSION_, HPROCI_, TYPE_, EXECUTION_, ACTIVITY_NAME_, START_, END_, DURATION_, TRANSITION_, NEXTIDX_, CLASS_, DBID_) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'act', ?)<br/>Hibernate: insert into JBPM4_HIST_ACTINST (DBVERSION_, HPROCI_, TYPE_, EXECUTION_, ACTIVITY_NAME_, START_, END_, DURATION_, TRANSITION_, NEXTIDX_, CLASS_, DBID_) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'act', ?)<br/>11:20:18,108 FST | [IntegerType] binding '0' to parameter: 1<br/>11:20:18,108 FST | [LongType] binding '60007' to parameter: 2<br/>11:20:18,108 FST | [StringType] binding 'state' to parameter: 3<br/>11:20:18,108 FST | [StringType] binding 'sp.60007' to parameter: 4<br/>11:20:18,108 FST | [StringType] binding 'a' to parameter: 5<br/>11:20:18,108 FST | [TimestampType] binding '2010-10-01 11:20:18' to parameter: 6<br/>11:20:18,108 FST | [TimestampType] binding null to parameter: 7<br/>11:20:18,108 FST | [LongType] binding '0' to parameter: 8<br/>11:20:18,108 FST | [StringType] binding null to parameter: 9<br/>11:20:18,108 FST | [IntegerType] binding '1' to parameter: 10<br/>11:20:18,108 FST | [LongType] binding '60008' to parameter: 11<br/>11:20:18,108 FIN | [SQL] update JBPM4_EXECUTION set DBVERSION_=?, ACTIVITYNAME_=?, PROCDEFID_=?, HASVARS_=?, NAME_=?, KEY_=?, ID_=?, STATE_=?, SUSPHISTSTATE_=?, PRIORITY_=?, HISACTINST_=?, PARENT_=?, INSTANCE_=?, SUPEREXEC_=?, SUBPROCINST_=? where DBID_=? and DBVERSION_=?<br/>Hibernate: update JBPM4_EXECUTION set DBVERSION_=?, ACTIVITYNAME_=?, PROCDEFID_=?, HASVARS_=?, NAME_=?, KEY_=?, ID_=?, STATE_=?, SUSPHISTSTATE_=?, PRIORITY_=?, HISACTINST_=?, PARENT_=?, INSTANCE_=?, SUPEREXEC_=?, SUBPROCINST_=? where DBID_=? and DBVERSION_=?<br/>11:20:18,108 FST | [IntegerType] binding '1' to parameter: 1<br/>11:20:18,108 FST | [StringType] binding 'a' to parameter: 2<br/>11:20:18,108 FST | [StringType] binding 'sp-5' to parameter: 3<br/>11:20:18,108 FST | [BooleanType] binding 'false' to parameter: 4<br/>11:20:18,108 FST | [StringType] binding null to parameter: 5<br/>11:20:18,108 FST | [StringType] binding null to parameter: 6<br/>11:20:18,108 FST | [StringType] binding 'sp.60007' to parameter: 7<br/>11:20:18,108 FST | [StringType] binding 'active-root' to parameter: 8<br/>11:20:18,108 FST | [StringType] binding null to parameter: 9<br/>11:20:18,108 FST | [IntegerType] binding '0' to parameter: 10<br/>11:20:18,108 FST | [LongType] binding '60008' to parameter: 11<br/>11:20:18,108 FST | [LongType] binding null to parameter: 12<br/>11:20:18,108 FST | [LongType] binding '60007' to parameter: 13<br/>11:20:18,108 FST | [LongType] binding null to parameter: 14<br/>11:20:18,108 FST | [LongType] binding null to parameter: 15<br/>11:20:18,108 FST | [LongType] binding '60007' to parameter: 16<br/>11:20:18,108 FST | [IntegerType] binding '0' to parameter: 17<br/>11:20:18,108 FIN | [HibernateSessionResource] ----- committing hibernate tx 2113092528 -------------------------------------------------------<br/>The No of active executions are :1<br/>Execution is execution[sp.60007]<br/>11:20:18,108 FIN | [HibernateSessionResource] ----- beginning hibernate tx 1584118582 --------------------------------------------------------<br/>11:20:18,108 FIN | [SQL] select executioni0_.DBID_ as DBID1_3_, executioni0_.DBVERSION_ as DBVERSION3_3_, executioni0_.ACTIVITYNAME_ as ACTIVITY4_3_, executioni0_.PROCDEFID_ as PROCDEFID5_3_, executioni0_.HASVARS_ as HASVARS6_3_, executioni0_.NAME_ as NAME7_3_, executioni0_.KEY_ as KEY8_3_, executioni0_.ID_ as ID9_3_, executioni0_.STATE_ as STATE10_3_, executioni0_.SUSPHISTSTATE_ as SUSPHIS11_3_, executioni0_.PRIORITY_ as PRIORITY12_3_, executioni0_.HISACTINST_ as HISACTINST13_3_, executioni0_.PARENT_ as PARENT14_3_, executioni0_.INSTANCE_ as INSTANCE15_3_, executioni0_.SUPEREXEC_ as SUPEREXEC16_3_, executioni0_.SUBPROCINST_ as SUBPROC17_3_ from JBPM4_EXECUTION executioni0_ where executioni0_.ID_=? limit ?<br/>Hibernate: select executioni0_.DBID_ as DBID1_3_, executioni0_.DBVERSION_ as DBVERSION3_3_, executioni0_.ACTIVITYNAME_ as ACTIVITY4_3_, executioni0_.PROCDEFID_ as PROCDEFID5_3_, executioni0_.HASVARS_ as HASVARS6_3_, executioni0_.NAME_ as NAME7_3_, executioni0_.KEY_ as KEY8_3_, executioni0_.ID_ as ID9_3_, executioni0_.STATE_ as STATE10_3_, executioni0_.SUSPHISTSTATE_ as SUSPHIS11_3_, executioni0_.PRIORITY_ as PRIORITY12_3_, executioni0_.HISACTINST_ as HISACTINST13_3_, executioni0_.PARENT_ as PARENT14_3_, executioni0_.INSTANCE_ as INSTANCE15_3_, executioni0_.SUPEREXEC_ as SUPEREXEC16_3_, executioni0_.SUBPROCINST_ as SUBPROC17_3_ from JBPM4_EXECUTION executioni0_ where executioni0_.ID_=? limit ?<br/>11:20:18,108 FST | [StringType] binding 'sp.60007' to parameter: 1<br/>11:20:18,123 FST | [LongType] returning '60007' as column: DBID1_3_<br/>11:20:18,123 FST | [IntegerType] returning '1' as column: DBVERSION3_3_<br/>11:20:18,123 FST | [StringType] returning 'a' as column: ACTIVITY4_3_<br/>11:20:18,123 FST | [StringType] returning 'sp-5' as column: PROCDEFID5_3_<br/>11:20:18,123 FST | [BooleanType] returning 'false' as column: HASVARS6_3_<br/>11:20:18,123 FST | [StringType] returning null as column: NAME7_3_<br/>11:20:18,123 FST | [StringType] returning null as column: KEY8_3_<br/>11:20:18,123 FST | [StringType] returning 'sp.60007' as column: ID9_3_<br/>11:20:18,123 FST | [StringType] returning 'active-root' as column: STATE10_3_<br/>11:20:18,123 FST | [StringType] returning null as column: SUSPHIS11_3_<br/>11:20:18,123 FST | [IntegerType] returning '0' as column: PRIORITY12_3_<br/>11:20:18,123 FST | [LongType] returning '60008' as column: HISACTINST13_3_<br/>11:20:18,123 FST | [LongType] returning null as column: PARENT14_3_<br/>11:20:18,123 FST | [LongType] returning '60007' as column: INSTANCE15_3_<br/>11:20:18,123 FST | [LongType] returning null as column: SUPEREXEC16_3_<br/>11:20:18,123 FST | [LongType] returning null as column: SUBPROC17_3_<br/>11:20:18,123 FIN | [SQL] select executions0_.PARENT_ as PARENT14_1_, executions0_.DBID_ as DBID1_1_, executions0_.PARENT_IDX_ as PARENT18_1_, executions0_.DBID_ as DBID1_3_0_, executions0_.DBVERSION_ as DBVERSION3_3_0_, executions0_.ACTIVITYNAME_ as ACTIVITY4_3_0_, executions0_.PROCDEFID_ as PROCDEFID5_3_0_, executions0_.HASVARS_ as HASVARS6_3_0_, executions0_.NAME_ as NAME7_3_0_, executions0_.KEY_ as KEY8_3_0_, executions0_.ID_ as ID9_3_0_, executions0_.STATE_ as STATE10_3_0_, executions0_.SUSPHISTSTATE_ as SUSPHIS11_3_0_, executions0_.PRIORITY_ as PRIORITY12_3_0_, executions0_.HISACTINST_ as HISACTINST13_3_0_, executions0_.PARENT_ as PARENT14_3_0_, executions0_.INSTANCE_ as INSTANCE15_3_0_, executions0_.SUPEREXEC_ as SUPEREXEC16_3_0_, executions0_.SUBPROCINST_ as SUBPROC17_3_0_ from JBPM4_EXECUTION executions0_ where executions0_.PARENT_=?<br/>Hibernate: select executions0_.PARENT_ as PARENT14_1_, executions0_.DBID_ as DBID1_1_, executions0_.PARENT_IDX_ as PARENT18_1_, executions0_.DBID_ as DBID1_3_0_, executions0_.DBVERSION_ as DBVERSION3_3_0_, executions0_.ACTIVITYNAME_ as ACTIVITY4_3_0_, executions0_.PROCDEFID_ as PROCDEFID5_3_0_, executions0_.HASVARS_ as HASVARS6_3_0_, executions0_.NAME_ as NAME7_3_0_, executions0_.KEY_ as KEY8_3_0_, executions0_.ID_ as ID9_3_0_, executions0_.STATE_ as STATE10_3_0_, executions0_.SUSPHISTSTATE_ as SUSPHIS11_3_0_, executions0_.PRIORITY_ as PRIORITY12_3_0_, executions0_.HISACTINST_ as HISACTINST13_3_0_, executions0_.PARENT_ as PARENT14_3_0_, executions0_.INSTANCE_ as INSTANCE15_3_0_, executions0_.SUPEREXEC_ as SUPEREXEC16_3_0_, executions0_.SUBPROCINST_ as SUBPROC17_3_0_ from JBPM4_EXECUTION executions0_ where executions0_.PARENT_=?<br/>11:20:18,123 FST | [LongType] binding '60007' to parameter: 1<br/>11:20:18,123 FIN | [SQL] select deployment0_.DBID_ as DBID1_1_, deployment0_.DEPLOYMENT_ as DEPLOYMENT2_1_, deployment0_.OBJNAME_ as OBJNAME3_1_, deployment0_.KEY_ as KEY4_1_, deployment0_.STRINGVAL_ as STRINGVAL5_1_, deployment0_.LONGVAL_ as LONGVAL6_1_ from JBPM4_DEPLOYPROP deployment0_ where deployment0_.KEY_='pdid' and deployment0_.STRINGVAL_='sp-5' limit ?<br/>11:20:18,123 FST | [LongType] returning '60004' as column: DBID1_1_<br/>11:20:18,123 FST | [LongType] returning '60001' as column: DEPLOYMENT2_1_<br/>11:20:18,123 FST | [StringType] returning 'sampleprocess' as column: OBJNAME3_1_<br/>Hibernate: select deployment0_.DBID_ as DBID1_1_, deployment0_.DEPLOYMENT_ as DEPLOYMENT2_1_, deployment0_.OBJNAME_ as OBJNAME3_1_, deployment0_.KEY_ as KEY4_1_, deployment0_.STRINGVAL_ as STRINGVAL5_1_, deployment0_.LONGVAL_ as LONGVAL6_1_ from JBPM4_DEPLOYPROP deployment0_ where deployment0_.KEY_='pdid' and deployment0_.STRINGVAL_='sp-5' limit ?<br/>Hibernate: select deployment0_.DBID_ as DBID1_0_0_, deployment0_.NAME_ as NAME2_0_0_, deployment0_.TIMESTAMP_ as TIMESTAMP3_0_0_, deployment0_.STATE_ as STATE4_0_0_ from JBPM4_DEPLOYMENT deployment0_ where deployment0_.DBID_=?<br/>11:20:18,123 FST | [StringType] returning 'pdid' as column: KEY4_1_<br/>11:20:18,123 FST | [StringType] returning 'sp-5' as column: STRINGVAL5_1_<br/>11:20:18,123 FST | [LongType] returning null as column: LONGVAL6_1_<br/>11:20:18,123 FIN | [SQL] select deployment0_.DBID_ as DBID1_0_0_, deployment0_.NAME_ as NAME2_0_0_, deployment0_.TIMESTAMP_ as TIMESTAMP3_0_0_, deployment0_.STATE_ as STATE4_0_0_ from JBPM4_DEPLOYMENT deployment0_ where deployment0_.DBID_=?<br/>11:20:18,123 FST | [LongType] binding '60001' to parameter: 1<br/>11:20:18,123 FST | [TextType] returning null as column: NAME2_0_0_<br/>11:20:18,123 FST | [LongType] returning '0' as column: TIMESTAMP3_0_0_<br/>11:20:18,123 FST | [StringType] returning 'active' as column: STATE4_0_0_<br/>11:20:18,123 FIN | [Signal] signalling activity(a), signalName=null<br/>Hibernate: select historyact0_.DBID_ as DBID1_8_0_, historyact0_.DBVERSION_ as DBVERSION3_8_0_, historyact0_.HPROCI_ as HPROCI4_8_0_, historyact0_.TYPE_ as TYPE5_8_0_, historyact0_.EXECUTION_ as EXECUTION6_8_0_, historyact0_.ACTIVITY_NAME_ as ACTIVITY7_8_0_, historyact0_.START_ as START8_8_0_, historyact0_.END_ as END9_8_0_, historyact0_.DURATION_ as DURATION10_8_0_, historyact0_.TRANSITION_ as TRANSITION11_8_0_, historyact0_.NEXTIDX_ as NEXTIDX12_8_0_, historyact0_.HTASK_ as HTASK13_8_0_, historyact0_.CLASS_ as CLASS2_8_0_ from JBPM4_HIST_ACTINST historyact0_ where historyact0_.DBID_=?<br/>11:20:18,139 FIN | [SQL] select historyact0_.DBID_ as DBID1_8_0_, historyact0_.DBVERSION_ as DBVERSION3_8_0_, historyact0_.HPROCI_ as HPROCI4_8_0_, historyact0_.TYPE_ as TYPE5_8_0_, historyact0_.EXECUTION_ as EXECUTION6_8_0_, historyact0_.ACTIVITY_NAME_ as ACTIVITY7_8_0_, historyact0_.START_ as START8_8_0_, historyact0_.END_ as END9_8_0_, historyact0_.DURATION_ as DURATION10_8_0_, historyact0_.TRANSITION_ as TRANSITION11_8_0_, historyact0_.NEXTIDX_ as NEXTIDX12_8_0_, historyact0_.HTASK_ as HTASK13_8_0_, historyact0_.CLASS_ as CLASS2_8_0_ from JBPM4_HIST_ACTINST historyact0_ where historyact0_.DBID_=?<br/>11:20:18,139 FST | [LongType] binding '60008' to parameter: 1<br/>11:20:18,139 FST | [StringType] returning 'act' as column: CLASS2_8_0_<br/>11:20:18,139 FST | [IntegerType] returning '0' as column: DBVERSION3_8_0_<br/>11:20:18,139 FST | [LongType] returning '60007' as column: HPROCI4_8_0_<br/>11:20:18,139 FST | [StringType] returning 'state' as column: TYPE5_8_0_<br/>11:20:18,139 FST | [StringType] returning 'sp.60007' as column: EXECUTION6_8_0_<br/>11:20:18,139 FST | [StringType] returning 'a' as column: ACTIVITY7_8_0_<br/>11:20:18,139 FST | [TimestampType] returning '2010-10-01 11:20:18' as column: START8_8_0_<br/>11:20:18,139 FST | [TimestampType] returning null as column: END9_8_0_<br/>11:20:18,139 FST | [LongType] returning '0' as column: DURATION10_8_0_<br/>11:20:18,139 FST | [StringType] returning null as column: TRANSITION11_8_0_<br/>11:20:18,139 FST | [IntegerType] returning '1' as column: NEXTIDX12_8_0_<br/>11:20:18,139 FIN | [ExecuteActivity] executing activity(b)<br/>11:20:18,139 FIN | [SQL] select historypro0_.DBID_ as DBID1_7_0_, historypro0_.DBVERSION_ as DBVERSION2_7_0_, historypro0_.ID_ as ID3_7_0_, historypro0_.PROCDEFID_ as PROCDEFID4_7_0_, historypro0_.KEY_ as KEY5_7_0_, historypro0_.START_ as START6_7_0_, historypro0_.END_ as END7_7_0_, historypro0_.DURATION_ as DURATION8_7_0_, historypro0_.STATE_ as STATE9_7_0_, historypro0_.ENDACTIVITY_ as ENDACTI10_7_0_, historypro0_.NEXTIDX_ as NEXTIDX11_7_0_ from JBPM4_HIST_PROCINST historypro0_ where historypro0_.DBID_=?<br/>Hibernate: select historypro0_.DBID_ as DBID1_7_0_, historypro0_.DBVERSION_ as DBVERSION2_7_0_, historypro0_.ID_ as ID3_7_0_, historypro0_.PROCDEFID_ as PROCDEFID4_7_0_, historypro0_.KEY_ as KEY5_7_0_, historypro0_.START_ as START6_7_0_, historypro0_.END_ as END7_7_0_, historypro0_.DURATION_ as DURATION8_7_0_, historypro0_.STATE_ as STATE9_7_0_, historypro0_.ENDACTIVITY_ as ENDACTI10_7_0_, historypro0_.NEXTIDX_ as NEXTIDX11_7_0_ from JBPM4_HIST_PROCINST historypro0_ where historypro0_.DBID_=?<br/>11:20:18,139 FST | [LongType] binding '60007' to parameter: 1<br/>11:20:18,139 FST | [IntegerType] returning '0' as column: DBVERSION2_7_0_<br/>11:20:18,139 FST | [StringType] returning 'sp.60007' as column: ID3_7_0_<br/>11:20:18,139 FST | [StringType] returning 'sp-5' as column: PROCDEFID4_7_0_<br/>11:20:18,139 FST | [StringType] returning null as column: KEY5_7_0_<br/>11:20:18,139 FST | [TimestampType] returning '2010-10-01 11:20:18' as column: START6_7_0_<br/>11:20:18,139 FST | [TimestampType] returning null as column: END7_7_0_<br/>11:20:18,139 FST | [LongType] returning null as column: DURATION8_7_0_<br/>11:20:18,139 FST | [StringType] returning 'active' as column: STATE9_7_0_<br/>11:20:18,139 FST | [StringType] returning null as column: ENDACTI10_7_0_<br/>11:20:18,139 FST | [IntegerType] returning '1' as column: NEXTIDX11_7_0_<br/>11:20:18,154 FIN | [SQL] insert into JBPM4_HIST_ACTINST (DBVERSION_, HPROCI_, TYPE_, EXECUTION_, ACTIVITY_NAME_, START_, END_, DURATION_, TRANSITION_, NEXTIDX_, CLASS_, DBID_) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'act', ?)<br/>Hibernate: insert into JBPM4_HIST_ACTINST (DBVERSION_, HPROCI_, TYPE_, EXECUTION_, ACTIVITY_NAME_, START_, END_, DURATION_, TRANSITION_, NEXTIDX_, CLASS_, DBID_) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'act', ?)<br/>11:20:18,154 FST | [IntegerType] binding '0' to parameter: 1<br/>11:20:18,154 FST | [LongType] binding '60007' to parameter: 2<br/>11:20:18,154 FST | [StringType] binding 'state' to parameter: 3<br/>11:20:18,154 FST | [StringType] binding 'sp.60007' to parameter: 4<br/>11:20:18,154 FST | [StringType] binding 'b' to parameter: 5<br/>11:20:18,154 FST | [TimestampType] binding '2010-10-01 11:20:18' to parameter: 6<br/>11:20:18,154 FST | [TimestampType] binding null to parameter: 7<br/>11:20:18,154 FST | [LongType] binding '0' to parameter: 8<br/>11:20:18,154 FST | [StringType] binding null to parameter: 9<br/>11:20:18,154 FST | [IntegerType] binding '1' to parameter: 10<br/>11:20:18,154 FST | [LongType] binding '60009' to parameter: 11<br/>11:20:18,154 FIN | [SQL] update JBPM4_EXECUTION set DBVERSION_=?, ACTIVITYNAME_=?, PROCDEFID_=?, HASVARS_=?, NAME_=?, KEY_=?, ID_=?, STATE_=?, SUSPHISTSTATE_=?, PRIORITY_=?, HISACTINST_=?, PARENT_=?, INSTANCE_=?, SUPEREXEC_=?, SUBPROCINST_=? where DBID_=? and DBVERSION_=?<br/>Hibernate: update JBPM4_EXECUTION set DBVERSION_=?, ACTIVITYNAME_=?, PROCDEFID_=?, HASVARS_=?, NAME_=?, KEY_=?, ID_=?, STATE_=?, SUSPHISTSTATE_=?, PRIORITY_=?, HISACTINST_=?, PARENT_=?, INSTANCE_=?, SUPEREXEC_=?, SUBPROCINST_=? where DBID_=? and DBVERSION_=?<br/>11:20:18,154 FST | [IntegerType] binding '2' to parameter: 1<br/>11:20:18,154 FST | [StringType] binding 'b' to parameter: 2<br/>11:20:18,154 FST | [StringType] binding 'sp-5' to parameter: 3<br/>11:20:18,154 FST | [BooleanType] binding 'false' to parameter: 4<br/>11:20:18,154 FST | [StringType] binding null to parameter: 5<br/>11:20:18,154 FST | [StringType] binding null to parameter: 6<br/>11:20:18,154 FST | [StringType] binding 'sp.60007' to parameter: 7<br/>11:20:18,154 FST | [StringType] binding 'active-root' to parameter: 8<br/>11:20:18,154 FST | [StringType] binding null to parameter: 9<br/>11:20:18,154 FST | [IntegerType] binding '0' to parameter: 10<br/>11:20:18,154 FST | [LongType] binding '60009' to parameter: 11<br/>11:20:18,154 FST | [LongType] binding null to parameter: 12<br/>11:20:18,154 FST | [LongType] binding '60007' to parameter: 13<br/>11:20:18,154 FST | [LongType] binding null to parameter: 14<br/>11:20:18,154 FST | [LongType] binding null to parameter: 15<br/>11:20:18,154 FST | [LongType] binding '60007' to parameter: 16<br/>11:20:18,154 FST | [IntegerType] binding '1' to parameter: 17<br/>11:20:18,154 FIN | [SQL] update JBPM4_HIST_ACTINST set DBVERSION_=?, HPROCI_=?, TYPE_=?, EXECUTION_=?, ACTIVITY_NAME_=?, START_=?, END_=?, DURATION_=?, TRANSITION_=?, NEXTIDX_=? where DBID_=? and DBVERSION_=?<br/>Hibernate: update JBPM4_HIST_ACTINST set DBVERSION_=?, HPROCI_=?, TYPE_=?, EXECUTION_=?, ACTIVITY_NAME_=?, START_=?, END_=?, DURATION_=?, TRANSITION_=?, NEXTIDX_=? where DBID_=? and DBVERSION_=?<br/>11:20:18,154 FST | [IntegerType] binding '1' to parameter: 1<br/>11:20:18,154 FST | [LongType] binding '60007' to parameter: 2<br/>11:20:18,154 FST | [StringType] binding 'state' to parameter: 3<br/>11:20:18,154 FST | [StringType] binding 'sp.60007' to parameter: 4<br/>11:20:18,154 FST | [StringType] binding 'a' to parameter: 5<br/>11:20:18,154 FST | [TimestampType] binding '2010-10-01 11:20:18' to parameter: 6<br/>11:20:18,154 FST | [TimestampType] binding '2010-10-01 11:20:18' to parameter: 7<br/>11:20:18,154 FST | [LongType] binding '139' to parameter: 8<br/>11:20:18,154 FST | [StringType] binding null to parameter: 9<br/>11:20:18,154 FST | [IntegerType] binding '1' to parameter: 10<br/>11:20:18,154 FST | [LongType] binding '60008' to parameter: 11<br/>11:20:18,154 FST | [IntegerType] binding '0' to parameter: 12<br/>11:20:18,154 FIN | [HibernateSessionResource] ----- committing hibernate tx 1448415374 -------------------------------------------------------<br/>Execution is execution[sp.60007]<br/>11:20:18,170 FIN | [HibernateSessionResource] ----- beginning hibernate tx 252689000 --------------------------------------------------------<br/>11:20:18,186 FIN | [SQL] select deployment1_.OBJNAME_ as col_0_0_, deployment1_.DEPLOYMENT_ as col_1_0_ from JBPM4_DEPLOYMENT deployment0_, JBPM4_DEPLOYPROP deployment1_, JBPM4_DEPLOYPROP deployment2_, JBPM4_DEPLOYPROP deployment3_ where deployment1_.KEY_='pdid' and deployment1_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.KEY_='pdkey' and deployment2_.OBJNAME_=deployment1_.OBJNAME_ and deployment2_.DEPLOYMENT_=deployment0_.DBID_ and deployment3_.KEY_='pdversion' and deployment3_.OBJNAME_=deployment1_.OBJNAME_ and deployment3_.DEPLOYMENT_=deployment0_.DBID_ and deployment1_.DEPLOYMENT_=60001<br/>Hibernate: select deployment1_.OBJNAME_ as col_0_0_, deployment1_.DEPLOYMENT_ as col_1_0_ from JBPM4_DEPLOYMENT deployment0_, JBPM4_DEPLOYPROP deployment1_, JBPM4_DEPLOYPROP deployment2_, JBPM4_DEPLOYPROP deployment3_ where deployment1_.KEY_='pdid' and deployment1_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.KEY_='pdkey' and deployment2_.OBJNAME_=deployment1_.OBJNAME_ and deployment2_.DEPLOYMENT_=deployment0_.DBID_ and deployment3_.KEY_='pdversion' and deployment3_.OBJNAME_=deployment1_.OBJNAME_ and deployment3_.DEPLOYMENT_=deployment0_.DBID_ and deployment1_.DEPLOYMENT_=60001<br/>11:20:18,186 FST | [StringType] returning 'sampleprocess' as column: col_0_0_<br/>11:20:18,186 FST | [LongType] returning '60001' as column: col_1_0_<br/>11:20:18,186 FIN | [SQL] select executioni0_.ID_ as col_0_0_ from JBPM4_EXECUTION executioni0_ where executioni0_.PROCDEFID_=? and (executioni0_.PARENT_ is null)<br/>Hibernate: select executioni0_.ID_ as col_0_0_ from JBPM4_EXECUTION executioni0_ where executioni0_.PROCDEFID_=? and (executioni0_.PARENT_ is null)<br/>11:20:18,186 FST | [StringType] binding 'sp-5' to parameter: 1<br/>11:20:18,186 FST | [StringType] returning 'sp.60007' as column: col_0_0_<br/>11:20:18,186 FIN | [SQL] select this_.DBID_ as DBID1_7_0_, this_.DBVERSION_ as DBVERSION2_7_0_, this_.ID_ as ID3_7_0_, this_.PROCDEFID_ as PROCDEFID4_7_0_, this_.KEY_ as KEY5_7_0_, this_.START_ as START6_7_0_, this_.END_ as END7_7_0_, this_.DURATION_ as DURATION8_7_0_, this_.STATE_ as STATE9_7_0_, this_.ENDACTIVITY_ as ENDACTI10_7_0_, this_.NEXTIDX_ as NEXTIDX11_7_0_ from JBPM4_HIST_PROCINST this_ where this_.ID_=?<br/>Hibernate: select this_.DBID_ as DBID1_7_0_, this_.DBVERSION_ as DBVERSION2_7_0_, this_.ID_ as ID3_7_0_, this_.PROCDEFID_ as PROCDEFID4_7_0_, this_.KEY_ as KEY5_7_0_, this_.START_ as START6_7_0_, this_.END_ as END7_7_0_, this_.DURATION_ as DURATION8_7_0_, this_.STATE_ as STATE9_7_0_, this_.ENDACTIVITY_ as ENDACTI10_7_0_, this_.NEXTIDX_ as NEXTIDX11_7_0_ from JBPM4_HIST_PROCINST this_ where this_.ID_=?<br/>11:20:18,186 FST | [StringType] binding 'sp.60007' to parameter: 1<br/>11:20:18,186 FST | [LongType] returning '60007' as column: DBID1_7_0_<br/>11:20:18,186 FST | [IntegerType] returning '0' as column: DBVERSION2_7_0_<br/>11:20:18,186 FST | [StringType] returning 'sp.60007' as column: ID3_7_0_<br/>11:20:18,186 FST | [StringType] returning 'sp-5' as column: PROCDEFID4_7_0_<br/>11:20:18,186 FST | [StringType] returning null as column: KEY5_7_0_<br/>11:20:18,186 FST | [TimestampType] returning '2010-10-01 11:20:18' as column: START6_7_0_<br/>11:20:18,186 FST | [TimestampType] returning null as column: END7_7_0_<br/>11:20:18,186 FST | [LongType] returning null as column: DURATION8_7_0_<br/>11:20:18,186 FST | [StringType] returning 'active' as column: STATE9_7_0_<br/>11:20:18,186 FST | [StringType] returning null as column: ENDACTI10_7_0_<br/>11:20:18,186 FST | [IntegerType] returning '1' as column: NEXTIDX11_7_0_<br/>11:20:18,186 FIN | [DbSessionImpl] deleting history process instance sp.60007<br/>11:20:18,201 FIN | [SQL] select historyact0_.HPROCI_ as HPROCI4_1_, historyact0_.DBID_ as DBID1_1_, historyact0_.DBID_ as DBID1_8_0_, historyact0_.DBVERSION_ as DBVERSION3_8_0_, historyact0_.HPROCI_ as HPROCI4_8_0_, historyact0_.TYPE_ as TYPE5_8_0_, historyact0_.EXECUTION_ as EXECUTION6_8_0_, historyact0_.ACTIVITY_NAME_ as ACTIVITY7_8_0_, historyact0_.START_ as START8_8_0_, historyact0_.END_ as END9_8_0_, historyact0_.DURATION_ as DURATION10_8_0_, historyact0_.TRANSITION_ as TRANSITION11_8_0_, historyact0_.NEXTIDX_ as NEXTIDX12_8_0_, historyact0_.HTASK_ as HTASK13_8_0_, historyact0_.CLASS_ as CLASS2_8_0_ from JBPM4_HIST_ACTINST historyact0_ where historyact0_.HPROCI_=?<br/>Hibernate: select historyact0_.HPROCI_ as HPROCI4_1_, historyact0_.DBID_ as DBID1_1_, historyact0_.DBID_ as DBID1_8_0_, historyact0_.DBVERSION_ as DBVERSION3_8_0_, historyact0_.HPROCI_ as HPROCI4_8_0_, historyact0_.TYPE_ as TYPE5_8_0_, historyact0_.EXECUTION_ as EXECUTION6_8_0_, historyact0_.ACTIVITY_NAME_ as ACTIVITY7_8_0_, historyact0_.START_ as START8_8_0_, historyact0_.END_ as END9_8_0_, historyact0_.DURATION_ as DURATION10_8_0_, historyact0_.TRANSITION_ as TRANSITION11_8_0_, historyact0_.NEXTIDX_ as NEXTIDX12_8_0_, historyact0_.HTASK_ as HTASK13_8_0_, historyact0_.CLASS_ as CLASS2_8_0_ from JBPM4_HIST_ACTINST historyact0_ where historyact0_.HPROCI_=?<br/>11:20:18,201 FST | [LongType] binding '60007' to parameter: 1<br/>11:20:18,201 FST | [LongType] returning '60008' as column: DBID1_8_0_<br/>11:20:18,201 FST | [StringType] returning 'act' as column: CLASS2_8_0_<br/>11:20:18,201 FST | [IntegerType] returning '1' as column: DBVERSION3_8_0_<br/>11:20:18,201 FST | [LongType] returning '60007' as column: HPROCI4_8_0_<br/>11:20:18,201 FST | [StringType] returning 'state' as column: TYPE5_8_0_<br/>11:20:18,201 FST | [StringType] returning 'sp.60007' as column: EXECUTION6_8_0_<br/>11:20:18,201 FST | [StringType] returning 'a' as column: ACTIVITY7_8_0_<br/>11:20:18,201 FST | [TimestampType] returning '2010-10-01 11:20:18' as column: START8_8_0_<br/>11:20:18,201 FST | [TimestampType] returning '2010-10-01 11:20:18' as column: END9_8_0_<br/>11:20:18,201 FST | [LongType] returning '139' as column: DURATION10_8_0_<br/>11:20:18,201 FST | [StringType] returning null as column: TRANSITION11_8_0_<br/>11:20:18,201 FST | [IntegerType] returning '1' as column: NEXTIDX12_8_0_<br/>11:20:18,201 FST | [LongType] returning '60007' as column: HPROCI4_1_<br/>11:20:18,201 FST | [LongType] returning '60008' as column: DBID1_1_<br/>11:20:18,201 FST | [LongType] returning '60009' as column: DBID1_8_0_<br/>11:20:18,201 FST | [StringType] returning 'act' as column: CLASS2_8_0_<br/>11:20:18,201 FST | [IntegerType] returning '0' as column: DBVERSION3_8_0_<br/>11:20:18,201 FST | [LongType] returning '60007' as column: HPROCI4_8_0_<br/>11:20:18,201 FST | [StringType] returning 'state' as column: TYPE5_8_0_<br/>11:20:18,201 FST | [StringType] returning 'sp.60007' as column: EXECUTION6_8_0_<br/>11:20:18,201 FST | [StringType] returning 'b' as column: ACTIVITY7_8_0_<br/>11:20:18,201 FST | [TimestampType] returning '2010-10-01 11:20:18' as column: START8_8_0_<br/>11:20:18,201 FST | [TimestampType] returning null as column: END9_8_0_<br/>11:20:18,201 FST | [LongType] returning '0' as column: DURATION10_8_0_<br/>11:20:18,201 FST | [StringType] returning null as column: TRANSITION11_8_0_<br/>11:20:18,201 FST | [IntegerType] returning '1' as column: NEXTIDX12_8_0_<br/>11:20:18,201 FST | [LongType] returning '60007' as column: HPROCI4_1_<br/>11:20:18,201 FST | [LongType] returning '60009' as column: DBID1_1_<br/>11:20:18,201 FIN | [SQL] select details0_.HACTI_ as HACTI8_1_, details0_.DBID_ as DBID1_1_, details0_.DBID_ as DBID1_11_0_, details0_.DBVERSION_ as DBVERSION3_11_0_, details0_.USERID_ as USERID4_11_0_, details0_.TIME_ as TIME5_11_0_, details0_.HPROCI_ as HPROCI6_11_0_, details0_.HPROCIIDX_ as HPROCIIDX7_11_0_, details0_.HACTI_ as HACTI8_11_0_, details0_.HACTIIDX_ as HACTIIDX9_11_0_, details0_.HTASK_ as HTASK10_11_0_, details0_.HTASKIDX_ as HTASKIDX11_11_0_, details0_.HVAR_ as HVAR12_11_0_, details0_.HVARIDX_ as HVARIDX13_11_0_, details0_.MESSAGE_ as MESSAGE14_11_0_, details0_.OLD_STR_ as OLD15_11_0_, details0_.NEW_STR_ as NEW16_11_0_, details0_.OLD_INT_ as OLD17_11_0_, details0_.NEW_INT_ as NEW18_11_0_, details0_.OLD_TIME_ as OLD19_11_0_, details0_.NEW_TIME_ as NEW20_11_0_, details0_.CLASS_ as CLASS2_11_0_ from JBPM4_HIST_DETAIL details0_ where details0_.HACTI_=?<br/>Hibernate: select details0_.HACTI_ as HACTI8_1_, details0_.DBID_ as DBID1_1_, details0_.DBID_ as DBID1_11_0_, details0_.DBVERSION_ as DBVERSION3_11_0_, details0_.USERID_ as USERID4_11_0_, details0_.TIME_ as TIME5_11_0_, details0_.HPROCI_ as HPROCI6_11_0_, details0_.HPROCIIDX_ as HPROCIIDX7_11_0_, details0_.HACTI_ as HACTI8_11_0_, details0_.HACTIIDX_ as HACTIIDX9_11_0_, details0_.HTASK_ as HTASK10_11_0_, details0_.HTASKIDX_ as HTASKIDX11_11_0_, details0_.HVAR_ as HVAR12_11_0_, details0_.HVARIDX_ as HVARIDX13_11_0_, details0_.MESSAGE_ as MESSAGE14_11_0_, details0_.OLD_STR_ as OLD15_11_0_, details0_.NEW_STR_ as NEW16_11_0_, details0_.OLD_INT_ as OLD17_11_0_, details0_.NEW_INT_ as NEW18_11_0_, details0_.OLD_TIME_ as OLD19_11_0_, details0_.NEW_TIME_ as NEW20_11_0_, details0_.CLASS_ as CLASS2_11_0_ from JBPM4_HIST_DETAIL details0_ where details0_.HACTI_=?<br/>11:20:18,201 FST | [LongType] binding '60008' to parameter: 1<br/>11:20:18,201 FIN | [SQL] select details0_.HACTI_ as HACTI8_1_, details0_.DBID_ as DBID1_1_, details0_.DBID_ as DBID1_11_0_, details0_.DBVERSION_ as DBVERSION3_11_0_, details0_.USERID_ as USERID4_11_0_, details0_.TIME_ as TIME5_11_0_, details0_.HPROCI_ as HPROCI6_11_0_, details0_.HPROCIIDX_ as HPROCIIDX7_11_0_, details0_.HACTI_ as HACTI8_11_0_, details0_.HACTIIDX_ as HACTIIDX9_11_0_, details0_.HTASK_ as HTASK10_11_0_, details0_.HTASKIDX_ as HTASKIDX11_11_0_, details0_.HVAR_ as HVAR12_11_0_, details0_.HVARIDX_ as HVARIDX13_11_0_, details0_.MESSAGE_ as MESSAGE14_11_0_, details0_.OLD_STR_ as OLD15_11_0_, details0_.NEW_STR_ as NEW16_11_0_, details0_.OLD_INT_ as OLD17_11_0_, details0_.NEW_INT_ as NEW18_11_0_, details0_.OLD_TIME_ as OLD19_11_0_, details0_.NEW_TIME_ as NEW20_11_0_, details0_.CLASS_ as CLASS2_11_0_ from JBPM4_HIST_DETAIL details0_ where details0_.HACTI_=?<br/>Hibernate: select details0_.HACTI_ as HACTI8_1_, details0_.DBID_ as DBID1_1_, details0_.DBID_ as DBID1_11_0_, details0_.DBVERSION_ as DBVERSION3_11_0_, details0_.USERID_ as USERID4_11_0_, details0_.TIME_ as TIME5_11_0_, details0_.HPROCI_ as HPROCI6_11_0_, details0_.HPROCIIDX_ as HPROCIIDX7_11_0_, details0_.HACTI_ as HACTI8_11_0_, details0_.HACTIIDX_ as HACTIIDX9_11_0_, details0_.HTASK_ as HTASK10_11_0_, details0_.HTASKIDX_ as HTASKIDX11_11_0_, details0_.HVAR_ as HVAR12_11_0_, details0_.HVARIDX_ as HVARIDX13_11_0_, details0_.MESSAGE_ as MESSAGE14_11_0_, details0_.OLD_STR_ as OLD15_11_0_, details0_.NEW_STR_ as NEW16_11_0_, details0_.OLD_INT_ as OLD17_11_0_, details0_.NEW_INT_ as NEW18_11_0_, details0_.OLD_TIME_ as OLD19_11_0_, details0_.NEW_TIME_ as NEW20_11_0_, details0_.CLASS_ as CLASS2_11_0_ from JBPM4_HIST_DETAIL details0_ where details0_.HACTI_=?<br/>11:20:18,201 FST | [LongType] binding '60009' to parameter: 1<br/>11:20:18,201 FIN | [SQL] select historyvar0_.HPROCI_ as HPROCI7_1_, historyvar0_.DBID_ as DBID1_1_, historyvar0_.DBID_ as DBID1_10_0_, historyvar0_.DBVERSION_ as DBVERSION2_10_0_, historyvar0_.PROCINSTID_ as PROCINSTID3_10_0_, historyvar0_.EXECUTIONID_ as EXECUTIO4_10_0_, historyvar0_.VARNAME_ as VARNAME5_10_0_, historyvar0_.VALUE_ as VALUE6_10_0_, historyvar0_.HPROCI_ as HPROCI7_10_0_, historyvar0_.HTASK_ as HTASK8_10_0_ from JBPM4_HIST_VAR historyvar0_ where historyvar0_.HPROCI_=?<br/>Hibernate: select historyvar0_.HPROCI_ as HPROCI7_1_, historyvar0_.DBID_ as DBID1_1_, historyvar0_.DBID_ as DBID1_10_0_, historyvar0_.DBVERSION_ as DBVERSION2_10_0_, historyvar0_.PROCINSTID_ as PROCINSTID3_10_0_, historyvar0_.EXECUTIONID_ as EXECUTIO4_10_0_, historyvar0_.VARNAME_ as VARNAME5_10_0_, historyvar0_.VALUE_ as VALUE6_10_0_, historyvar0_.HPROCI_ as HPROCI7_10_0_, historyvar0_.HTASK_ as HTASK8_10_0_ from JBPM4_HIST_VAR historyvar0_ where historyvar0_.HPROCI_=?<br/>11:20:18,201 FST | [LongType] binding '60007' to parameter: 1<br/>11:20:18,201 FIN | [SQL] select details0_.HPROCI_ as HPROCI6_1_, details0_.DBID_ as DBID1_1_, details0_.DBID_ as DBID1_11_0_, details0_.DBVERSION_ as DBVERSION3_11_0_, details0_.USERID_ as USERID4_11_0_, details0_.TIME_ as TIME5_11_0_, details0_.HPROCI_ as HPROCI6_11_0_, details0_.HPROCIIDX_ as HPROCIIDX7_11_0_, details0_.HACTI_ as HACTI8_11_0_, details0_.HACTIIDX_ as HACTIIDX9_11_0_, details0_.HTASK_ as HTASK10_11_0_, details0_.HTASKIDX_ as HTASKIDX11_11_0_, details0_.HVAR_ as HVAR12_11_0_, details0_.HVARIDX_ as HVARIDX13_11_0_, details0_.MESSAGE_ as MESSAGE14_11_0_, details0_.OLD_STR_ as OLD15_11_0_, details0_.NEW_STR_ as NEW16_11_0_, details0_.OLD_INT_ as OLD17_11_0_, details0_.NEW_INT_ as NEW18_11_0_, details0_.OLD_TIME_ as OLD19_11_0_, details0_.NEW_TIME_ as NEW20_11_0_, details0_.CLASS_ as CLASS2_11_0_ from JBPM4_HIST_DETAIL details0_ where details0_.HPROCI_=?<br/>Hibernate: select details0_.HPROCI_ as HPROCI6_1_, details0_.DBID_ as DBID1_1_, details0_.DBID_ as DBID1_11_0_, details0_.DBVERSION_ as DBVERSION3_11_0_, details0_.USERID_ as USERID4_11_0_, details0_.TIME_ as TIME5_11_0_, details0_.HPROCI_ as HPROCI6_11_0_, details0_.HPROCIIDX_ as HPROCIIDX7_11_0_, details0_.HACTI_ as HACTI8_11_0_, details0_.HACTIIDX_ as HACTIIDX9_11_0_, details0_.HTASK_ as HTASK10_11_0_, details0_.HTASKIDX_ as HTASKIDX11_11_0_, details0_.HVAR_ as HVAR12_11_0_, details0_.HVARIDX_ as HVARIDX13_11_0_, details0_.MESSAGE_ as MESSAGE14_11_0_, details0_.OLD_STR_ as OLD15_11_0_, details0_.NEW_STR_ as NEW16_11_0_, details0_.OLD_INT_ as OLD17_11_0_, details0_.NEW_INT_ as NEW18_11_0_, details0_.OLD_TIME_ as OLD19_11_0_, details0_.NEW_TIME_ as NEW20_11_0_, details0_.CLASS_ as CLASS2_11_0_ from JBPM4_HIST_DETAIL details0_ where details0_.HPROCI_=?<br/>11:20:18,201 FST | [LongType] binding '60007' to parameter: 1<br/>11:20:18,201 FIN | [SQL] select executioni0_.DBID_ as DBID1_3_, executioni0_.DBVERSION_ as DBVERSION3_3_, executioni0_.ACTIVITYNAME_ as ACTIVITY4_3_, executioni0_.PROCDEFID_ as PROCDEFID5_3_, executioni0_.HASVARS_ as HASVARS6_3_, executioni0_.NAME_ as NAME7_3_, executioni0_.KEY_ as KEY8_3_, executioni0_.ID_ as ID9_3_, executioni0_.STATE_ as STATE10_3_, executioni0_.SUSPHISTSTATE_ as SUSPHIS11_3_, executioni0_.PRIORITY_ as PRIORITY12_3_, executioni0_.HISACTINST_ as HISACTINST13_3_, executioni0_.PARENT_ as PARENT14_3_, executioni0_.INSTANCE_ as INSTANCE15_3_, executioni0_.SUPEREXEC_ as SUPEREXEC16_3_, executioni0_.SUBPROCINST_ as SUBPROC17_3_ from JBPM4_EXECUTION executioni0_ where executioni0_.ID_=? and (executioni0_.PARENT_ is null) limit ?<br/>Hibernate: select executioni0_.DBID_ as DBID1_3_, executioni0_.DBVERSION_ as DBVERSION3_3_, executioni0_.ACTIVITYNAME_ as ACTIVITY4_3_, executioni0_.PROCDEFID_ as PROCDEFID5_3_, executioni0_.HASVARS_ as HASVARS6_3_, executioni0_.NAME_ as NAME7_3_, executioni0_.KEY_ as KEY8_3_, executioni0_.ID_ as ID9_3_, executioni0_.STATE_ as STATE10_3_, executioni0_.SUSPHISTSTATE_ as SUSPHIS11_3_, executioni0_.PRIORITY_ as PRIORITY12_3_, executioni0_.HISACTINST_ as HISACTINST13_3_, executioni0_.PARENT_ as PARENT14_3_, executioni0_.INSTANCE_ as INSTANCE15_3_, executioni0_.SUPEREXEC_ as SUPEREXEC16_3_, executioni0_.SUBPROCINST_ as SUBPROC17_3_ from JBPM4_EXECUTION executioni0_ where executioni0_.ID_=? and (executioni0_.PARENT_ is null) limit ?<br/>11:20:18,201 FST | [StringType] binding 'sp.60007' to parameter: 1<br/>11:20:18,217 FST | [LongType] returning '60007' as column: DBID1_3_<br/>11:20:18,217 FST | [IntegerType] returning '2' as column: DBVERSION3_3_<br/>11:20:18,217 FST | [StringType] returning 'b' as column: ACTIVITY4_3_<br/>11:20:18,217 FST | [StringType] returning 'sp-5' as column: PROCDEFID5_3_<br/>11:20:18,217 FST | [BooleanType] returning 'false' as column: HASVARS6_3_<br/>11:20:18,217 FST | [StringType] returning null as column: NAME7_3_<br/>11:20:18,217 FST | [StringType] returning null as column: KEY8_3_<br/>11:20:18,217 FST | [StringType] returning 'sp.60007' as column: ID9_3_<br/>11:20:18,217 FST | [StringType] returning 'active-root' as column: STATE10_3_<br/>11:20:18,217 FST | [StringType] returning null as column: SUSPHIS11_3_<br/>11:20:18,217 FST | [IntegerType] returning '0' as column: PRIORITY12_3_<br/>11:20:18,217 FST | [LongType] returning '60009' as column: HISACTINST13_3_<br/>11:20:18,217 FST | [LongType] returning null as column: PARENT14_3_<br/>11:20:18,217 FST | [LongType] returning '60007' as column: INSTANCE15_3_<br/>11:20:18,217 FST | [LongType] returning null as column: SUPEREXEC16_3_<br/>11:20:18,217 FST | [LongType] returning null as column: SUBPROC17_3_<br/>11:20:18,217 FIN | [SQL] select executions0_.PARENT_ as PARENT14_1_, executions0_.DBID_ as DBID1_1_, executions0_.PARENT_IDX_ as PARENT18_1_, executions0_.DBID_ as DBID1_3_0_, executions0_.DBVERSION_ as DBVERSION3_3_0_, executions0_.ACTIVITYNAME_ as ACTIVITY4_3_0_, executions0_.PROCDEFID_ as PROCDEFID5_3_0_, executions0_.HASVARS_ as HASVARS6_3_0_, executions0_.NAME_ as NAME7_3_0_, executions0_.KEY_ as KEY8_3_0_, executions0_.ID_ as ID9_3_0_, executions0_.STATE_ as STATE10_3_0_, executions0_.SUSPHISTSTATE_ as SUSPHIS11_3_0_, executions0_.PRIORITY_ as PRIORITY12_3_0_, executions0_.HISACTINST_ as HISACTINST13_3_0_, executions0_.PARENT_ as PARENT14_3_0_, executions0_.INSTANCE_ as INSTANCE15_3_0_, executions0_.SUPEREXEC_ as SUPEREXEC16_3_0_, executions0_.SUBPROCINST_ as SUBPROC17_3_0_ from JBPM4_EXECUTION executions0_ where executions0_.PARENT_=?<br/>Hibernate: select executions0_.PARENT_ as PARENT14_1_, executions0_.DBID_ as DBID1_1_, executions0_.PARENT_IDX_ as PARENT18_1_, executions0_.DBID_ as DBID1_3_0_, executions0_.DBVERSION_ as DBVERSION3_3_0_, executions0_.ACTIVITYNAME_ as ACTIVITY4_3_0_, executions0_.PROCDEFID_ as PROCDEFID5_3_0_, executions0_.HASVARS_ as HASVARS6_3_0_, executions0_.NAME_ as NAME7_3_0_, executions0_.KEY_ as KEY8_3_0_, executions0_.ID_ as ID9_3_0_, executions0_.STATE_ as STATE10_3_0_, executions0_.SUSPHISTSTATE_ as SUSPHIS11_3_0_, executions0_.PRIORITY_ as PRIORITY12_3_0_, executions0_.HISACTINST_ as HISACTINST13_3_0_, executions0_.PARENT_ as PARENT14_3_0_, executions0_.INSTANCE_ as INSTANCE15_3_0_, executions0_.SUPEREXEC_ as SUPEREXEC16_3_0_, executions0_.SUBPROCINST_ as SUBPROC17_3_0_ from JBPM4_EXECUTION executions0_ where executions0_.PARENT_=?<br/>11:20:18,217 FST | [LongType] binding '60007' to parameter: 1<br/>11:20:18,217 FIN | [SQL] select this_.DBID_ as DBID1_12_1_, this_.DBVERSION_ as DBVERSION3_12_1_, this_.NAME_ as NAME4_12_1_, this_.DESCR_ as DESCR5_12_1_, this_.STATE_ as STATE6_12_1_, this_.SUSPHISTSTATE_ as SUSPHIST7_12_1_, this_.ASSIGNEE_ as ASSIGNEE8_12_1_, this_.FORM_ as FORM9_12_1_, this_.PRIORITY_ as PRIORITY10_12_1_, this_.CREATE_ as CREATE11_12_1_, this_.DUEDATE_ as DUEDATE12_12_1_, this_.PROGRESS_ as PROGRESS13_12_1_, this_.SIGNALLING_ as SIGNALLING14_12_1_, this_.EXECUTION_ID_ as EXECUTION15_12_1_, this_.ACTIVITY_NAME_ as ACTIVITY16_12_1_, this_.HASVARS_ as HASVARS17_12_1_, this_.SUPERTASK_ as SUPERTASK18_12_1_, this_.EXECUTION_ as EXECUTION19_12_1_, this_.PROCINST_ as PROCINST20_12_1_, this_.SWIMLANE_ as SWIMLANE21_12_1_, this_.TASKDEFNAME_ as TASKDEF22_12_1_, pi1_.DBID_ as DBID1_3_0_, pi1_.DBVERSION_ as DBVERSION3_3_0_, pi1_.ACTIVITYNAME_ as ACTIVITY4_3_0_, pi1_.PROCDEFID_ as PROCDEFID5_3_0_, pi1_.HASVARS_ as HASVARS6_3_0_, pi1_.NAME_ as NAME7_3_0_, pi1_.KEY_ as KEY8_3_0_, pi1_.ID_ as ID9_3_0_, pi1_.STATE_ as STATE10_3_0_, pi1_.SUSPHISTSTATE_ as SUSPHIS11_3_0_, pi1_.PRIORITY_ as PRIORITY12_3_0_, pi1_.HISACTINST_ as HISACTINST13_3_0_, pi1_.PARENT_ as PARENT14_3_0_, pi1_.INSTANCE_ as INSTANCE15_3_0_, pi1_.SUPEREXEC_ as SUPEREXEC16_3_0_, pi1_.SUBPROCINST_ as SUBPROC17_3_0_ from JBPM4_TASK this_ inner join JBPM4_EXECUTION pi1_ on this_.PROCINST_=pi1_.DBID_ where pi1_.ID_=?<br/>Hibernate: select this_.DBID_ as DBID1_12_1_, this_.DBVERSION_ as DBVERSION3_12_1_, this_.NAME_ as NAME4_12_1_, this_.DESCR_ as DESCR5_12_1_, this_.STATE_ as STATE6_12_1_, this_.SUSPHISTSTATE_ as SUSPHIST7_12_1_, this_.ASSIGNEE_ as ASSIGNEE8_12_1_, this_.FORM_ as FORM9_12_1_, this_.PRIORITY_ as PRIORITY10_12_1_, this_.CREATE_ as CREATE11_12_1_, this_.DUEDATE_ as DUEDATE12_12_1_, this_.PROGRESS_ as PROGRESS13_12_1_, this_.SIGNALLING_ as SIGNALLING14_12_1_, this_.EXECUTION_ID_ as EXECUTION15_12_1_, this_.ACTIVITY_NAME_ as ACTIVITY16_12_1_, this_.HASVARS_ as HASVARS17_12_1_, this_.SUPERTASK_ as SUPERTASK18_12_1_, this_.EXECUTION_ as EXECUTION19_12_1_, this_.PROCINST_ as PROCINST20_12_1_, this_.SWIMLANE_ as SWIMLANE21_12_1_, this_.TASKDEFNAME_ as TASKDEF22_12_1_, pi1_.DBID_ as DBID1_3_0_, pi1_.DBVERSION_ as DBVERSION3_3_0_, pi1_.ACTIVITYNAME_ as ACTIVITY4_3_0_, pi1_.PROCDEFID_ as PROCDEFID5_3_0_, pi1_.HASVARS_ as HASVARS6_3_0_, pi1_.NAME_ as NAME7_3_0_, pi1_.KEY_ as KEY8_3_0_, pi1_.ID_ as ID9_3_0_, pi1_.STATE_ as STATE10_3_0_, pi1_.SUSPHISTSTATE_ as SUSPHIS11_3_0_, pi1_.PRIORITY_ as PRIORITY12_3_0_, pi1_.HISACTINST_ as HISACTINST13_3_0_, pi1_.PARENT_ as PARENT14_3_0_, pi1_.INSTANCE_ as INSTANCE15_3_0_, pi1_.SUPEREXEC_ as SUPEREXEC16_3_0_, pi1_.SUBPROCINST_ as SUBPROC17_3_0_ from JBPM4_TASK this_ inner join JBPM4_EXECUTION pi1_ on this_.PROCINST_=pi1_.DBID_ where pi1_.ID_=?<br/>11:20:18,217 FST | [StringType] binding 'sp.60007' to parameter: 1<br/>11:20:18,217 FIN | [SQL] select this_.DBID_ as DBID1_6_1_, this_.DBVERSION_ as DBVERSION3_6_1_, this_.DUEDATE_ as DUEDATE4_6_1_, this_.STATE_ as STATE5_6_1_, this_.ISEXCLUSIVE_ as ISEXCLUS6_6_1_, this_.LOCKOWNER_ as LOCKOWNER7_6_1_, this_.LOCKEXPTIME_ as LOCKEXPT8_6_1_, this_.EXCEPTION_ as EXCEPTION9_6_1_, this_.RETRIES_ as RETRIES10_6_1_, this_.PROCESSINSTANCE_ as PROCESS11_6_1_, this_.EXECUTION_ as EXECUTION12_6_1_, this_.CFG_ as CFG13_6_1_, this_.SIGNAL_ as SIGNAL14_6_1_, this_.EVENT_ as EVENT15_6_1_, this_.REPEAT_ as REPEAT16_6_1_, this_.CLASS_ as CLASS2_6_1_, pi1_.DBID_ as DBID1_3_0_, pi1_.DBVERSION_ as DBVERSION3_3_0_, pi1_.ACTIVITYNAME_ as ACTIVITY4_3_0_, pi1_.PROCDEFID_ as PROCDEFID5_3_0_, pi1_.HASVARS_ as HASVARS6_3_0_, pi1_.NAME_ as NAME7_3_0_, pi1_.KEY_ as KEY8_3_0_, pi1_.ID_ as ID9_3_0_, pi1_.STATE_ as STATE10_3_0_, pi1_.SUSPHISTSTATE_ as SUSPHIS11_3_0_, pi1_.PRIORITY_ as PRIORITY12_3_0_, pi1_.HISACTINST_ as HISACTINST13_3_0_, pi1_.PARENT_ as PARENT14_3_0_, pi1_.INSTANCE_ as INSTANCE15_3_0_, pi1_.SUPEREXEC_ as SUPEREXEC16_3_0_, pi1_.SUBPROCINST_ as SUBPROC17_3_0_ from JBPM4_JOB this_ inner join JBPM4_EXECUTION pi1_ on this_.PROCESSINSTANCE_=pi1_.DBID_ where pi1_.ID_=?<br/>Hibernate: select this_.DBID_ as DBID1_6_1_, this_.DBVERSION_ as DBVERSION3_6_1_, this_.DUEDATE_ as DUEDATE4_6_1_, this_.STATE_ as STATE5_6_1_, this_.ISEXCLUSIVE_ as ISEXCLUS6_6_1_, this_.LOCKOWNER_ as LOCKOWNER7_6_1_, this_.LOCKEXPTIME_ as LOCKEXPT8_6_1_, this_.EXCEPTION_ as EXCEPTION9_6_1_, this_.RETRIES_ as RETRIES10_6_1_, this_.PROCESSINSTANCE_ as PROCESS11_6_1_, this_.EXECUTION_ as EXECUTION12_6_1_, this_.CFG_ as CFG13_6_1_, this_.SIGNAL_ as SIGNAL14_6_1_, this_.EVENT_ as EVENT15_6_1_, this_.REPEAT_ as REPEAT16_6_1_, this_.CLASS_ as CLASS2_6_1_, pi1_.DBID_ as DBID1_3_0_, pi1_.DBVERSION_ as DBVERSION3_3_0_, pi1_.ACTIVITYNAME_ as ACTIVITY4_3_0_, pi1_.PROCDEFID_ as PROCDEFID5_3_0_, pi1_.HASVARS_ as HASVARS6_3_0_, pi1_.NAME_ as NAME7_3_0_, pi1_.KEY_ as KEY8_3_0_, pi1_.ID_ as ID9_3_0_, pi1_.STATE_ as STATE10_3_0_, pi1_.SUSPHISTSTATE_ as SUSPHIS11_3_0_, pi1_.PRIORITY_ as PRIORITY12_3_0_, pi1_.HISACTINST_ as HISACTINST13_3_0_, pi1_.PARENT_ as PARENT14_3_0_, pi1_.INSTANCE_ as INSTANCE15_3_0_, pi1_.SUPEREXEC_ as SUPEREXEC16_3_0_, pi1_.SUBPROCINST_ as SUBPROC17_3_0_ from JBPM4_JOB this_ inner join JBPM4_EXECUTION pi1_ on this_.PROCESSINSTANCE_=pi1_.DBID_ where pi1_.ID_=?<br/>11:20:18,217 FST | [StringType] binding 'sp.60007' to parameter: 1<br/>11:20:18,217 FIN | [DbSessionImpl] Deleting process instance sp.60007<br/>11:20:18,217 FIN | [SQL] select variables0_.EXECUTION_ as EXECUTION7_1_, variables0_.DBID_ as DBID1_1_, variables0_.KEY_ as KEY4_1_, variables0_.DBID_ as DBID1_4_0_, variables0_.DBVERSION_ as DBVERSION3_4_0_, variables0_.KEY_ as KEY4_4_0_, variables0_.CONVERTER_ as CONVERTER5_4_0_, variables0_.HIST_ as HIST6_4_0_, variables0_.EXECUTION_ as EXECUTION7_4_0_, variables0_.TASK_ as TASK8_4_0_, variables0_.LOB_ as LOB9_4_0_, variables0_.DATE_VALUE_ as DATE10_4_0_, variables0_.DOUBLE_VALUE_ as DOUBLE11_4_0_, variables0_.CLASSNAME_ as CLASSNAME12_4_0_, variables0_.LONG_VALUE_ as LONG13_4_0_, variables0_.STRING_VALUE_ as STRING14_4_0_, variables0_.TEXT_VALUE_ as TEXT15_4_0_, variables0_.CLASS_ as CLASS2_4_0_ from JBPM4_VARIABLE variables0_ where variables0_.EXECUTION_=?<br/>Hibernate: select variables0_.EXECUTION_ as EXECUTION7_1_, variables0_.DBID_ as DBID1_1_, variables0_.KEY_ as KEY4_1_, variables0_.DBID_ as DBID1_4_0_, variables0_.DBVERSION_ as DBVERSION3_4_0_, variables0_.KEY_ as KEY4_4_0_, variables0_.CONVERTER_ as CONVERTER5_4_0_, variables0_.HIST_ as HIST6_4_0_, variables0_.EXECUTION_ as EXECUTION7_4_0_, variables0_.TASK_ as TASK8_4_0_, variables0_.LOB_ as LOB9_4_0_, variables0_.DATE_VALUE_ as DATE10_4_0_, variables0_.DOUBLE_VALUE_ as DOUBLE11_4_0_, variables0_.CLASSNAME_ as CLASSNAME12_4_0_, variables0_.LONG_VALUE_ as LONG13_4_0_, variables0_.STRING_VALUE_ as STRING14_4_0_, variables0_.TEXT_VALUE_ as TEXT15_4_0_, variables0_.CLASS_ as CLASS2_4_0_ from JBPM4_VARIABLE variables0_ where variables0_.EXECUTION_=?<br/>11:20:18,217 FST | [LongType] binding '60007' to parameter: 1<br/>11:20:18,217 FIN | [SQL] select systemvari0_.EXESYS_ as EXESYS16_1_, systemvari0_.DBID_ as DBID1_1_, systemvari0_.KEY_ as KEY4_1_, systemvari0_.DBID_ as DBID1_4_0_, systemvari0_.DBVERSION_ as DBVERSION3_4_0_, systemvari0_.KEY_ as KEY4_4_0_, systemvari0_.CONVERTER_ as CONVERTER5_4_0_, systemvari0_.HIST_ as HIST6_4_0_, systemvari0_.EXECUTION_ as EXECUTION7_4_0_, systemvari0_.TASK_ as TASK8_4_0_, systemvari0_.LOB_ as LOB9_4_0_, systemvari0_.DATE_VALUE_ as DATE10_4_0_, systemvari0_.DOUBLE_VALUE_ as DOUBLE11_4_0_, systemvari0_.CLASSNAME_ as CLASSNAME12_4_0_, systemvari0_.LONG_VALUE_ as LONG13_4_0_, systemvari0_.STRING_VALUE_ as STRING14_4_0_, systemvari0_.TEXT_VALUE_ as TEXT15_4_0_, systemvari0_.CLASS_ as CLASS2_4_0_ from JBPM4_VARIABLE systemvari0_ where systemvari0_.EXESYS_=?<br/>Hibernate: select systemvari0_.EXESYS_ as EXESYS16_1_, systemvari0_.DBID_ as DBID1_1_, systemvari0_.KEY_ as KEY4_1_, systemvari0_.DBID_ as DBID1_4_0_, systemvari0_.DBVERSION_ as DBVERSION3_4_0_, systemvari0_.KEY_ as KEY4_4_0_, systemvari0_.CONVERTER_ as CONVERTER5_4_0_, systemvari0_.HIST_ as HIST6_4_0_, systemvari0_.EXECUTION_ as EXECUTION7_4_0_, systemvari0_.TASK_ as TASK8_4_0_, systemvari0_.LOB_ as LOB9_4_0_, systemvari0_.DATE_VALUE_ as DATE10_4_0_, systemvari0_.DOUBLE_VALUE_ as DOUBLE11_4_0_, systemvari0_.CLASSNAME_ as CLASSNAME12_4_0_, systemvari0_.LONG_VALUE_ as LONG13_4_0_, systemvari0_.STRING_VALUE_ as STRING14_4_0_, systemvari0_.TEXT_VALUE_ as TEXT15_4_0_, systemvari0_.CLASS_ as CLASS2_4_0_ from JBPM4_VARIABLE systemvari0_ where systemvari0_.EXESYS_=?<br/>11:20:18,217 FST | [LongType] binding '60007' to parameter: 1<br/>11:20:18,217 FIN | [SQL] select swimlanes0_.EXECUTION_ as EXECUTION5_1_, swimlanes0_.DBID_ as DBID1_1_, swimlanes0_.NAME_ as NAME3_1_, swimlanes0_.DBID_ as DBID1_14_0_, swimlanes0_.DBVERSION_ as DBVERSION2_14_0_, swimlanes0_.NAME_ as NAME3_14_0_, swimlanes0_.ASSIGNEE_ as ASSIGNEE4_14_0_, swimlanes0_.EXECUTION_ as EXECUTION5_14_0_ from JBPM4_SWIMLANE swimlanes0_ where swimlanes0_.EXECUTION_=?<br/>Hibernate: select swimlanes0_.EXECUTION_ as EXECUTION5_1_, swimlanes0_.DBID_ as DBID1_1_, swimlanes0_.NAME_ as NAME3_1_, swimlanes0_.DBID_ as DBID1_14_0_, swimlanes0_.DBVERSION_ as DBVERSION2_14_0_, swimlanes0_.NAME_ as NAME3_14_0_, swimlanes0_.ASSIGNEE_ as ASSIGNEE4_14_0_, swimlanes0_.EXECUTION_ as EXECUTION5_14_0_ from JBPM4_SWIMLANE swimlanes0_ where swimlanes0_.EXECUTION_=?<br/>11:20:18,217 FST | [LongType] binding '60007' to parameter: 1<br/>11:20:18,217 FIN | [SQL] update JBPM4_HIST_ACTINST set HPROCI_=null where HPROCI_=?<br/>Hibernate: update JBPM4_HIST_ACTINST set HPROCI_=null where HPROCI_=?<br/>11:20:18,217 FST | [LongType] binding '60007' to parameter: 1<br/>11:20:18,232 FIN | [SQL] delete from JBPM4_HIST_ACTINST where DBID_=? and DBVERSION_=?<br/>Hibernate: delete from JBPM4_HIST_ACTINST where DBID_=? and DBVERSION_=?<br/>11:20:18,232 FST | [LongType] binding '60008' to parameter: 1<br/>11:20:18,232 FST | [IntegerType] binding '1' to parameter: 2<br/>11:20:18,232 FIN | [SQL] delete from JBPM4_HIST_ACTINST where DBID_=? and DBVERSION_=?<br/>Hibernate: delete from JBPM4_HIST_ACTINST where DBID_=? and DBVERSION_=?<br/>11:20:18,232 FST | [LongType] binding '60009' to parameter: 1<br/>11:20:18,232 FST | [IntegerType] binding '0' to parameter: 2<br/>11:20:18,232 FIN | [SQL] delete from JBPM4_HIST_PROCINST where DBID_=? and DBVERSION_=?<br/>Hibernate: delete from JBPM4_HIST_PROCINST where DBID_=? and DBVERSION_=?<br/>11:20:18,232 FST | [LongType] binding '60007' to parameter: 1<br/>11:20:18,232 FST | [IntegerType] binding '0' to parameter: 2<br/>11:20:18,232 FIN | [SQL] delete from JBPM4_EXECUTION where DBID_=? and DBVERSION_=?<br/>Hibernate: delete from JBPM4_EXECUTION where DBID_=? and DBVERSION_=?<br/>11:20:18,232 FST | [LongType] binding '60007' to parameter: 1<br/>11:20:18,232 FST | [IntegerType] binding '2' to parameter: 2<br/>11:20:18,232 WRN | [JDBCExceptionReporter] SQL Error: 1451, SQLState: 23000<br/>11:20:18,232 SEV | [JDBCExceptionReporter] Cannot delete or update a parent row: a foreign key constraint fails (`jbpmdb`.`jbpm4_execution`, CONSTRAINT `FK_EXEC_INSTANCE` FOREIGN KEY (`INSTANCE_`) REFERENCES `jbpm4_execution` (`DBID_`))<br/>### EXCEPTION ###########################################<br/>11:20:18,232 SEV | [AbstractFlushingEventListener] Could not synchronize database state with session<br/>org.hibernate.exception.ConstraintViolationException: could not delete: [org.jbpm.pvm.internal.model.ExecutionImpl#60007]<br/> at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)<br/> at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)<br/> at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2569)<br/> at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2725)<br/> at org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:97)<br/> at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)<br/> at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)<br/> at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:172)<br/> at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)<br/> at org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:64)<br/> at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:996)<br/> at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1589)<br/> at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:306)<br/> at org.jbpm.pvm.internal.hibernate.DbSessionImpl.deleteProcessDefinitionHistory(DbSessionImpl.java:113)<br/> at org.jbpm.pvm.internal.cmd.DeleteDeploymentCmd.execute(DeleteDeploymentCmd.java:76)<br/> at org.jbpm.pvm.internal.svc.DefaultCommandService.execute(DefaultCommandService.java:42)<br/> at org.jbpm.pvm.internal.tx.StandardTransactionInterceptor.execute(StandardTransactionInterceptor.java:50)<br/> at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.executeInNewEnvironment(EnvironmentInterceptor.java:53)<br/> at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:40)<br/> at org.jbpm.pvm.internal.svc.RetryInterceptor.execute(RetryInterceptor.java:56)<br/> at org.jbpm.pvm.internal.svc.SkipInterceptor.execute(SkipInterceptor.java:43)<br/> at org.jbpm.pvm.internal.repository.RepositoryServiceImpl.deleteDeploymentCascade(RepositoryServiceImpl.java:71)<br/> at com.mhgadm.za.sample.SampleProcessTest.deleteProcessDefinitation(SampleProcessTest.java:53)<br/> at com.mhgadm.za.sample.SampleProcessTest.main(SampleProcessTest.java:45)<br/>Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (`jbpmdb`.`jbpm4_execution`, CONSTRAINT `FK_EXEC_INSTANCE` FOREIGN KEY (`INSTANCE_`) REFERENCES `jbpm4_execution` (`DBID_`))<br/> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)<br/> at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)<br/> at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)<br/> at java.lang.reflect.Constructor.newInstance(Unknown Source)<br/> at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)<br/> at com.mysql.jdbc.Util.getInstance(Util.java:381)<br/> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015)<br/> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)<br/> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3536)<br/> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3468)<br/> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1957)<br/> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2107)<br/> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2648)<br/> at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2086)<br/> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2371)<br/> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2289)<br/> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2274)<br/> at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2551)<br/> ... 21 more<br/>### EXCEPTION ###########################################<br/>### EXCEPTION ###########################################<br/>11:20:18,232 INF | [DefaultCommandService] exception while executing command <a class="jive-link-external-small" href="mailto:org.jbpm.pvm.internal.cmd.DeleteDeploymentCmd@6a301bf5">org.jbpm.pvm.internal.cmd.DeleteDeploymentCmd@6a301bf5</a><br/>org.hibernate.exception.ConstraintViolationException: could not delete: [org.jbpm.pvm.internal.model.ExecutionImpl#60007]<br/> at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)<br/> at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)<br/> at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2569)<br/> at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2725)<br/> at org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:97)<br/> at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)<br/> at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)<br/> at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:172)<br/> at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)<br/> at org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:64)<br/> at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:996)<br/> at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1589)<br/> at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:306)<br/> at org.jbpm.pvm.internal.hibernate.DbSessionImpl.deleteProcessDefinitionHistory(DbSessionImpl.java:113)<br/> at org.jbpm.pvm.internal.cmd.DeleteDeploymentCmd.execute(DeleteDeploymentCmd.java:76)<br/> at org.jbpm.pvm.internal.svc.DefaultCommandService.execute(DefaultCommandService.java:42)<br/> at org.jbpm.pvm.internal.tx.StandardTransactionInterceptor.execute(StandardTransactionInterceptor.java:50)<br/> at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.executeInNewEnvironment(EnvironmentInterceptor.java:53)<br/> at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:40)<br/> at org.jbpm.pvm.internal.svc.RetryInterceptor.execute(RetryInterceptor.java:56)<br/> at org.jbpm.pvm.internal.svc.SkipInterceptor.execute(SkipInterceptor.java:43)<br/> at org.jbpm.pvm.internal.repository.RepositoryServiceImpl.deleteDeploymentCascade(RepositoryServiceImpl.java:71)<br/> at com.mhgadm.za.sample.SampleProcessTest.deleteProcessDefinitation(SampleProcessTest.java:53)<br/> at com.mhgadm.za.sample.SampleProcessTest.main(SampleProcessTest.java:45)<br/>Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (`jbpmdb`.`jbpm4_execution`, CONSTRAINT `FK_EXEC_INSTANCE` FOREIGN KEY (`INSTANCE_`) REFERENCES `jbpm4_execution` (`DBID_`))<br/> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)<br/> at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)<br/> at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)<br/> at java.lang.reflect.Constructor.newInstance(Unknown Source)<br/> at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)<br/> at com.mysql.jdbc.Util.getInstance(Util.java:381)<br/> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015)<br/> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)<br/> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3536)<br/> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3468)<br/> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1957)<br/> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2107)<br/> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2648)<br/> at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2086)<br/> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2371)<br/> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2289)<br/> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2274)<br/> at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2551)<br/> ... 21 more<br/>### EXCEPTION ###########################################<br/>11:20:18,248 FIN | [HibernateSessionResource] ----- rolling back hibernate tx 2088478793 -----------------------------------------------------</p><p><br/>=== Problem description =========================</p><p>ProcessDefinitation deployment and Process instance are working fine. The problem is in deleting the deployed ProcessDefinitation.</p><p>repositoryService.deleteDeploymentCascade(deploymentId) Exception <span> :) </span> [JDBCExceptionReporter] Cannot delete or update a parent row: a foreign key constraint fails (`jbpmdb`.`jbpm4_execution`, CONSTRAINT `FK_EXEC_INSTANCE` FOREIGN KEY (`INSTANCE_`) REFERENCES `jbpm4_execution` (`DBID_`))</p></div>
<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style="margin: 0;">Comment by <a href="http://community.jboss.org/docs/DOC-15927">going to Community</a></p>
<p style="margin: 0;">Create a new document in jBPM Development at <a href="http://community.jboss.org/choose-container!input.jspa?contentType=102&containerType=14&container=2035">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>