<!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;">
Error in Sample Task Service
</h3>
<span style="margin-bottom: 10px;">
created by <a href="http://community.jboss.org/people/blarevil">Mike Panetta</a> in <i>jBPM</i> - <a href="http://community.jboss.org/message/613053#613053">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 just downloaded the jbpm 5.1 full installer.  After installing and starting the demo, I went into the jbpm console and created a new instance</p><p>of the evaulation process.  Upon doing this, I get an error in the human task service (see below).  </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Any idea what I may be missing here?  Looks like some data is missing in the OrganizationalEntity table and I'm not sure how to go about loading this. Does this have anything to with the LoadUsers.mvel and LoadGroups.mvel files that are loaded when the task starts? I tried connecting to the H2 Database through eclipse, but I do not see any tables in this system.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>I treid out the jbpm 5.0 installer and have the same problem.  Several months ago I was able to get this demo running under the Drools Flow project, but I cannot find a download page for this project anymore.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>javax.persistence.RollbackException: Error while commiting the transaction</p><p>    at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:71)</p><p>    at org.jbpm.task.service.TaskServiceSession.doOperationInTransaction(TaskServiceSession.java:820)</p><p>    at org.jbpm.task.service.TaskServiceSession.addTask(TaskServiceSession.java:134)</p><p>    at org.jbpm.task.service.TaskServerHandler.messageReceived(TaskServerHandler.java:109)</p><p>    at org.jbpm.task.service.mina.MinaTaskServerHandler.messageReceived(MinaTaskServerHandler.java:41)</p><p>    at org.apache.mina.core.filterchain.DefaultIoFilterChain$TailFilter.messageReceived(DefaultIoFilterChain.java:713)</p><p>    at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434)</p><p>    at org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:46)</p><p>    at org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:793)</p><p>    at org.apache.mina.filter.codec.ProtocolCodecFilter$ProtocolDecoderOutputImpl.flush(ProtocolCodecFilter.java:375)</p><p>    at org.apache.mina.filter.codec.ProtocolCodecFilter.messageReceived(ProtocolCodecFilter.java:229)</p><p>    at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434)</p><p>    at org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:46)</p><p>    at org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:793)</p><p>    at org.apache.mina.filter.logging.LoggingFilter.messageReceived(LoggingFilter.java:176)</p><p>    at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434)</p><p>    at org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:46)</p><p>    at org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:793)</p><p>    at org.apache.mina.core.filterchain.IoFilterAdapter.messageReceived(IoFilterAdapter.java:119)</p><p>    at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434)</p><p>    at org.apache.mina.core.filterchain.DefaultIoFilterChain.fireMessageReceived(DefaultIoFilterChain.java:426)</p><p>    at org.apache.mina.core.polling.AbstractPollingIoProcessor.read(AbstractPollingIoProcessor.java:638)</p><p>    at org.apache.mina.core.polling.AbstractPollingIoProcessor.process(AbstractPollingIoProcessor.java:598)</p><p>    at org.apache.mina.core.polling.AbstractPollingIoProcessor.process(AbstractPollingIoProcessor.java:587)</p><p>    at org.apache.mina.core.polling.AbstractPollingIoProcessor.access$400(AbstractPollingIoProcessor.java:61)</p><p>    at org.apache.mina.core.polling.AbstractPollingIoProcessor$Processor.run(AbstractPollingIoProcessor.java:969)</p><p>    at org.apache.mina.util.NamePreservingRunnable.run(NamePreservingRunnable.java:64)</p><p>    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)</p><p>    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)</p><p>    at java.lang.Thread.run(Thread.java:680)</p><p>Caused by: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update</p><p>    at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)</p><p>    at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)</p><p>    at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)</p><p>    at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)</p><p>    at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:168)</p><p>    at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)</p><p>    at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)</p><p>    at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027)</p><p>    at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:365)</p><p>    at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:137)</p><p>    at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:54)</p><p>    ... 29 more</p><p>Caused by: org.h2.jdbc.JdbcBatchUpdateException: Referential integrity constraint violation: "FK27A9A59E619A0: PUBLIC.TASK FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.ORGANIZATIONALENTITY(ID)"; SQL statement:</p><p>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=? [23002-124]</p><p>    at org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1082)</p><p>    at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)</p><p>    at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)</p><p>    ... 37 more</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/613053#613053">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>