Hyland Connect

ct1 · ‎06-28-2012

I am seeing the OptimisticLockingException that plagues my use of timers and boundary events.

While trying to use a timer start event, I am getting the OptimisticLockingException.

With this very simple process, I am just trying to start the process at a specified time and log via a script task that it started. I had no other Process Engines running (although .war files that contain applications that create Process Engines were on the classpath). I have read and reread the User's Guide and the Activiti In Action sections describing the timers, but still am unable to make even a simple one to work without throwing an exception.

I am running Activiti 5.9, Microsoft SQL Server 2008 R2, jtds-1.2.5, Apache Tomcat 7.0.27 on Windows 7

Would you please have time to point out what I am doing incorrectly? I am having similar problems using boundary timer events, but I think that if I can get this simple process to work, I might be able to get the boundary timer events to work also.

Here is the BPMN file:


<?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:omgdc="http://www.omg.org/spec/DD/20100524/DC" xmlns:omgdi="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.activiti.org/test">
  <process id="timeStartProc01" name="Timer Start Proc 01">
    <startEvent id="timerProc01Start" name="Timer Proc01 Start ">
[b]      <timerEventDefinition>
        <timeDate>2012-06-28T12:01:00</timeDate>
      </timerEventDefinition>[/b]
    </startEvent>
    <scriptTask id="scripttask1" name="Script Task" scriptFormat="groovy">
      <script><![CDATA[Date timerStarted = new Date();
String timerStartedStr = timerStarted.format('yyyy/MM/dd HH:mm:ss SSS');
print "Timer-Start-Proc 01 logged at $timerStartedStr \n";]]></script>
    </scriptTask>
    <endEvent id="timerStartProc01End" name="tTmer Start Proc01 End"></endEvent>
    <sequenceFlow id="flow1" name="" sourceRef="timerProc01Start" targetRef="scripttask1"></sequenceFlow>
    <sequenceFlow id="flow2" name="" sourceRef="scripttask1" targetRef="timerStartProc01End"></sequenceFlow>
  </process>
  <bpmndi:BPMNDiagram id="BPMNDiagram_timeStartProc01">
    <bpmndi:BPMNPlane bpmnElement="timeStartProc01" id="BPMNPlane_timeStartProc01">
      <bpmndi:BPMNShape bpmnElement="timerProc01Start" id="BPMNShape_timerProc01Start">
        <omgdc:Bounds height="35" width="35" x="110" y="230"></omgdc:Bounds>
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape bpmnElement="scripttask1" id="BPMNShape_scripttask1">
        <omgdc:Bounds height="55" width="105" x="220" y="220"></omgdc:Bounds>
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape bpmnElement="timerStartProc01End" id="BPMNShape_timerStartProc01End">
        <omgdc:Bounds height="35" width="35" x="390" y="230"></omgdc:Bounds>
      </bpmndi:BPMNShape>
      <bpmndi:BPMNEdge bpmnElement="flow1" id="BPMNEdge_flow1">
        <omgdi:waypoint x="145" y="247"></omgdi:waypoint>
        <omgdi:waypoint x="220" y="247"></omgdi:waypoint>
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge bpmnElement="flow2" id="BPMNEdge_flow2">
        <omgdi:waypoint x="325" y="247"></omgdi:waypoint>
        <omgdi:waypoint x="390" y="247"></omgdi:waypoint>
      </bpmndi:BPMNEdge>
    </bpmndi:BPMNPlane>
  </bpmndi:BPMNDiagram>
</definitions>
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

And, this is the activiti.cfg.xml


<?xml version="1.0" encoding="UTF-8"?>

<beans xmlns="http://www.springframework.org/schema/beans" 
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xsi:schemaLocation="http://www.springframework.org/schema/beans   http://www.springframework.org/schema/beans/spring-beans.xsd">

  <bean id="processEngineConfiguration" class="org.activiti.engine.impl.cfg.StandaloneProcessEngineConfiguration">
  
    <!– Database configurations –>
    <property name="databaseSchemaUpdate" value="true" />
   
   <property name="databaseType" value="mssql" />
   
    <property name="jdbcUrl" value="jdbc:jtds:sqlserver://lusr1315:1433/Activiti_DB" />
    <property name="jdbcDriver" value="net.sourceforge.jtds.jdbc.Driver" />
    <property name="jdbcUsername" value="xxxxxxxxxxx" />
    <property name="jdbcPassword" value="yyyyyyyyyyyy" />
    
    <property name="jobExecutorActivate" value="true" />
   
   <property name="mailServerHost" value="localhost" />
   <property name="mailServerPort" value="25" />

  </bean>

</beans>
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

And this is the exception I get at the time the timer start event should begin:


