topic SQL Contraint Violations when calling deleteProcessInstance in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/sql-contraint-violations-when-calling-deleteprocessinstance/m-p/164507#M118243 <HTML><HEAD></HEAD><BODY><SPAN>Greetings,</SPAN><BR /><BR /><SPAN>When calling RunTimeService::deleteProcessInstance(…), I am receiving the following error. I've tried this by invoking deleteProcessInstance from within a service task within the process I am trying to delete as well as externally. Any ideas of what I am doing wrong?</SPAN><BR /><BR /><SPAN>&lt;blockcode&gt;</SPAN><BR /><SPAN>[#|2013-10-11T17:23:55.647-0700|SEVERE|glassfish3.1.2|org.camunda.bpm.engine.impl.interceptor.CommandContext|_ThreadID=206;_ThreadName=pool-36-thread-1;|Error while closing command context</SPAN><BR /><SPAN>org.apache.ibatis.exceptions.PersistenceException:</SPAN><BR /><SPAN>### Error updating database.&nbsp; Cause: org.h2.jdbc.JdbcSQLException: Referential integrity constraint violation: "ACT_FK_VAR_EXE: PUBLIC.ACT_RU_VARIABLE FOREIGN KEY(EXECUTION_ID_) REFERENCES PUBLIC.ACT_RU_EXECUTION(ID_) ('4')"; SQL statement:</SPAN><BR /><SPAN>insert into ACT_RU_VARIABLE (ID_, REV_, TYPE_, NAME_, PROC_INST_ID_, EXECUTION_ID_, TASK_ID_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; values (</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; ) [23506-171]</SPAN><BR /><SPAN>### The error may involve org.camunda.bpm.engine.impl.persistence.entity.VariableInstanceEntity.insertVariableInstance-Inline</SPAN><BR /><SPAN>### The error occurred while setting parameters</SPAN><BR /><SPAN>### SQL: insert into ACT_RU_VARIABLE (ID_, REV_, TYPE_, NAME_, PROC_INST_ID_, EXECUTION_ID_, TASK_ID_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_)&nbsp;&nbsp;&nbsp;&nbsp; values (&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?&nbsp;&nbsp;&nbsp;&nbsp; )</SPAN><BR /><SPAN>### Cause: org.h2.jdbc.JdbcSQLException: Referential integrity constraint violation: "ACT_FK_VAR_EXE: PUBLIC.ACT_RU_VARIABLE FOREIGN KEY(EXECUTION_ID_) REFERENCES PUBLIC.ACT_RU_EXECUTION(ID_) ('4')"; SQL statement:</SPAN><BR /><SPAN>insert into ACT_RU_VARIABLE (ID_, REV_, TYPE_, NAME_, PROC_INST_ID_, EXECUTION_ID_, TASK_ID_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; values (</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; ) [23506-171]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:147)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:134)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.camunda.bpm.engine.impl.db.DbSqlSession.flushInserts(DbSqlSession.java:679)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.camunda.bpm.engine.impl.db.DbSqlSession.flush(DbSqlSession.java:499)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.camunda.bpm.engine.impl.interceptor.CommandContext.flushSessions(CommandContext.java:211)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.camunda.bpm.engine.impl.interceptor.CommandContext.close(CommandContext.java:154)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.camunda.bpm.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:49)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.camunda.bpm.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:32)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.camunda.bpm.engine.impl.jobexecutor.ExecuteJobsRunnable.executeJob(ExecuteJobsRunnable.java:79)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.camunda.bpm.engine.impl.jobexecutor.ExecuteJobsRunnable.run(ExecuteJobsRunnable.java:67)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.lang.Thread.run(Thread.java:722)</SPAN><BR /><SPAN>&lt;/blockcode&gt;</SPAN></BODY></HTML> Sat, 12 Oct 2013 00:49:09 GMT rolleiflux 2013-10-12T00:49:09Z SQL Contraint Violations when calling deleteProcessInstance https://connect.hyland.com/t5/alfresco-archive/sql-contraint-violations-when-calling-deleteprocessinstance/m-p/164507#M118243 Greetings,When calling RunTimeService::deleteProcessInstance(…), I am receiving the following error. I've tried this by invoking deleteProcessInstance from within a service task within the process I am trying to delete as well as externally. Any ideas of what I am doing wrong?&lt;blockcode&gt;[#|201 Sat, 12 Oct 2013 00:49:09 GMT https://connect.hyland.com/t5/alfresco-archive/sql-contraint-violations-when-calling-deleteprocessinstance/m-p/164507#M118243 rolleiflux 2013-10-12T00:49:09Z Re: SQL Contraint Violations when calling deleteProcessInstance https://connect.hyland.com/t5/alfresco-archive/sql-contraint-violations-when-calling-deleteprocessinstance/m-p/164508#M118244 <HTML><HEAD></HEAD><BODY><SPAN>Are you joking? I see camunda package names in the exception log, so it's better to ask them.</SPAN><BR /></BODY></HTML> Mon, 21 Oct 2013 10:53:24 GMT https://connect.hyland.com/t5/alfresco-archive/sql-contraint-violations-when-calling-deleteprocessinstance/m-p/164508#M118244 trademak 2013-10-21T10:53:24Z