dhis2-users team mailing list archive

[Alex Tumwesigye <atumwesigye@xxxxxxxxx>]

Check your database connection.
The web application may be failing to connecy to db.

Alex

On Tuesday, March 20, 2018, Barnabas Akumba <akumbabarns@xxxxxxxxx> 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 "