Hi Sumudu, You can try saving the org unit levels. Go to Organisation Unit -> Organisation unit level and save the levels. Then generate the analytics again. This might solve it.
Best Busoye > On 30 Mar 2015, at 08:56, sumudu weerasinghe <[email protected]> wrote: > > Hi All, > > We used dhis 2.17 for aggregate data in our hospital. (No tracker ). > When i try to generate report from , dataset report, data visuializer and > pivot tables , always gives "no datavalue found". > Analytic tables has already generated. > > In the log it says - > > org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL > gram > mar [select "de","monthly", sum(value) as value from analytics_2014 where > "de" i > n ('TmrNNl3pful') and "monthly" in ('201412') and ( "uidlevel7" in > ('s8MjXuFVsDr > ') ) group by "de","monthly"]; nested exception is > org.postgresql.util.PSQLExcep > tion: ERROR: column "uidlevel7" does not exist > > > > I have gone through the analytic tables , but there is no column called > "uidlevel7". > What is "uidlevel7" ? > Can any one give reason for this error. > > I used > DHIS2 2.17 > R 17683 > PostgreSQL > OS - windows 7 > log and screen shot attached here. > > <reportgeneration error.txt><reportgeneration > error.PNG>_______________________________________________ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : [email protected] > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
