<!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;">
jBPM 4.3 deployment on oracle
</h3>
<span style="margin-bottom: 10px;">
created by <a href="http://community.jboss.org/people/joris.dewinne">Joris De Winne</a> in <i>jBPM</i> - <a href="http://community.jboss.org/message/556628#556628">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'm having an issue with one specific process deploying it on an oracle db. In total I've around 20 business process definitions. When the one specific process is included, I can not start any process execution. Not even an execution that has nothing to do with it. Also when going to the jBPM console I can not see the process definitions.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>My configuration:</p><p>- jBPM 4.3</p><p>- Oracle driver: 10.2.0.1.0</p><p>- Using the ant task to deploy: org.jbpm.pvm.internal.ant.JbpmDeployTask</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>The process definition that is giving the problems:</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><pre class="jive-pre"><code class="jive-code jive-xml">
<span class="jive-xml-tag"><?xml version="1.0" encoding="UTF-8"?></span>
<span class="jive-xml-tag"><span><process xmlns="</span><a class="jive-link-external-small" href="http://jbpm.org/4.0/jpdl" target="_blank">http://jbpm.org/4.0/jpdl</a><span>" name="notifySigningFinished"></span></span>
   <span class="jive-xml-tag"><start name="start1" g="21,233,48,48"></span><span class="jive-xml-tag"><transition to="getBundle"/></span><span class="jive-xml-tag"></start></span>
   <span class="jive-xml-comment"><!-- Check if bundle is both signed --></span>
   <span class="jive-xml-tag"><java ejb-jndi-name="SignatureProcessBean/local" method="getBundle" name="getBundle" var="bundle" g="200,162,92,48"></span>
      <span class="jive-xml-tag"><arg></span><span class="jive-xml-tag"><object expr="#{bundleId}"/></span><span class="jive-xml-tag"></arg></span>
      <span class="jive-xml-tag"><transition to="isSigned" g="-39,-21"/></span>
   <span class="jive-xml-tag"></java></span>
   <span class="jive-xml-tag"><decision name="isSigned" g="316,162,48,48"></span>
     <span class="jive-xml-tag"><transition name="to bundle is signed" to="fetchBundleInfo" g="-128,-22"></span>
           <span class="jive-xml-tag"><condition expr="#{bundle.signStatus eq 'BOTH_SIGNED'}" /></span>
      <span class="jive-xml-tag"></transition></span>
      <span class="jive-xml-tag"><transition name="to end" to="end" g="-3,-22"/></span>
   <span class="jive-xml-tag"></decision></span>
   <span class="jive-xml-tag"><java ejb-jndi-name="SignatureProcessBean/local" g="516,162,92,48" method="getBundleInfo" name="fetchBundleInfo" var="bundleInfo"></span>
      <span class="jive-xml-tag"><arg></span>
      <span class="jive-xml-tag"><object expr="#{bundleId}"/></span>
      <span class="jive-xml-tag"></arg></span>
      <span class="jive-xml-tag"><transition to="fetchMailToList"/></span>
   <span class="jive-xml-tag"></java></span>
   <span class="jive-xml-tag"><java ejb-jndi-name="SignatureProcessBean/local" g="650,162,92,48" method="getMailToAPLList" name="fetchMailToList" var="mailToAPLList"></span>
      <span class="jive-xml-tag"><transition to="bundle is signed"/></span>
   <span class="jive-xml-tag"></java></span>
    <span class="jive-xml-tag"><state name="bundle is signed" g="650,265,48,48"></span>
       <span class="jive-xml-tag"><transition name="end" to="end" /></span>
   <span class="jive-xml-tag"><transition name="timeout" to="sendBundleSignedNotification"></span>
      <span class="jive-xml-tag"><timer duedate="1 business seconds" /></span>
    <span class="jive-xml-tag"></transition></span>
  <span class="jive-xml-tag"></state></span>
  <span class="jive-xml-tag"><sub-process g="750,265,92,52" name="sendBundleSignedNotification" sub-process-key="sendBundleSignedMail"></span>
             <span class="jive-xml-tag"><parameter-in subvar="mailToAPLList" var="mailToAPLList"/></span>
             <span class="jive-xml-tag"><parameter-in subvar="bundleInfo" var="bundleInfo"/></span>
<span class="jive-xml-tag"><transition to="end"/></span>
   <span class="jive-xml-tag"></sub-process></span>
   <span class="jive-xml-tag"><end name="end" /></span>
