<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Error accessing PooledConnection. Connection is invalid. in Alfresco Archive</title>
    <link>https://connect.hyland.com/t5/alfresco-archive/error-accessing-pooledconnection-connection-is-invalid/m-p/122543#M86301</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;We were running Activiti quite fine for several months. We are running 5.10 connected to Oracle. Last Thrusday we got first error Error accessing PooledConnection. Connection is invalid. Activiti seems to keep running, but after some time server stopped responding.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;We cheked db, even migrated from Oracle 9 to 11 (which was planned anyway). But today we got this error again.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Does anyone have an idea what can cause this? This time I have Oracle debug turned on, but it will take me some time to get those logs since they have 6GB.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;—————-&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;28.11.2012 12:16:42&amp;nbsp;&amp;nbsp; HTTP JVM: Caused by: &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;28.11.2012 12:16:42&amp;nbsp;&amp;nbsp; HTTP JVM: org.apache.ibatis.exceptions.PersistenceException: &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;28.11.2012 12:16:42&amp;nbsp;&amp;nbsp; HTTP JVM: ### Error querying database.&amp;nbsp; Cause: java.sql.SQLException: Error accessing PooledConnection. Connection is invalid.&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;28.11.2012 12:16:42&amp;nbsp;&amp;nbsp; HTTP JVM: ### The error may exist in org/activiti/db/mapping/entity/VariableInstance.xml&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;28.11.2012 12:16:42&amp;nbsp;&amp;nbsp; HTTP JVM: ### The error may involve org.activiti.engine.impl.persistence.entity.VariableInstanceEntity.selectVariablesByTaskId&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;28.11.2012 12:16:42&amp;nbsp;&amp;nbsp; HTTP JVM: ### The error occurred while executing a query&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;28.11.2012 12:16:42&amp;nbsp;&amp;nbsp; HTTP JVM: ### SQL: select * from ACT_RU_VARIABLE where&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; TASK_ID_ = ?&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;28.11.2012 12:16:42&amp;nbsp;&amp;nbsp; HTTP JVM: ### Cause: java.sql.SQLException: Error accessing PooledConnection. Connection is invalid.&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;28.11.2012 12:16:42&amp;nbsp;&amp;nbsp; HTTP JVM: &amp;nbsp;&amp;nbsp;&amp;nbsp;at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;28.11.2012 12:16:42&amp;nbsp;&amp;nbsp; HTTP JVM: &amp;nbsp;&amp;nbsp;&amp;nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:104)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;28.11.2012 12:16:42&amp;nbsp;&amp;nbsp; HTTP JVM: &amp;nbsp;&amp;nbsp;&amp;nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:95)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;28.11.2012 12:16:42&amp;nbsp;&amp;nbsp; HTTP JVM: &amp;nbsp;&amp;nbsp;&amp;nbsp;at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:216)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;28.11.2012 12:16:42&amp;nbsp;&amp;nbsp; HTTP JVM: &amp;nbsp;&amp;nbsp;&amp;nbsp;at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:200)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;28.11.2012 12:16:42&amp;nbsp;&amp;nbsp; HTTP JVM: &amp;nbsp;&amp;nbsp;&amp;nbsp;at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:181)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;28.11.2012 12:16:42&amp;nbsp;&amp;nbsp; HTTP JVM: &amp;nbsp;&amp;nbsp;&amp;nbsp;at org.activiti.engine.impl.persistence.entity.VariableInstanceManager.findVariableInstancesByTaskId(VariableInstanceManager.java:42)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;28.11.2012 12:16:42&amp;nbsp;&amp;nbsp; HTTP JVM: &amp;nbsp;&amp;nbsp;&amp;nbsp;at org.activiti.engine.impl.persistence.entity.TaskEntity.loadVariableInstances(TaskEntity.java:223)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;28.11.2012 12:16:42&amp;nbsp;&amp;nbsp; HTTP JVM: &amp;nbsp;&amp;nbsp;&amp;nbsp;at org.activiti.engine.impl.persistence.entity.VariableScopeImpl.ensureVariableInstancesInitialized(VariableScopeImpl.java:57)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;28.11.2012 12:16:42&amp;nbsp;&amp;nbsp; HTTP JVM: &amp;nbsp;&amp;nbsp;&amp;nbsp;at org.activiti.engine.impl.persistence.entity.VariableScopeImpl.getVariableLocal(VariableScopeImpl.java:103)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;28.11.2012 12:16:42&amp;nbsp;&amp;nbsp; HTTP JVM: &amp;nbsp;&amp;nbsp;&amp;nbsp;at cz.actis.activiti.history.UserTaskCreateHandlerLN.notify(UserTaskCreateHandlerLN.java:56)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;28.11.2012 12:16:42&amp;nbsp;&amp;nbsp; HTTP JVM: &amp;nbsp;&amp;nbsp;&amp;nbsp;at org.activiti.engine.impl.delegate.TaskListenerInvocation.invoke(TaskListenerInvocation.java:34)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;28.11.2012 12:16:42&amp;nbsp;&amp;nbsp; HTTP JVM: &amp;nbsp;&amp;nbsp;&amp;nbsp;at org.activiti.engine.impl.delegate.DelegateInvocation.proceed(DelegateInvocation.java:37)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;28.11.2012 12:16:42&amp;nbsp;&amp;nbsp; HTTP JVM: &amp;nbsp;&amp;nbsp;&amp;nbsp;at org.activiti.engine.impl.delegate.DefaultDelegateInterceptor.handleInvocation(DefaultDelegateInterceptor.java:25)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;28.11.2012 12:16:42&amp;nbsp;&amp;nbsp; HTTP JVM: &amp;nbsp;&amp;nbsp;&amp;nbsp;at org.activiti.engine.impl.persistence.entity.TaskEntity.fireEvent(TaskEntity.java:515)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;28.11.2012 12:16:42&amp;nbsp;&amp;nbsp; HTTP JVM: &amp;nbsp;&amp;nbsp;&amp;nbsp;… 217 more&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;28.11.2012 12:16:42&amp;nbsp;&amp;nbsp; HTTP JVM: Caused by: &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;28.11.2012 12:16:42&amp;nbsp;&amp;nbsp; HTTP JVM: java.sql.SQLException: Error accessing PooledConnection. Connection is invalid.&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Wed, 28 Nov 2012 11:55:30 GMT</pubDate>
    <dc:creator>mpradny</dc:creator>
    <dc:date>2012-11-28T11:55:30Z</dc:date>
    <item>
      <title>Error accessing PooledConnection. Connection is invalid.</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/error-accessing-pooledconnection-connection-is-invalid/m-p/122543#M86301</link>
      <description>We were running Activiti quite fine for several months. We are running 5.10 connected to Oracle. Last Thrusday we got first error Error accessing PooledConnection. Connection is invalid. Activiti seems to keep running, but after some time server stopped responding.We cheked db, even migrated from Or</description>
      <pubDate>Wed, 28 Nov 2012 11:55:30 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/error-accessing-pooledconnection-connection-is-invalid/m-p/122543#M86301</guid>
      <dc:creator>mpradny</dc:creator>
      <dc:date>2012-11-28T11:55:30Z</dc:date>
    </item>
    <item>
      <title>Re: Error accessing PooledConnection. Connection is invalid.</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/error-accessing-pooledconnection-connection-is-invalid/m-p/122544#M86302</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;I'd search the internet for how to configure connectionpools (in a generic way)&amp;nbsp; correctly&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 28 Nov 2012 15:51:47 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/error-accessing-pooledconnection-connection-is-invalid/m-p/122544#M86302</guid>
      <dc:creator>ronald_van_kuij</dc:creator>
      <dc:date>2012-11-28T15:51:47Z</dc:date>
    </item>
    <item>
      <title>Re: Error accessing PooledConnection. Connection is invalid.</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/error-accessing-pooledconnection-connection-is-invalid/m-p/122545#M86303</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;I tried. Currently we have default Activiti/MyBatis configuration and it worked fine for many months. &lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;I just wondered if anyone had similar issue and was able to reproduce it. We have seen in so far only few times with no luck to reproduce &lt;img id="smileysad" class="emoticon emoticon-smileysad" src="https://connect.hyland.com/i/smilies/16x16_smiley-sad.png" alt="Smiley Sad" title="Smiley Sad" /&gt;.&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 28 Nov 2012 15:56:28 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/error-accessing-pooledconnection-connection-is-invalid/m-p/122545#M86303</guid>
      <dc:creator>mpradny</dc:creator>
      <dc:date>2012-11-28T15:56:28Z</dc:date>
    </item>
    <item>
      <title>Re: Error accessing PooledConnection. Connection is invalid.</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/error-accessing-pooledconnection-connection-is-invalid/m-p/122546#M86304</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Again, search the internet about invalid connections… Has nothing to do with activiti itself, but how you configured your datapool. If I search the internet on this, I get so many relevant answers that I cannot imagine there is not one for you…&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 28 Nov 2012 23:31:30 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/error-accessing-pooledconnection-connection-is-invalid/m-p/122546#M86304</guid>
      <dc:creator>ronald_van_kuij</dc:creator>
      <dc:date>2012-11-28T23:31:30Z</dc:date>
    </item>
  </channel>
</rss>

