topic Re: Complete Task error jpa_entity in Alfresco Archive

Complete Task error jpa_entity

jcharnet — Fri, 26 Aug 2011 19:01:07 GMT

Hello, I'm having an error when I try to complete a human task through Activiti Explorer.I'm starting the workflow through my own APP, and then use Activiti Explorer to claim and complete the Task.Here is my error Cause: org.apache.ibatis.exceptions.PersistenceException: ### Error querying database.

Re: Complete Task error jpa_entity

frederikherema1 — Mon, 29 Aug 2011 11:50:26 GMT

Does your configuration state you're using JPA? If not, the JPA-type will not be registered… The applicationContext.xml (if you're using explorer2) contains the engine configuration by the way:

http://www.activiti.org/userguide/index.html#jpaconfiguration , relevant properties:


 <property name="jpaPersistenceUnitName" value="activiti-jpa-pu" />
    <property name="jpaHandleTransaction" value="true" />
    <property name="jpaCloseEntityManager" value="true" />

Re: Complete Task error jpa_entity

jcharnet — Mon, 29 Aug 2011 12:55:59 GMT

Thanks for your reply.
This error is happening from Activiti Explorer (the newer version from Activiti 5.7), when I click on the Complete button, from a user task.

When you asked if my configuration stated using JPA, do you mean my application that starts the workflow and sets the entity in the process ?
If so, it is configured to use JPA, but it did not have these 2 parameters you mentioned jpaHandleTransaction and jpaCloseEntityManager.
I've set these 2 parameters in my application, and also in Activiti Explorer. Executed my workflow from my application, and went in Activiti Explorer, to claim and complete the task. When I clicked the complete button, I got the same exception
Caused by: org.activiti.engine.ActivitiException: unknown variable type name jpa-entity

Am I missing some other configuration ?

Thanks again.

John

Re: Complete Task error jpa_entity

jbarrez — Mon, 29 Aug 2011 13:32:14 GMT

Have you changed the applicationContext.xml file in the explorer webapp?

Re: Complete Task error jpa_entity

jcharnet — Mon, 29 Aug 2011 13:47:23 GMT

Yes, this is what my processEngineConfiguration looks like

<bean id="processEngineConfiguration" class="org.activiti.spring.SpringProcessEngineConfiguration">
   <property name="dataSource" ref="dataSource" />
   <property name="transactionManager" ref="transactionManager" />
   <property name="databaseSchemaUpdate" value="true" />
   <property name="jobExecutorActivate" value="true" />
   <property name="jpaHandleTransaction" value="true" />
   <property name="jpaCloseEntityManager" value="true" />
    <property name="customFormTypes">
      <list>
        <ref bean="userFormType"/>
      </list>
    </property>
</bean>

Re: Complete Task error jpa_entity

frederikherema1 — Mon, 29 Aug 2011 15:03:43 GMT

You should also set the EntityManager in your activiti-configuration that should be used, otherwise the JPA-variable type won't be added… This is off course required, to fetch/save the entities you're using.

Re: Complete Task error jpa_entity

jcharnet — Mon, 05 Sep 2011 14:16:10 GMT

Sorry for the delay to answer.
I just did a test, configuring my jpa settings in Activiti Exploerer, copying all the necessary jars. Everything seems do go well.
But now, when I try to view my process instance (that has the jpa entity), I'm getting the following error:

org.activiti.engine.ActivitiException: Cannot flush EntityManager, an active transaction is required

Any idea on what I need to do to configure this ?

Thanks,

John

Re: Complete Task error jpa_entity

frederikherema1 — Mon, 05 Sep 2011 14:20:11 GMT

Can you elaborate a bit more on your setup:

- How does your process look?
- How and where do you add the JPA-entity to the process.
- Where are you viewing your process when you say "I try to view my process instance (that has the jpa entity), I'm getting the following error:"

Re: Complete Task error jpa_entity

jcharnet — Mon, 05 Sep 2011 14:32:22 GMT

- Not sure what you mean by this question ("How does your process look").
My process is a simple workflow that has a Service task and a human task.
My web application starts the workflow and passes my entity as a parameter. My service task, uses this entity to validate some information and then calls a my Spring class to do some business rule. Then comes the human task, which is waiting for some user to claim and complete the task.
I'm trying to use activiti to view my process instance (My instance menu). So that I can see what step I'm in, in the workflow.

Did I clarify anything for you ?
If you need any other information, please let me know.

Thanks.

Re: Complete Task error jpa_entity

frederikherema1 — Mon, 05 Sep 2011 14:55:42 GMT

By the look of your process I mean the XML

So your webapp is running in the same tomcat as the activiti-explorer? If yes, is the activiti explorer and your other app configured the same way (in terms of entity-manager configuration etc)?

Re: Complete Task error jpa_entity

jcharnet — Mon, 05 Sep 2011 15:56:41 GMT

