Report generation Error

Support - Assistance technique
1

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 (16.4 KB)

image

2

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@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 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.

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp

3

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@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 sumuduw00@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 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.

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp