<?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 Duplicate process ids  in Alfresco Archive</title>
    <link>https://connect.hyland.com/t5/alfresco-archive/duplicate-process-ids/m-p/147580#M103012</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;SPAN&gt;Just wondering if this is a known problem, or configuration issue.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;I&amp;nbsp; am supporting a JSF application using Actitviti 5.9. It seems that duplicate process ids are being created while running a batch job that creates 100+ process instances.&amp;nbsp; In a method that iterates through the objects, a new process is started for each object. &lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt; &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;At this point, randomly, a duplicate key will be retuned:&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt; String procId = runtimeService.startProcessInstanceByKey("ffsClaimApproval", variables).getId();&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;These processes are running: async&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt; &amp;lt;serviceTask id="thresholdCheckFFSClaim" name="Check Thresholds on FFS Claim" activiti:class="com.dms.workflow.ClaimCheckThresholdsDelegate" activiti:async="true" /&amp;gt;&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Out of 118 objects, 30 process instances failed because of a duplicate process id.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Which throws the below error:&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;2013-04-23 00:36:18,931 INFO&amp;nbsp; [com.dms.workflow.ClaimCheckThresholdsDelegate] (pool-32-thread-9) Claim #7,206 is ready to be checked against rate thresholds&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;2013-04-23 00:36:18,931 SEVERE [org.activiti.engine.impl.interceptor.CommandContext] (pool-32-thread-8) Error while closing command context: org.apache.ibatis.exceptions.PersistenceException: &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;### Error updating database.&amp;nbsp; Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (DMS.XX_ACT_PROCVER_UNIQUE) violated&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;### The error may involve org.activiti.engine.impl.persistence.entity.ProcessDefinitionEntity.insertProcessDefinition-Inline&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;### The error occurred while setting parameters&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;### Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (DMS.XX_ACT_PROCVER_UNIQUE) violated&lt;/SPAN&gt;&lt;BR /&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Wed, 22 May 2013 20:01:04 GMT</pubDate>
    <dc:creator>mitchyoung</dc:creator>
    <dc:date>2013-05-22T20:01:04Z</dc:date>
    <item>
      <title>Duplicate process ids</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/duplicate-process-ids/m-p/147580#M103012</link>
      <description>Hi,Just wondering if this is a known problem, or configuration issue.I&amp;nbsp; am supporting a JSF application using Actitviti 5.9. It seems that duplicate process ids are being created while running a batch job that creates 100+ process instances.&amp;nbsp; In a method that iterates through the objects, a new proc</description>
      <pubDate>Wed, 22 May 2013 20:01:04 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/duplicate-process-ids/m-p/147580#M103012</guid>
      <dc:creator>mitchyoung</dc:creator>
      <dc:date>2013-05-22T20:01:04Z</dc:date>
    </item>
    <item>
      <title>Re: Duplicate process ids</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/duplicate-process-ids/m-p/147581#M103013</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Does the com.dms.workflow.ClaimCheckThresholdsDelegate do anything with an Activiti-service? How is the activiti-engine fetched and constructed?&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 23 May 2013 07:21:27 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/duplicate-process-ids/m-p/147581#M103013</guid>
      <dc:creator>frederikherema1</dc:creator>
      <dc:date>2013-05-23T07:21:27Z</dc:date>
    </item>
    <item>
      <title>Re: Duplicate process ids</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/duplicate-process-ids/m-p/147582#M103014</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Hi Frederik,&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;Thank you for your response.&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;The Activiti process engine is fetched as follows:&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; RepositoryService repositoryService = processEngine.getRepositoryService();&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; RuntimeService runtimeService = processEngine.getRuntimeService();&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;This is in the method that that loops through the objects but is outside of the loop.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;The process definition is deployed inside the loop:&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;repositoryService.createDeployment().addClasspathResource("ffs-claim-approval.bpmn20.xml").deploy();&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;A new&amp;nbsp; process instance is created inside the loop for each claim object:&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;String procId = runtimeService.startProcessInstanceByKey("ffsClaimApproval", variables).getId();&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;The application is running on JBoss jboss-6.1.0.Final&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;The ClaimCheckThresholdsDelegate class sets variables to the DelegateExecution object via&amp;nbsp; execution.setVariable("approved", true) but does not do anything with Activiti-service.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;I have attached the method that loops through the claim objects and creates the process instances: processFFSClaims.txt.&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;Also the ClaimCheckThresholdsDelegate class and the process definition xml.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Hope that's OK, &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;Thanks again.&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;Mitch Young&lt;/SPAN&gt;&lt;BR /&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 23 May 2013 14:35:56 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/duplicate-process-ids/m-p/147582#M103014</guid>
      <dc:creator>mitchyoung</dc:creator>
      <dc:date>2013-05-23T14:35:56Z</dc:date>
    </item>
    <item>
      <title>Re: Duplicate process ids</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/duplicate-process-ids/m-p/147583#M103015</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;I see… Is the transaction spanning the whole method (that is in processFSSClaims)? What's the isolation-level on the DB-transactions?&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 04 Jun 2013 13:38:52 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/duplicate-process-ids/m-p/147583#M103015</guid>
      <dc:creator>frederikherema1</dc:creator>
      <dc:date>2013-06-04T13:38:52Z</dc:date>
    </item>
  </channel>
</rss>

