I am getting error "An error occurred when trying to get Analytics Report D

I am getting error "An error occurred when trying to get Analytics Report Data" when I am trying to execute Appian defined report "All Tasks for Reassign" from node "Execute Process Report" for user who does not have any active tasks. Do I have to check if user have some active tasks before execution? Any advice?

OriginalPostID-149466

OriginalPostID-149466

  Discussion posts and replies are publicly visible

Parents
  • Caused by: java.sql.SQLException: Connection has been administratively destroyed because the pool got too many consecutive failed connection tests, and failures to obtain replacement connections from the DBMS. Please see the server log entries at that time for more details. Reconnect. java.lang.Exception: It was destroyed at Fri May 15 05:16:18 GMT 2015
    at weblogic.jdbc.common.internal.ConnectionEnv.destroy(ConnectionEnv.java:658)
    at weblogic.jdbc.common.internal.ConnectionEnv.forceDestroy(ConnectionEnv.java:643)
    at weblogic.common.resourcepool.ResourcePoolImpl.forceDestroyResource(ResourcePoolImpl.java:1898)
    at weblogic.common.resourcepool.ResourcePoolImpl.reclaimReservedResources(ResourcePoolImpl.java:1536)
    at weblogic.common.resourcepool.ResourcePoolImpl.disablePool(ResourcePoolImpl.java:1512)
    at weblogic.common.resourcepool.ResourcePoolImpl.processFailCountExceededDisableThreshold(ResourcePoolImpl.java:1827)
    at weblogic.common.resourcepool.ResourcePoolImpl.incrementResetFailCount(ResourcePoolImpl.java:1808)
    at weblogic.common.resourcepool.ResourcePoolImpl.makeResources(ResourcePoolImpl.java:1312)
    at weblogic.common.resourcepool.ResourcePoolImpl.makeResources(ResourcePoolImpl.java:1226)
    at weblogic.common.resourcepool.ResourcePoolImpl.reserveResourceInternal(ResourcePoolImpl.java:450)
    at weblogic.common.resourcepool.ResourcePoolImpl.reserveResource(ResourcePoolImpl.java:342)
    at weblogic.common.resourcepool.ResourcePoolImpl.reserveResource(ResourcePoolImpl.java:329)
    at weblogic.jdbc.common.internal.ConnectionPool.reserve(ConnectionPool.java:467)
    at weblogic.jdbc.common.internal.ConnectionPool.reserve(ConnectionPool.java:409)
    at weblogic.jdbc.common.internal.ConnectionPoolManager.reserve(ConnectionPoolManager.java:132)
    at weblogic.jdbc.common.internal.ConnectionPoolManager.reserve(ConnectionPoolManager.java:82)
    at weblogic.jdbc.jta.DataSource.getXAConnectionFromPool(DataSource.java:1821)
    at weblogic.jdbc.jta.DataSource.refreshXAConnAndEnlist(DataSource.java:1613)
    at weblogic.jdbc.jta.DataSource.getConnectionInternal(DataSource.java:517)
    at weblogic.jdbc.jta.DataSource.getConnection(DataSource.java:494)
    at weblogic.jdbc.common.internal.RmiDataSource.getConnectionInternal(RmiDataSource.java:564)
    at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:545)
    at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:538)
    at org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:92)
    at com.appiancorp.rdbms.hb.LoggingDatasourceConnectionProvider.getConnection(LoggingDatasourceConnectionProvider.java:28)
    at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)
    at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)
    at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:160)
    at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:81)
    at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1473)
    at org.hibernate.ejb.TransactionImpl.begin(TransactionImpl.java:60)
    at org.springframework.orm.jpa.DefaultJpaDialect.beginTransaction(DefaultJpaDialect.java:70)
    at org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:377)
    at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:371)
    at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:127)
    at com.appiancorp.common.config.persistence.ReadWriteConfigurationDaoImpl.getConfig(ReadWriteConfigurationDaoImpl.java:52)
    at com.appiancorp.common.config.persistence.ReadWriteConfigurationDaoIm
Reply
  • Caused by: java.sql.SQLException: Connection has been administratively destroyed because the pool got too many consecutive failed connection tests, and failures to obtain replacement connections from the DBMS. Please see the server log entries at that time for more details. Reconnect. java.lang.Exception: It was destroyed at Fri May 15 05:16:18 GMT 2015
    at weblogic.jdbc.common.internal.ConnectionEnv.destroy(ConnectionEnv.java:658)
    at weblogic.jdbc.common.internal.ConnectionEnv.forceDestroy(ConnectionEnv.java:643)
    at weblogic.common.resourcepool.ResourcePoolImpl.forceDestroyResource(ResourcePoolImpl.java:1898)
    at weblogic.common.resourcepool.ResourcePoolImpl.reclaimReservedResources(ResourcePoolImpl.java:1536)
    at weblogic.common.resourcepool.ResourcePoolImpl.disablePool(ResourcePoolImpl.java:1512)
    at weblogic.common.resourcepool.ResourcePoolImpl.processFailCountExceededDisableThreshold(ResourcePoolImpl.java:1827)
    at weblogic.common.resourcepool.ResourcePoolImpl.incrementResetFailCount(ResourcePoolImpl.java:1808)
    at weblogic.common.resourcepool.ResourcePoolImpl.makeResources(ResourcePoolImpl.java:1312)
    at weblogic.common.resourcepool.ResourcePoolImpl.makeResources(ResourcePoolImpl.java:1226)
    at weblogic.common.resourcepool.ResourcePoolImpl.reserveResourceInternal(ResourcePoolImpl.java:450)
    at weblogic.common.resourcepool.ResourcePoolImpl.reserveResource(ResourcePoolImpl.java:342)
    at weblogic.common.resourcepool.ResourcePoolImpl.reserveResource(ResourcePoolImpl.java:329)
    at weblogic.jdbc.common.internal.ConnectionPool.reserve(ConnectionPool.java:467)
    at weblogic.jdbc.common.internal.ConnectionPool.reserve(ConnectionPool.java:409)
    at weblogic.jdbc.common.internal.ConnectionPoolManager.reserve(ConnectionPoolManager.java:132)
    at weblogic.jdbc.common.internal.ConnectionPoolManager.reserve(ConnectionPoolManager.java:82)
    at weblogic.jdbc.jta.DataSource.getXAConnectionFromPool(DataSource.java:1821)
    at weblogic.jdbc.jta.DataSource.refreshXAConnAndEnlist(DataSource.java:1613)
    at weblogic.jdbc.jta.DataSource.getConnectionInternal(DataSource.java:517)
    at weblogic.jdbc.jta.DataSource.getConnection(DataSource.java:494)
    at weblogic.jdbc.common.internal.RmiDataSource.getConnectionInternal(RmiDataSource.java:564)
    at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:545)
    at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:538)
    at org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:92)
    at com.appiancorp.rdbms.hb.LoggingDatasourceConnectionProvider.getConnection(LoggingDatasourceConnectionProvider.java:28)
    at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)
    at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)
    at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:160)
    at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:81)
    at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1473)
    at org.hibernate.ejb.TransactionImpl.begin(TransactionImpl.java:60)
    at org.springframework.orm.jpa.DefaultJpaDialect.beginTransaction(DefaultJpaDialect.java:70)
    at org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:377)
    at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:371)
    at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:127)
    at com.appiancorp.common.config.persistence.ReadWriteConfigurationDaoImpl.getConfig(ReadWriteConfigurationDaoImpl.java:52)
    at com.appiancorp.common.config.persistence.ReadWriteConfigurationDaoIm
Children
No Data