Jun 28, 2012 12:01:00 PM org.activiti.engine.impl.interceptor.CommandContext close
SEVERE: Error while closing command context
org.activiti.engine.ActivitiOptimisticLockingException: TimerEntity[959818] was updated by another t
ransaction concurrently
        at org.activiti.engine.impl.db.DbSqlSession.flushUpdates(DbSqlSession.java:452)
        at org.activiti.engine.impl.db.DbSqlSession.flush(DbSqlSession.java:348)
        at org.activiti.engine.impl.interceptor.CommandContext.flushSessions(CommandContext.java:149
)
        at org.activiti.engine.impl.interceptor.CommandContext.close(CommandContext.java:105)
        at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInte
rceptor.java:49)
        at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33)
        at org.activiti.engine.impl.jobexecutor.AcquireJobsRunnable.run(AcquireJobsRunnable.java:57)

        at java.lang.Thread.run(Thread.java:662)
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Thank you.

frederikherema1 · ‎06-29-2012

Hi, seems like there are 2 job-executors running:


 at org.activiti.engine.impl.jobexecutor.AcquireJobsRunnable.run(AcquireJobsRunnable.java:57)

Make sure there are not more activiti.cfg.xml-files on your class path if you are using the ProcessEngines.getDefaultProcessEngine() approach (explorer does this by default). Alternatively, you can try to specify the correct file to load instead of just using ProcessEngines.getDefaultProcessEngine…

ct1 · ‎06-29-2012

Thank you for reviewing my post.

Here is a little more information.

I looked in the Activiti Rest classpath for activiti.cfg.xml files and found only one.
(It was in the …webapps\activiti-rest\WEB-INF\classes directory.) Do you think
there could be one hidden in one of the .jar files?

I used Activiti Explorer to deploy the BPMN20.xml file below. Then signed out of Explorer.

I stopped Tomcat and restarted the entire workstation. This should have stopped any
Process Engines that were running.

Then I started the instance of Tomcat that has the activiti-rest.war file in its webapp directory.
Looking at the Log File below, it looks like two Job Executors were started. Does it look like that to you?
Do you still think this indicates the presence of multiple activiti.cfg.xml files?

When the timer start event was supposed to start, the exception was thrown, as before. The next task
in the process did run, even though the exception was thrown.

I do have a general question, in addition to the specific ones above. If the existance of multiple
ProcessEngines causes a Timer Start Event to throw this exception, would the exception also
be thrown when I have another application that completes tasks in another BPMN process while
this Timer Start Event is waiting to start?

Log file when starting Tomcat:

Jun 29, 2012 8:57:41 AM org.activiti.engine.ProcessEngines initProcessEnginFromResource
INFO: initializing process engine for resource file:/C:/Workflow/Tomcat/apache-tomcat-7.0.27/webapps
/activiti-rest/WEB-INF/classes/activiti.cfg.xml

http://www.slf4j.org/codes.html#StaticLoggerBinder

Jun 29, 2012 8:57:43 AM org.activiti.engine.impl.ProcessEngineImpl <init>
INFO: ProcessEngine default created <<<<<<<<<<<<<<<<<<<<<<<<< ——— One ProcessEngine created???
Jun 29, 2012 8:57:43 AM org.activiti.engine.impl.jobexecutor.JobExecutor start
INFO: Starting up the JobExecutor[org.activiti.engine.impl.jobexecutor.DefaultJobExecutor].
Jun 29, 2012 8:57:43 AM org.activiti.engine.ProcessEngines initProcessEnginFromResource
INFO: initialised process engine default
Jun 29, 2012 8:57:43 AM org.activiti.engine.impl.jobexecutor.AcquireJobsRunnable run

INFO: Loading XML bean definitions from URL [file:/C:/Workflow/Tomcat/apache-tomcat-7.0.27/webapps/a
ctiviti-rest/WEB-INF/classes/activiti-context.xml]

Jun 29, 2012 8:57:43 AM org.activiti.engine.impl.ProcessEngineImpl <init>
INFO: ProcessEngine default created <<<<<<<<<<<<<<<<<<<<<<<<< ————- Second ProcessEngine created??????
Jun 29, 2012 8:57:43 AM org.activiti.engine.impl.jobexecutor.JobExecutor start
INFO: Starting up the JobExecutor[org.activiti.engine.impl.jobexecutor.DefaultJobExecutor].
Jun 29, 2012 8:57:43 AM org.activiti.engine.impl.jobexecutor.AcquireJobsRunnable run

The bpmn20.xml file:

http://www.omg.org/spec/BPMN/20100524/MODEL

http://www.w3.org/2001/XMLSchema-instance

http://activiti.org/bpmn

http://www.omg.org/spec/BPMN/20100524/DI

http://www.omg.org/spec/DD/20100524/DC

http://www.omg.org/spec/DD/20100524/DI

http://www.w3.org/2001/XMLSchema

http://www.w3.org/1999/XPath

http://www.activiti.org/test

Contents of the webapps directory. Several of the Projects contain activiti.cfg.xml files, but
activiti-rest would not be looking in any of them for a cfg file, would it?

For information, here are the contents of the directory containing the activiti.cfg.xml file:

