← Back to team overview

dhis2-devs team mailing list archive

[Bug 1268787] Re: Generating Analytics in Live version

 

That doesn’t work either. After analyse the source code my conclusions are:
 
Once H2 is casesensitive when using quotes on names and, for this specific problem, column names are quoted 
 
JdbcAnalyticsTableManager 220: String column = quote( PREFIX_ORGUNITLEVEL + level.getLevel() );
Where 
JdbcAnalyticsTableManager 66: public static final String PREFIX_ORGUNITLEVEL = "uidlevel";
 
Comparing postgres tables with h2 tables I just realize that ones are using lower case and others using upper case. 
databaseToUpper
Database setting DATABASE_TO_UPPER (default: true).
Database short names are converted to uppercase for the DATABASE() function, and in the CATALOG column of all database meta data methods. Setting this to "false" is experimental. When set to false, all identifier names (table names, column names) are case sensitive (except aggregate, built-in functions, data types, and keywords).
 
hibernate.connection.url = jdbc:h2:./database/dhis2;AUTO_SERVER=TRUE;DATABASE_TO_UPPER=false
 
Adding this to the connection String is not working having an error during server startup.
 
Any recommendation… ?! 
 
Regards,
Paulo Grácio

-- 
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:
  New

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