topic {error} exception when ending process in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/error-exception-when-ending-process/m-p/150572#M105427 <HTML><HEAD></HEAD><BODY><SPAN>I keep getting this error all the time. What exactly is going wrong?</SPAN><BR /><BR /><SPAN>I'm using WL datasource with JTA transaction.</SPAN><BR /><BR /><SPAN>WARNING: Exception or error caught in resource</SPAN><BR /><SPAN>org.apache.ibatis.exceptions.PersistenceException: </SPAN><BR /><SPAN>### Error updating database.&nbsp; Cause: java.sql.SQLException: Connection has already been closed.</SPAN><BR /><SPAN>### SQL: insert into ACT_HI_VARINST (ID_, PROC_INST_ID_, EXECUTION_ID_, TASK_ID_, NAME_, REV_, VAR_TYPE_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_)&nbsp;&nbsp;&nbsp;&nbsp; values (&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?&nbsp;&nbsp;&nbsp;&nbsp; )</SPAN><BR /><SPAN>### Cause: java.sql.SQLException: Connection has already been closed.</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:150)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:137)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.engine.impl.db.DbSqlSession.flushInserts(DbSqlSession.java:538)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.engine.impl.db.DbSqlSession.flush(DbSqlSession.java:441)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.engine.impl.interceptor.CommandContext.flushSessions(CommandContext.java:169)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.engine.impl.interceptor.CommandContext.close(CommandContext.java:116)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:70)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:42)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:40)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:31)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.engine.impl.TaskServiceImpl.complete(TaskServiceImpl.java:167)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.rest.api.runtime.task.TaskResource.completeTask(TaskResource.java:131)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.rest.api.runtime.task.TaskResource.executeTaskAction(TaskResource.java:80)</SPAN><BR /><SPAN>…</SPAN><BR /><SPAN>Caused by: java.sql.SQLException: Connection has already been closed.</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at weblogic.jdbc.wrapper.PoolConnection.checkConnection(PoolConnection.java:55)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at weblogic.jdbc.wrapper.Connection.preInvocationHandler(Connection.java:92)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at weblogic.jdbc.wrapper.Connection.prepareStatement(Connection.java:482)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.GeneratedMethodAccessor73.invoke(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.lang.reflect.Method.invoke(Method.java:597)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy$TransactionAwareInvocationHandler.invoke(TransactionAwareDataSourceProxy.java:239)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.sun.proxy.$Proxy73.prepareStatement(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.ibatis.executor.statement.PreparedStatementHandler.instantiateStatement(PreparedStatementHandler.java:72)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.ibatis.executor.statement.BaseStatementHandler.prepare(BaseStatementHandler.java:82)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.ibatis.executor.statement.RoutingStatementHandler.prepare(RoutingStatementHandler.java:54)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:70)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:44)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:100)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:75)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:148)</SPAN><BR /></BODY></HTML> Tue, 24 Sep 2013 15:24:53 GMT schitale 2013-09-24T15:24:53Z {error} exception when ending process https://connect.hyland.com/t5/alfresco-archive/error-exception-when-ending-process/m-p/150572#M105427 I keep getting this error all the time. What exactly is going wrong?I'm using WL datasource with JTA transaction.WARNING: Exception or error caught in resourceorg.apache.ibatis.exceptions.PersistenceException: ### Error updating database.&nbsp; Cause: java.sql.SQLException: Connection has already been cl Tue, 24 Sep 2013 15:24:53 GMT https://connect.hyland.com/t5/alfresco-archive/error-exception-when-ending-process/m-p/150572#M105427 schitale 2013-09-24T15:24:53Z Re: {error} exception when ending process https://connect.hyland.com/t5/alfresco-archive/error-exception-when-ending-process/m-p/150573#M105428 <HTML><HEAD></HEAD><BODY><SPAN>I see this multiple times in the WL log:</SPAN><BR /><BR /><SPAN>&lt;Sep 25, 2013 7:31:23 AM EDT&gt; &lt;Warning&gt; &lt;JDBC&gt; &lt;BEA-001153&gt; &lt;Forcibly releasing inactive connection "weblogic.jdbc.wrapper.PoolConnection_oracle_jdbc_driver_T4CConnection@1afbd9" back into the connection pool "ACTIVITI_DB_POOL", currently reserved by: java.lang.Exception</SPAN><BR /><BR /><BR /></BODY></HTML> Wed, 25 Sep 2013 18:49:40 GMT https://connect.hyland.com/t5/alfresco-archive/error-exception-when-ending-process/m-p/150573#M105428 schitale 2013-09-25T18:49:40Z Re: {error} exception when ending process https://connect.hyland.com/t5/alfresco-archive/error-exception-when-ending-process/m-p/150574#M105429 <HTML><HEAD></HEAD><BODY><SPAN>Without your Activiti config we can't say much about what it wrong</SPAN></BODY></HTML> Mon, 30 Sep 2013 06:19:44 GMT https://connect.hyland.com/t5/alfresco-archive/error-exception-when-ending-process/m-p/150574#M105429 jbarrez 2013-09-30T06:19:44Z