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
3650 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
0
abhi.jana
Appian Employee
over 9 years ago
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.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
pavelb
over 9 years ago
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
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
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
0
pavelb
over 9 years ago
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
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
abhi.jana
Appian Employee
over 9 years ago
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.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel