← Back to team overview

dhis2-devs team mailing list archive

Re: [Bug 1268787] Re: Generating Analytics in Live version

 

Hi Paulo,

this should be fixed now in trunk, 2.14 and 2.13.

regards,

Lars


On Thu, Jan 16, 2014 at 11:25 AM, Paulo Grácio <pgracio@xxxxxxxxxxxxxxxxxxxx
> wrote:

> To fix the problem reported above we need to:
>
> org.hisp.dhis.analytics.table.JdbcAnalyticsTableManager
>
> add at line 274
> String quote = statementBuilder.getColumnQuote();
>
> replace line
> sql.append( column + " = null," );
> with
> sql.append( quote ).append( column ).append( quote ).append( " = null," );
>
> --
> You received this bug notification because you are a bug assignee.
> https://bugs.launchpad.net/bugs/1268787
>
> Title:
>   Generating Analytics in Live version
>
> Status in DHIS 2:
>   Fix Committed
>
> Bug description:
>   DHIS Live 2.13
>
>   * INFO  10:29:50,023 [Level: ERROR, category: DATAMART, time: Fri Dec 13
> 10:29:50 GMT 2013, message: Process failed:
>   er-2])
>   * ERROR 10:29:50,123 Unexpected error occurred in scheduled task.
> (TaskUtils.java [taskScheduler-2])
>   java.lang.RuntimeException: Exception during execution
>           at
> org.hisp.dhis.system.util.ConcurrentUtils.waitForCompletion(ConcurrentUtils.java:55)
>           at
> org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.populateTables(DefaultAnalyticsTableService.ja
>           at
> org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.update(DefaultAnalyticsTableService.java:113)
>           at
> org.hisp.dhis.analytics.scheduling.AnalyticsTableTask.run(AnalyticsTableTask.java:95)
>           at
> org.hisp.dhis.scheduling.ScheduledTasks.run(ScheduledTasks.java:60)
>           at
> org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnabl
>           at
> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439)
>           at
> java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
>           at java.util.concurrent.FutureTask.run(FutureTask.java:138)
>           at
> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecut
>           at
> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java
>           at
> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
>           at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
>           at java.lang.Thread.run(Thread.java:662)
>
>   Regards,
>   Paulo Grácio
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/dhis2/+bug/1268787/+subscriptions
>

-- 
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1268787

Title:
  Generating Analytics in Live version

Status in DHIS 2:
  Fix Committed

Bug description:
  DHIS Live 2.13

  * INFO  10:29:50,023 [Level: ERROR, category: DATAMART, time: Fri Dec 13 10:29:50 GMT 2013, message: Process failed:
  er-2])
  * ERROR 10:29:50,123 Unexpected error occurred in scheduled task. (TaskUtils.java [taskScheduler-2])
  java.lang.RuntimeException: Exception during execution
          at org.hisp.dhis.system.util.ConcurrentUtils.waitForCompletion(ConcurrentUtils.java:55)
          at org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.populateTables(DefaultAnalyticsTableService.ja
          at org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.update(DefaultAnalyticsTableService.java:113)
          at org.hisp.dhis.analytics.scheduling.AnalyticsTableTask.run(AnalyticsTableTask.java:95)
          at org.hisp.dhis.scheduling.ScheduledTasks.run(ScheduledTasks.java:60)
          at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnabl
          at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439)
          at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
          at java.util.concurrent.FutureTask.run(FutureTask.java:138)
          at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecut
          at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java
          at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
          at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
          at java.lang.Thread.run(Thread.java:662)
   
  Regards,
  Paulo Grácio

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1268787/+subscriptions


References