dhis2-devs team mailing list archive

[sumudu weerasinghe <sumuduw00@xxxxxxxxx>]

Thanks Adebusoye, for your quick reply.

Yes it worked for me. now all reports generated.

Regards
Sumudu

On Mon, Mar 30, 2015 at 1:40 PM, Adebusoye Anifalaje <busoye@xxxxxxxx>
wrote:

> 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 grammar [select "de","monthly", sum(value) as value from analytics_2014
> where "de" in ('TmrNNl3pful') and "monthly" in ('201412') and ( "uidlevel7"
> in ('s8MjXuFVsDr') ) group by "de","monthly"]; nested exception is
> org.postgresql.util.PSQLException: 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
>
>
>