Thank you.

frederikherema1 · ‎07-02-2012

Activiti-explorer uses a separate "java" engine than the REST-webapp… If you point the two configs to the same database, they'll play nicely together.

ct1 · ‎07-02-2012

Thank you.

That is good news. So it is alright to have multiple ProcessEngines pointing to the same database.

However, it does not seem to speak to my situation. I have both REST and Explorer configured to point to the same database, and both deployed in the same instance of Tomcat.

I am only starting the instance of Tomcat that has the activiti-explorer.war and the activiti-rest.war in its webapp directory. I do not attempt to use either Activiti Explorer or the REST interface in any application. The only action anticipated is that the timer start event defined as the first task in a process will start at the specified time and the process will continue until it hits a wait state, in this case, the end event. Instead of running cleanly, the timer start event seems to cause an exception.

Should this happen? If not, what should I do to prevent it?

Thank you again.

frederikherema1 · ‎07-02-2012

Since 2 engine's are running, 2 job-executors are active by default. One of them a quires the job together with the second one. The first one will execute the job successfully. The second one, unaware of the job being acquired already (transactions overlap) will execute also and get an exception. This is intended to work this way. The second "execute" is rolled back. So you timer fires correctly and the second job-executor execution is a no-op (due to the rollback).

This is fine when you system integrates with the activiti transactions (or the other way around). The only downside is that you get these exceptions? To overcome this, you can disable the job-executor in one of the engines. This way, only one engine (eg. webapp-rest) is responsible for all timer and async-related operations.

ct1 · ‎07-02-2012

Thank you.

Your response really made this much clearer. So, I should put

<property name="jobExecutorActivate" value="false" />
in the activiti.cfg.xml file in the …/webapps/activiti-explorer/WEB-INF/classes directory?

The, all processes with a timer start event or a timer boundary event will be handled by the Job
Executor defined in the activiti.cfg.xml file in the …activiti-rest/WEB-INF/classes directory. Right?

Thank you.

frederikherema1 · ‎07-02-2012

spot on!

ct1 · ‎07-03-2012

I am trying your solution.

I turned off the jobExecutorActivate (set to "false") in the …\webapps\activiti-explorer\WEB-INF\classes\activiti.cfg.xml file, stopped Tomcat, started Tomcat, used Explorer to redeploy the BPMN20.xml file containing the timer start event. I then logged off Explorer and waited for the timer start event to execute. The exception was thrown again.

I have several applications deployed on that instance of Tomcat that use ProcessEngines. I will next remove each of their war files from the webapps directory and delete the application directories that Tomcat created from each of them. Then I will try the timer start event again.

Related to the reply you gave above, do I need to be concerned that the …\webapps\activiti-rest\WEB-INF\classes\activiti-context.xml file has the property
'<property name="jobExecutorActivate" value="true" />'
in the bean id processEngineConfiguration? Will that create another JobExecutor? I was under the impression that when I use the activiti.cfg.xml to configure Activiti, that the activiti-context.xml would not be used, but I know I could be mistaken. Do I also need to set that to "false" also?

Thank you.

ct1 · ‎07-06-2012

Thank you for all your help getting to this point.

I am attempting to implement your suggestion by removing all applications, except activiti-rest, that might create a Job Executor from the Tomcat instance running activiti-rest.

I deployed the BPMN20 process that contains the timer start event using Activiti Explorer. Then I stopped Tomcat, removed the activiti-explorer directory from the …/webapps directory and then restarted Tomcat. I got the log shown below which seems to show two Process Engines created but only on JobExecutor started. The directory listing of the …/webapps directory is below, showing activiti-rest to be the only Activiti application deployed.

This is the log file when I restarted Tomcat:

INFO: initializing process engine for resource file:/C:/Workflow/Tomcat/apache-tomcat-7.0.27/webapps
/activiti-rest/WEB-INF/classes/activiti.cfg.xml

http://www.slf4j.org/codes.html#StaticLoggerBinder

INFO: ProcessEngine default created

<<<<<<<<—————-First Process Engine Starts

INFO: Starting up the JobExecutor[org.activiti.engine.impl.jobexecutor.DefaultJobExecutor].

<<<— Job Executor Starts

<<<<<<<—– Second Process Engine Starts

INFO: ProcessEngine default created

<<<<<<< —- No Second Job Executor started

…/webapps directory:

<<<<<<<<<<—- Only app with a JobExecutor

At the time the timer start event was configured to start, this was logged:

The timer start event ran as scheduled and did not throw an exception.

Now, my question is, is this a reasonable configuration (one instance of the activiti.cfg.xml file with the "JobExecutorActivate=true") considering that we may need instances of Tomcat running activiti-rest on multiple servers accessing the same database? If we run like that and the server that created the JobExecutor goes down, won't we then miss executing all the timer events scheduled for the time the JobExecutor is down?

Thank you again for helping.

Hyland Connect

Very Simple Process with Timer Start Event throws Exception