<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic PropertyEntity[next.dbid] was updated by another transaction in Alfresco Archive</title>
    <link>https://connect.hyland.com/t5/alfresco-archive/propertyentity-next-dbid-was-updated-by-another-transaction/m-p/69522#M44726</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Hi,&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;I use Activiti 5.5 in an EJB with Container Managed Persistence.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;The ProcessEngine is created this way:&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;PRE class="language-none line-numbers"&gt;&lt;CODE&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; ProcessEngineConfiguration processEngineConfiguration = ProcessEngineConfiguration.createProcessEngineConfigurationFromResourceDefault();&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; processEngineConfiguration.setDataSource(this.activitiDataSource);&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; processEngineConfiguration.setTransactionsExternallyManaged(true);&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; processEngineConfiguration.setDatabaseSchemaUpdate("false");&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; processEngineConfiguration.setHistory("full");&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; ProcessEngine processEngine = processEngineConfiguration.buildProcessEngine();&lt;SPAN class="line-numbers-rows"&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/CODE&gt;&lt;/PRE&gt;&lt;BR /&gt;&lt;SPAN&gt;When running 20 EJBs in parallel about 5% of all workflow calls fail with the following exception:&lt;/SPAN&gt;&lt;BR /&gt;&lt;PRE class="language-none line-numbers"&gt;&lt;CODE&gt;PropertyEntity[next.dbid] was updated by another transaction concurrently&lt;BR /&gt;org.activiti.engine.ActivitiOptimisticLockingException: PropertyEntity[next.dbid] was updated by another transaction concurrently&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at java.lang.Throwable.&amp;lt;init&amp;gt;(Throwable.java:67)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.activiti.engine.ActivitiException.&amp;lt;init&amp;gt;(ActivitiException.java:30)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.activiti.engine.impl.db.DbSqlSession.flushUpdates(DbSqlSession.java:416)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.activiti.engine.impl.db.DbSqlSession.flush(DbSqlSession.java:338)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.activiti.engine.impl.interceptor.CommandContext.flushSessions(CommandContext.java:147)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.activiti.engine.impl.interceptor.CommandContext.close(CommandContext.java:103)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:49)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.activiti.engine.impl.db.DbIdGenerator.getNewBlock(DbIdGenerator.java:41)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.activiti.engine.impl.db.DbIdGenerator.getNextId(DbIdGenerator.java:34)&lt;SPAN class="line-numbers-rows"&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/CODE&gt;&lt;/PRE&gt;&lt;BR /&gt;&lt;SPAN&gt;This dbid in table ACT_GE_PROPERTY seems to be a sequence number? Is it possible to switch to a database sequence instead?&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Thanks,&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;Thomas&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Wed, 18 May 2011 10:58:23 GMT</pubDate>
    <dc:creator>thomas1</dc:creator>
    <dc:date>2011-05-18T10:58:23Z</dc:date>
    <item>
      <title>PropertyEntity[next.dbid] was updated by another transaction</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/propertyentity-next-dbid-was-updated-by-another-transaction/m-p/69522#M44726</link>
      <description>Hi,I use Activiti 5.5 in an EJB with Container Managed Persistence.The ProcessEngine is created this way:&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; ProcessEngineConfiguration processEngineConfiguration = ProcessEngineConfiguration.createProcessEngineConfigurationFromResourceDefault();&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; processEngineConfiguration.setData</description>
      <pubDate>Wed, 18 May 2011 10:58:23 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/propertyentity-next-dbid-was-updated-by-another-transaction/m-p/69522#M44726</guid>
      <dc:creator>thomas1</dc:creator>
      <dc:date>2011-05-18T10:58:23Z</dc:date>
    </item>
    <item>
      <title>Re: PropertyEntity[next.dbid] was updated by another transaction</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/propertyentity-next-dbid-was-updated-by-another-transaction/m-p/69523#M44727</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Are those EJB's updating the same execution or process-instance?&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 20 May 2011 14:05:08 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/propertyentity-next-dbid-was-updated-by-another-transaction/m-p/69523#M44727</guid>
      <dc:creator>frederikherema1</dc:creator>
      <dc:date>2011-05-20T14:05:08Z</dc:date>
    </item>
    <item>
      <title>Re: PropertyEntity[next.dbid] was updated by another transaction</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/propertyentity-next-dbid-was-updated-by-another-transaction/m-p/69524#M44728</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;No, each EJB has its own process-instance and execution but all access the same database.&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 23 May 2011 18:05:19 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/propertyentity-next-dbid-was-updated-by-another-transaction/m-p/69524#M44728</guid>
      <dc:creator>thomas1</dc:creator>
      <dc:date>2011-05-23T18:05:19Z</dc:date>
    </item>
    <item>
      <title>Re: PropertyEntity[next.dbid] was updated by another transaction</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/propertyentity-next-dbid-was-updated-by-another-transaction/m-p/69525#M44729</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Hi, &lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;I have exactly the same issue, with OptimisticLockingException being thrown. I found the following open ticket on Activiti Issues page: &lt;/SPAN&gt;&lt;A href="http://jira.codehaus.org/browse/ACT-789" rel="nofollow noopener noreferrer"&gt;http://jira.codehaus.org/browse/ACT-789&lt;/A&gt;&lt;SPAN&gt; , which should fix the problem.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Do you know if there is any confirmation that the fix will really be included in 5.7?&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Thanks!&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 27 Jun 2011 09:28:19 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/propertyentity-next-dbid-was-updated-by-another-transaction/m-p/69525#M44729</guid>
      <dc:creator>madi</dc:creator>
      <dc:date>2011-06-27T09:28:19Z</dc:date>
    </item>
  </channel>
</rss>

