topic Duplicate Business Key causing problems in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/duplicate-business-key-causing-problems/m-p/45456#M25292 <HTML><HEAD></HEAD><BODY><SPAN>Hi Community,</SPAN><BR /><BR /><SPAN>I have a situation where I have same business key for multiple instances of process definition. At any moment, a given business key will be with only one Active instance, after the instance has ended, there might be another instance created with the same business key.</SPAN><BR /><BR /><SPAN>When I try doing that I get the following which seems to suggest that there cannot be same business key for the same process_definition_id accross all instances. Did I read that right? It seems confusing the use of business key if this behavior is expected. Could you please explain a bit more on the use of it? Thanks a lot. </SPAN><BR /><BR /><SPAN>/Prasanna Rajaperumal</SPAN><BR /><SPAN>Cisco Systems</SPAN><BR /><BR /><SPAN>Could not start an instance of Process /_system/governance/workflows/cca/devline/templates/default. Error IOException org.apache.ibatis.exceptions.PersistenceException: </SPAN><BR /><SPAN>### Error updating database.&nbsp; Cause: org.h2.jdbc.JdbcSQLException: Unique index or primary key violation: "ACT_UNIQ_HI_BUS_KEY_INDEX_8 ON PUBLIC.ACT_HI_PROCINST(PROC_DEF_ID_, BUSINESS_KEY_)"; SQL statement:</SPAN><BR /><SPAN>insert into ACT_HI_PROCINST (</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ID_,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PROC_INST_ID_,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BUSINESS_KEY_,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PROC_DEF_ID_,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; START_TIME_,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; END_TIME_,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DURATION_,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; START_USER_ID_,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; START_ACT_ID_,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; END_ACT_ID_</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ) values (</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ) [23505-155]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.h2.message.DbException.getJdbcSQLException(DbException.java:327)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.h2.message.DbException.get(DbException.java:167)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.h2.message.DbException.get(DbException.java:144)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.h2.index.BaseIndex.getDuplicateKeyException(BaseIndex.java:80)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.h2.index.PageBtree.find(PageBtree.java:121)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.h2.index.PageBtreeLeaf.addRow(PageBtreeLeaf.java:146)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.h2.index.PageBtreeLeaf.addRowTry(PageBtreeLeaf.java:100)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.h2.index.PageBtreeIndex.addRow(PageBtreeIndex.java:93)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.h2.index.PageBtreeIndex.add(PageBtreeIndex.java:84)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.h2.table.RegularTable.addRow(RegularTable.java:127)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.h2.command.dml.Insert.insertRows(Insert.java:124)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.h2.command.dml.Insert.update(Insert.java:84)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.h2.command.CommandContainer.update(CommandContainer.java:71)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.h2.command.Command.executeUpdate(Command.java:212)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.h2.server.TcpServerThread.process(TcpServerThread.java:300)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.h2.server.TcpServerThread.run(TcpServerThread.java:137)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.lang.Thread.run(Thread.java:680)</SPAN></BODY></HTML> Wed, 10 Aug 2011 05:44:47 GMT prasanna_bits 2011-08-10T05:44:47Z Duplicate Business Key causing problems https://connect.hyland.com/t5/alfresco-archive/duplicate-business-key-causing-problems/m-p/45456#M25292 Hi Community,I have a situation where I have same business key for multiple instances of process definition. At any moment, a given business key will be with only one Active instance, after the instance has ended, there might be another instance created with the same business key.When I try doing th Wed, 10 Aug 2011 05:44:47 GMT https://connect.hyland.com/t5/alfresco-archive/duplicate-business-key-causing-problems/m-p/45456#M25292 prasanna_bits 2011-08-10T05:44:47Z Re: Duplicate Business Key causing problems https://connect.hyland.com/t5/alfresco-archive/duplicate-business-key-causing-problems/m-p/45457#M25293 <HTML><HEAD></HEAD><BODY><SPAN>The business-key must be unique over ALL process-instances for a given process-definition, that includes RUNNING and FINISHED process instances. So the error you're getting makes sense…</SPAN></BODY></HTML> Wed, 10 Aug 2011 11:11:09 GMT https://connect.hyland.com/t5/alfresco-archive/duplicate-business-key-causing-problems/m-p/45457#M25293 frederikherema1 2011-08-10T11:11:09Z