[ERROR] Tests run: 31, Failures: 0, Errors: 9, Skipped: 0, Time elapsed: 74.396 s <<< FAILURE! - in org.camunda.bpm.engine.test.history.HistoricActivityStatisticsQueryTest [ERROR] testQueryIncludeIncidentsWhenNoIncidents(org.camunda.bpm.engine.test.history.HistoricActivityStatisticsQueryTest) Time elapsed: 0.769 s <<< ERROR! org.camunda.bpm.engine.ProcessEngineException: Process engine persistence exception at org.camunda.bpm.engine.impl.interceptor.CommandInvocationContext.rethrow(CommandInvocationContext.java:153) at org.camunda.bpm.engine.impl.interceptor.CommandContext.close(CommandContext.java:229) at org.camunda.bpm.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:119) at org.camunda.bpm.engine.impl.interceptor.ProcessApplicationContextInterceptor.execute(ProcessApplicationContextInterceptor.java:70) at org.camunda.bpm.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33) at org.camunda.bpm.engine.impl.AbstractQuery.executeResult(AbstractQuery.java:160) at org.camunda.bpm.engine.impl.AbstractQuery.list(AbstractQuery.java:142) at org.camunda.bpm.engine.test.history.HistoricActivityStatisticsQueryTest.testQueryIncludeIncidentsWhenNoIncidents(HistoricActivityStatisticsQueryTest.java:1132) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at junit.framework.TestCase.runTest(TestCase.java:176) at junit.framework.TestCase.runBare(TestCase.java:141) at org.camunda.bpm.engine.impl.test.AbstractProcessEngineTestCase.runBare(AbstractProcessEngineTestCase.java:115) at junit.framework.TestResult$1.protect(TestResult.java:122) at junit.framework.TestResult.runProtected(TestResult.java:142) at junit.framework.TestResult.run(TestResult.java:125) at junit.framework.TestCase.run(TestCase.java:129) at junit.framework.TestSuite.runTest(TestSuite.java:252) at junit.framework.TestSuite.run(TestSuite.java:247) at org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:86) at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:365) at org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:273) at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:238) at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:159) at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:384) at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:345) at org.apache.maven.surefire.booter.ForkedBooter.execute(ForkedBooter.java:126) at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:418) Caused by: org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: org.postgresql.util.PSQLException: ERROR: UNION types int and decimal cannot be matched ### The error may exist in org/camunda/bpm/engine/impl/mapping/entity/HistoricStatistics.xml ### The error may involve org.camunda.bpm.engine.history.HistoricActivityStatistics.selectHistoricActivityStatistics-Inline ### The error occurred while setting parameters ### SQL: select RES.* from ( select ID_, sum(INSTANCE_COUNT_) as INSTANCE_COUNT_ , sum(FINISHED_COUNT_) as FINISHED_COUNT_ , sum(CANCELED_COUNT_) as CANCELED_COUNT_ , sum(COMPLETE_SCOPE_COUNT_) as COMPLETE_SCOPE_COUNT_ , sum(OPEN_INCIDENT_COUNT_) as OPEN_INCIDENT_COUNT_ , sum(RESOLVED_INCIDENT_COUNT_) as RESOLVED_INCIDENT_COUNT_ , sum(DELETED_INCIDENT_COUNT_) as DELETED_INCIDENT_COUNT_ from ( select ACT.ACT_ID_ as ID_, sum(CASE WHEN ACT.END_TIME_ is NULL THEN 1 ELSE 0 END) as INSTANCE_COUNT_ , sum(CASE WHEN ACT.END_TIME_ is not NULL THEN 1 ELSE 0 END) as FINISHED_COUNT_ , sum(CASE WHEN ACT.ACT_INST_STATE_ = 2 THEN 1 ELSE 0 END) as CANCELED_COUNT_ , sum(CASE WHEN ACT.ACT_INST_STATE_ = 1 THEN 1 ELSE 0 END) as COMPLETE_SCOPE_COUNT_ , 0 as OPEN_INCIDENT_COUNT_ , 0 as RESOLVED_INCIDENT_COUNT_ , 0 as DELETED_INCIDENT_COUNT_ from ACT_HI_ACTINST ACT where ACT.PROC_DEF_ID_ = ? GROUP BY ACT_ID_ UNION select INC.ACTIVITY_ID_ as ID_, 0 as INSTANCE_COUNT_ , 0 as FINISHED_COUNT_ , 0 as CANCELED_COUNT_ , 0 as COMPLETE_SCOPE_COUNT_ , sum(CASE WHEN INC.INCIDENT_STATE_ = 0 THEN 1 ELSE 0 END) as OPEN_INCIDENT_COUNT_ , sum(CASE WHEN INC.INCIDENT_STATE_ = 1 THEN 1 ELSE 0 END) as RESOLVED_INCIDENT_COUNT_ , sum(CASE WHEN INC.INCIDENT_STATE_ = 2 THEN 1 ELSE 0 END) as DELETED_INCIDENT_COUNT_ from ACT_HI_INCIDENT INC where INC.PROC_DEF_ID_ = ? GROUP BY INC.ACTIVITY_ID_ ) RES GROUP BY ID_ ) RES order by RES.ID_ asc LIMIT ? OFFSET ? ### Cause: org.postgresql.util.PSQLException: ERROR: UNION types int and decimal cannot be matched at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:149) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140) at org.camunda.bpm.engine.impl.db.sql.DbSqlSession.selectList(DbSqlSession.java:97) at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.selectListWithRawParameter(DbEntityManager.java:181) at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.selectList(DbEntityManager.java:173) at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.selectList(DbEntityManager.java:165) at org.camunda.bpm.engine.impl.persistence.entity.HistoricStatisticsManager.getHistoricStatisticsGroupedByActivity(HistoricStatisticsManager.java:42) at org.camunda.bpm.engine.impl.HistoricActivityStatisticsQueryImpl.executeList(HistoricActivityStatisticsQueryImpl.java:123) at org.camunda.bpm.engine.impl.AbstractQuery.evaluateExpressionsAndExecuteList(AbstractQuery.java:219) at org.camunda.bpm.engine.impl.AbstractQuery.execute(AbstractQuery.java:193) at org.camunda.bpm.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:28) at org.camunda.bpm.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:110) ... 27 more Caused by: org.postgresql.util.PSQLException: ERROR: UNION types int and decimal cannot be matched at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2455) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2155) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:288) at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:430) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:356) at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:168) at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:157) at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64) at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79) at org.apache.ibatis.executor.BatchExecutor.doQuery(BatchExecutor.java:92) at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324) at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147) ... 38 more [ERROR] testQueryCompletedIncludeIncidentsDeletedOnly(org.camunda.bpm.engine.test.history.HistoricActivityStatisticsQueryTest) Time elapsed: 1.342 s <<< ERROR! org.camunda.bpm.engine.ProcessEngineException: Process engine persistence exception at org.camunda.bpm.engine.impl.interceptor.CommandInvocationContext.rethrow(CommandInvocationContext.java:153) at org.camunda.bpm.engine.impl.interceptor.CommandContext.close(CommandContext.java:229) at org.camunda.bpm.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:119) at org.camunda.bpm.engine.impl.interceptor.ProcessApplicationContextInterceptor.execute(ProcessApplicationContextInterceptor.java:70) at org.camunda.bpm.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33) at org.camunda.bpm.engine.impl.AbstractQuery.executeResult(AbstractQuery.java:160) at org.camunda.bpm.engine.impl.AbstractQuery.list(AbstractQuery.java:142) at org.camunda.bpm.engine.test.history.HistoricActivityStatisticsQueryTest.testQueryCompletedIncludeIncidentsDeletedOnly(HistoricActivityStatisticsQueryTest.java:1304) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at junit.framework.TestCase.runTest(TestCase.java:176) at junit.framework.TestCase.runBare(TestCase.java:141) at org.camunda.bpm.engine.impl.test.AbstractProcessEngineTestCase.runBare(AbstractProcessEngineTestCase.java:115) at junit.framework.TestResult$1.protect(TestResult.java:122) at junit.framework.TestResult.runProtected(TestResult.java:142) at junit.framework.TestResult.run(TestResult.java:125) at junit.framework.TestCase.run(TestCase.java:129) at junit.framework.TestSuite.runTest(TestSuite.java:252) at junit.framework.TestSuite.run(TestSuite.java:247) at org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:86) at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:365) at org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:273) at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:238) at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:159) at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:384) at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:345) at org.apache.maven.surefire.booter.ForkedBooter.execute(ForkedBooter.java:126) at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:418) Caused by: org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: org.postgresql.util.PSQLException: ERROR: UNION types int and decimal cannot be matched ### The error may exist in org/camunda/bpm/engine/impl/mapping/entity/HistoricStatistics.xml ### The error may involve org.camunda.bpm.engine.history.HistoricActivityStatistics.selectHistoricActivityStatistics-Inline ### The error occurred while setting parameters ### SQL: select RES.* from ( select ID_, sum(INSTANCE_COUNT_) as INSTANCE_COUNT_ , sum(FINISHED_COUNT_) as FINISHED_COUNT_ , sum(CANCELED_COUNT_) as CANCELED_COUNT_ , sum(COMPLETE_SCOPE_COUNT_) as COMPLETE_SCOPE_COUNT_ , sum(OPEN_INCIDENT_COUNT_) as OPEN_INCIDENT_COUNT_ , sum(RESOLVED_INCIDENT_COUNT_) as RESOLVED_INCIDENT_COUNT_ , sum(DELETED_INCIDENT_COUNT_) as DELETED_INCIDENT_COUNT_ from ( select ACT.ACT_ID_ as ID_, sum(CASE WHEN ACT.END_TIME_ is NULL THEN 1 ELSE 0 END) as INSTANCE_COUNT_ , sum(CASE WHEN ACT.END_TIME_ is not NULL THEN 1 ELSE 0 END) as FINISHED_COUNT_ , sum(CASE WHEN ACT.ACT_INST_STATE_ = 2 THEN 1 ELSE 0 END) as CANCELED_COUNT_ , sum(CASE WHEN ACT.ACT_INST_STATE_ = 1 THEN 1 ELSE 0 END) as COMPLETE_SCOPE_COUNT_ , 0 as OPEN_INCIDENT_COUNT_ , 0 as RESOLVED_INCIDENT_COUNT_ , 0 as DELETED_INCIDENT_COUNT_ from ACT_HI_ACTINST ACT INNER JOIN ACT_HI_PROCINST PI ON ACT.PROC_INST_ID_ = PI.ID_ where ACT.PROC_DEF_ID_ = ? and PI.END_TIME_ <= ? and PI.END_TIME_ >= ? GROUP BY ACT_ID_ UNION select INC.ACTIVITY_ID_ as ID_, 0 as INSTANCE_COUNT_ , 0 as FINISHED_COUNT_ , 0 as CANCELED_COUNT_ , 0 as COMPLETE_SCOPE_COUNT_ , sum(CASE WHEN INC.INCIDENT_STATE_ = 0 THEN 1 ELSE 0 END) as OPEN_INCIDENT_COUNT_ , sum(CASE WHEN INC.INCIDENT_STATE_ = 1 THEN 1 ELSE 0 END) as RESOLVED_INCIDENT_COUNT_ , sum(CASE WHEN INC.INCIDENT_STATE_ = 2 THEN 1 ELSE 0 END) as DELETED_INCIDENT_COUNT_ from ACT_HI_INCIDENT INC INNER JOIN ACT_HI_PROCINST PI ON INC.PROC_INST_ID_ = PI.ID_ where INC.PROC_DEF_ID_ = ? and PI.END_TIME_ <= ? and PI.END_TIME_ >= ? GROUP BY INC.ACTIVITY_ID_ ) RES GROUP BY ID_ ) RES order by RES.ID_ asc LIMIT ? OFFSET ? ### Cause: org.postgresql.util.PSQLException: ERROR: UNION types int and decimal cannot be matched at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:149) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140) at org.camunda.bpm.engine.impl.db.sql.DbSqlSession.selectList(DbSqlSession.java:97) at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.selectListWithRawParameter(DbEntityManager.java:181) at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.selectList(DbEntityManager.java:173) at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.selectList(DbEntityManager.java:165) at org.camunda.bpm.engine.impl.persistence.entity.HistoricStatisticsManager.getHistoricStatisticsGroupedByActivity(HistoricStatisticsManager.java:42) at org.camunda.bpm.engine.impl.HistoricActivityStatisticsQueryImpl.executeList(HistoricActivityStatisticsQueryImpl.java:123) at org.camunda.bpm.engine.impl.AbstractQuery.evaluateExpressionsAndExecuteList(AbstractQuery.java:219) at org.camunda.bpm.engine.impl.AbstractQuery.execute(AbstractQuery.java:193) at org.camunda.bpm.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:28) at org.camunda.bpm.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:110) ... 27 more Caused by: org.postgresql.util.PSQLException: ERROR: UNION types int and decimal cannot be matched at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2455) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2155) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:288) at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:430) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:356) at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:168) at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:157) at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64) at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79) at org.apache.ibatis.executor.BatchExecutor.doQuery(BatchExecutor.java:92) at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324) at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147) ... 38 more [ERROR] testQueryCancelledIncludeIncidentsDeletedOnly(org.camunda.bpm.engine.test.history.HistoricActivityStatisticsQueryTest) Time elapsed: 1.434 s <<< ERROR! org.camunda.bpm.engine.ProcessEngineException: Process engine persistence exception at org.camunda.bpm.engine.impl.interceptor.CommandInvocationContext.rethrow(CommandInvocationContext.java:153) at org.camunda.bpm.engine.impl.interceptor.CommandContext.close(CommandContext.java:229) at org.camunda.bpm.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:119) at org.camunda.bpm.engine.impl.interceptor.ProcessApplicationContextInterceptor.execute(ProcessApplicationContextInterceptor.java:70) at org.camunda.bpm.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33) at org.camunda.bpm.engine.impl.AbstractQuery.executeResult(AbstractQuery.java:160) at org.camunda.bpm.engine.impl.AbstractQuery.list(AbstractQuery.java:142) at org.camunda.bpm.engine.test.history.HistoricActivityStatisticsQueryTest.testQueryCancelledIncludeIncidentsDeletedOnly(HistoricActivityStatisticsQueryTest.java:1259) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at junit.framework.TestCase.runTest(TestCase.java:176) at junit.framework.TestCase.runBare(TestCase.java:141) at org.camunda.bpm.engine.impl.test.AbstractProcessEngineTestCase.runBare(AbstractProcessEngineTestCase.java:115) at junit.framework.TestResult$1.protect(TestResult.java:122) at junit.framework.TestResult.runProtected(TestResult.java:142) at junit.framework.TestResult.run(TestResult.java:125) at junit.framework.TestCase.run(TestCase.java:129) at junit.framework.TestSuite.runTest(TestSuite.java:252) at junit.framework.TestSuite.run(TestSuite.java:247) at org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:86) at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:365) at org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:273) at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:238) at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:159) at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:384) at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:345) at org.apache.maven.surefire.booter.ForkedBooter.execute(ForkedBooter.java:126) at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:418) Caused by: org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: org.postgresql.util.PSQLException: ERROR: UNION types int and decimal cannot be matched ### The error may exist in org/camunda/bpm/engine/impl/mapping/entity/HistoricStatistics.xml ### The error may involve org.camunda.bpm.engine.history.HistoricActivityStatistics.selectHistoricActivityStatistics-Inline ### The error occurred while setting parameters ### SQL: select RES.* from ( select ID_, sum(INSTANCE_COUNT_) as INSTANCE_COUNT_ , sum(FINISHED_COUNT_) as FINISHED_COUNT_ , sum(CANCELED_COUNT_) as CANCELED_COUNT_ , sum(COMPLETE_SCOPE_COUNT_) as COMPLETE_SCOPE_COUNT_ , sum(OPEN_INCIDENT_COUNT_) as OPEN_INCIDENT_COUNT_ , sum(RESOLVED_INCIDENT_COUNT_) as RESOLVED_INCIDENT_COUNT_ , sum(DELETED_INCIDENT_COUNT_) as DELETED_INCIDENT_COUNT_ from ( select ACT.ACT_ID_ as ID_, sum(CASE WHEN ACT.END_TIME_ is NULL THEN 1 ELSE 0 END) as INSTANCE_COUNT_ , sum(CASE WHEN ACT.END_TIME_ is not NULL THEN 1 ELSE 0 END) as FINISHED_COUNT_ , sum(CASE WHEN ACT.ACT_INST_STATE_ = 2 THEN 1 ELSE 0 END) as CANCELED_COUNT_ , sum(CASE WHEN ACT.ACT_INST_STATE_ = 1 THEN 1 ELSE 0 END) as COMPLETE_SCOPE_COUNT_ , 0 as OPEN_INCIDENT_COUNT_ , 0 as RESOLVED_INCIDENT_COUNT_ , 0 as DELETED_INCIDENT_COUNT_ from ACT_HI_ACTINST ACT INNER JOIN ACT_HI_PROCINST PI ON ACT.PROC_INST_ID_ = PI.ID_ where ACT.PROC_DEF_ID_ = ? and PI.START_TIME_ <= ? and PI.START_TIME_ >= ? GROUP BY ACT_ID_ UNION select INC.ACTIVITY_ID_ as ID_, 0 as INSTANCE_COUNT_ , 0 as FINISHED_COUNT_ , 0 as CANCELED_COUNT_ , 0 as COMPLETE_SCOPE_COUNT_ , sum(CASE WHEN INC.INCIDENT_STATE_ = 0 THEN 1 ELSE 0 END) as OPEN_INCIDENT_COUNT_ , sum(CASE WHEN INC.INCIDENT_STATE_ = 1 THEN 1 ELSE 0 END) as RESOLVED_INCIDENT_COUNT_ , sum(CASE WHEN INC.INCIDENT_STATE_ = 2 THEN 1 ELSE 0 END) as DELETED_INCIDENT_COUNT_ from ACT_HI_INCIDENT INC INNER JOIN ACT_HI_PROCINST PI ON INC.PROC_INST_ID_ = PI.ID_ where INC.PROC_DEF_ID_ = ? and PI.START_TIME_ <= ? and PI.START_TIME_ >= ? GROUP BY INC.ACTIVITY_ID_ ) RES GROUP BY ID_ ) RES order by RES.ID_ asc LIMIT ? OFFSET ? ### Cause: org.postgresql.util.PSQLException: ERROR: UNION types int and decimal cannot be matched at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:149) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140) at org.camunda.bpm.engine.impl.db.sql.DbSqlSession.selectList(DbSqlSession.java:97) at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.selectListWithRawParameter(DbEntityManager.java:181) at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.selectList(DbEntityManager.java:173) at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.selectList(DbEntityManager.java:165) at org.camunda.bpm.engine.impl.persistence.entity.HistoricStatisticsManager.getHistoricStatisticsGroupedByActivity(HistoricStatisticsManager.java:42) at org.camunda.bpm.engine.impl.HistoricActivityStatisticsQueryImpl.executeList(HistoricActivityStatisticsQueryImpl.java:123) at org.camunda.bpm.engine.impl.AbstractQuery.evaluateExpressionsAndExecuteList(AbstractQuery.java:219) at org.camunda.bpm.engine.impl.AbstractQuery.execute(AbstractQuery.java:193) at org.camunda.bpm.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:28) at org.camunda.bpm.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:110) ... 27 more Caused by: org.postgresql.util.PSQLException: ERROR: UNION types int and decimal cannot be matched at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2455) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2155) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:288) at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:430) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:356) at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:168) at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:157) at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64) at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79) at org.apache.ibatis.executor.BatchExecutor.doQuery(BatchExecutor.java:92) at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324) at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147) ... 38 more [ERROR] testQueryIncludeIncidentsWhenNoHistoricActivityInstanceDeletedOnly(org.camunda.bpm.engine.test.history.HistoricActivityStatisticsQueryTest) Time elapsed: 1.136 s <<< ERROR! org.camunda.bpm.engine.ProcessEngineException: Process engine persistence exception at org.camunda.bpm.engine.impl.interceptor.CommandInvocationContext.rethrow(CommandInvocationContext.java:153) at org.camunda.bpm.engine.impl.interceptor.CommandContext.close(CommandContext.java:229) at org.camunda.bpm.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:119) at org.camunda.bpm.engine.impl.interceptor.ProcessApplicationContextInterceptor.execute(ProcessApplicationContextInterceptor.java:70) at org.camunda.bpm.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33) at org.camunda.bpm.engine.impl.AbstractQuery.executeResult(AbstractQuery.java:160) at org.camunda.bpm.engine.impl.AbstractQuery.list(AbstractQuery.java:142) at org.camunda.bpm.engine.test.history.HistoricActivityStatisticsQueryTest.testQueryIncludeIncidentsWhenNoHistoricActivityInstanceDeletedOnly(HistoricActivityStatisticsQueryTest.java:1341) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at junit.framework.TestCase.runTest(TestCase.java:176) at junit.framework.TestCase.runBare(TestCase.java:141) at org.camunda.bpm.engine.impl.test.AbstractProcessEngineTestCase.runBare(AbstractProcessEngineTestCase.java:115) at junit.framework.TestResult$1.protect(TestResult.java:122) at junit.framework.TestResult.runProtected(TestResult.java:142) at junit.framework.TestResult.run(TestResult.java:125) at junit.framework.TestCase.run(TestCase.java:129) at junit.framework.TestSuite.runTest(TestSuite.java:252) at junit.framework.TestSuite.run(TestSuite.java:247) at org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:86) at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:365) at org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:273) at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:238) at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:159) at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:384) at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:345) at org.apache.maven.surefire.booter.ForkedBooter.execute(ForkedBooter.java:126) at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:418) Caused by: org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: org.postgresql.util.PSQLException: ERROR: UNION types int and decimal cannot be matched ### The error may exist in org/camunda/bpm/engine/impl/mapping/entity/HistoricStatistics.xml ### The error may involve org.camunda.bpm.engine.history.HistoricActivityStatistics.selectHistoricActivityStatistics-Inline ### The error occurred while setting parameters ### SQL: select RES.* from ( select ID_, sum(INSTANCE_COUNT_) as INSTANCE_COUNT_ , sum(FINISHED_COUNT_) as FINISHED_COUNT_ , sum(OPEN_INCIDENT_COUNT_) as OPEN_INCIDENT_COUNT_ , sum(RESOLVED_INCIDENT_COUNT_) as RESOLVED_INCIDENT_COUNT_ , sum(DELETED_INCIDENT_COUNT_) as DELETED_INCIDENT_COUNT_ from ( select ACT.ACT_ID_ as ID_, sum(CASE WHEN ACT.END_TIME_ is NULL THEN 1 ELSE 0 END) as INSTANCE_COUNT_ , sum(CASE WHEN ACT.END_TIME_ is not NULL THEN 1 ELSE 0 END) as FINISHED_COUNT_ , 0 as OPEN_INCIDENT_COUNT_ , 0 as RESOLVED_INCIDENT_COUNT_ , 0 as DELETED_INCIDENT_COUNT_ from ACT_HI_ACTINST ACT where ACT.PROC_DEF_ID_ = ? GROUP BY ACT_ID_ UNION select INC.ACTIVITY_ID_ as ID_, 0 as INSTANCE_COUNT_ , 0 as FINISHED_COUNT_ , sum(CASE WHEN INC.INCIDENT_STATE_ = 0 THEN 1 ELSE 0 END) as OPEN_INCIDENT_COUNT_ , sum(CASE WHEN INC.INCIDENT_STATE_ = 1 THEN 1 ELSE 0 END) as RESOLVED_INCIDENT_COUNT_ , sum(CASE WHEN INC.INCIDENT_STATE_ = 2 THEN 1 ELSE 0 END) as DELETED_INCIDENT_COUNT_ from ACT_HI_INCIDENT INC where INC.PROC_DEF_ID_ = ? GROUP BY INC.ACTIVITY_ID_ ) RES GROUP BY ID_ ) RES order by RES.ID_ asc LIMIT ? OFFSET ? ### Cause: org.postgresql.util.PSQLException: ERROR: UNION types int and decimal cannot be matched at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:149) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140) at org.camunda.bpm.engine.impl.db.sql.DbSqlSession.selectList(DbSqlSession.java:97) at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.selectListWithRawParameter(DbEntityManager.java:181) at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.selectList(DbEntityManager.java:173) at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.selectList(DbEntityManager.java:165) at org.camunda.bpm.engine.impl.persistence.entity.HistoricStatisticsManager.getHistoricStatisticsGroupedByActivity(HistoricStatisticsManager.java:42) at org.camunda.bpm.engine.impl.HistoricActivityStatisticsQueryImpl.executeList(HistoricActivityStatisticsQueryImpl.java:123) at org.camunda.bpm.engine.impl.AbstractQuery.evaluateExpressionsAndExecuteList(AbstractQuery.java:219) at org.camunda.bpm.engine.impl.AbstractQuery.execute(AbstractQuery.java:193) at org.camunda.bpm.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:28) at org.camunda.bpm.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:110) ... 27 more Caused by: org.postgresql.util.PSQLException: ERROR: UNION types int and decimal cannot be matched at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2455) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2155) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:288) at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:430) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:356) at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:168) at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:157) at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64) at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79) at org.apache.ibatis.executor.BatchExecutor.doQuery(BatchExecutor.java:92) at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324) at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147) ... 38 more [ERROR] testQueryIncludeIncidentsMultipleRunningTasksDeletedOnly(org.camunda.bpm.engine.test.history.HistoricActivityStatisticsQueryTest) Time elapsed: 2.85 s <<< ERROR! org.camunda.bpm.engine.ProcessEngineException: Process engine persistence exception at org.camunda.bpm.engine.impl.interceptor.CommandInvocationContext.rethrow(CommandInvocationContext.java:153) at org.camunda.bpm.engine.impl.interceptor.CommandContext.close(CommandContext.java:229) at org.camunda.bpm.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:119) at org.camunda.bpm.engine.impl.interceptor.ProcessApplicationContextInterceptor.execute(ProcessApplicationContextInterceptor.java:70) at org.camunda.bpm.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33) at org.camunda.bpm.engine.impl.AbstractQuery.executeResult(AbstractQuery.java:160) at org.camunda.bpm.engine.impl.AbstractQuery.list(AbstractQuery.java:142) at org.camunda.bpm.engine.test.history.HistoricActivityStatisticsQueryTest.testQueryIncludeIncidentsMultipleRunningTasksDeletedOnly(HistoricActivityStatisticsQueryTest.java:1170) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at junit.framework.TestCase.runTest(TestCase.java:176) at junit.framework.TestCase.runBare(TestCase.java:141) at org.camunda.bpm.engine.impl.test.AbstractProcessEngineTestCase.runBare(AbstractProcessEngineTestCase.java:115) at junit.framework.TestResult$1.protect(TestResult.java:122) at junit.framework.TestResult.runProtected(TestResult.java:142) at junit.framework.TestResult.run(TestResult.java:125) at junit.framework.TestCase.run(TestCase.java:129) at junit.framework.TestSuite.runTest(TestSuite.java:252) at junit.framework.TestSuite.run(TestSuite.java:247) at org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:86) at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:365) at org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:273) at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:238) at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:159) at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:384) at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:345) at org.apache.maven.surefire.booter.ForkedBooter.execute(ForkedBooter.java:126) at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:418) Caused by: org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: org.postgresql.util.PSQLException: ERROR: UNION types int and decimal cannot be matched ### The error may exist in org/camunda/bpm/engine/impl/mapping/entity/HistoricStatistics.xml ### The error may involve org.camunda.bpm.engine.history.HistoricActivityStatistics.selectHistoricActivityStatistics-Inline ### The error occurred while setting parameters ### SQL: select RES.* from ( select ID_, sum(INSTANCE_COUNT_) as INSTANCE_COUNT_ , sum(FINISHED_COUNT_) as FINISHED_COUNT_ , sum(CANCELED_COUNT_) as CANCELED_COUNT_ , sum(COMPLETE_SCOPE_COUNT_) as COMPLETE_SCOPE_COUNT_ , sum(OPEN_INCIDENT_COUNT_) as OPEN_INCIDENT_COUNT_ , sum(RESOLVED_INCIDENT_COUNT_) as RESOLVED_INCIDENT_COUNT_ , sum(DELETED_INCIDENT_COUNT_) as DELETED_INCIDENT_COUNT_ from ( select ACT.ACT_ID_ as ID_, sum(CASE WHEN ACT.END_TIME_ is NULL THEN 1 ELSE 0 END) as INSTANCE_COUNT_ , sum(CASE WHEN ACT.END_TIME_ is not NULL THEN 1 ELSE 0 END) as FINISHED_COUNT_ , sum(CASE WHEN ACT.ACT_INST_STATE_ = 2 THEN 1 ELSE 0 END) as CANCELED_COUNT_ , sum(CASE WHEN ACT.ACT_INST_STATE_ = 1 THEN 1 ELSE 0 END) as COMPLETE_SCOPE_COUNT_ , 0 as OPEN_INCIDENT_COUNT_ , 0 as RESOLVED_INCIDENT_COUNT_ , 0 as DELETED_INCIDENT_COUNT_ from ACT_HI_ACTINST ACT where ACT.PROC_DEF_ID_ = ? GROUP BY ACT_ID_ UNION select INC.ACTIVITY_ID_ as ID_, 0 as INSTANCE_COUNT_ , 0 as FINISHED_COUNT_ , 0 as CANCELED_COUNT_ , 0 as COMPLETE_SCOPE_COUNT_ , sum(CASE WHEN INC.INCIDENT_STATE_ = 0 THEN 1 ELSE 0 END) as OPEN_INCIDENT_COUNT_ , sum(CASE WHEN INC.INCIDENT_STATE_ = 1 THEN 1 ELSE 0 END) as RESOLVED_INCIDENT_COUNT_ , sum(CASE WHEN INC.INCIDENT_STATE_ = 2 THEN 1 ELSE 0 END) as DELETED_INCIDENT_COUNT_ from ACT_HI_INCIDENT INC where INC.PROC_DEF_ID_ = ? GROUP BY INC.ACTIVITY_ID_ ) RES GROUP BY ID_ ) RES order by RES.ID_ asc LIMIT ? OFFSET ? ### Cause: org.postgresql.util.PSQLException: ERROR: UNION types int and decimal cannot be matched at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:149) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140) at org.camunda.bpm.engine.impl.db.sql.DbSqlSession.selectList(DbSqlSession.java:97) at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.selectListWithRawParameter(DbEntityManager.java:181) at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.selectList(DbEntityManager.java:173) at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.selectList(DbEntityManager.java:165) at org.camunda.bpm.engine.impl.persistence.entity.HistoricStatisticsManager.getHistoricStatisticsGroupedByActivity(HistoricStatisticsManager.java:42) at org.camunda.bpm.engine.impl.HistoricActivityStatisticsQueryImpl.executeList(HistoricActivityStatisticsQueryImpl.java:123) at org.camunda.bpm.engine.impl.AbstractQuery.evaluateExpressionsAndExecuteList(AbstractQuery.java:219) at org.camunda.bpm.engine.impl.AbstractQuery.execute(AbstractQuery.java:193) at org.camunda.bpm.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:28) at org.camunda.bpm.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:110) ... 27 more Caused by: org.postgresql.util.PSQLException: ERROR: UNION types int and decimal cannot be matched at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2455) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2155) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:288) at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:430) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:356) at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:168) at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:157) at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64) at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79) at org.apache.ibatis.executor.BatchExecutor.doQuery(BatchExecutor.java:92) at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324) at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147) ... 38 more [ERROR] testQueryIncludeIncidentsWhenNoHistoricActivityInstanceWithoutFilters(org.camunda.bpm.engine.test.history.HistoricActivityStatisticsQueryTest) Time elapsed: 1.299 s <<< ERROR! org.camunda.bpm.engine.ProcessEngineException: Process engine persistence exception at org.camunda.bpm.engine.impl.interceptor.CommandInvocationContext.rethrow(CommandInvocationContext.java:153) at org.camunda.bpm.engine.impl.interceptor.CommandContext.close(CommandContext.java:229) at org.camunda.bpm.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:119) at org.camunda.bpm.engine.impl.interceptor.ProcessApplicationContextInterceptor.execute(ProcessApplicationContextInterceptor.java:70) at org.camunda.bpm.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33) at org.camunda.bpm.engine.impl.AbstractQuery.executeResult(AbstractQuery.java:160) at org.camunda.bpm.engine.impl.AbstractQuery.list(AbstractQuery.java:142) at org.camunda.bpm.engine.test.history.HistoricActivityStatisticsQueryTest.testQueryIncludeIncidentsWhenNoHistoricActivityInstanceWithoutFilters(HistoricActivityStatisticsQueryTest.java:1374) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at junit.framework.TestCase.runTest(TestCase.java:176) at junit.framework.TestCase.runBare(TestCase.java:141) at org.camunda.bpm.engine.impl.test.AbstractProcessEngineTestCase.runBare(AbstractProcessEngineTestCase.java:115) at junit.framework.TestResult$1.protect(TestResult.java:122) at junit.framework.TestResult.runProtected(TestResult.java:142) at junit.framework.TestResult.run(TestResult.java:125) at junit.framework.TestCase.run(TestCase.java:129) at junit.framework.TestSuite.runTest(TestSuite.java:252) at junit.framework.TestSuite.run(TestSuite.java:247) at org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:86) at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:365) at org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:273) at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:238) at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:159) at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:384) at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:345) at org.apache.maven.surefire.booter.ForkedBooter.execute(ForkedBooter.java:126) at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:418) Caused by: org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: org.postgresql.util.PSQLException: ERROR: UNION types int and decimal cannot be matched ### The error may exist in org/camunda/bpm/engine/impl/mapping/entity/HistoricStatistics.xml ### The error may involve org.camunda.bpm.engine.history.HistoricActivityStatistics.selectHistoricActivityStatistics-Inline ### The error occurred while setting parameters ### SQL: select RES.* from ( select ID_, sum(INSTANCE_COUNT_) as INSTANCE_COUNT_ , sum(OPEN_INCIDENT_COUNT_) as OPEN_INCIDENT_COUNT_ , sum(RESOLVED_INCIDENT_COUNT_) as RESOLVED_INCIDENT_COUNT_ , sum(DELETED_INCIDENT_COUNT_) as DELETED_INCIDENT_COUNT_ from ( select ACT.ACT_ID_ as ID_, sum(CASE WHEN ACT.END_TIME_ is NULL THEN 1 ELSE 0 END) as INSTANCE_COUNT_ , 0 as OPEN_INCIDENT_COUNT_ , 0 as RESOLVED_INCIDENT_COUNT_ , 0 as DELETED_INCIDENT_COUNT_ from ACT_HI_ACTINST ACT where ACT.PROC_DEF_ID_ = ? and ( ACT.END_TIME_ is null ) GROUP BY ACT_ID_ UNION select INC.ACTIVITY_ID_ as ID_, 0 as INSTANCE_COUNT_ , sum(CASE WHEN INC.INCIDENT_STATE_ = 0 THEN 1 ELSE 0 END) as OPEN_INCIDENT_COUNT_ , sum(CASE WHEN INC.INCIDENT_STATE_ = 1 THEN 1 ELSE 0 END) as RESOLVED_INCIDENT_COUNT_ , sum(CASE WHEN INC.INCIDENT_STATE_ = 2 THEN 1 ELSE 0 END) as DELETED_INCIDENT_COUNT_ from ACT_HI_INCIDENT INC where INC.PROC_DEF_ID_ = ? GROUP BY INC.ACTIVITY_ID_ ) RES GROUP BY ID_ ) RES order by RES.ID_ asc LIMIT ? OFFSET ? ### Cause: org.postgresql.util.PSQLException: ERROR: UNION types int and decimal cannot be matched at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:149) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140) at org.camunda.bpm.engine.impl.db.sql.DbSqlSession.selectList(DbSqlSession.java:97) at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.selectListWithRawParameter(DbEntityManager.java:181) at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.selectList(DbEntityManager.java:173) at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.selectList(DbEntityManager.java:165) at org.camunda.bpm.engine.impl.persistence.entity.HistoricStatisticsManager.getHistoricStatisticsGroupedByActivity(HistoricStatisticsManager.java:42) at org.camunda.bpm.engine.impl.HistoricActivityStatisticsQueryImpl.executeList(HistoricActivityStatisticsQueryImpl.java:123) at org.camunda.bpm.engine.impl.AbstractQuery.evaluateExpressionsAndExecuteList(AbstractQuery.java:219) at org.camunda.bpm.engine.impl.AbstractQuery.execute(AbstractQuery.java:193) at org.camunda.bpm.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:28) at org.camunda.bpm.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:110) ... 27 more Caused by: org.postgresql.util.PSQLException: ERROR: UNION types int and decimal cannot be matched at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2455) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2155) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:288) at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:430) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:356) at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:168) at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:157) at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64) at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79) at org.apache.ibatis.executor.BatchExecutor.doQuery(BatchExecutor.java:92) at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324) at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147) ... 38 more [ERROR] testQueryIncludeIncidentsMultipleRunningTasksOpenOnly(org.camunda.bpm.engine.test.history.HistoricActivityStatisticsQueryTest) Time elapsed: 3.229 s <<< ERROR! org.camunda.bpm.engine.ProcessEngineException: Process engine persistence exception at org.camunda.bpm.engine.impl.interceptor.CommandInvocationContext.rethrow(CommandInvocationContext.java:153) at org.camunda.bpm.engine.impl.interceptor.CommandContext.close(CommandContext.java:229) at org.camunda.bpm.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:119) at org.camunda.bpm.engine.impl.interceptor.ProcessApplicationContextInterceptor.execute(ProcessApplicationContextInterceptor.java:70) at org.camunda.bpm.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33) at org.camunda.bpm.engine.impl.AbstractQuery.executeResult(AbstractQuery.java:160) at org.camunda.bpm.engine.impl.AbstractQuery.list(AbstractQuery.java:142) at org.camunda.bpm.engine.test.history.HistoricActivityStatisticsQueryTest.testQueryIncludeIncidentsMultipleRunningTasksOpenOnly(HistoricActivityStatisticsQueryTest.java:1212) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at junit.framework.TestCase.runTest(TestCase.java:176) at junit.framework.TestCase.runBare(TestCase.java:141) at org.camunda.bpm.engine.impl.test.AbstractProcessEngineTestCase.runBare(AbstractProcessEngineTestCase.java:115) at junit.framework.TestResult$1.protect(TestResult.java:122) at junit.framework.TestResult.runProtected(TestResult.java:142) at junit.framework.TestResult.run(TestResult.java:125) at junit.framework.TestCase.run(TestCase.java:129) at junit.framework.TestSuite.runTest(TestSuite.java:252) at junit.framework.TestSuite.run(TestSuite.java:247) at org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:86) at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:365) at org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:273) at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:238) at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:159) at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:384) at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:345) at org.apache.maven.surefire.booter.ForkedBooter.execute(ForkedBooter.java:126) at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:418) Caused by: org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: org.postgresql.util.PSQLException: ERROR: UNION types int and decimal cannot be matched ### The error may exist in org/camunda/bpm/engine/impl/mapping/entity/HistoricStatistics.xml ### The error may involve org.camunda.bpm.engine.history.HistoricActivityStatistics.selectHistoricActivityStatistics-Inline ### The error occurred while setting parameters ### SQL: select RES.* from ( select ID_, sum(INSTANCE_COUNT_) as INSTANCE_COUNT_ , sum(OPEN_INCIDENT_COUNT_) as OPEN_INCIDENT_COUNT_ , sum(RESOLVED_INCIDENT_COUNT_) as RESOLVED_INCIDENT_COUNT_ , sum(DELETED_INCIDENT_COUNT_) as DELETED_INCIDENT_COUNT_ from ( select ACT.ACT_ID_ as ID_, sum(CASE WHEN ACT.END_TIME_ is NULL THEN 1 ELSE 0 END) as INSTANCE_COUNT_ , 0 as OPEN_INCIDENT_COUNT_ , 0 as RESOLVED_INCIDENT_COUNT_ , 0 as DELETED_INCIDENT_COUNT_ from ACT_HI_ACTINST ACT where ACT.PROC_DEF_ID_ = ? and ( ACT.END_TIME_ is null ) GROUP BY ACT_ID_ UNION select INC.ACTIVITY_ID_ as ID_, 0 as INSTANCE_COUNT_ , sum(CASE WHEN INC.INCIDENT_STATE_ = 0 THEN 1 ELSE 0 END) as OPEN_INCIDENT_COUNT_ , sum(CASE WHEN INC.INCIDENT_STATE_ = 1 THEN 1 ELSE 0 END) as RESOLVED_INCIDENT_COUNT_ , sum(CASE WHEN INC.INCIDENT_STATE_ = 2 THEN 1 ELSE 0 END) as DELETED_INCIDENT_COUNT_ from ACT_HI_INCIDENT INC where INC.PROC_DEF_ID_ = ? GROUP BY INC.ACTIVITY_ID_ ) RES GROUP BY ID_ ) RES order by RES.ID_ asc LIMIT ? OFFSET ? ### Cause: org.postgresql.util.PSQLException: ERROR: UNION types int and decimal cannot be matched at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:149) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140) at org.camunda.bpm.engine.impl.db.sql.DbSqlSession.selectList(DbSqlSession.java:97) at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.selectListWithRawParameter(DbEntityManager.java:181) at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.selectList(DbEntityManager.java:173) at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.selectList(DbEntityManager.java:165) at org.camunda.bpm.engine.impl.persistence.entity.HistoricStatisticsManager.getHistoricStatisticsGroupedByActivity(HistoricStatisticsManager.java:42) at org.camunda.bpm.engine.impl.HistoricActivityStatisticsQueryImpl.executeList(HistoricActivityStatisticsQueryImpl.java:123) at org.camunda.bpm.engine.impl.AbstractQuery.evaluateExpressionsAndExecuteList(AbstractQuery.java:219) at org.camunda.bpm.engine.impl.AbstractQuery.execute(AbstractQuery.java:193) at org.camunda.bpm.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:28) at org.camunda.bpm.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:110) ... 27 more Caused by: org.postgresql.util.PSQLException: ERROR: UNION types int and decimal cannot be matched at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2455) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2155) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:288) at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:430) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:356) at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:168) at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:157) at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64) at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79) at org.apache.ibatis.executor.BatchExecutor.doQuery(BatchExecutor.java:92) at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324) at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147) ... 38 more [ERROR] testQueryIncludeIncidentsDeletedOnlyAndProcessInstanceIds(org.camunda.bpm.engine.test.history.HistoricActivityStatisticsQueryTest) Time elapsed: 1.477 s <<< ERROR! org.camunda.bpm.engine.ProcessEngineException: Process engine persistence exception at org.camunda.bpm.engine.impl.interceptor.CommandInvocationContext.rethrow(CommandInvocationContext.java:153) at org.camunda.bpm.engine.impl.interceptor.CommandContext.close(CommandContext.java:229) at org.camunda.bpm.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:119) at org.camunda.bpm.engine.impl.interceptor.ProcessApplicationContextInterceptor.execute(ProcessApplicationContextInterceptor.java:70) at org.camunda.bpm.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33) at org.camunda.bpm.engine.impl.AbstractQuery.executeResult(AbstractQuery.java:160) at org.camunda.bpm.engine.impl.AbstractQuery.list(AbstractQuery.java:142) at org.camunda.bpm.engine.test.history.HistoricActivityStatisticsQueryTest.testQueryIncludeIncidentsDeletedOnlyAndProcessInstanceIds(HistoricActivityStatisticsQueryTest.java:1101) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at junit.framework.TestCase.runTest(TestCase.java:176) at junit.framework.TestCase.runBare(TestCase.java:141) at org.camunda.bpm.engine.impl.test.AbstractProcessEngineTestCase.runBare(AbstractProcessEngineTestCase.java:115) at junit.framework.TestResult$1.protect(TestResult.java:122) at junit.framework.TestResult.runProtected(TestResult.java:142) at junit.framework.TestResult.run(TestResult.java:125) at junit.framework.TestCase.run(TestCase.java:129) at junit.framework.TestSuite.runTest(TestSuite.java:252) at junit.framework.TestSuite.run(TestSuite.java:247) at org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:86) at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:365) at org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:273) at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:238) at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:159) at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:384) at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:345) at org.apache.maven.surefire.booter.ForkedBooter.execute(ForkedBooter.java:126) at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:418) Caused by: org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: org.postgresql.util.PSQLException: ERROR: UNION types int and decimal cannot be matched ### The error may exist in org/camunda/bpm/engine/impl/mapping/entity/HistoricStatistics.xml ### The error may involve org.camunda.bpm.engine.history.HistoricActivityStatistics.selectHistoricActivityStatistics-Inline ### The error occurred while setting parameters ### SQL: select RES.* from ( select ID_, sum(INSTANCE_COUNT_) as INSTANCE_COUNT_ , sum(FINISHED_COUNT_) as FINISHED_COUNT_ , sum(CANCELED_COUNT_) as CANCELED_COUNT_ , sum(COMPLETE_SCOPE_COUNT_) as COMPLETE_SCOPE_COUNT_ , sum(OPEN_INCIDENT_COUNT_) as OPEN_INCIDENT_COUNT_ , sum(RESOLVED_INCIDENT_COUNT_) as RESOLVED_INCIDENT_COUNT_ , sum(DELETED_INCIDENT_COUNT_) as DELETED_INCIDENT_COUNT_ from ( select ACT.ACT_ID_ as ID_, sum(CASE WHEN ACT.END_TIME_ is NULL THEN 1 ELSE 0 END) as INSTANCE_COUNT_ , sum(CASE WHEN ACT.END_TIME_ is not NULL THEN 1 ELSE 0 END) as FINISHED_COUNT_ , sum(CASE WHEN ACT.ACT_INST_STATE_ = 2 THEN 1 ELSE 0 END) as CANCELED_COUNT_ , sum(CASE WHEN ACT.ACT_INST_STATE_ = 1 THEN 1 ELSE 0 END) as COMPLETE_SCOPE_COUNT_ , 0 as OPEN_INCIDENT_COUNT_ , 0 as RESOLVED_INCIDENT_COUNT_ , 0 as DELETED_INCIDENT_COUNT_ from ACT_HI_ACTINST ACT where ACT.PROC_DEF_ID_ = ? and ACT.PROC_INST_ID_ in ( ? ) GROUP BY ACT_ID_ UNION select INC.ACTIVITY_ID_ as ID_, 0 as INSTANCE_COUNT_ , 0 as FINISHED_COUNT_ , 0 as CANCELED_COUNT_ , 0 as COMPLETE_SCOPE_COUNT_ , sum(CASE WHEN INC.INCIDENT_STATE_ = 0 THEN 1 ELSE 0 END) as OPEN_INCIDENT_COUNT_ , sum(CASE WHEN INC.INCIDENT_STATE_ = 1 THEN 1 ELSE 0 END) as RESOLVED_INCIDENT_COUNT_ , sum(CASE WHEN INC.INCIDENT_STATE_ = 2 THEN 1 ELSE 0 END) as DELETED_INCIDENT_COUNT_ from ACT_HI_INCIDENT INC where INC.PROC_DEF_ID_ = ? and INC.PROC_INST_ID_ in ( ? ) GROUP BY INC.ACTIVITY_ID_ ) RES GROUP BY ID_ ) RES order by RES.ID_ asc LIMIT ? OFFSET ? ### Cause: org.postgresql.util.PSQLException: ERROR: UNION types int and decimal cannot be matched at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:149) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140) at org.camunda.bpm.engine.impl.db.sql.DbSqlSession.selectList(DbSqlSession.java:97) at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.selectListWithRawParameter(DbEntityManager.java:181) at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.selectList(DbEntityManager.java:173) at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.selectList(DbEntityManager.java:165) at org.camunda.bpm.engine.impl.persistence.entity.HistoricStatisticsManager.getHistoricStatisticsGroupedByActivity(HistoricStatisticsManager.java:42) at org.camunda.bpm.engine.impl.HistoricActivityStatisticsQueryImpl.executeList(HistoricActivityStatisticsQueryImpl.java:123) at org.camunda.bpm.engine.impl.AbstractQuery.evaluateExpressionsAndExecuteList(AbstractQuery.java:219) at org.camunda.bpm.engine.impl.AbstractQuery.execute(AbstractQuery.java:193) at org.camunda.bpm.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:28) at org.camunda.bpm.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:110) ... 27 more Caused by: org.postgresql.util.PSQLException: ERROR: UNION types int and decimal cannot be matched at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2455) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2155) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:288) at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:430) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:356) at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:168) at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:157) at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64) at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79) at org.apache.ibatis.executor.BatchExecutor.doQuery(BatchExecutor.java:92) at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324) at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147) ... 38 more [ERROR] testQueryIncludeIncidents(org.camunda.bpm.engine.test.history.HistoricActivityStatisticsQueryTest) Time elapsed: 1.766 s <<< ERROR! org.camunda.bpm.engine.ProcessEngineException: Process engine persistence exception at org.camunda.bpm.engine.impl.interceptor.CommandInvocationContext.rethrow(CommandInvocationContext.java:153) at org.camunda.bpm.engine.impl.interceptor.CommandContext.close(CommandContext.java:229) at org.camunda.bpm.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:119) at org.camunda.bpm.engine.impl.interceptor.ProcessApplicationContextInterceptor.execute(ProcessApplicationContextInterceptor.java:70) at org.camunda.bpm.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33) at org.camunda.bpm.engine.impl.AbstractQuery.executeResult(AbstractQuery.java:160) at org.camunda.bpm.engine.impl.AbstractQuery.list(AbstractQuery.java:142) at org.camunda.bpm.engine.test.history.HistoricActivityStatisticsQueryTest.testQueryIncludeIncidents(HistoricActivityStatisticsQueryTest.java:1061) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at junit.framework.TestCase.runTest(TestCase.java:176) at junit.framework.TestCase.runBare(TestCase.java:141) at org.camunda.bpm.engine.impl.test.AbstractProcessEngineTestCase.runBare(AbstractProcessEngineTestCase.java:115) at junit.framework.TestResult$1.protect(TestResult.java:122) at junit.framework.TestResult.runProtected(TestResult.java:142) at junit.framework.TestResult.run(TestResult.java:125) at junit.framework.TestCase.run(TestCase.java:129) at junit.framework.TestSuite.runTest(TestSuite.java:252) at junit.framework.TestSuite.run(TestSuite.java:247) at org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:86) at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:365) at org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:273) at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:238) at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:159) at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:384) at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:345) at org.apache.maven.surefire.booter.ForkedBooter.execute(ForkedBooter.java:126) at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:418) Caused by: org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: org.postgresql.util.PSQLException: ERROR: UNION types int and decimal cannot be matched ### The error may exist in org/camunda/bpm/engine/impl/mapping/entity/HistoricStatistics.xml ### The error may involve org.camunda.bpm.engine.history.HistoricActivityStatistics.selectHistoricActivityStatistics-Inline ### The error occurred while setting parameters ### SQL: select RES.* from ( select ID_, sum(INSTANCE_COUNT_) as INSTANCE_COUNT_ , sum(FINISHED_COUNT_) as FINISHED_COUNT_ , sum(CANCELED_COUNT_) as CANCELED_COUNT_ , sum(OPEN_INCIDENT_COUNT_) as OPEN_INCIDENT_COUNT_ , sum(RESOLVED_INCIDENT_COUNT_) as RESOLVED_INCIDENT_COUNT_ , sum(DELETED_INCIDENT_COUNT_) as DELETED_INCIDENT_COUNT_ from ( select ACT.ACT_ID_ as ID_, sum(CASE WHEN ACT.END_TIME_ is NULL THEN 1 ELSE 0 END) as INSTANCE_COUNT_ , sum(CASE WHEN ACT.END_TIME_ is not NULL THEN 1 ELSE 0 END) as FINISHED_COUNT_ , sum(CASE WHEN ACT.ACT_INST_STATE_ = 2 THEN 1 ELSE 0 END) as CANCELED_COUNT_ , 0 as OPEN_INCIDENT_COUNT_ , 0 as RESOLVED_INCIDENT_COUNT_ , 0 as DELETED_INCIDENT_COUNT_ from ACT_HI_ACTINST ACT where ACT.PROC_DEF_ID_ = ? GROUP BY ACT_ID_ UNION select INC.ACTIVITY_ID_ as ID_, 0 as INSTANCE_COUNT_ , 0 as FINISHED_COUNT_ , 0 as CANCELED_COUNT_ , sum(CASE WHEN INC.INCIDENT_STATE_ = 0 THEN 1 ELSE 0 END) as OPEN_INCIDENT_COUNT_ , sum(CASE WHEN INC.INCIDENT_STATE_ = 1 THEN 1 ELSE 0 END) as RESOLVED_INCIDENT_COUNT_ , sum(CASE WHEN INC.INCIDENT_STATE_ = 2 THEN 1 ELSE 0 END) as DELETED_INCIDENT_COUNT_ from ACT_HI_INCIDENT INC where INC.PROC_DEF_ID_ = ? GROUP BY INC.ACTIVITY_ID_ ) RES GROUP BY ID_ ) RES order by RES.ID_ asc LIMIT ? OFFSET ? ### Cause: org.postgresql.util.PSQLException: ERROR: UNION types int and decimal cannot be matched at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:149) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140) at org.camunda.bpm.engine.impl.db.sql.DbSqlSession.selectList(DbSqlSession.java:97) at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.selectListWithRawParameter(DbEntityManager.java:181) at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.selectList(DbEntityManager.java:173) at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.selectList(DbEntityManager.java:165) at org.camunda.bpm.engine.impl.persistence.entity.HistoricStatisticsManager.getHistoricStatisticsGroupedByActivity(HistoricStatisticsManager.java:42) at org.camunda.bpm.engine.impl.HistoricActivityStatisticsQueryImpl.executeList(HistoricActivityStatisticsQueryImpl.java:123) at org.camunda.bpm.engine.impl.AbstractQuery.evaluateExpressionsAndExecuteList(AbstractQuery.java:219) at org.camunda.bpm.engine.impl.AbstractQuery.execute(AbstractQuery.java:193) at org.camunda.bpm.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:28) at org.camunda.bpm.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:110) ... 27 more Caused by: org.postgresql.util.PSQLException: ERROR: UNION types int and decimal cannot be matched at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2455) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2155) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:288) at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:430) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:356) at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:168) at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:157) at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64) at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79) at org.apache.ibatis.executor.BatchExecutor.doQuery(BatchExecutor.java:92) at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324) at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147) ... 38 more