<!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;">
Re: TaskService Referential integrity constraint violation
</h3>
<span style="margin-bottom: 10px;">
created by <a href="http://community.jboss.org/people/GaryS">Gary Struthers</a> in <i>jBPM</i> - <a href="http://community.jboss.org/message/620978#620978">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>I changed <span style="text-decoration: underline;">WSHumanTaskHandler</span> to <span style="text-decoration: underline;">CommandBasedWSHumanTaskHandler</span> and that raises enough questions to start another discussion. This looks like it is persisting both session and task but a foreign key is wrong. Here is the console log I hope someone can see the problem.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">Hibernate: select task0_.id as col_0_0_, deadline1_.id as col_1_0_, deadline1_.deadline_date as col_2_0_ from Task task0_, Deadline deadline1_ where (deadline1_.id in (select startdeadl2_.id from Deadline startdeadl2_ where task0_.id=startdeadl2_.Deadlines_StartDeadLine_Id) or deadline1_.id in (select enddeadlin3_.id from Deadline enddeadlin3_ where task0_.id=enddeadlin3_.Deadlines_EndDeadLine_Id)) and deadline1_.escalated=0 order by deadline1_.deadline_date</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">Hibernate: insert into OrganizationalEntity (DTYPE, id) values ('User', ?)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">Hibernate: insert into OrganizationalEntity (DTYPE, id) values ('User', ?)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">Hibernate: insert into OrganizationalEntity (DTYPE, id) values ('User', ?)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">Hibernate: insert into OrganizationalEntity (DTYPE, id) values ('User', ?)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">Hibernate: insert into OrganizationalEntity (DTYPE, id) values ('Group', ?)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">Waiting for the Mina Server to come up</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">..Hibernate: insert into SessionInfo (id, lastModificationDate, rulesByteArray, startDate, OPTLOCK) values (null, ?, ?, ?, ?)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">Connected ? =>true</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">OBJECT ASSERTED value:PIvars [id=59f8c5d6-a18c-40a6-9e37-973f0e0ad0e8, appId=0, assignedTeam=null, assignedReader=null, applicationReady=false, score=null, canScore=false, validScore=false, arRecommended=false, eligible2ndRead=false, is2ndRead=false, need3ndRead=false, requiresQC=false] factId: 1</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">Hibernate: update SessionInfo set lastModificationDate=?, rulesByteArray=?, startDate=?, OPTLOCK=? where id=? and OPTLOCK=?</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">Hibernate: update SessionInfo set lastModificationDate=?, rulesByteArray=?, startDate=?, OPTLOCK=? where id=? and OPTLOCK=?</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">Hibernate: select sessioninf0_.id as id41_0_, sessioninf0_.lastModificationDate as lastModi2_41_0_, sessioninf0_.rulesByteArray as rulesByt3_41_0_, sessioninf0_.startDate as startDate41_0_, sessioninf0_.OPTLOCK as OPTLOCK41_0_ from SessionInfo sessioninf0_ where sessioninf0_.id=?</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">Hibernate: select processins0_.InstanceId as InstanceId42_0_, processins0_.lastModificationDate as lastModi2_42_0_, processins0_.lastReadDate as lastRead3_42_0_, processins0_.processId as processId42_0_, processins0_.processInstanceByteArray as processI5_42_0_, processins0_.startDate as startDate42_0_, processins0_.state as state42_0_, processins0_.OPTLOCK as OPTLOCK42_0_ from ProcessInstanceInfo processins0_ where processins0_.InstanceId=?</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">Hibernate: update SessionInfo set lastModificationDate=?, rulesByteArray=?, startDate=?, OPTLOCK=? where id=? and OPTLOCK=?</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">Hibernate: select sessioninf0_.id as id41_0_, sessioninf0_.lastModificationDate as lastModi2_41_0_, sessioninf0_.rulesByteArray as rulesByt3_41_0_, sessioninf0_.startDate as startDate41_0_, sessioninf0_.OPTLOCK as OPTLOCK41_0_ from SessionInfo sessioninf0_ where sessioninf0_.id=?</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">Hibernate: insert into ProcessInstanceInfo (InstanceId, lastModificationDate, lastReadDate, processId, processInstanceByteArray, startDate, state, OPTLOCK) values (null, ?, ?, ?, ?, ?, ?, ?)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">BEFORE RULEFLOW VARIABLE CHANGED canScore=true process:Read.bp[id=XXX]</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">AFTER RULEFLOW VARIABLE CHANGED canScore=true process:Read.bp[id=XXX]</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">BEFORE RULEFLOW VARIABLE CHANGED vars=PIvars [id=59f8c5d6-a18c-40a6-9e37-973f0e0ad0e8, appId=0, assignedTeam=null, assignedReader=null, applicationReady=false, score=null, canScore=false, validScore=false, arRecommended=false, eligible2ndRead=false, is2ndRead=false, need3ndRead=false, requiresQC=false] process:Read.bp[id=XXX]</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">AFTER RULEFLOW VARIABLE CHANGED vars=PIvars [id=59f8c5d6-a18c-40a6-9e37-973f0e0ad0e8, appId=0, assignedTeam=null, assignedReader=null, applicationReady=false, score=null, canScore=false, validScore=false, arRecommended=false, eligible2ndRead=false, is2ndRead=false, need3ndRead=false, requiresQC=false] process:Read.bp[id=XXX]</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">BEFORE RULEFLOW STARTED process:Read.bp[id=XXX]</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">BEFORE PROCESS NODE TRIGGERED node:Start[id=1] process:Read.bp[id=XXX]</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">BEFORE PROCESS NODE EXITED node:Start[id=1] process:Read.bp[id=XXX]</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">BEFORE PROCESS NODE TRIGGERED node:Score Application[id=6] process:PEfreshmanRead.bp[id=XXX]</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">Hibernate: insert into WorkItemInfo (workItemId, creationDate, name, processInstanceId, state, OPTLOCK, workItemByteArray) values (null, ?, ?, ?, ?, ?, ?)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">AFTER PROCESS NODE TRIGGERED node:Score Application[id=6] process:Read.bp[id=XXX]</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">AFTER PROCESS NODE TRIGGERED node:Start[id=1] process:Read.bp[id=XXX]</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">AFTER PROCESS NODE TRIGGERED node:Start[id=1] process:Read.bp[id=XXX]</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">AFTER RULEFLOW STARTED process:Read.bp[id=XXX]</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">Hibernate: insert into Task (id, allowedToDelegate, taskInitiator_id, priority, activationTime, actualOwner_id, createdBy_id, createdOn, documentAccessType, documentContentId, documentType, expirationTime, faultAccessType, faultContentId, faultName, faultType, outputAccessType, outputContentId, outputType, parentId, previousStatus, processInstanceId, skipable, status, workItemId) values (null, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">Hibernate: insert into I18NText (id, language, text) values (null, ?, ?)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">Hibernate: insert into Content (id, content) values (null, ?)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">Hibernate: update ProcessInstanceInfo set lastModificationDate=?, lastReadDate=?, processId=?, processInstanceByteArray=?, startDate=?, state=?, OPTLOCK=? where InstanceId=? and OPTLOCK=?</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">Hibernate: update Task set allowedToDelegate=?, taskInitiator_id=?, priority=?, activationTime=?, actualOwner_id=?, createdBy_id=?, createdOn=?, documentAccessType=?, documentContentId=?, documentType=?, expirationTime=?, faultAccessType=?, faultContentId=?, faultName=?, faultType=?, outputAccessType=?, outputContentId=?, outputType=?, parentId=?, previousStatus=?, processInstanceId=?, skipable=?, status=?, workItemId=? where id=?</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">Hibernate: update WorkItemInfo set creationDate=?, name=?, processInstanceId=?, state=?, OPTLOCK=?, workItemByteArray=? where workItemId=? and OPTLOCK=?</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">Hibernate: update I18NText set Task_Names_Id=? where id=?</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">Hibernate: insert into PeopleAssignments_BAs (task_id, entity_id) values (?, ?)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">Hibernate: insert into PeopleAssignments_PotOwners (task_id, entity_id) values (?, ?)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">Hibernate: update SessionInfo set lastModificationDate=?, rulesByteArray=?, startDate=?, OPTLOCK=? where id=? and OPTLOCK=?</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">0    14/08 12:33:53,996[NioProcessor-1] ERROR hibernate.util.JDBCExceptionReporter.logExceptions - Referential integrity constraint violation: "FK1EE418D2C122ED2: PUBLIC.PEOPLEASSIGNMENTS_POTOWNERS FOREIGN KEY(ENTITY_ID) REFERENCES PUBLIC.ORGANIZATIONALENTITY(ID)"; SQL statement:</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">insert into PeopleAssignments_PotOwners (task_id, entity_id) values (?, ?) [23002-128]</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">5    14/08 12:33:54,001[NioProcessor-1] ERROR hibernate.util.JDBCExceptionReporter.logExceptions - Referential integrity constraint violation: "FK1EE418D2C122ED2: PUBLIC.PEOPLEASSIGNMENTS_POTOWNERS FOREIGN KEY(ENTITY_ID) REFERENCES PUBLIC.ORGANIZATIONALENTITY(ID)"; SQL statement:</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">insert into PeopleAssignments_PotOwners (task_id, entity_id) values (?, ?) [23002-128]</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">7    14/08 12:33:54,003[NioProcessor-1] ERROR event.def.AbstractFlushingEventListener.performExecutions - Could not synchronize database state with session</p><p style="margin: 0.0px 0.0px 0.0px 0.0px; color: #150097;"><span style="text-decoration: underline;">org.hibernate.exception.ConstraintViolationException</span><span style="color: #000000;">: Could not execute JDBC batch update</span></p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">          at org.hibernate.exception.SQLStateConverter.convert(<span style="text-decoration: underline; color: #150097;">SQLStateConverter.java:71</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">          at org.hibernate.exception.JDBCExceptionHelper.convert(<span style="text-decoration: underline; color: #150097;">JDBCExceptionHelper.java:43</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">          at org.hibernate.jdbc.AbstractBatcher.executeBatch(<span style="text-decoration: underline; color: #150097;">AbstractBatcher.java:254</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">          at org.hibernate.engine.ActionQueue.executeActions(<span style="text-decoration: underline; color: #150097;">ActionQueue.java:266</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">          at org.hibernate.engine.ActionQueue.executeActions(<span style="text-decoration: underline; color: #150097;">ActionQueue.java:171</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">          at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(<span style="text-decoration: underline; color: #150097;">AbstractFlushingEventListener.java:298</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">          at org.hibernate.event.def.DefaultFlushEventListener.onFlush(<span style="text-decoration: underline; color: #150097;">DefaultFlushEventListener.java:27</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">          at org.hibernate.impl.SessionImpl.flush(<span style="text-decoration: underline; color: #150097;">SessionImpl.java:1001</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">          at org.hibernate.impl.SessionImpl.managedFlush(<span style="text-decoration: underline; color: #150097;">SessionImpl.java:339</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">          at org.hibernate.transaction.JDBCTransaction.commit(<span style="text-decoration: underline; color: #150097;">JDBCTransaction.java:106</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">          at org.hibernate.ejb.TransactionImpl.commit(<span style="text-decoration: underline; color: #150097;">TransactionImpl.java:54</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">          at org.jbpm.task.service.TaskServiceSession.doOperationInTransaction(<span style="text-decoration: underline; color: #150097;">TaskServiceSession.java:820</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">          at org.jbpm.task.service.TaskServiceSession.addTask(<span style="text-decoration: underline; color: #150097;">TaskServiceSession.java:134</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">          at org.jbpm.task.service.TaskServerHandler.messageReceived(<span style="text-decoration: underline; color: #150097;">TaskServerHandler.java:109</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">          at org.jbpm.task.service.mina.MinaTaskServerHandler.messageReceived(<span style="text-decoration: underline; color: #150097;">MinaTaskServerHandler.java:41</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">          at org.apache.mina.core.filterchain.DefaultIoFilterChain$TailFilter.messageReceived(<span style="text-decoration: underline; color: #150097;">DefaultIoFilterChain.java:713</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">          at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(<span style="text-decoration: underline; color: #150097;">DefaultIoFilterChain.java:434</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">          at org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(<span style="text-decoration: underline; color: #150097;">DefaultIoFilterChain.java:46</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">          at org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(<span style="text-decoration: underline; color: #150097;">DefaultIoFilterChain.java:793</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">          at org.apache.mina.filter.codec.ProtocolCodecFilter$ProtocolDecoderOutputImpl.flush(<span style="text-decoration: underline; color: #150097;">ProtocolCodecFilter.java:375</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">          at org.apache.mina.filter.codec.ProtocolCodecFilter.messageReceived(<span style="text-decoration: underline; color: #150097;">ProtocolCodecFilter.java:229</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">          at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(<span style="text-decoration: underline; color: #150097;">DefaultIoFilterChain.java:434</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">          at org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(<span style="text-decoration: underline; color: #150097;">DefaultIoFilterChain.java:46</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">          at org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(<span style="text-decoration: underline; color: #150097;">DefaultIoFilterChain.java:793</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">          at org.apache.mina.filter.logging.LoggingFilter.messageReceived(<span style="text-decoration: underline; color: #150097;">LoggingFilter.java:176</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">          at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(<span style="text-decoration: underline; color: #150097;">DefaultIoFilterChain.java:434</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">          at org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(<span style="text-decoration: underline; color: #150097;">DefaultIoFilterChain.java:46</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">          at org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(<span style="text-decoration: underline; color: #150097;">DefaultIoFilterChain.java:793</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">          at org.apache.mina.core.filterchain.IoFilterAdapter.messageReceived(<span style="text-decoration: underline; color: #150097;">IoFilterAdapter.java:119</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">          at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(<span style="text-decoration: underline; color: #150097;">DefaultIoFilterChain.java:434</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">          at org.apache.mina.core.filterchain.DefaultIoFilterChain.fireMessageReceived(<span style="text-decoration: underline; color: #150097;">DefaultIoFilterChain.java:426</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">          at org.apache.mina.core.polling.AbstractPollingIoProcessor.read(<span style="text-decoration: underline; color: #150097;">AbstractPollingIoProcessor.java:638</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">          at org.apache.mina.core.polling.AbstractPollingIoProcessor.process(<span style="text-decoration: underline; color: #150097;">AbstractPollingIoProcessor.java:598</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">          at org.apache.mina.core.polling.AbstractPollingIoProcessor.process(<span style="text-decoration: underline; color: #150097;">AbstractPollingIoProcessor.java:587</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">          at org.apache.mina.core.polling.AbstractPollingIoProcessor.access$400(<span style="text-decoration: underline; color: #150097;">AbstractPollingIoProcessor.java:61</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">          at org.apache.mina.core.polling.AbstractPollingIoProcessor$Processor.run(<span style="text-decoration: underline; color: #150097;">AbstractPollingIoProcessor.java:969</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">          at org.apache.mina.util.NamePreservingRunnable.run(<span style="text-decoration: underline; color: #150097;">NamePreservingRunnable.java:64</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">          at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(<span style="text-decoration: underline; color: #150097;">ThreadPoolExecutor.java:886</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">          at java.util.concurrent.ThreadPoolExecutor$Worker.run(<span style="text-decoration: underline; color: #150097;">ThreadPoolExecutor.java:908</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">          at java.lang.Thread.run(<span style="text-decoration: underline; color: #150097;">Thread.java:680</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">Caused by: <span style="text-decoration: underline; color: #150097;">org.h2.jdbc.JdbcBatchUpdateException</span>: Referential integrity constraint violation: "FK1EE418D2C122ED2: PUBLIC.PEOPLEASSIGNMENTS_POTOWNERS FOREIGN KEY(ENTITY_ID) REFERENCES PUBLIC.ORGANIZATIONALENTITY(ID)"; SQL statement:</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">insert into PeopleAssignments_PotOwners (task_id, entity_id) values (?, ?) [23002-128]</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">          at org.h2.jdbc.JdbcPreparedStatement.executeBatch(<span style="text-decoration: underline; color: #150097;">JdbcPreparedStatement.java:1119</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">          at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(<span style="text-decoration: underline; color: #150097;">BatchingBatcher.java:48</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">          at org.hibernate.jdbc.AbstractBatcher.executeBatch(<span style="text-decoration: underline; color: #150097;">AbstractBatcher.java:247</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">          ... 37 more</p><p style="margin: 0.0px 0.0px 0.0px 0.0px; color: #ff0000;"><span style="text-decoration: underline; color: #150097;">javax.persistence.RollbackException</span>: Error while commiting the transaction</p><p style="margin: 0.0px 0.0px 0.0px 0.0px; color: #ff0000;">          at org.hibernate.ejb.TransactionImpl.commit(<span style="text-decoration: underline; color: #150097;">TransactionImpl.java:71</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px; color: #ff0000;">          at org.jbpm.task.service.TaskServiceSession.doOperationInTransaction(<span style="text-decoration: underline; color: #150097;">TaskServiceSession.java:820</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px; color: #ff0000;">          at org.jbpm.task.service.TaskServiceSession.addTask(<span style="text-decoration: underline; color: #150097;">TaskServiceSession.java:134</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px; color: #ff0000;">          at org.jbpm.task.service.TaskServerHandler.messageReceived(<span style="text-decoration: underline; color: #150097;">TaskServerHandler.java:109</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px; color: #ff0000;">          at org.jbpm.task.service.mina.MinaTaskServerHandler.messageReceived(<span style="text-decoration: underline; color: #150097;">MinaTaskServerHandler.java:41</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px; color: #ff0000;">          at org.apache.mina.core.filterchain.DefaultIoFilterChain$TailFilter.messageReceived(<span style="text-decoration: underline; color: #150097;">DefaultIoFilterChain.java:713</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px; color: #ff0000;">          at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(<span style="text-decoration: underline; color: #150097;">DefaultIoFilterChain.java:434</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px; color: #ff0000;">          at org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(<span style="text-decoration: underline; color: #150097;">DefaultIoFilterChain.java:46</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px; color: #ff0000;">          at org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(<span style="text-decoration: underline; color: #150097;">DefaultIoFilterChain.java:793</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px; color: #ff0000;">          at org.apache.mina.filter.codec.ProtocolCodecFilter$ProtocolDecoderOutputImpl.flush(<span style="text-decoration: underline; color: #150097;">ProtocolCodecFilter.java:375</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px; color: #ff0000;">          at org.apache.mina.filter.codec.ProtocolCodecFilter.messageReceived(<span style="text-decoration: underline; color: #150097;">ProtocolCodecFilter.java:229</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px; color: #ff0000;">          at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(<span style="text-decoration: underline; color: #150097;">DefaultIoFilterChain.java:434</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px; color: #ff0000;">          at org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(<span style="text-decoration: underline; color: #150097;">DefaultIoFilterChain.java:46</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px; color: #ff0000;">          at org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(<span style="text-decoration: underline; color: #150097;">DefaultIoFilterChain.java:793</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px; color: #ff0000;">          at org.apache.mina.filter.logging.LoggingFilter.messageReceived(<span style="text-decoration: underline; color: #150097;">LoggingFilter.java:176</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px; color: #ff0000;">          at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(<span style="text-decoration: underline; color: #150097;">DefaultIoFilterChain.java:434</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px; color: #ff0000;">          at org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(<span style="text-decoration: underline; color: #150097;">DefaultIoFilterChain.java:46</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px; color: #ff0000;">          at org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(<span style="text-decoration: underline; color: #150097;">DefaultIoFilterChain.java:793</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px; color: #ff0000;">          at org.apache.mina.core.filterchain.IoFilterAdapter.messageReceived(<span style="text-decoration: underline; color: #150097;">IoFilterAdapter.java:119</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px; color: #ff0000;">          at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(<span style="text-decoration: underline; color: #150097;">DefaultIoFilterChain.java:434</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px; color: #ff0000;">          at org.apache.mina.core.filterchain.DefaultIoFilterChain.fireMessageReceived(<span style="text-decoration: underline; color: #150097;">DefaultIoFilterChain.java:426</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px; color: #ff0000;">          at org.apache.mina.core.polling.AbstractPollingIoProcessor.read(<span style="text-decoration: underline; color: #150097;">AbstractPollingIoProcessor.java:638</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px; color: #ff0000;">          at org.apache.mina.core.polling.AbstractPollingIoProcessor.process(<span style="text-decoration: underline; color: #150097;">AbstractPollingIoProcessor.java:598</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px; color: #ff0000;">          at org.apache.mina.core.polling.AbstractPollingIoProcessor.process(<span style="text-decoration: underline; color: #150097;">AbstractPollingIoProcessor.java:587</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px; color: #ff0000;">          at org.apache.mina.core.polling.AbstractPollingIoProcessor.access$400(<span style="text-decoration: underline; color: #150097;">AbstractPollingIoProcessor.java:61</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px; color: #ff0000;">          at org.apache.mina.core.polling.AbstractPollingIoProcessor$Processor.run(<span style="text-decoration: underline; color: #150097;">AbstractPollingIoProcessor.java:969</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px; color: #ff0000;">          at org.apache.mina.util.NamePreservingRunnable.run(<span style="text-decoration: underline; color: #150097;">NamePreservingRunnable.java:64</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px; color: #ff0000;">          at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(<span style="text-decoration: underline; color: #150097;">ThreadPoolExecutor.java:886</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px; color: #ff0000;">          at java.util.concurrent.ThreadPoolExecutor$Worker.run(<span style="text-decoration: underline; color: #150097;">ThreadPoolExecutor.java:908</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px; color: #ff0000;">          at java.lang.Thread.run(<span style="text-decoration: underline; color: #150097;">Thread.java:680</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px; color: #150097;"><span style="color: #ff0000;">Caused by: </span><span style="text-decoration: underline;">org.hibernate.exception.ConstraintViolationException</span><span style="color: #ff0000;">: Could not execute JDBC batch update</span></p><p style="margin: 0.0px 0.0px 0.0px 0.0px; color: #ff0000;">          at org.hibernate.exception.SQLStateConverter.convert(<span style="text-decoration: underline; color: #150097;">SQLStateConverter.java:71</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px; color: #ff0000;">          at org.hibernate.exception.JDBCExceptionHelper.convert(<span style="text-decoration: underline; color: #150097;">JDBCExceptionHelper.java:43</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px; color: #ff0000;">          at org.hibernate.jdbc.AbstractBatcher.executeBatch(<span style="text-decoration: underline; color: #150097;">AbstractBatcher.java:254</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px; color: #ff0000;">          at org.hibernate.engine.ActionQueue.executeActions(<span style="text-decoration: underline; color: #150097;">ActionQueue.java:266</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px; color: #ff0000;">          at org.hibernate.engine.ActionQueue.executeActions(<span style="text-decoration: underline; color: #150097;">ActionQueue.java:171</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px; color: #ff0000;">          at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(<span style="text-decoration: underline; color: #150097;">AbstractFlushingEventListener.java:298</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px; color: #ff0000;">          at org.hibernate.event.def.DefaultFlushEventListener.onFlush(<span style="text-decoration: underline; color: #150097;">DefaultFlushEventListener.java:27</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px; color: #ff0000;">          at org.hibernate.impl.SessionImpl.flush(<span style="text-decoration: underline; color: #150097;">SessionImpl.java:1001</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px; color: #ff0000;">          at org.hibernate.impl.SessionImpl.managedFlush(<span style="text-decoration: underline; color: #150097;">SessionImpl.java:339</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px; color: #ff0000;">          at org.hibernate.transaction.JDBCTransaction.commit(<span style="text-decoration: underline; color: #150097;">JDBCTransaction.java:106</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px; color: #ff0000;">          at org.hibernate.ejb.TransactionImpl.commit(<span style="text-decoration: underline; color: #150097;">TransactionImpl.java:54</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px; color: #ff0000;">          ... 29 more</p><p style="margin: 0.0px 0.0px 0.0px 0.0px; color: #ff0000;">Caused by: <span style="text-decoration: underline; color: #150097;">org.h2.jdbc.JdbcBatchUpdateException</span>: Referential integrity constraint violation: "FK1EE418D2C122ED2: PUBLIC.PEOPLEASSIGNMENTS_POTOWNERS FOREIGN KEY(ENTITY_ID) REFERENCES PUBLIC.ORGANIZATIONALENTITY(ID)"; SQL statement:</p><p style="margin: 0.0px 0.0px 0.0px 0.0px; color: #ff0000;">insert into PeopleAssignments_PotOwners (task_id, entity_id) values (?, ?) [23002-128]</p><p style="margin: 0.0px 0.0px 0.0px 0.0px; color: #ff0000;">          at org.h2.jdbc.JdbcPreparedStatement.executeBatch(<span style="text-decoration: underline; color: #150097;">JdbcPreparedStatement.java:1119</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px; color: #ff0000;">          at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(<span style="text-decoration: underline; color: #150097;">BatchingBatcher.java:48</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px; color: #ff0000;">          at org.hibernate.jdbc.AbstractBatcher.executeBatch(<span style="text-decoration: underline; color: #150097;">AbstractBatcher.java:247</span>)</p><p style="margin: 0.0px 0.0px 0.0px 0.0px; color: #ff0000;">          ... 37 more</p><p style="margin: 0.0px 0.0px 0.0px 0.0px;">Hibernate: update SessionInfo set lastModificationDate=?, rulesByteArray=?, startDate=?, OPTLOCK=? where id=? and OPTLOCK=?</p></div>
<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style="margin: 0;">Reply to this message by <a href="http://community.jboss.org/message/620978#620978">going to Community</a></p>
<p style="margin: 0;">Start a new discussion in jBPM at <a href="http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>