Sorry about the misunderstanding.

Here is my XML:

<?xml version="1.0" encoding="UTF-8"?>
<definitions xmlns="http://www.omg.org/spec/BPMN/20100524/MODEL" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:activiti="http://activiti.org/bpmn" xmlns:bpmndi="http://www.omg.org/spec/BPMN/20100524/DI" xmlns:smileysurprised:mgdc="http://www.omg.org/spec/DD/20100524/DC" xmlns:smileysurprised:mgdi="http://www.omg.org/spec/DD/20100524/DI" typeLanguage="http://www.w3.org/2001/XMLSchema" expressionLanguage="http://www.w3.org/1999/XPath" targetNamespace="http://www.softwasa.com">
  <process id="CondPagtoWorkflow" name="Workflow de Condição de Pagamento">
    <startEvent id="startevent1" name="Start"></startEvent>
    <scriptTask id="verificaDiasParcela" name="Verifica Dias Parcela" scriptFormat="groovy">
      <script><![CDATA[if (entity != null) {
 for (condPagDia in entity.getSwCondPagamentoDiaCollection()) {
  if (condPagDia.getQtdeDiasPagto().intValue() > Integer.valueOf(qtdeDiasMaximo).intValue()) {
   swCondPagamentoService.changeTipoParcela(condPagDia);
  }
 }
}]]></script>
    </scriptTask>
    <sequenceFlow id="flow1" name="" sourceRef="startevent1" targetRef="verificaDiasParcela"></sequenceFlow>
    <userTask id="aprovarCondPagto" name="Aprovar" activiti:candidateGroups="${normalGroup}"></userTask>
    <sequenceFlow id="flow2" name="" sourceRef="verificaDiasParcela" targetRef="aprovarCondPagto"></sequenceFlow>
    <endEvent id="endevent1" name="End"></endEvent>
    <sequenceFlow id="flow3" name="" sourceRef="aprovarCondPagto" targetRef="endevent1"></sequenceFlow>
  </process>
  <bpmndi:BPMNDiagram id="BPMNDiagram_CondPagtoWorkflow">
    <bpmndi:BPMNPlane bpmnElement="CondPagtoWorkflow" id="BPMNPlane_CondPagtoWorkflow">
      <bpmndi:BPMNShape bpmnElement="startevent1" id="BPMNShape_startevent1">
        <omgdc:Bounds height="35" width="35" x="72" y="157"></omgdc:Bounds>
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape bpmnElement="verificaDiasParcela" id="BPMNShape_verificaDiasParcela">
        <omgdc:Bounds height="55" width="141" x="180" y="147"></omgdc:Bounds>
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape bpmnElement="aprovarCondPagto" id="BPMNShape_aprovarCondPagto">
        <omgdc:Bounds height="55" width="105" x="380" y="147"></omgdc:Bounds>
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape bpmnElement="endevent1" id="BPMNShape_endevent1">
        <omgdc:Bounds height="35" width="35" x="570" y="157"></omgdc:Bounds>
      </bpmndi:BPMNShape>
      <bpmndi:BPMNEdge bpmnElement="flow1" id="BPMNEdge_flow1">
        <omgdi:waypoint x="107" y="174"></omgdi:waypoint>
        <omgdi:waypoint x="180" y="174"></omgdi:waypoint>
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge bpmnElement="flow2" id="BPMNEdge_flow2">
        <omgdi:waypoint x="321" y="174"></omgdi:waypoint>
        <omgdi:waypoint x="380" y="174"></omgdi:waypoint>
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge bpmnElement="flow3" id="BPMNEdge_flow3">
        <omgdi:waypoint x="485" y="174"></omgdi:waypoint>
        <omgdi:waypoint x="570" y="174"></omgdi:waypoint>
      </bpmndi:BPMNEdge>
    </bpmndi:BPMNPlane>
  </bpmndi:BPMNDiagram>
</definitions>

Actually I'm running activiti as a separate application, with it's own tomcat. Could this be a problem ?
I wanted to demonstrate that with activiti, we can integrate different types of "client" to view and show workflow processes information.

Re: Complete Task error jpa_entity

frederikherema1 — Tue, 06 Sep 2011 08:03:24 GMT

Running on different machines is no issue. But you should make sure the configuration is exactly the same (JPA-related). How is the explorer-app configured (spring-context)?

Re: Complete Task error jpa_entity

jcharnet — Tue, 06 Sep 2011 12:21:00 GMT

It worked.
I had missed that activiti-explorer had a transactionManager bean defined, that was overriding my transactionManagaer bean. I commented the activiti bean, and it worked.

Thanks for all the help !

Sincerely,

John

Re: Complete Task error jpa_entity

frederikherema1 — Tue, 06 Sep 2011 12:52:58 GMT

No problem, nice it works out for you!