dhis2-users team mailing list archive

[Ifeanyi Okoye <ifeanyiokoye@xxxxxxxxx>]

Hello,
 

Weare currently experiencing an issue with the analytics on our DHIS2installation.

 

Theinstance went live on Thursday and data entry commenced that same day. OnSaturday, I tried to run dataset reports and got no output (just the formstructure). Pivot tables also returned no data.

 

Iran the analytics generation, which completed successfully each time from thefront end but still no data. Tried running maintenance but that went onindefinitely.

 

 

Iasked our IT folks to pull the database and system logs and noticed some errors(see attached PostgreSQL and Catalina logs). 

 

Here'sa subsection:

 

INFO 2016-06-18 20:51:25,517 Query failed, likely because the requestedanalytics 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

           atorg.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:99)

           atorg.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)

           atorg.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)

           atorg.hisp.dhis.analytics.data.JdbcAnalyticsManager.getKeyValueMap(JdbcAnalyticsManager.java:395)

           atorg.hisp.dhis.analytics.data.JdbcAnalyticsManager.getAggregatedDataValues(JdbcAnalyticsManager.java:143)

           at sun.reflect.GeneratedMethodAccessor538.invoke(Unknown Source)

 

Thetext in red is pretty recurrent across the catalina logs from the 18th of June.

 

Weare running DHIS2 2.22 build 22057. 

 

Dokindly take a look and help us resolve this.

 

Wouldgladly provide any other information  required.

 

Thankyou.

 
Warm Regards, 

Ifeanyi

Read DrMaestro's Blog
www.ifeanyiokoye.com