<span class="jive-xml-tag"></process></span>
</code></pre><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>The exception I'm getting when starting a process execution:</p><pre class="jive-pre"><code class="jive-code">2010-08-09 18:16:04,465 INFO  [org.jbpm.pvm.internal.svc.DefaultCommandService] (EJB-Timer-1281101023833[target=jboss.j2ee:ear=***REMOVED***,name=***REMOVED***]) exception while executing command org.jbpm.pvm.internal.cmd.StartProcessInstanceInLatestCmd@51c50bce
java.lang.NullPointerException
        at java.io.ByteArrayInputStream.<init>(ByteArrayInputStream.java:89)
        at org.jbpm.pvm.internal.repository.ProcessDeployer.deploy(ProcessDeployer.java:63)
        at org.jbpm.pvm.internal.repository.DeployerManager.deploy(DeployerManager.java:46)
        at org.jbpm.pvm.internal.repository.RepositorySessionImpl.getObject(RepositorySessionImpl.java:129)
        at org.jbpm.pvm.internal.query.ProcessDefinitionQueryImpl.execute(ProcessDefinitionQueryImpl.java:72)
        at org.jbpm.pvm.internal.query.AbstractQuery.untypedList(AbstractQuery.java:71)
        at org.jbpm.pvm.internal.query.AbstractQuery.untypedUniqueResult(AbstractQuery.java:75)
        at org.jbpm.pvm.internal.query.ProcessDefinitionQueryImpl.uniqueResult(ProcessDefinitionQueryImpl.java:145)
        at org.jbpm.pvm.internal.repository.RepositorySessionImpl.findProcessDefinitionByKey(RepositorySessionImpl.java:153)
        at org.jbpm.pvm.internal.cmd.StartProcessInstanceInLatestCmd.execute(StartProcessInstanceInLatestCmd.java:58)
        at org.jbpm.pvm.internal.cmd.StartProcessInstanceInLatestCmd.execute(StartProcessInstanceInLatestCmd.java:38)
        at org.jbpm.pvm.internal.svc.DefaultCommandService.execute(DefaultCommandService.java:42)
        at org.jbpm.pvm.internal.tx.JtaTransactionInterceptor.executeInExistingTx(JtaTransactionInterceptor.java:70)
        at org.jbpm.pvm.internal.tx.JtaTransactionInterceptor.execute(JtaTransactionInterceptor.java:55)
        at org.jbpm.pvm.internal.tx.JtaRetryInterceptor.executeWithoutRetry(JtaRetryInterceptor.java:56)
        at org.jbpm.pvm.internal.tx.JtaRetryInterceptor.execute(JtaRetryInterceptor.java:48)
        at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.executeInNewEnvironment(EnvironmentInterceptor.java:53)
        at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:40)
        at org.jbpm.pvm.internal.svc.SkipInterceptor.execute(SkipInterceptor.java:43)
        at org.jbpm.pvm.internal.svc.ExecutionServiceImpl.startProcessInstanceByKey(ExecutionServiceImpl.java:66)
        at be.cirb.business.beans.upload.TriggerProcessFilesImpl.timeout(TriggerProcessFilesImpl.java:39)
        at sun.reflect.GeneratedMethodAccessor487.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.jboss.aop.joinpoint.MethodInvocation.invokeTarget(MethodInvocation.java:122)
        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:111)
        at org.jboss.ejb3.EJBContainerInvocationWrapper.invokeNext(EJBContainerInvocationWrapper.java:69)
        at org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor$InvocationContext.proceed(InvocationContextInterceptor.java:138)
        at org.jboss.seam.intercept.EJBInvocationContext.proceed(EJBInvocationContext.java:44)
        at org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:101)
        at org.jboss.seam.intercept.SessionBeanInterceptor.aroundInvoke(SessionBeanInterceptor.java:50)
        at sun.reflect.GeneratedMethodAccessor395.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.jboss.ejb3.interceptors.aop.EJB3InterceptorInterceptor.invoke(EJB3InterceptorInterceptor.java:83)
        at org.jboss.ejb3.interceptors.aop.EJB3InterceptorInterceptor.invoke(EJB3InterceptorInterceptor.java:70)
        at org.jboss.ejb3.EJBContainerInvocationWrapper.invokeNext(EJBContainerInvocationWrapper.java:59)
        at org.jboss.ejb3.interceptors.aop.InterceptorSequencer.invoke(InterceptorSequencer.java:76)
        at org.jboss.ejb3.interceptors.aop.InterceptorSequencer.aroundInvoke(InterceptorSequencer.java:62)
        at sun.reflect.GeneratedMethodAccessor394.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
</code></pre><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>When deploying it on a local mySQL, I've no problems.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Some additional remarks: I've had similar problems with oracle in the past (deploying jBPM business processes). I could fix them by removing all xml comments from the jpdl files and also any DOS line feeds. When doing a google search on this issue, I can find one related post (<a class="jive-link-external-small" href="http://permalink.gmane.org/gmane.comp.java.jboss.user/293637">http://permalink.gmane.org/gmane.comp.java.jboss.user/293637</a>), but I can not find back that message in the user forums, so no idea if there's a solution for this.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Joris</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </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/556628#556628">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>