Hi,
We are using java 8 and Camunda 7.17.0 spring boot project with MSSQL database.
Following configuration is the part of History cleanup in application .yml
#Camunda history cleanup Details
camunda.bpm.generic-properties.properties.history-time-to-live=P1D
camunda.bpm.generic-properties.properties.history-cleanup-strategy=endTimeBased
camunda.bpm.generic-properties.properties.historyRemovalTimeStrategy=end
camunda.bpm.generic-properties.properties.history-cleanup-batch-window-start-time=16:15
camunda.bpm.generic-properties.properties.history-cleanup-batch-window-end-time=17:00
camunda.bpm.generic-properties.properties.history-cleanup-batch-size = 100
I have tried removal time-based strategy too but randomly its throwing below error after that process will not be completed in camunda.
Please let me know if any configuration is missing or what is the probelm?
}
2024-03-14 18:14:08.631 ERROR 9832 — [ntContainer#0-1] org.camunda.bpm.engine.context : ENGINE-16004 Exception while closing command context: An exception occurred in the persistence layer. Please check the server logs for a detailed message and the entire exception stack trace.
org.camunda.bpm.engine.ProcessEngineException: An exception occurred in the persistence layer. Please check the server logs for a detailed message and the entire exception stack trace.
at org.camunda.bpm.engine.impl.util.ExceptionUtil.wrapPersistenceException(ExceptionUtil.java:263) ~[camunda-engine-7.17.0.jar:7.17.0]
at org.camunda.bpm.engine.impl.db.EnginePersistenceLogger.flushDbOperationUnexpectedException(EnginePersistenceLogger.java:680) ~[camunda-engine-7.17.0.jar:7.17.0]
at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.flushDbOperations(DbEntityManager.java:344) ~[camunda-engine-7.17.0.jar:7.17.0]
at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.flushDbOperationManager(DbEntityManager.java:323) ~[camunda-engine-7.17.0.jar:7.17.0]
at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.flush(DbEntityManager.java:295) ~[camunda-engine-7.17.0.jar:7.17.0]
at org.camunda.bpm.engine.impl.interceptor.CommandContext.flushSessions(CommandContext.java:272) ~[camunda-engine-7.17.0.jar:7.17.0]
at org.camunda.bpm.engine.impl.interceptor.CommandContext.close(CommandContext.java:188) ~[camunda-engine-7.17.0.jar:7.17.0]
at org.camunda.bpm.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:119) [camunda-engine-7.17.0.jar:7.17.0]
at org.camunda.bpm.engine.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:72) [camunda-engine-spring-7.17.0.jar:7.17.0]
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140) [spring-tx-5.3.20.jar:5.3.20]
at org.camunda.bpm.engine.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:70) [camunda-engine-spring-7.17.0.jar:7.17.0]
at org.camunda.bpm.engine.impl.interceptor.ProcessApplicationContextInterceptor.execute(ProcessApplicationContextInterceptor.java:70) [camunda-engine-7.17.0.jar:7.17.0]
at org.camunda.bpm.engine.impl.interceptor.CommandCounterInterceptor.execute(CommandCounterInterceptor.java:35) [camunda-engine-7.17.0.jar:7.17.0]
at org.camunda.bpm.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33) [camunda-engine-7.17.0.jar:7.17.0]
at org.camunda.bpm.engine.impl.RuntimeServiceImpl.messageEventReceived(RuntimeServiceImpl.java:669) [camunda-engine-7.17.0.jar:7.17.0]
at com.xceedance.dwm.listener.XscServiceBusTopicListener.receiveMessage(XscServiceBusTopicListener.java:32) [classes/:na]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_202]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_202]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_202]
at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_202]
at org.springframework.messaging.handler.invocation.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:169) [spring-messaging-5.3.20.jar:5.3.20]
at org.springframework.messaging.handler.invocation.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:119) [spring-messaging-5.3.20.jar:5.3.20]
at org.springframework.jms.listener.adapter.MessagingMessageListenerAdapter.invokeHandler(MessagingMessageListenerAdapter.java:114) [spring-jms-5.3.20.jar:5.3.20]
at org.springframework.jms.listener.adapter.MessagingMessageListenerAdapter.onMessage(MessagingMessageListenerAdapter.java:77) [spring-jms-5.3.20.jar:5.3.20]
at org.springframework.jms.listener.AbstractMessageListenerContainer.doInvokeListener(AbstractMessageListenerContainer.java:736) [spring-jms-5.3.20.jar:5.3.20]
at org.springframework.jms.listener.AbstractMessageListenerContainer.invokeListener(AbstractMessageListenerContainer.java:696) [spring-jms-5.3.20.jar:5.3.20]
at org.springframework.jms.listener.AbstractMessageListenerContainer.doExecuteListener(AbstractMessageListenerContainer.java:674) [spring-jms-5.3.20.jar:5.3.20]
at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.doReceiveAndExecute(AbstractPollingMessageListenerContainer.java:331) [spring-jms-5.3.20.jar:5.3.20]
at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.receiveAndExecute(AbstractPollingMessageListenerContainer.java:270) [spring-jms-5.3.20.jar:5.3.20]
at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.invokeListener(DefaultMessageListenerContainer.java:1237) [spring-jms-5.3.20.jar:5.3.20]
at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.executeOngoingLoop(DefaultMessageListenerContainer.java:1227) [spring-jms-5.3.20.jar:5.3.20]
at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.run(DefaultMessageListenerContainer.java:1120) [spring-jms-5.3.20.jar:5.3.20]
at java.lang.Thread.run(Thread.java:748) [na:1.8.0_202]
Caused by: org.camunda.bpm.engine.ProcessEngineException: ENGINE-03083 Unexpected exception while executing database operations with message ’
Error flushing statements. Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Query processor could not produce a query plan because of the hints defined in this query. Resubmit the query without specifying any hints and without using SET FORCEPLAN.
Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Query processor could not produce a query plan because of the hints defined in this query. Resubmit the query without specifying any hints and without using SET FORCEPLAN.'. Flush summary:
[
INSERT HistoricVariableInstanceEntity[8ccc233c-e200-11ee-9101-a029427b6e76]
INSERT HistoricVariableInstanceEntity[8ccc233e-e200-11ee-9101-a029427b6e76]
INSERT HistoricVariableInstanceEntity[8ccc2340-e200-11ee-9101-a029427b6e76]
INSERT HistoricVariableInstanceEntity[8cd09019-e200-11ee-9101-a029427b6e76]
INSERT HistoricVariableInstanceEntity[8cd1a191-e200-11ee-9101-a029427b6e76]
INSERT HistoricVariableInstanceEntity[8cd1a194-e200-11ee-9101-a029427b6e76]
INSERT HistoricVariableInstanceEntity[8cd2b30c-e200-11ee-9101-a029427b6e76]
INSERT HistoricVariableUpdateEventEntity[8ccb11c8-e200-11ee-9101-a029427b6e76]
INSERT HistoricVariableUpdateEventEntity[8ccbae09-e200-11ee-9101-a029427b6e76]
INSERT HistoricVariableUpdateEventEntity[8ccbae0a-e200-11ee-9101-a029427b6e76]
INSERT HistoricVariableUpdateEventEntity[8ccbd51b-e200-11ee-9101-a029427b6e76]
INSERT HistoricVariableUpdateEventEntity[8ccc233d-e200-11ee-9101-a029427b6e76]
INSERT HistoricVariableUpdateEventEntity[8ccc233f-e200-11ee-9101-a029427b6e76]
INSERT HistoricVariableUpdateEventEntity[8ccc2341-e200-11ee-9101-a029427b6e76]
INSERT HistoricVariableUpdateEventEntity[8ccf0973-e200-11ee-9101-a029427b6e76]
INSERT HistoricVariableUpdateEventEntity[8ccf3084-e200-11ee-9101-a029427b6e76]
INSERT HistoricVariableUpdateEventEntity[8ccf7ea5-e200-11ee-9101-a029427b6e76]
INSERT HistoricVariableUpdateEventEntity[8ccfa5b6-e200-11ee-9101-a029427b6e76]
INSERT HistoricVariableUpdateEventEntity[8cd041f7-e200-11ee-9101-a029427b6e76]
INSERT HistoricVariableUpdateEventEntity[8cd06908-e200-11ee-9101-a029427b6e76]
INSERT HistoricVariableUpdateEventEntity[8cd0901a-e200-11ee-9101-a029427b6e76]
INSERT HistoricVariableUpdateEventEntity[8cd0901b-e200-11ee-9101-a029427b6e76]
INSERT HistoricVariableUpdateEventEntity[8cd0b72c-e200-11ee-9101-a029427b6e76]
INSERT HistoricVariableUpdateEventEntity[8cd0de3d-e200-11ee-9101-a029427b6e76]
INSERT HistoricVariableUpdateEventEntity[8cd1054e-e200-11ee-9101-a029427b6e76]
INSERT HistoricVariableUpdateEventEntity[8cd12c5f-e200-11ee-9101-a029427b6e76]
INSERT HistoricVariableUpdateEventEntity[8cd15370-e200-11ee-9101-a029427b6e76]
INSERT HistoricVariableUpdateEventEntity[8cd1a192-e200-11ee-9101-a029427b6e76]
INSERT HistoricVariableUpdateEventEntity[8cd1a193-e200-11ee-9101-a029427b6e76]
INSERT HistoricVariableUpdateEventEntity[8cd1c8a5-e200-11ee-9101-a029427b6e76]
INSERT HistoricVariableUpdateEventEntity[8cd1c8a6-e200-11ee-9101-a029427b6e76]
INSERT HistoricVariableUpdateEventEntity[8cd1efb7-e200-11ee-9101-a029427b6e76]
INSERT HistoricVariableUpdateEventEntity[8cd216c8-e200-11ee-9101-a029427b6e76]
INSERT HistoricVariableUpdateEventEntity[8cd23dd9-e200-11ee-9101-a029427b6e76]
INSERT HistoricVariableUpdateEventEntity[8cd264ea-e200-11ee-9101-a029427b6e76]
INSERT HistoricVariableUpdateEventEntity[8cd28bfb-e200-11ee-9101-a029427b6e76]
INSERT HistoricVariableUpdateEventEntity[8cd2b30d-e200-11ee-9101-a029427b6e76]
INSERT HistoricActivityInstanceEventEntity[EndEvent:8ccdd0f2-e200-11ee-9101-a029427b6e76]
INSERT HistoricActivityInstanceEventEntity[Event_08top94:8cd2da1e-e200-11ee-9101-a029427b6e76]
DELETE EventSubscriptionEntity[255a34c0-e200-11ee-9101-a029427b6e76]
DELETE VariableInstanceEntity[238c5236-e200-11ee-9101-a029427b6e76]
DELETE VariableInstanceEntity[238ca058-e200-11ee-9101-a029427b6e76]
DELETE VariableInstanceEntity[238ca05a-e200-11ee-9101-a029427b6e76]
DELETE VariableInstanceEntity[238ca05c-e200-11ee-9101-a029427b6e76]
DELETE VariableInstanceEntity[238ca05e-e200-11ee-9101-a029427b6e76]
DELETE VariableInstanceEntity[238ca060-e200-11ee-9101-a029427b6e76]
DELETE VariableInstanceEntity[238ca062-e200-11ee-9101-a029427b6e76]
DELETE VariableInstanceEntity[238cc774-e200-11ee-9101-a029427b6e76]
DELETE VariableInstanceEntity[238cc776-e200-11ee-9101-a029427b6e76]
DELETE VariableInstanceEntity[238cc778-e200-11ee-9101-a029427b6e76]
DELETE VariableInstanceEntity[238cee8a-e200-11ee-9101-a029427b6e76]
DELETE VariableInstanceEntity[238d159c-e200-11ee-9101-a029427b6e76]
DELETE VariableInstanceEntity[23f0b96f-e200-11ee-9101-a029427b6e76]
DELETE VariableInstanceEntity[23f1cae1-e200-11ee-9101-a029427b6e76]
DELETE VariableInstanceEntity[23f43be7-e200-11ee-9101-a029427b6e76]
DELETE VariableInstanceEntity[23f43be9-e200-11ee-9101-a029427b6e76]
DELETE VariableInstanceEntity[23f462fb-e200-11ee-9101-a029427b6e76]
DELETE VariableInstanceEntity[23f462fd-e200-11ee-9101-a029427b6e76]
DELETE VariableInstanceEntity[23f462ff-e200-11ee-9101-a029427b6e76]
DELETE VariableInstanceEntity[23f94502-e200-11ee-9101-a029427b6e76]
DELETE VariableInstanceEntity[23f94504-e200-11ee-9101-a029427b6e76]
DELETE VariableInstanceEntity[23f94506-e200-11ee-9101-a029427b6e76]
DELETE VariableInstanceEntity[23f94508-e200-11ee-9101-a029427b6e76]
DELETE VariableInstanceEntity[23f9450a-e200-11ee-9101-a029427b6e76]
DELETE VariableInstanceEntity[23f9450c-e200-11ee-9101-a029427b6e76]
DELETE VariableInstanceEntity[23f9450e-e200-11ee-9101-a029427b6e76]
DELETE VariableInstanceEntity[23f96c20-e200-11ee-9101-a029427b6e76]
DELETE VariableInstanceEntity[23f96c22-e200-11ee-9101-a029427b6e76]
DELETE VariableInstanceEntity[23f96c24-e200-11ee-9101-a029427b6e76]
DELETE VariableInstanceEntity[23f96c26-e200-11ee-9101-a029427b6e76]
DELETE VariableInstanceEntity[23f96c28-e200-11ee-9101-a029427b6e76]
DELETE VariableInstanceEntity[23f96c2a-e200-11ee-9101-a029427b6e76]
DELETE VariableInstanceEntity[23f96c2c-e200-11ee-9101-a029427b6e76]
DELETE VariableInstanceEntity[23f96c2e-e200-11ee-9101-a029427b6e76]
DELETE VariableInstanceEntity[23f99340-e200-11ee-9101-a029427b6e76]
DELETE VariableInstanceEntity[23f99342-e200-11ee-9101-a029427b6e76]
DELETE VariableInstanceEntity[23f99344-e200-11ee-9101-a029427b6e76]
DELETE VariableInstanceEntity[23f99346-e200-11ee-9101-a029427b6e76]
DELETE ExecutionEntity[255811df-e200-11ee-9101-a029427b6e76]
DELETE ExecutionEntity[23f91df1-e200-11ee-9101-a029427b6e76]
DELETE ExecutionEntity[23f3edc5-e200-11ee-9101-a029427b6e76]
DELETE ExecutionEntity[238a2f55-e200-11ee-9101-a029427b6e76]
UPDATE HistoricActivityInstanceEventEntity[FinalStage:23f3edc6-e200-11ee-9101-a029427b6e76]
UPDATE HistoricActivityInstanceEventEntity[ReceiveMessage:255a34c1-e200-11ee-9101-a029427b6e76]
UPDATE HistoricProcessInstanceEventEntity[238a2f55-e200-11ee-9101-a029427b6e76]
UPDATE HistoricProcessInstanceEventEntity[23f91df1-e200-11ee-9101-a029427b6e76]
DELETE_BULK deleteAuthorizationsForResourceId {resourceId=23f91df1-e200-11ee-9101-a029427b6e76, resourceType=8}
DELETE_BULK deleteAuthorizationsForResourceId {resourceId=238a2f55-e200-11ee-9101-a029427b6e76, resourceType=8}
UPDATE_BULK updateHistoricActivityInstancesByRootProcessInstanceId {rootProcessInstanceId=238a2f55-e200-11ee-9101-a029427b6e76, removalTime=Thu Mar 14 18:14:08 IST 2024}
UPDATE_BULK updateHistoricTaskInstancesByRootProcessInstanceId {rootProcessInstanceId=238a2f55-e200-11ee-9101-a029427b6e76, removalTime=Thu Mar 14 18:14:08 IST 2024}
UPDATE_BULK updateHistoricVariableInstancesByRootProcessInstanceId {rootProcessInstanceId=238a2f55-e200-11ee-9101-a029427b6e76, removalTime=Thu Mar 14 18:14:08 IST 2024}
UPDATE_BULK updateHistoricDetailsByRootProcessInstanceId {rootProcessInstanceId=238a2f55-e200-11ee-9101-a029427b6e76, removalTime=Thu Mar 14 18:14:08 IST 2024}
UPDATE_BULK updateHistoricIncidentsByRootProcessInstanceId {rootProcessInstanceId=238a2f55-e200-11ee-9101-a029427b6e76, removalTime=Thu Mar 14 18:14:08 IST 2024}
UPDATE_BULK updateExternalTaskLogByRootProcessInstanceId {rootProcessInstanceId=238a2f55-e200-11ee-9101-a029427b6e76, removalTime=Thu Mar 14 18:14:08 IST 2024}
UPDATE_BULK updateJobLogByRootProcessInstanceId {rootProcessInstanceId=238a2f55-e200-11ee-9101-a029427b6e76, removalTime=Thu Mar 14 18:14:08 IST 2024}
UPDATE_BULK updateUserOperationLogByRootProcessInstanceId {rootProcessInstanceId=238a2f55-e200-11ee-9101-a029427b6e76, removalTime=Thu Mar 14 18:14:08 IST 2024}
UPDATE_BULK updateIdentityLinkLogByRootProcessInstanceId {rootProcessInstanceId=238a2f55-e200-11ee-9101-a029427b6e76, removalTime=Thu Mar 14 18:14:08 IST 2024}
UPDATE_BULK updateCommentsByRootProcessInstanceId {rootProcessInstanceId=238a2f55-e200-11ee-9101-a029427b6e76, removalTime=Thu Mar 14 18:14:08 IST 2024}
UPDATE_BULK updateAttachmentsByRootProcessInstanceId {rootProcessInstanceId=238a2f55-e200-11ee-9101-a029427b6e76, removalTime=Thu Mar 14 18:14:08 IST 2024}
UPDATE_BULK updateByteArraysByRootProcessInstanceId {rootProcessInstanceId=238a2f55-e200-11ee-9101-a029427b6e76, removalTime=Thu Mar 14 18:14:08 IST 2024}
UPDATE_BULK updateHistoricProcessInstanceEventsByRootProcessInstanceId {rootProcessInstanceId=238a2f55-e200-11ee-9101-a029427b6e76, removalTime=Thu Mar 14 18:14:08 IST 2024}
UPDATE_BULK updateHistoricDecisionInstancesByRootProcessInstanceId {rootProcessInstanceId=238a2f55-e200-11ee-9101-a029427b6e76, removalTime=Thu Mar 14 18:14:08 IST 2024}
UPDATE_BULK updateHistoricDecisionInputInstancesByRootProcessInstanceId {rootProcessInstanceId=238a2f55-e200-11ee-9101-a029427b6e76, removalTime=Thu Mar 14 18:14:08 IST 2024}
UPDATE_BULK updateHistoricDecisionOutputInstancesByRootProcessInstanceId {rootProcessInstanceId=238a2f55-e200-11ee-9101-a029427b6e76, removalTime=Thu Mar 14 18:14:08 IST 2024}
]
at org.camunda.bpm.engine.impl.db.EnginePersistenceLogger.flushDbOperationUnexpectedException(EnginePersistenceLogger.java:679) ~[camunda-engine-7.17.0.jar:7.17.0]
… 31 common frames omitted
Caused by: org.apache.ibatis.exceptions.PersistenceException:
Error flushing statements. Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Query processor could not produce a query plan because of the hints defined in this query. Resubmit the query without specifying any hints and without using SET FORCEPLAN.
Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Query processor could not produce a query plan because of the hints defined in this query. Resubmit the query without specifying any hints and without using SET FORCEPLAN.
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30) ~[mybatis-3.5.6.jar:3.5.6]
at org.apache.ibatis.session.defaults.DefaultSqlSession.flushStatements(DefaultSqlSession.java:254) ~[mybatis-3.5.6.jar:3.5.6]
at org.camunda.bpm.engine.impl.db.sql.DbSqlSession.flushBatchOperations(DbSqlSession.java:444) ~[camunda-engine-7.17.0.jar:7.17.0]
at org.camunda.bpm.engine.impl.db.sql.BatchDbSqlSession.executeDbOperations(BatchDbSqlSession.java:74) ~[camunda-engine-7.17.0.jar:7.17.0]
at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.flushDbOperations(DbEntityManager.java:341) ~[camunda-engine-7.17.0.jar:7.17.0]
... 30 common frames omitted
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Query processor could not produce a query plan because of the hints defined in this query. Resubmit the query without specifying any hints and without using SET FORCEPLAN.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:265) ~[mssql-jdbc-10.2.1.jre8.jar:na]
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1676) ~[mssql-jdbc-10.2.1.jre8.jar:na]
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatementBatch(SQLServerPreparedStatement.java:2845) ~[mssql-jdbc-10.2.1.jre8.jar:na]
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtBatchExecCmd.doExecute(SQLServerPreparedStatement.java:2709) ~[mssql-jdbc-10.2.1.jre8.jar:na]
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7730) ~[mssql-jdbc-10.2.1.jre8.jar:na]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:3786) ~[mssql-jdbc-10.2.1.jre8.jar:na]
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:268) ~[mssql-jdbc-10.2.1.jre8.jar:na]
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:242) ~[mssql-jdbc-10.2.1.jre8.jar:na]
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeBatch(SQLServerPreparedStatement.java:2107) ~[mssql-jdbc-10.2.1.jre8.jar:na]
at com.zaxxer.hikari.pool.ProxyStatement.executeBatch(ProxyStatement.java:127) ~[HikariCP-4.0.3.jar:na]
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeBatch(HikariProxyPreparedStatement.java) ~[HikariCP-4.0.3.jar:na]
at org.apache.ibatis.executor.BatchExecutor.doFlushStatements(BatchExecutor.java:123) ~[mybatis-3.5.6.jar:3.5.6]
at org.apache.ibatis.executor.BaseExecutor.flushStatements(BaseExecutor.java:129) ~[mybatis-3.5.6.jar:3.5.6]
at org.apache.ibatis.executor.BaseExecutor.flushStatements(BaseExecutor.java:122) ~[mybatis-3.5.6.jar:3.5.6]
at org.apache.ibatis.executor.CachingExecutor.flushStatements(CachingExecutor.java:114) ~[mybatis-3.5.6.jar:3.5.6]
at org.apache.ibatis.session.defaults.DefaultSqlSession.flushStatements(DefaultSqlSession.java:252) ~[mybatis-3.5.6.jar:3.5.6]
… 33 common frames omitted
2024-03-14 18:14:08.797 WARN 9832 — [ntContainer#0-1] o.s.j.l.DefaultMessageListenerContainer : Execution of JMS message listener failed, and no ErrorHandler has been set.
org.springframework.jms.listener.adapter.ListenerExecutionFailedException: Listener method ‘public void com.xceedance.dwm.listener.XscServiceBusTopicListener.receiveMessage(java.lang.String) throws com.fasterxml.jackson.core.JsonProcessingException’ threw exception; nested exception is org.camunda.bpm.engine.ProcessEngineException: An exception occurred in the persistence layer. Please check the server logs for a detailed message and the entire exception stack trace.
at org.springframework.jms.listener.adapter.MessagingMessageListenerAdapter.invokeHandler(MessagingMessageListenerAdapter.java:122) ~[spring-jms-5.3.20.jar:5.3.20]
at org.springframework.jms.listener.adapter.MessagingMessageListenerAdapter.onMessage(MessagingMessageListenerAdapter.java:77) ~[spring-jms-5.3.20.jar:5.3.20]
at org.springframework.jms.listener.AbstractMessageListenerContainer.doInvokeListener(AbstractMessageListenerContainer.java:736) ~[spring-jms-5.3.20.jar:5.3.20]
at org.springframework.jms.listener.AbstractMessageListenerContainer.invokeListener(AbstractMessageListenerContainer.java:696) ~[spring-jms-5.3.20.jar:5.3.20]
at org.springframework.jms.listener.AbstractMessageListenerContainer.doExecuteListener(AbstractMessageListenerContainer.java:674) ~[spring-jms-5.3.20.jar:5.3.20]
at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.doReceiveAndExecute(AbstractPollingMessageListenerContainer.java:331) [spring-jms-5.3.20.jar:5.3.20]
at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.receiveAndExecute(AbstractPollingMessageListenerContainer.java:270) [spring-jms-5.3.20.jar:5.3.20]
at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.invokeListener(DefaultMessageListenerContainer.java:1237) [spring-jms-5.3.20.jar:5.3.20]
at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.executeOngoingLoop(DefaultMessageListenerContainer.java:1227) [spring-jms-5.3.20.jar:5.3.20]
at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.run(DefaultMessageListenerContainer.java:1120) [spring-jms-5.3.20.jar:5.3.20]
at java.lang.Thread.run(Thread.java:748) [na:1.8.0_202]
Caused by: org.camunda.bpm.engine.ProcessEngineException: An exception occurred in the persistence layer. Please check the server logs for a detailed message and the entire exception stack trace.
at org.camunda.bpm.engine.impl.util.ExceptionUtil.wrapPersistenceException(ExceptionUtil.java:263) ~[camunda-engine-7.17.0.jar:7.17.0]
at org.camunda.bpm.engine.impl.db.EnginePersistenceLogger.flushDbOperationUnexpectedException(EnginePersistenceLogger.java:680) ~[camunda-engine-7.17.0.jar:7.17.0]
at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.flushDbOperations(DbEntityManager.java:344) ~[camunda-engine-7.17.0.jar:7.17.0]
at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.flushDbOperationManager(DbEntityManager.java:323) ~[camunda-engine-7.17.0.jar:7.17.0]
at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.flush(DbEntityManager.java:295) ~[camunda-engine-7.17.0.jar:7.17.0]
at org.camunda.bpm.engine.impl.interceptor.CommandContext.flushSessions(CommandContext.java:272) ~[camunda-engine-7.17.0.jar:7.17.0]
at org.camunda.bpm.engine.impl.interceptor.CommandContext.close(CommandContext.java:188) ~[camunda-engine-7.17.0.jar:7.17.0]
at org.camunda.bpm.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:119) ~[camunda-engine-7.17.0.jar:7.17.0]
at org.camunda.bpm.engine.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:72) ~[camunda-engine-spring-7.17.0.jar:7.17.0]
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140) ~[spring-tx-5.3.20.jar:5.3.20]
at org.camunda.bpm.engine.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:70) ~[camunda-engine-spring-7.17.0.jar:7.17.0]
at org.camunda.bpm.engine.impl.interceptor.ProcessApplicationContextInterceptor.execute(ProcessApplicationContextInterceptor.java:70) ~[camunda-engine-7.17.0.jar:7.17.0]
at org.camunda.bpm.engine.impl.interceptor.CommandCounterInterceptor.execute(CommandCounterInterceptor.java:35) ~[camunda-engine-7.17.0.jar:7.17.0]
at org.camunda.bpm.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33) ~[camunda-engine-7.17.0.jar:7.17.0]
at org.camunda.bpm.engine.impl.RuntimeServiceImpl.messageEventReceived(RuntimeServiceImpl.java:669) ~[camunda-engine-7.17.0.jar:7.17.0]
at com.xceedance.dwm.listener.XscServiceBusTopicListener.receiveMessage(XscServiceBusTopicListener.java:32) ~[classes/:na]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_202]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_202]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_202]
at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_202]
at org.springframework.messaging.handler.invocation.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:169) ~[spring-messaging-5.3.20.jar:5.3.20]
at org.springframework.messaging.handler.invocation.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:119) ~[spring-messaging-5.3.20.jar:5.3.20]
at org.springframework.jms.listener.adapter.MessagingMessageListenerAdapter.invokeHandler(MessagingMessageListenerAdapter.java:114) ~[spring-jms-5.3.20.jar:5.3.20]
… 10 common frames omitted