Re: [Dhis2-devs] [Bug 1268787] Re: Generating Analytics in Live version

2014-01-17 Thread Lars Helge Øverland
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 pgra...@criticalsoftware.com wrote: To fix the problem reported above we need to: org.hisp.dhis.analytics.table.JdbcAnalyticsTableManager add at line 274 String

[Dhis2-devs] [Bug 1268787] Re: Generating Analytics in Live version

2014-01-16 Thread Paulo Grácio
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, );

Re: [Dhis2-devs] [Bug 1268787] Re: Generating Analytics in Live version

2014-01-15 Thread Lars Helge Øverland
This should be fixed now in trunk, 2.14 and 2.13. Please test. On Tue, Jan 14, 2014 at 12:58 AM, Paulo Grácio pgra...@criticalsoftware.com wrote: Hi Busoye, We are not using the default OU Levels, please see the attachment. Regards, Paulo Grácio -- You received this bug notification

[Dhis2-devs] [Bug 1268787] Re: Generating Analytics in Live version

2014-01-15 Thread Lars Helge Øverland
** Changed in: dhis2 Status: New = Fix Committed ** Changed in: dhis2 Importance: Undecided = High ** Changed in: dhis2 Assignee: (unassigned) = Lars Helge Øverland (larshelge) ** Changed in: dhis2 Milestone: None = 2.14 -- You received this bug notification because you are

[Dhis2-devs] [Bug 1268787] Re: Generating Analytics in Live version

2014-01-15 Thread Paulo Grácio
Hi Lars, we are still getting this error on the log: * INFO 00:58:01,539 [Level: ERROR, category: DATAMART, time: Thu Jan 16 00:58:01 GMT 2014, message: Process failed: Exception during execution] (InMemoryNotifier.java [taskSchedul er-3]) * ERROR 00:58:01,610 Unexpected error occurred in

[Dhis2-devs] [Bug 1268787] Re: Generating Analytics in Live version

2014-01-13 Thread Paulo Grácio
On 17 Dec 2013, at 17:01, Paulo Grácio pgra...@criticalsoftware.com wrote: Hi, It looks like the problem is related with quoted names http://h2database.com/html/grammar.html#quoted_name Please see attached imaged, any idea of how to work around this problem? Regards, Paulo Grácio -- You

[Dhis2-devs] [Bug 1268787] Re: Generating Analytics in Live version

2014-01-13 Thread Paulo Grácio
On Fri, Dec 13, 2013 at 3:21 PM, Paulo Grácio pgra...@criticalsoftware.com wrote: Hi all, Any idea of what might be causing this problem? Caused by: org.h2.jdbc.JdbcSQLException: Column OUS.uidlevel1 not found; SQL statement: Regards, Paulo Grácio -- You received this bug notification

[Dhis2-devs] [Bug 1268787] Re: Generating Analytics in Live version

2014-01-13 Thread Paulo Grácio
From: Adebusoye Anifalaje [mailto:bus...@hisp.org] Sent: terça-feira, 17 de Dezembro de 2013 18:37 To: Paulo Grácio Cc: DHIS 2 developers Subject: Re: [Dhis2-devs] Generating Analytics in Live version Try saving the levels as they are and then run analytics again. See what happens. If that

[Dhis2-devs] [Bug 1268787] Re: Generating Analytics in Live version

2014-01-13 Thread Paulo Grácio
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

[Dhis2-devs] [Bug 1268787] Re: Generating Analytics in Live version

2014-01-13 Thread Paulo Grácio
From: Adebusoye Anifalaje [mailto:bus...@hisp.org] Sent: terça-feira, 17 de Dezembro de 2013 17:19 To: Paulo Grácio Cc: DHIS 2 developers Subject: Re: [Dhis2-devs] Generating Analytics in Live version Importance: High Hi Paulo, There have been a number of people with this problem. What you

[Dhis2-devs] [Bug 1268787] Re: Generating Analytics in Live version

2014-01-13 Thread Paulo Grácio
Hi Busoye, We are not using the default OU Levels, please see the attachment. 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