topic Problem Setup AsyncExecutor with Spring on Oracle in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/problem-setup-asyncexecutor-with-spring-on-oracle/m-p/198263#M151393 <HTML><HEAD></HEAD><BODY><SPAN>Hi there,</SPAN><BR /><BR /><SPAN>currently i have a problem setting up activiti with asyncexecutor like described in user guide. it can not fetch the transaction.</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />2015-08-06 13:50:06,972 INFO&nbsp; org.activiti.engine.impl.ProcessEngineImpl [http-nio-8080-exec-5] ProcessEngine default created <BR />2015-08-06 13:50:06,974 INFO&nbsp; org.activiti.engine.impl.asyncexecutor.DefaultAsyncJobExecutor [http-nio-8080-exec-5] Starting up the default async job executor [org.activiti.engine.impl.asyncexecutor.DefaultAsyncJobExecutor]. <BR />2015-08-06 13:50:06,975 INFO&nbsp; org.activiti.engine.impl.asyncexecutor.DefaultAsyncJobExecutor [http-nio-8080-exec-5] Creating thread pool queue of size 100 <BR />2015-08-06 13:50:06,975 INFO&nbsp; org.activiti.engine.impl.asyncexecutor.DefaultAsyncJobExecutor [http-nio-8080-exec-5] Creating executor service with corePoolSize 2, maxPoolSize 10 and keepAliveTime 5000 <BR />2015-08-06 13:50:06,976 INFO&nbsp; org.activiti.engine.impl.asyncexecutor.AcquireTimerJobsRunnable [Thread-12] {} starting to acquire async jobs due <BR />2015-08-06 13:50:06,976 INFO&nbsp; org.activiti.engine.impl.asyncexecutor.AcquireAsyncJobsDueRunnable [Thread-13] {} starting to acquire async jobs due <BR />2015-08-06 13:50:06,977 ERROR&nbsp; org.activiti.engine.impl.asyncexecutor.AcquireAsyncJobsDueRunnable [Thread-13] exception during async job acquisition: Could not open JDBC Connection for transaction; nested exception is java.lang.NullPointerException org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.lang.NullPointerException<BR />&nbsp;&nbsp;&nbsp;at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:243)<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>the config is</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />&lt;bean id="processEngineConfiguration" class="org.activiti.spring.SpringProcessEngineConfiguration"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="dataSource" ref="dataSource"/&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="transactionManager" ref="transactionManager"/&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="jobExecutorActivate" value="false"/&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="asyncExecutorEnabled" value="true"/&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="asyncExecutorActivate" value="true"/&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="deploymentResources" value="pathtoresourses"/&gt;<BR />&nbsp;&nbsp;&nbsp;&lt;/bean&gt;<BR /><BR />&nbsp;&nbsp;&nbsp;&lt;bean id="processEngine" class="org.activiti.spring.ProcessEngineFactoryBean"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="processEngineConfiguration" ref="processEngineConfiguration"/&gt;<BR />&nbsp;&nbsp;&nbsp;&lt;/bean&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>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>Maybe someone can help if there is a problem with the setup.</SPAN></BODY></HTML> Thu, 06 Aug 2015 11:59:33 GMT gehen 2015-08-06T11:59:33Z Problem Setup AsyncExecutor with Spring on Oracle https://connect.hyland.com/t5/alfresco-archive/problem-setup-asyncexecutor-with-spring-on-oracle/m-p/198263#M151393 Hi there,currently i have a problem setting up activiti with asyncexecutor like described in user guide. it can not fetch the transaction.2015-08-06 13:50:06,972 INFO&nbsp; org.activiti.engine.impl.ProcessEngineImpl [http-nio-8080-exec-5] ProcessEngine default created 2015-08-06 13:50:06,974 INFO&nbsp; org.ac Thu, 06 Aug 2015 11:59:33 GMT https://connect.hyland.com/t5/alfresco-archive/problem-setup-asyncexecutor-with-spring-on-oracle/m-p/198263#M151393 gehen 2015-08-06T11:59:33Z Re: Problem Setup AsyncExecutor with Spring on Oracle https://connect.hyland.com/t5/alfresco-archive/problem-setup-asyncexecutor-with-spring-on-oracle/m-p/198264#M151394 <HTML><HEAD></HEAD><BODY><SPAN>just dove more into it. we have a setup for datasource with more than one tenant. this is resolved via threadlocal but seems like not populated when in asyncExecutor spans new threads. is there a way to hook into?</SPAN></BODY></HTML> Thu, 06 Aug 2015 13:07:03 GMT https://connect.hyland.com/t5/alfresco-archive/problem-setup-asyncexecutor-with-spring-on-oracle/m-p/198264#M151394 gehen 2015-08-06T13:07:03Z