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 <bus...@hisp.org>
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 <sumudu...@gmail.com> 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-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help : https://help.launchpad.net/ListHelp
>
>
>
_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp
