topic The DELETE statement conflicted with the REFERENCE constraint 'ACT_FK_VAR_EXE' in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/the-delete-statement-conflicted-with-the-reference-constraint/m-p/196167#M149297 <HTML><HEAD></HEAD><BODY><SPAN>We have an error in the logs which appears about every 5min.</SPAN><BR /><BR /><SPAN>2015-08-04 10:27:29,534 ERROR [pool-18-thread-40] mpl.interceptor.CommandContext: Error while closing command context</SPAN><BR /><SPAN>org.apache.ibatis.exceptions.PersistenceException: </SPAN><BR /><SPAN>### Error updating database.&nbsp; Cause: com.microsoft.sqlserver.jdbc.SQLServerException: The DELETE statement conflicted with the REFERENCE constraint "ACT_FK_VAR_EXE". The conflict occurred in database "XXX", table "dbo.ACT_RU_VARIABLE", column 'EXECUTION_ID_'.</SPAN><BR /><SPAN>### The error may involve org.activiti.engine.impl.persistence.entity.ExecutionEntity.deleteExecution-Inline</SPAN><BR /><SPAN>### The error occurred while setting parameters</SPAN><BR /><SPAN>### SQL: delete from ACT_RU_EXECUTION where ID_ = ? and REV_ = ?</SPAN><BR /><SPAN>### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: The DELETE statement conflicted with the REFERENCE constraint "ACT_FK_VAR_EXE". The conflict occurred in database "XXX", table "dbo.ACT_RU_VARIABLE", column 'EXECUTION_ID_'.</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:150)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.delete(DefaultSqlSession.java:161)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.db.DbSqlSession$CheckedDeleteOperation.execute(DbSqlSession.java:225)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.db.DbSqlSession.flushDeletes(DbSqlSession.java:577)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.db.DbSqlSession.flush(DbSqlSession.java:445)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.CommandContext.flushSessions(CommandContext.java:170)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.CommandContext.close(CommandContext.java:117)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:66)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:47)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:45)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:31)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:40)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:35)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.jobexecutor.ExecuteJobsRunnable.run(ExecuteJobsRunnable.java:46)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.lang.Thread.run(Thread.java:745)</SPAN><BR /><SPAN>Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The DELETE statement conflicted with the REFERENCE constraint "ACT_FK_VAR_EXE". The conflict occurred in database "XXX", table "dbo.ACT_RU_VARIABLE", column 'EXECUTION_ID_'.</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:332)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:41)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:66)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:45)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:100)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:75)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:148)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;… 17 more</SPAN><BR /><BR /><SPAN>By Looking at error and "ACT_FK_VAR_EXE" i made this Query:</SPAN><BR /><SPAN>SELECT TOP 1000 [ID_]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,[REV_]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,[PROC_INST_ID_]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,[BUSINESS_KEY_]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,[PARENT_ID_]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,[PROC_DEF_ID_]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,[SUPER_EXEC_]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,[ACT_ID_]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,[IS_ACTIVE_]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,[IS_CONCURRENT_]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,[IS_SCOPE_]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,[SUSPENSION_STATE_]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,[IS_EVENT_SCOPE_]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,[CACHED_ENT_STATE_]</SPAN><BR /><SPAN>&nbsp; FROM [gnt2sql].[dbo].[ACT_RU_EXECUTION]</SPAN><BR /><SPAN>&nbsp; WHERE ID_ NOT IN (SELECT DISTINCT EXECUTION_ID_ FROM ACT_RU_VARIABLE)</SPAN><BR /><BR /><SPAN>The result are 2 rows with PROC_INST_ID_ which aren't in ACT_RU_TASK or ACT_RU_VARIABLE.</SPAN><BR /><SPAN>The History ACT_HI_TASKINST shows 1 row for each PROC_INST_ID_ but END_TIME_ is null.</SPAN><BR /><BR /><SPAN>What should i do with these Records in ACT_RU_EXECUTION? Can I delete them?</SPAN><BR /><SPAN>Is this the source of the Errors in the log?</SPAN><BR /><BR /><SPAN>Thx in advance</SPAN><BR /><SPAN>Cyrill</SPAN><BR /><BR /><BR /><BR /></BODY></HTML> Tue, 04 Aug 2015 08:46:32 GMT cyr1 2015-08-04T08:46:32Z The DELETE statement conflicted with the REFERENCE constraint 'ACT_FK_VAR_EXE' https://connect.hyland.com/t5/alfresco-archive/the-delete-statement-conflicted-with-the-reference-constraint/m-p/196167#M149297 We have an error in the logs which appears about every 5min.2015-08-04 10:27:29,534 ERROR [pool-18-thread-40] mpl.interceptor.CommandContext: Error while closing command contextorg.apache.ibatis.exceptions.PersistenceException: ### Error updating database.&nbsp; Cause: com.microsoft.sqlserver.jdbc.SQLSer Tue, 04 Aug 2015 08:46:32 GMT https://connect.hyland.com/t5/alfresco-archive/the-delete-statement-conflicted-with-the-reference-constraint/m-p/196167#M149297 cyr1 2015-08-04T08:46:32Z Re: The DELETE statement conflicted with the REFERENCE constraint 'ACT_FK_VAR_EXE' https://connect.hyland.com/t5/alfresco-archive/the-delete-statement-conflicted-with-the-reference-constraint/m-p/196168#M149298 <HTML><HEAD></HEAD><BODY><SPAN>we are Using Activiti 5.14</SPAN></BODY></HTML> Tue, 04 Aug 2015 09:06:56 GMT https://connect.hyland.com/t5/alfresco-archive/the-delete-statement-conflicted-with-the-reference-constraint/m-p/196168#M149298 cyr1 2015-08-04T09:06:56Z