Hello Everyone,
We set up a DHIS2 instance getting on 2 weeks now for our program and data entry began in earnest. For some reason, all the analytics from dataset reports to pivot tables are not working.
I have checked previous posts on the launchpad and elsewhere about this error but the most definite recommendation was to save OrgUnit levels, which I have done, but this is still not working.
We can see the data from the forms but not in any reports.
Have run analytics export severally and no errors from the front end even though the logs (below) say otherwise. Have run maintenance severally (even though the option Prune Periods never completes). Generated resource tables as well.
A portion of the logs is posted below:
INFO 2016-06-18 20:51:25,517 Query failed, likely because the requested analytics table does not exist (JdbcAnalyticsManager.java [SimpleAsyncTaskExecutor-487])
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select “dx”,“co”,“monthly”,“uidlevel1”, sum(value) as value from analytics_2016 where “dx” in (‘txAGdhIyCoP’) and “co” in (‘L8BiaJcGlDA’, ‘Nii07uRlq9I’, ‘aajj1DKxqPa’, ‘deVhyY1hfDO’, ‘QLmvl8CxNYs’, ‘UdufjVycW0s’, ‘Kf0uVFPuA8s’, ‘hlgJQWw4vlY’, ‘RSq3AOSIUh1’, ‘pErlxyLqK8G’, ‘ofRCydRthqG’, ‘E0oECMnEhKK’, ‘Lr49tVveh4n’, ‘AmgnnAu4Raw’, ‘hvMYNwgY0fN’, ‘wy5xiY6VZNM’, ‘yKSHLcb0fVY’, ‘M3gaIIkX5Ea’, ‘zq5W69j1A5O’, ‘iBipMNkNvEU’, ‘mQGIahEkqQr’, ‘rVbaaj8FKdA’, ‘iOr97drPOoZ’, ‘WW0OzurqWny’, ‘dAZsyxKTru2’, ‘z4R5rXEPVcN’, ‘GenN3reQduf’, ‘FWDHae3zoIz’, ‘dwPdgJxljWD’, ‘rfVGtr1syCt’, ‘FQ0T8oicM1q’, ‘zeOLrHi1DED’, ‘wZey9PSViRb’, ‘x4aIvEhgnCX’, ‘skAHXkrqvUx’, ‘L6j7K9kmltt’, ‘LVhjAVcUC8z’, ‘XhCoL9nItWA’, ‘O1uKi3kQsGi’, ‘Fmy4z8hQFri’, ‘B6Kdba5mGpB’, ‘Ya8X9slYFDV’, ‘H8HAVyunZwj’, ‘ofCLpSSvqFp’, ‘IXTMAi8ASDP’, ‘C0cgd3RxLRF’, ‘e2o6yW76PzJ’, ‘nddeqMEE0s4’, ‘qn32iuP28aI’, ‘REeTM8YMG5t’, ‘VfrL2mVMKtW’, ‘qU7giGjkkUw’, ‘oysF1o76Qxl’, ‘HPAxapmoBvr’, ‘s9CyZFKA9n7’, ‘A8A8JF9lpue’, ‘qTTDZKszW4O’, ‘ujy6e2O2Y6W’, ‘BRmlLoDHsjT’, ‘e27h0KUYBEK’, ‘okuojwTFZo3’, ‘dQfpHrCSl0J’, ‘xBHYXY7Lfip’, ‘kru3fGkvxka’, ‘GJMevtelfZp’, ‘TrhQf5tFVih’, ‘sbWJ3tN5DuY’, ‘VGt0aLQgbdc’) and “monthly” in (‘201604’) and “uidlevel1” in (‘C983g0J6p9m’) and ( “sASLYFgAkiG” in (‘CW20DvNk041’) ) and ( “LKC6LlcxjzT” in (‘jj2GfLHSgGP’) ) group by “dx”,“co”,“monthly”,“uidlevel1”]; nested exception is org.postgresql.util.PSQLException: ERROR: column “sASLYFgAkiG” does not exist
Position: 1213
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:99)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:416)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:471)
at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:526)
at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getKeyValueMap(JdbcAnalyticsManager.java:395)
at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getAggregatedDataValues(JdbcAnalyticsManager.java:143)
at sun.reflect.GeneratedMethodAccessor538.invoke(Unknown Source)
The PostgreSQL logs are below:
2016-06-19 07:34:55 WAT ERROR: table “analytics_1500” does not exist
2016-06-19 07:34:55 WAT STATEMENT: drop table analytics_1500
2016-06-19 07:34:55 WAT ERROR: table “analytics_1500” does not exist
2016-06-19 07:34:55 WAT STATEMENT: drop table analytics_1500
2016-06-19 07:34:55 WAT ERROR: table “analytics_temp_1500” does not exist
2016-06-19 07:34:55 WAT STATEMENT: drop table analytics_temp_1500
2016-06-19 07:34:55 WAT ERROR: table “analytics_1500” does not exist
2016-06-19 07:34:55 WAT STATEMENT: drop table analytics_1500
2016-06-19 07:34:55 WAT ERROR: table “analytics_1501” does not exist
2016-06-19 07:34:55 WAT STATEMENT: drop table analytics_1501
2016-06-19 07:34:55 WAT ERROR: table “analytics_1501” does not exist
2016-06-19 07:34:55 WAT STATEMENT: drop table analytics_1501
2016-06-19 07:34:55 WAT ERROR: table “analytics_temp_1501” does not exist
2016-06-19 07:34:55 WAT STATEMENT: drop table analytics_temp_1501
2016-06-19 07:34:55 WAT ERROR: table “analytics_1501” does not exist
2016-06-19 07:34:55 WAT STATEMENT: drop table analytics_1501
2016-06-19 07:34:55 WAT ERROR: table “analytics_1502” does not exist
2016-06-19 07:34:55 WAT STATEMENT: drop table analytics_1502
2016-06-19 07:34:55 WAT ERROR: table “analytics_1502” does not exist
2016-06-19 07:34:55 WAT STATEMENT: drop table analytics_1502
2016-06-19 07:34:55 WAT ERROR: table “analytics_temp_1502” does not exist
2016-06-19 07:34:55 WAT STATEMENT: drop table analytics_temp_1502
2016-06-19 07:34:55 WAT ERROR: table “analytics_1502” does not exist
2016-06-19 07:34:55 WAT STATEMENT: drop table analytics_1502
2016-06-19 07:34:55 WAT ERROR: table “analytics_1503” does not exist
2016-06-19 07:34:55 WAT STATEMENT: drop table analytics_1503
2016-06-19 07:34:55 WAT ERROR: table “analytics_1503” does not exist
2016-06-19 07:34:55 WAT STATEMENT: drop table analytics_1503
2016-06-19 07:34:55 WAT ERROR: table “analytics_temp_1503” does not exist
2016-06-19 07:34:55 WAT STATEMENT: drop table analytics_temp_1503
2016-06-19 07:34:55 WAT ERROR: table “analytics_1503” does not exist
2016-06-19 07:34:55 WAT STATEMENT: drop table analytics_1503
2016-06-19 07:34:55 WAT ERROR: table “analytics_1504” does not exist
2016-06-19 07:34:55 WAT STATEMENT: drop table analytics_1504
2016-06-19 07:34:55 WAT ERROR: table “analytics_1504” does not exist
2016-06-19 07:34:55 WAT STATEMENT: drop table analytics_1504
2016-06-19 07:34:55 WAT ERROR: table “analytics_temp_1504” does not exist
2016-06-19 07:34:55 WAT STATEMENT: drop table analytics_temp_1504
2016-06-19 07:34:55 WAT ERROR: table “analytics_1504” does not exist
2016-06-19 07:34:55 WAT STATEMENT: drop table analytics_1504
2016-06-19 07:34:55 WAT ERROR: table “analytics_1505” does not exist
2016-06-19 07:34:55 WAT STATEMENT: drop table analytics_1505
2016-06-19 07:34:55 WAT ERROR: table “analytics_1505” does not exist
2016-06-19 07:34:55 WAT STATEMENT: drop table analytics_1505
2016-06-19 07:34:55 WAT ERROR: table “analytics_temp_1505” does not exist
2016-06-19 07:34:55 WAT STATEMENT: drop table analytics_temp_1505
2016-06-19 07:34:55 WAT ERROR: table “analytics_1505” does not exist
2016-06-19 07:34:55 WAT STATEMENT: drop table analytics_1505
2016-06-19 07:34:55 WAT ERROR: table “analytics_1506” does not exist
2016-06-19 07:34:55 WAT STATEMENT: drop table analytics_1506
2016-06-19 07:34:55 WAT ERROR: table “analytics_1506” does not exist
2016-06-19 07:34:55 WAT STATEMENT: drop table analytics_1506
2016-06-19 07:34:55 WAT ERROR: table “analytics_temp_1506” does not exist
2016-06-19 07:34:55 WAT STATEMENT: drop table analytics_temp_1506
2016-06-19 07:34:55 WAT ERROR: table “analytics_1506” does not exist
2016-06-19 07:34:55 WAT STATEMENT: drop table analytics_1506
2016-06-19 07:34:55 WAT ERROR: table “analytics_1507” does not exist
2016-06-19 07:34:55 WAT STATEMENT: drop table analytics_1507
2016-06-19 07:34:55 WAT ERROR: table “analytics_1507” does not exist
What can we do to resolve this?
Warm Regards,
Ifeanyi
Ifeanyi Okoye MB;BS, M.Inf.Sc
Strategic Information Manager,
US Department of Defense-Walter Reed Program Nigeria
Embassy of the United States of America
Plot 1075 Diplomatic Drive Central Business District, Abuja, Nigeria