Check your database connection. The web application may be failing to connecy to db.
Alex On Tuesday, March 20, 2018, Barnabas Akumba <akumbaba...@gmail.com> wrote: > Hello All, > > I've been receiving an Analytics Failure message on my DHIS2 Instance > (version 2.27) for some days now. > I've been looking through the Error message to try and figure out what the > issue could be but can't pin-point it. > Any one with a solution to this problem? > See Error message below: > > Time: 2018-03-20T01:32:49.598Z > Message: Exception during execution > > Cause: java.util.concurrent.ExecutionException: org.springframework. > transaction.CannotCreateTransactionException: Could not open Hibernate > Session for transaction; nested exception is org.hibernate.exception. > GenericJDBCException: Unable to acquire JDBC Connection > at java.util.concurrent.FutureTask.report(FutureTask.java:122) > at java.util.concurrent.FutureTask.get(FutureTask.java:192) > at org.hisp.dhis.commons.util.ConcurrentUtils.waitForCompletion( > ConcurrentUtils.java:53) > at org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.p > opulateTables(DefaultAnalyticsTableService.java:210) > at org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.update( > DefaultAnalyticsTableService.java:132) > at org.hisp.dhis.analytics.table.DefaultAnalyticsTableGenerator > .generateTables(DefaultAnalyticsTableGenerator.java:112) > at org.hisp.dhis.analytics.table.scheduling.AnalyticsTableTask. > call(AnalyticsTableTask.java:68) > at org.hisp.dhis.security.NoSecurityContextRunnable.run(NoSecur > ityContextRunnable.java:47) > at org.hisp.dhis.scheduling.ScheduledTasks.run(ScheduledTasks.java:60) > at org.springframework.scheduling.support.DelegatingErrorHandlingRunnabl > e.run(DelegatingErrorHandlingRunnable.java:54) > at org.springframework.scheduling.concurrent.ReschedulingRunnable.run( > ReschedulingRunnable.java:81) > at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) > at java.util.concurrent.FutureTask.run(FutureTask.java:266) > at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFu > tureTask.access$201(ScheduledThreadPoolExecutor.java:180) > at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFu > tureTask.run(ScheduledThreadPoolExecutor.java:293) > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPool > Executor.java:1142) > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoo > lExecutor.java:617) > at java.lang.Thread.run(Thread.java:748) > Caused by: org.springframework.transaction.CannotCreateTransactionException: > Could not open Hibernate Session for transaction; nested exception is > org.hibernate.exception.GenericJDBCException: Unable to acquire JDBC > Connection > at org.springframework.orm.hibernate5.HibernateTransactionManager.doBegin( > HibernateTransactionManager.java:542) > at org.springframework.transaction.support.AbstractPlatformTransactionMan > ager.getTransaction(AbstractPlatformTransactionManager.java:373) > at org.springframework.transaction.interceptor.TransactionAspectSupport. > createTransactionIfNecessary(TransactionAspectSupport.java:447) > at org.springframework.transaction.interceptor.TransactionAspectSupport. > invokeWithinTransaction(TransactionAspectSupport.java:277) > at org.springframework.transaction.interceptor.TransactionInter > ceptor.invoke(TransactionInterceptor.java:96) > at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed( > ReflectiveMethodInvocation.java:179) > at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke( > ExposeInvocationInterceptor.java:92) > at org.springframework.aop. > -- Alex Tumwesigye Kampala Uganda +256 774149 775, + 256 759 800161 Skype ID: talexie IT Consultant (Servers, Networks and Security, Health Information Systems - DHIS2, Disease Outbreak & Surveillance Systems) & Solar Consultant "I don't want to be anything other than what I have been - one tree hill "
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
