dhis2-devs team mailing list archive

[Adebusoye Anifalaje <busoye@xxxxxxxx>]

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 <sumuduw00@xxxxxxxxx> 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     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp