topic Transaction Synchronization Error with timer boundary events in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/transaction-synchronization-error-with-timer-boundary-events/m-p/196790#M149920 <HTML><HEAD></HEAD><BODY><SPAN>Hi Experts,</SPAN><BR /><SPAN>I created a custom workflow using Eclipse activiti designer. In the workflow we wanted to send some remainder emails based on the due date which is assigned in the task. To send the remainder emails, we have used JAVA delegates.</SPAN><BR /><BR /><SPAN>All are fine in the development environment and in the test environment. When we deploy the same in the QA environment only the remainder emails are not triggering. Configuration wise, the test environment and QA environment are same. </SPAN><BR /><SPAN>When I looked at the alfresco.log file, the following error is logged in the QA environment.</SPAN><BR /><BR /><SPAN>06:07:42,284 ERROR [org.springframework.transaction.support.TransactionSynchronizationUtils] TransactionSynchronization.afterCompletion threw exception</SPAN><BR /><SPAN>java.lang.IllegalStateException: No value for key [org.apache.ibatis.session.defaults.DefaultSqlSessionFactory@6c822e6c] bound to thread [pool-5-thread-3]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.transaction.support.TransactionSynchronizationManager.unbindResource(TransactionSynchronizationManager.java:199)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.mybatis.spring.SqlSessionUtils$SqlSessionSynchronization.suspend(SqlSessionUtils.java:243)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.transaction.support.AbstractPlatformTransactionManager.doSuspendSynchronization(AbstractPlatformTransactionManager.java:666)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.transaction.support.AbstractPlatformTransactionManager.suspend(AbstractPlatformTransactionManager.java:569)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.transaction.support.AbstractPlatformTransactionManager.handleExistingTransaction(AbstractPlatformTransactionManager.java:418)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:347)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:127)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:40)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.jobexecutor.DecrementJobRetriesListener.execute(DecrementJobRetriesListener.java:38)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.spring.SpringTransactionContext$4.afterCompletion(SpringTransactionContext.java:82)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.transaction.support.TransactionSynchronizationUtils.invokeAfterCompletion(TransactionSynchronizationUtils.java:168)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.transaction.support.AbstractPlatformTransactionManager.invokeAfterCompletion(AbstractPlatformTransactionManager.java:996)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.transaction.support.AbstractPlatformTransactionManager.triggerAfterCompletion(AbstractPlatformTransactionManager.java:971)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:874)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:822)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.transaction.support.TransactionTemplate.rollbackOnException(TransactionTemplate.java:161)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:134)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:40)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.jobexecutor.ExecuteJobsRunnable.run(ExecuteJobsRunnable.java:36)</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 /><BR /><PRE class="language-none line-numbers"><CODE><BR /> &lt;boundaryEvent id="boundarytimer4" name="Timer" attachedToRef="sid-A9FA5F1E-66A8-4E7B-A6AF-A8105A56BDD4" cancelActivity="false"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;timerEventDefinition&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;timeDuration&gt;R/PT2H&lt;/timeDuration&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/timerEventDefinition&gt;<BR />&nbsp;&nbsp;&nbsp; &lt;/boundaryEvent&gt;<BR /><BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>The above snippet says, execute the task for every two hours. We have hooked up the java delegate here to send the remainder emails.</SPAN><BR /><BR /><BR /><BR /><SPAN>Can someone throw some lights on this?</SPAN><BR /></BODY></HTML> Thu, 05 Feb 2015 06:44:09 GMT muralidharand 2015-02-05T06:44:09Z Transaction Synchronization Error with timer boundary events https://connect.hyland.com/t5/alfresco-archive/transaction-synchronization-error-with-timer-boundary-events/m-p/196790#M149920 Hi Experts,I created a custom workflow using Eclipse activiti designer. In the workflow we wanted to send some remainder emails based on the due date which is assigned in the task. To send the remainder emails, we have used JAVA delegates.All are fine in the development environment and in the test e Thu, 05 Feb 2015 06:44:09 GMT https://connect.hyland.com/t5/alfresco-archive/transaction-synchronization-error-with-timer-boundary-events/m-p/196790#M149920 muralidharand 2015-02-05T06:44:09Z Re: Transaction Synchronization Error with timer boundary events https://connect.hyland.com/t5/alfresco-archive/transaction-synchronization-error-with-timer-boundary-events/m-p/196791#M149921 <HTML><HEAD></HEAD><BODY><SPAN>How are you sure it's the timer boundary causing this? </SPAN><BR /><BR /><SPAN>I assume this is in Alfresco. Is the delegate executed with the correct user in Alfresco (don't know the exact Alfresco terminology here)?</SPAN></BODY></HTML> Mon, 09 Feb 2015 19:25:08 GMT https://connect.hyland.com/t5/alfresco-archive/transaction-synchronization-error-with-timer-boundary-events/m-p/196791#M149921 jbarrez 2015-02-09T19:25:08Z