← Back to team overview

dhis2-users team mailing list archive

Analytics Not Working - Help Needed

 

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 exist2016-06-19 07:34:55 WAT STATEMENT:  drop table analytics_15002016-06-19 07:34:55 WAT ERROR:  table "analytics_1500" does not exist2016-06-19 07:34:55 WAT STATEMENT:  drop table analytics_15002016-06-19 07:34:55 WAT ERROR:  table "analytics_temp_1500" does not exist2016-06-19 07:34:55 WAT STATEMENT:  drop table analytics_temp_15002016-06-19 07:34:55 WAT ERROR:  table "analytics_1500" does not exist2016-06-19 07:34:55 WAT STATEMENT:  drop table analytics_15002016-06-19 07:34:55 WAT ERROR:  table "analytics_1501" does not exist2016-06-19 07:34:55 WAT STATEMENT:  drop table analytics_15012016-06-19 07:34:55 WAT ERROR:  table "analytics_1501" does not exist2016-06-19 07:34:55 WAT STATEMENT:  drop table analytics_15012016-06-19 07:34:55 WAT ERROR:  table "analytics_temp_1501" does not exist2016-06-19 07:34:55 WAT STATEMENT:  drop table analytics_temp_15012016-06-19 07:34:55 WAT ERROR:  table "analytics_1501" does not exist2016-06-19 07:34:55 WAT STATEMENT:  drop table analytics_15012016-06-19 07:34:55 WAT ERROR:  table "analytics_1502" does not exist2016-06-19 07:34:55 WAT STATEMENT:  drop table analytics_15022016-06-19 07:34:55 WAT ERROR:  table "analytics_1502" does not exist2016-06-19 07:34:55 WAT STATEMENT:  drop table analytics_15022016-06-19 07:34:55 WAT ERROR:  table "analytics_temp_1502" does not exist2016-06-19 07:34:55 WAT STATEMENT:  drop table analytics_temp_15022016-06-19 07:34:55 WAT ERROR:  table "analytics_1502" does not exist2016-06-19 07:34:55 WAT STATEMENT:  drop table analytics_15022016-06-19 07:34:55 WAT ERROR:  table "analytics_1503" does not exist2016-06-19 07:34:55 WAT STATEMENT:  drop table analytics_15032016-06-19 07:34:55 WAT ERROR:  table "analytics_1503" does not exist2016-06-19 07:34:55 WAT STATEMENT:  drop table analytics_15032016-06-19 07:34:55 WAT ERROR:  table "analytics_temp_1503" does not exist2016-06-19 07:34:55 WAT STATEMENT:  drop table analytics_temp_15032016-06-19 07:34:55 WAT ERROR:  table "analytics_1503" does not exist2016-06-19 07:34:55 WAT STATEMENT:  drop table analytics_15032016-06-19 07:34:55 WAT ERROR:  table "analytics_1504" does not exist2016-06-19 07:34:55 WAT STATEMENT:  drop table analytics_15042016-06-19 07:34:55 WAT ERROR:  table "analytics_1504" does not exist2016-06-19 07:34:55 WAT STATEMENT:  drop table analytics_15042016-06-19 07:34:55 WAT ERROR:  table "analytics_temp_1504" does not exist2016-06-19 07:34:55 WAT STATEMENT:  drop table analytics_temp_15042016-06-19 07:34:55 WAT ERROR:  table "analytics_1504" does not exist2016-06-19 07:34:55 WAT STATEMENT:  drop table analytics_15042016-06-19 07:34:55 WAT ERROR:  table "analytics_1505" does not exist2016-06-19 07:34:55 WAT STATEMENT:  drop table analytics_15052016-06-19 07:34:55 WAT ERROR:  table "analytics_1505" does not exist2016-06-19 07:34:55 WAT STATEMENT:  drop table analytics_15052016-06-19 07:34:55 WAT ERROR:  table "analytics_temp_1505" does not exist2016-06-19 07:34:55 WAT STATEMENT:  drop table analytics_temp_15052016-06-19 07:34:55 WAT ERROR:  table "analytics_1505" does not exist2016-06-19 07:34:55 WAT STATEMENT:  drop table analytics_15052016-06-19 07:34:55 WAT ERROR:  table "analytics_1506" does not exist2016-06-19 07:34:55 WAT STATEMENT:  drop table analytics_15062016-06-19 07:34:55 WAT ERROR:  table "analytics_1506" does not exist2016-06-19 07:34:55 WAT STATEMENT:  drop table analytics_15062016-06-19 07:34:55 WAT ERROR:  table "analytics_temp_1506" does not exist2016-06-19 07:34:55 WAT STATEMENT:  drop table analytics_temp_15062016-06-19 07:34:55 WAT ERROR:  table "analytics_1506" does not exist2016-06-19 07:34:55 WAT STATEMENT:  drop table analytics_15062016-06-19 07:34:55 WAT ERROR:  table "analytics_1507" does not exist2016-06-19 07:34:55 WAT STATEMENT:  drop table analytics_15072016-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