Creating charts, maps and tables in dhis2-live 2.14

Support - Assistance technique
1

Dear all,

I have imported some data into a 2.14 dhis2-live and run the analytics process.

Version:
2.14
Build revision:
13752
Build date:
2014-01-31 16:41

It has gone well, and I´ve checked with an SQL view that the analytics table and its values are there. However when I when I try to create a chart, table or map, I get the “Values not found” message.

Having a look at the log (complete log attached)

* INFO 17:45:29,251 Query failed, likely because the requested analytics table does not exist (JdbcAnalyticsManager.java [SimpleAsyncTaskExecutor-6])

org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select “uidlevel4”,“de”, sum(value) as value from analytics_2011 where “uidlevel4” in (‘zXcr52pysDR’, ‘dOfLwJp4HCR’, ‘ZZ2j0yKuZu8’, ‘xTki3rdk7cd’, ‘Y5pHHOo6Omn’) and “de” in (‘gUvSpUrTCCH’) and (“yearly” in (‘2011’)) group by “uidlevel4”,“de”]; nested exception is org.h2.jdbc.JdbcSQLException: Column “de” not found; SQL statement:

select “uidlevel4”,“de”, sum(value) as value from analytics_2011 where “uidlevel4” in (‘u4Idnn89LtY’, ‘XGPQ2WduCfW’, ‘S4cPuE2d3dv’, ‘OCtV1PUshto’, ‘pBihSffHkhT’) and “de” in (‘gUvSpUrTCCH’) and (“yearly” in (‘2011’)) group by “uidlevel4”,“de” [42122-173]

It seems like the query fails because “de” does not exist… However in the DB I see column a column DE and H2 is not supposed to be case sensitive.

I found that it may be acting like this because of the double quote https://groups.google.com/forum/#!topic/h2-database/UXI2Mz5HM3s

, tried an SQL view without the quotes and worked so…

In case this is the problem… is there any way it can be solved?

thanks!!

dhis.log (95.5 KB)

2

Hi Marta,

thanks for reporting. Your investigation is correct - there was again an issue with column encoding on H2. It should be fixed now in trunk and 2.14. Can you please try again by

Let us know how it works.

Lars

···

On Mon, Feb 3, 2014 at 6:15 PM, Marta Vila martavila@gmail.com wrote:

Dear all,

I have imported some data into a 2.14 dhis2-live and run the analytics process.

Version:
2.14
Build revision:
13752
Build date:
2014-01-31 16:41

It has gone well, and I´ve checked with an SQL view that the analytics table and its values are there. However when I when I try to create a chart, table or map, I get the “Values not found” message.

Having a look at the log (complete log attached)

* INFO 17:45:29,251 Query failed, likely because the requested analytics table does not exist (JdbcAnalyticsManager.java [SimpleAsyncTaskExecutor-6])

org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select “uidlevel4”,“de”, sum(value) as value from analytics_2011 where “uidlevel4” in (‘zXcr52pysDR’, ‘dOfLwJp4HCR’, ‘ZZ2j0yKuZu8’, ‘xTki3rdk7cd’, ‘Y5pHHOo6Omn’) and “de” in (‘gUvSpUrTCCH’) and (“yearly” in (‘2011’)) group by “uidlevel4”,“de”]; nested exception is org.h2.jdbc.JdbcSQLException: Column “de” not found; SQL statement:

select “uidlevel4”,“de”, sum(value) as value from analytics_2011 where “uidlevel4” in (‘u4Idnn89LtY’, ‘XGPQ2WduCfW’, ‘S4cPuE2d3dv’, ‘OCtV1PUshto’, ‘pBihSffHkhT’) and “de” in (‘gUvSpUrTCCH’) and (“yearly” in (‘2011’)) group by “uidlevel4”,“de” [42122-173]

It seems like the query fails because “de” does not exist… However in the DB I see column a column DE and H2 is not supposed to be case sensitive.

I found that it may be acting like this because of the double quote https://groups.google.com/forum/#!topic/h2-database/UXI2Mz5HM3s

, tried an SQL view without the quotes and worked so…

In case this is the problem… is there any way it can be solved?

thanks!!

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

3

Hi Lars, all,

sorry for the late response. I downloaded the war file today, it is fixed now.

I´ve been able to run analytics and visualize charts and maps using the live version.

Version:
2.14
Build revision:
13805
Build date:
2014-03-04 02:06

Thank you !!

···

On 18 February 2014 10:43, Lars Helge Øverland larshelge@gmail.com wrote:

