dhis2-devs team mailing list archive
-
dhis2-devs team
-
Mailing list archive
-
Message #27531
[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