Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
5 replies
Subscribers
6 subscribers
Views
3653 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Process
I am getting error "An error occurred when trying to get Analytics Report D
pavelb
over 9 years ago
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
0
pavelb
over 9 years ago
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
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
pavelb
over 9 years ago
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
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data