Hi Marta,

thanks for reporting. Your investigation is correct - there was again an issue with column encoding on H2. It should be fixed now in trunk and 2.14. Can you please try again by

  • re-run analytics

Let us know how it works.

Lars

On Mon, Feb 3, 2014 at 6:15 PM, Marta Vila martavila@gmail.com wrote:

Dear all,

I have imported some data into a 2.14 dhis2-live and run the analytics process.

Version:
2.14
Build revision:
13752
Build date:
2014-01-31 16:41

It has gone well, and I´ve checked with an SQL view that the analytics table and its values are there. However when I when I try to create a chart, table or map, I get the “Values not found” message.

Having a look at the log (complete log attached)

* INFO 17:45:29,251 Query failed, likely because the requested analytics table does not exist (JdbcAnalyticsManager.java [SimpleAsyncTaskExecutor-6])

org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select “uidlevel4”,“de”, sum(value) as value from analytics_2011 where “uidlevel4” in (‘zXcr52pysDR’, ‘dOfLwJp4HCR’, ‘ZZ2j0yKuZu8’, ‘xTki3rdk7cd’, ‘Y5pHHOo6Omn’) and “de” in (‘gUvSpUrTCCH’) and (“yearly” in (‘2011’)) group by “uidlevel4”,“de”]; nested exception is org.h2.jdbc.JdbcSQLException: Column “de” not found; SQL statement:

select “uidlevel4”,“de”, sum(value) as value from analytics_2011 where “uidlevel4” in (‘u4Idnn89LtY’, ‘XGPQ2WduCfW’, ‘S4cPuE2d3dv’, ‘OCtV1PUshto’, ‘pBihSffHkhT’) and “de” in (‘gUvSpUrTCCH’) and (“yearly” in (‘2011’)) group by “uidlevel4”,“de” [42122-173]

It seems like the query fails because “de” does not exist… However in the DB I see column a column DE and H2 is not supposed to be case sensitive.

I found that it may be acting like this because of the double quote https://groups.google.com/forum/#!topic/h2-database/UXI2Mz5HM3s

, tried an SQL view without the quotes and worked so…

In case this is the problem… is there any way it can be solved?

thanks!!

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

4

Great…

···

On 18 February 2014 10:43, Lars Helge Øverland larshelge@gmail.com wrote:

Hi Marta,

thanks for reporting. Your investigation is correct - there was again an issue with column encoding on H2. It should be fixed now in trunk and 2.14. Can you please try again by

  • re-run analytics

Let us know how it works.

Lars

On Mon, Feb 3, 2014 at 6:15 PM, Marta Vila martavila@gmail.com wrote:

Dear all,

I have imported some data into a 2.14 dhis2-live and run the analytics process.

Version:
2.14
Build revision:
13752
Build date:
2014-01-31 16:41

It has gone well, and I´ve checked with an SQL view that the analytics table and its values are there. However when I when I try to create a chart, table or map, I get the “Values not found” message.

Having a look at the log (complete log attached)

* INFO 17:45:29,251 Query failed, likely because the requested analytics table does not exist (JdbcAnalyticsManager.java [SimpleAsyncTaskExecutor-6])

org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select “uidlevel4”,“de”, sum(value) as value from analytics_2011 where “uidlevel4” in (‘zXcr52pysDR’, ‘dOfLwJp4HCR’, ‘ZZ2j0yKuZu8’, ‘xTki3rdk7cd’, ‘Y5pHHOo6Omn’) and “de” in (‘gUvSpUrTCCH’) and (“yearly” in (‘2011’)) group by “uidlevel4”,“de”]; nested exception is org.h2.jdbc.JdbcSQLException: Column “de” not found; SQL statement:

select “uidlevel4”,“de”, sum(value) as value from analytics_2011 where “uidlevel4” in (‘u4Idnn89LtY’, ‘XGPQ2WduCfW’, ‘S4cPuE2d3dv’, ‘OCtV1PUshto’, ‘pBihSffHkhT’) and “de” in (‘gUvSpUrTCCH’) and (“yearly” in (‘2011’)) group by “uidlevel4”,“de” [42122-173]

It seems like the query fails because “de” does not exist… However in the DB I see column a column DE and H2 is not supposed to be case sensitive.

I found that it may be acting like this because of the double quote https://groups.google.com/forum/#!topic/h2-database/UXI2Mz5HM3s

, tried an SQL view without the quotes and worked so…

In case this is the problem… is there any way it can be solved?

thanks!!

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp