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
_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to : [email protected]
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
