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 _______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
