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

  • Check the application-server.log for more details on the issue. You should be able to find a related stacktrace and/or a corresponding "Caused By" section in the stacktrace which should be helpful in identifying the root cause.
  • I can see this exception in log file...

    2015-05-19 14:05:46,607 [Appian Work Item - 6634 - ProcessExec00 : UnattendedJavaActivityRequest] ERROR com.appiancorp.util.BundleUtils - java.util.MissingResourceException: Can't find bundle for base name text.java.com.appiancorp.process.runtime.activities.GetReportDataActivity601, locale en_US
    java.util.MissingResourceException: Can't find bundle for base name text.java.com.appiancorp.process.runtime.activities.GetReportDataActivity601, locale en_US
    at java.util.ResourceBundle.throwMissingResourceException(ResourceBundle.java:1499)
    at java.util.ResourceBundle.getBundleImpl(ResourceBundle.java:1322)
    at java.util.ResourceBundle.getBundle(ResourceBundle.java:1246)
    at com.appiancorp.util.BundleUtils.getBundle(BundleUtils.java:95)
    at com.appiancorp.util.BundleUtils.getBundle(BundleUtils.java:78)
    at com.appiancorp.util.BundleUtils.getText(BundleUtils.java:36)
    at com.appiancorp.process.runtime.activities.GetReportDataActivity601.execute(GetReportDataActivity601.java:127)
    at com.appiancorp.suiteapi.process.framework.AbstractActivity.perform(AbstractActivity.java:104)
    at com.appiancorp.process.runtime.framework.LegacyActivityExecutor$2.call(LegacyActivityExecutor.java:88)
    at com.appiancorp.process.runtime.framework.LegacyActivityExecutor$2.call(LegacyActivityExecutor.java:85)
    at com.appiancorp.common.ContextClassLoaderSwitcher.runInContext(ContextClassLoaderSwitcher.java:21)
    at com.appiancorp.process.runtime.framework.LegacyActivityExecutor.execute(LegacyActivityExecutor.java:85)
    at com.appiancorp.process.engine.UnattendedJavaActivityRequest.execute(UnattendedJavaActivityRequest.java:83)
    at com.appiancorp.process.engine.UnattendedJavaActivityRequest.execute0(UnattendedJavaActivityRequest.java:55)
    at com.appiancorp.process.engine.ContinuationRequest.execute(ContinuationRequest.java:80)
    at com.appiancorp.mdb.UnattendedRequestHandlerBean.onMessage(UnattendedRequestHandlerBean.java:26)
    at com.appiancorp.mdb.UnattendedRequestHandlerBean_f43arq_MDOImpl.__WL_invoke(Unknown Source)
    at weblogic.ejb.container.internal.MDOMethodInvoker.invoke(MDOMethodInvoker.java:36)
    at com.appiancorp.mdb.UnattendedRequestHandlerBean_f43arq_MDOImpl.onMessage(Unknown Source)
    at com.appiancorp.ra.workpoller.WorkItem.run(WorkItem.java:54)
    at weblogic.connector.security.layer.WorkImpl.runIt(WorkImpl.java:70)
    at weblogic.connector.security.layer.WorkImpl.run(WorkImpl.java:45)
    at weblogic.connector.work.WorkRequest.run(WorkRequest.java:123)
    at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:550)
    at weblogic.work.ExecuteThread.execute(ExecuteThread.java:295)
    at weblogic.work.ExecuteThread.run(ExecuteThread.java:254)
    2015-05-19 14:05:46,608 [Appian Work Item - 6634 - ProcessExec00 : UnattendedJavaActivityRequest] ERROR com.appiancorp.util.BundleUtils - java.util.MissingResourceException: Can't find bundle for base name text.java.com.appiancorp.process.runtime.activities.GetReportDataActivity601, locale en_US
    java.util.MissingResourceException: Can't find bundle for base name text.java.com.appiancorp.process.runtime.activities.GetReportDataActivity601, locale en_US
    at java.util.ResourceBundle.throwMissingResourceException(ResourceBundle.java:1499)
    at java.util.ResourceBundle.getBundleImpl(ResourceBundle.java:1322)
    at java.util.ResourceBundle.getBundle(ResourceBundle.java:1246)
    at com.appiancorp.util.BundleUtils.getBundle(BundleUtils.java:95)
    at com.appiancorp.util.BundleUtils.getBundle(BundleUtils.java:81)
    at com.appiancorp.util.BundleUtils.getText(BundleUtils.java:36)
    at com.appiancorp.process.runtime.activities.GetReportDataActivity601.execute(GetReportDataActivity601.java:127)
    at com.appiancorp.suiteapi.process.frame
  • 2015-05-19 14:07:16,239 [Appian ReschedulingTimerTask - SearchIndexSyncTimerTask - 78550] ERROR com.appiancorp.rdbms.common.search.SearchIndexSyncTimerTask - [Search index sync: jdbc/AppianPrimaryDS] 37725 consecutive errors. Will try again in 10000 ms.
    org.hibernate.TransactionException: JDBC begin failed:
    at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:92)
    at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1473)
    at sun.reflect.GeneratedMethodAccessor521.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)
    at org.hibernate.context.ThreadLocalSessionContext$TransactionProtectionWrapper.invoke(ThreadLocalSessionContext.java:345)
    at com.sun.proxy.$Proxy146.beginTransaction(Unknown Source)
    at com.appiancorp.rdbms.hb.search.SearchIndexSynchronizerHbImpl.sync(SearchIndexSynchronizerHbImpl.java:177)
    at com.appiancorp.rdbms.hb.search.SearchIndexSynchronizerHbImpl.sync(SearchIndexSynchronizerHbImpl.java:126)
    at com.appiancorp.rdbms.common.search.SearchIndexSyncTimerTask.execute(SearchIndexSyncTimerTask.java:109)
    at com.appiancorp.common.ReschedulingTimerTask.run(ReschedulingTimerTask.java:110)
    at java.util.TimerThread.mainLoop(Timer.java:555)
    at java.util.TimerThread.run(Timer.java:505)
    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.RmiDataSou
  • 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
  • This seems to indicate that the weblogic server is unable to connect to the database due to failed login attempts. You may need to verify the connectivity/authentication to the database server from weblogic first and then restart weblogic to attempt to reestablish the connection.