Re: [Dhis2-devs] Not able to add favorites in GIS

[Saurabh]

Thanks Lars!

Will do the needful and share results accordingly.

Regards

Saurabh

On Tue, Dec 13, 2016 at 12:21 AM Lars Helge Øverland <l...@dhis2.org> wrote:

> Hi Saurabh,
>
> I've been looking into this but not able to reproduce. Could you try again
> with the very latest 2.25? Could you please give us access privately to a
> database dump where this happens?
>
> regards,
>
> Lars
>
>
>
>
>
>
> On Wed, Nov 23, 2016 at 1:42 PM, Saurabh <saurabh.leekh...@gmail.com>
> wrote:
>
> Hi Devs
>
>
>
> We have configured DHIS2 GIS application via the GML import process. We
> are able to plot data on maps and all works fine till we move towards
> adding a favorite. Somehow we are not able to add one.
>
>
>
> We checked the console and found the error mentioned in the attached text
> file. We did check on the DHIS2 demo instance and it works fine there. Any
> help on how this can be resolved will be appreciated.
>
>
>
> Following are the version and build details:
>
>
>
> Version:
>
> 2.25
>
> Build revision:
>
> 04a7fe7
>
> Build date:
>
> 2016-11-23 06:37
>
>
>
>
>
> Regards
>
>
>
> Saurabh
>
>
>
>
>
> ___
> 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
>
>
>
>
> --
> Lars Helge Øverland
> Lead developer, DHIS 2
> University of Oslo
> Skype: larshelgeoverland
> l...@dhis2.org
> http://www.dhis2.org <https://www.dhis2.org/>
>
>
___
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

Re: [Dhis2-devs] Unable to create a favourites on GIS module

[Saurabh]

Hi Lars

We too are facing the same issue. We had configured an instance on 2.25
from scratch. We did talk to Bjorn about it, and he had raised a bug on
JIRA for that as well.

This works fine on the demo instance.

Attached is the error that we get on console.

Thanks!

On Thu, Dec 1, 2016 at 5:23 PM Jose Garcia Muñoz  wrote:

>
> Hi Lars, Morten,
>
> any update on this? The issue is becoming really important now (We have a
> presentation in the Cambodia MoH tomorrow). This seems to happen only when
> we start a database from the scratch in 2.25. It is working fine when the
> database has been upgraded from previous versions.
>
> Any quick comments will be highly appreciated.
>
> thanks guys!
>
> I'm copy the error again:
>
>
> ERROR 2016-12-01 11:40:06,394 ERROR: null value in column "uid" violates
> not-null constraint
>   Detail: Failing row contains (15217, null, null, null, null, null,
> thematic1, 15218, f, f, f, null, null, null, null, null, 2, 5, ff,
> 00ff00, #d4,#fed98e,#fe9929,#d95f0e,#993404, null, 5, 15,
> 0.800044, null, null, f, f, 11px, normal, normal, #00, f,
> null, 0, null). (SqlExceptionHelper.java [http-apr-8081-exec-8])
> * ERROR 2016-12-01 11:40:06,395 HHH000346: Error during managed flush
> [could not execute statement] (SessionImpl.java [http-apr-8081-exec-8])
>
>
> On Tue, Nov 8, 2016 at 12:30 PM, Jose Garcia Muñoz 
> wrote:
>
>
>
> Hi Morten,
>
> also we (PSI) are having the same problem. For some reason the uid is null
> when trying to save the favourite in the mapview table of the database.
>
> Don't know why it is working on the demo, but no in our database...
>
> On Tue, Nov 8, 2016 at 12:11 PM, Archana Chillala <
> archa...@thoughtworks.com> wrote:
>
> Hi Morten,
>
> You're right, it works fine on the play server, but not on our machines.
> Not sure of the reason, though.
>
>
>
>
> Archana Chillala
> Application Developer
> Email archa...@thoughtworks.com
> Telephone +91 9100960533 <+91+9100960533>
> [image: ThoughtWorks]
> 
>
> On Mon, Nov 7, 2016 at 7:04 AM, Morten Olav Hansen 
> wrote:
>
> Hi Archana
>
> Seems to work fine on the play/demo server, but maybe you have a certain
> config that doesn't work.
>
> Can you try and reproduce on [1] and give us the steps back?
>
> [1] https://play.dhis2.org/demo (admin/district)
>
> --
> Morten Olav Hansen
> Senior Engineer, DHIS 2
> University of Oslo
> http://www.dhis2.org
>
> On Fri, Nov 4, 2016 at 7:18 PM, Archana Chillala <
> archa...@thoughtworks.com> wrote:
>
> Hi,
>
> We are using the latest version of DHIS 2.25 (build - 5e16867).
> We are trying to create a favourite on GIS module, but it does not get
> created. Following is the exception it throws in the logs.
>
>
> * INFO  2016-11-03 11:43:07,115 'admin' create org.hisp.dhis.mapping.Map,
> name: amsterdam location, uid: c9wq3KMvvuy (AuditLogUtil.java
> [http-bio-8080-exec-2])
> * WARN  2016-11-03 11:43:07,131 SQL Error: 0, SQLState: 23502
> (SqlExceptionHelper.java [http-bio-8080-exec-2])
> * *ERROR 2016-11-03 11:43:07,133 ERROR: null value in column "uid"
> violates not-null constraint*
> *  Detail: Failing row contains (369, null, null, null, null, boundary,
> null, f, f, f, null, null, null, null, null, null, null, null, null, null,
> 5, null, 1, null, null, f, f, 11px, null, normal, null, f, null, 0, null,
> null, null). (SqlExceptionHelper.java [http-bio-8080-exec-2])*
> * ERROR 2016-11-03 11:43:07,134 HHH000346: Error during managed flush
> [could not execute statement] (SessionImpl.java [http-bio-8080-exec-2])
> org.springframework.dao.DataIntegrityViolationException: could not execute
> statement; SQL [n/a]; constraint [uid]; nested exception is
> org.hibernate.exception.ConstraintViolationException: could not execute
> statement
> at
> org.springframework.orm.hibernate5.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:164)
> at
> org.springframework.orm.hibernate5.HibernateTransactionManager.convertHibernateAccessException(HibernateTransactionManager.java:741)
> at
> org.springframework.orm.hibernate5.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:589)
> at
> org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:761)
> at
> org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:730)
> at
> org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:485)
> at
> org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:291)
> at
> 

[Dhis2-devs] Not able to add favorites in GIS

[Saurabh]

Hi Devs

 

We have configured DHIS2 GIS application via the GML import process. We are
able to plot data on maps and all works fine till we move towards adding a
favorite. Somehow we are not able to add one.

 

We checked the console and found the error mentioned in the attached text
file. We did check on the DHIS2 demo instance and it works fine there. Any
help on how this can be resolved will be appreciated. 

 

Following are the version and build details:

 

Version:

2.25

Build revision:

04a7fe7

Build date:

2016-11-23 06:37

 

 

Regards

 

Saurabh

 

 

* INFO  2016-11-23 15:20:44,249 'admin' create org.hisp.dhis.mapping.Map, name: 
Test, uid: aCO0mEbTSGB (AuditLogUtil.java [http-nio-29003-exec-3])
* WARN  2016-11-23 15:20:44,255 SQL Error: 0, SQLState: 23502 
(SqlExceptionHelper.java [http-nio-29003-exec-3])
* ERROR 2016-11-23 15:20:44,256 ERROR: null value in column "uid" violates 
not-null constraint
  Detail: Failing row contains (2486, null, null, null, null, null, thematic1, 
2487, f, f, f, null, null, null, null, null, 2, 5, ff, 00ff00, 
#d4,#fed98e,#fe9929,#d95f0e,#993404, null, 5, 15, 0.800044, 
null, null, f, f, 11px, normal, normal, #00, f, null, 0, null). 
(SqlExceptionHelper.java [http-nio-29003-exec-3])
* ERROR 2016-11-23 15:20:44,257 HHH000346: Error during managed flush [could 
not execute statement] (SessionImpl.java [http-nio-29003-exec-3])
org.springframework.dao.DataIntegrityViolationException: could not execute 
statement; SQL [n/a]; constraint [uid]; nested exception is 
org.hibernate.exception.ConstraintViolationException: could not execute 
statement
at 
org.springframework.orm.hibernate5.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:164)
at 
org.springframework.orm.hibernate5.HibernateTransactionManager.convertHibernateAccessException(HibernateTransactionManager.java:741)
at 
org.springframework.orm.hibernate5.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:589)
at 
org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:761)
at 
org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:730)
at 
org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:485)
at 
org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:291)
at 
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at 
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at 
org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
at 
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at 
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208)
at com.sun.proxy.$Proxy130.addMap(Unknown Source)
at 
org.hisp.dhis.webapi.controller.mapping.MapController.postJsonObject(MapController.java:129)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at 
org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)
at 
org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136)
at 
org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110)
at 
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:817)
at 
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:731)
at 
org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
at 
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:959)
at 
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:893)
at 
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:968)
at 
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:870)
at javax.servlet.http.HttpServlet.service(HttpServle

Re: [Dhis2-devs] Issue with calculation of Age through program indicator

[Saurabh]

Thanks Markus for the response.

Will try again and share the results.

Regards

Saurabh

On 3 Nov 2016 19:16, "Markus Bekken" <markus.bek...@gmail.com> wrote:

> Hi there Saurabh,
>
> The d2:yearsBetween() is not yet supported in the server side aggregation
> of program indicators. For now you would have to use d2:daysBetween() / 365
> - which is not 100% correct as the leap years is not considered. You wrote
> d2daysBetween in your mail below(without the colon between d2 and
> daysBetween), but i assume that was a typo in the mail.
> If you used the expression 
> *d2:daysBetween(A{yourDateOfBirthAttributeUID},V{event_date})
> / 365* that should work fine on both the server and client side. Let me
> know if this was the expression you tried. Note that the attribute UID
> should be prefixed with A.
>
> In the dev instance the example indicators on the MNCH / PHC program use
> the V{event_date} as basis for the age calculation. This causes the
> indicators to be calculated to NaN until you enter an event date. If you do
> not explicitly want the age at the event, you can use V{enrollment_date}
> instead.
>
> Markus
>
> P.S. The attributes of type date is not shown in the expression part of
> the Program Indicator UI, only in the filter further down. This is all
> getting reworked and sorted out soon, but as a workaround for avoiding
> typos you can add the attribute in the filter part of the UI then
> cut'n'paste.
>
> 18. okt. 2016 kl. 18.11 skrev Saurabh <saurabh.leekh...@gmail.com>:
>
> Hi Devs
>
> Have been trying to create a program indicator for calculation of Age (in
> years) using the ‘d2yearsBetween’ expression (have tried with
> ‘d2daysBetween’ as well), and then putting the attribute for date of birth,
> and event/current date. The date of birth is not part of the attribute list
> in the ‘Expression’ part of the program indicator, hence the attribute UID
> (for DOB) is used instead in the expression.
>
> Although the expression is shown as valid, but the output is still ‘NaN’.
>
> Similar indicators are available on the dev instance (
> https://play.dhis2.org/dev/) for the MNCH program for Mother’s Age at
> visit in years/days, but there also the value shows as ‘NaN’.
>
> Would appreciate some help around this, if this can be fixed, or we are
> doing something wrong here!
>
> Regards
>
> Saurabh
>
> ___
> 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
>
>
>
___
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

[Dhis2-devs] Issue with calculation of Age through program indicator

[Saurabh]

Hi Devs

 

Have been trying to create a program indicator for calculation of Age (in
years) using the 'd2yearsBetween' expression (have tried with
'd2daysBetween' as well), and then putting the attribute for date of birth,
and event/current date. The date of birth is not part of the attribute list
in the 'Expression' part of the program indicator, hence the attribute UID
(for DOB) is used instead in the expression.

 

Although the expression is shown as valid, but the output is still 'NaN'.

 

Similar indicators are available on the dev instance
(https://play.dhis2.org/dev/) for the MNCH program for Mother's Age at visit
in years/days, but there also the value shows as 'NaN'.

 

Would appreciate some help around this, if this can be fixed, or we are
doing something wrong here!

 

Regards

 

Saurabh

 

___
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

Re: [Dhis2-devs] Average (Sum over Organisation Unit Hierarchy) for Financial April Dataset

[Saurabh]

Hi Devs

Any update on this will be much appreciated.

Regards

Saurabh

On Sun, Feb 28, 2016 at 10:18 PM Saurabh <saurabh.leekh...@gmail.com> wrote:

> Hi Devs and Users
>
> We are currently working on DHIS2 version 2.21.
>
> Have made a data element (used as dominator in an indicator) with the
> aggregation operator as *Average (sum in org unit hierarchy), *and it is
> assigned to a dataset with frequency *Financial year April.*
>
> We have entered data for this, and did run analytics. When the data is
> analysed for this over a period of last 12 months, it only shows the data
> from April to December for the year ’n’, and data for ‘n+1’ year is not
> shown in the graph/table.
>
> For e.g. data from April to December 2014 is shown in the graph/table, but
> Jan-Mar 2015 is not shown (financial year 2014-2015)
>
> Same behaviour is observed for the data element, as well as the annualised
> indicator made using the above data element.
>
> Have attached a screenshot of the graph, would like to understand is this
> a bug/or we have taken some wrong steps, or financial year April frequency
> is not yet fully supported for the selected aggregation operator.
>
> Any help on this will be appreciated!
>
> Regards
>
> Saurabh
>
> [image: Data element.png][image: Indicator.png]
>
___
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

[Dhis2-devs] Average (Sum over Organisation Unit Hierarchy) for Financial April Dataset

[Saurabh]

Hi Devs and Users

We are currently working on DHIS2 version 2.21.

Have made a data element (used as dominator in an indicator) with the 
aggregation operator as Average (sum in org unit hierarchy), and it is assigned 
to a dataset with frequency Financial year April.

We have entered data for this, and did run analytics. When the data is analysed 
for this over a period of last 12 months, it only shows the data from April to 
December for the year ’n’, and data for ‘n+1’ year is not shown in the 
graph/table.

For e.g. data from April to December 2014 is shown in the graph/table, but 
Jan-Mar 2015 is not shown (financial year 2014-2015)

Same behaviour is observed for the data element, as well as the annualised 
indicator made using the above data element.

Have attached a screenshot of the graph, would like to understand is this a 
bug/or we have taken some wrong steps, or financial year April frequency is not 
yet fully supported for the selected aggregation operator.

Any help on this will be appreciated!

Regards

Saurabh

___
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

[Dhis2-devs] Exception while seeking JSON response of Pivot Table while using Program Indicators/Event data items

[Saurabh]

Hi team

We have created some program indicators, and are using them to generate reports 
in Pivot Table module.

The team was trying to get a JSON response for the created pivot table, but an 
exception comes when a JSON response is sought through the following selections 
'Download —>Plain data source—>JSON’.

I checked for the same on the demo website (https://play.dhis2.org/dev 
<https://play.dhis2.org/dev>), and got the same exception when followed the 
same steps using 'Program Indicators', however when ‘Indicators’ were selected 
and JSON response was sought it worked fine.

Have created a ‘Child Health’ favorite using program indicators on the dev 
instance, here is the link: 
https://play.dhis2.org/dev/api/analytics.json?dimension=dx:GxdhnY5wmHq;p2Zxg0wcPQ3;hCYU0G5Ti2T;rXoaHGAXWy9;fM7RZGVndZE;eo73fim1b2i;tt54DiKuQ9c=pe:LAST_12_MONTHS=ou:ImspTQPwCqd=NAME=IpHINAT79UW
 
<https://play.dhis2.org/dev/api/analytics.json?dimension=dx:GxdhnY5wmHq;p2Zxg0wcPQ3;hCYU0G5Ti2T;rXoaHGAXWy9;fM7RZGVndZE;eo73fim1b2i;tt54DiKuQ9c=pe:LAST_12_MONTHS=ou:ImspTQPwCqd=NAME=IpHINAT79UW>

Requesting help on this please!

Regards

Saurabh

___
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

Re: [Dhis2-devs] Exception while seeking JSON response of Pivot Table while using Program Indicators/Event data items

[Saurabh]

Hi Lars

Works fine since we upgraded to version 2.22

Thanks for the followup.

Regards

Saurabh

On Fri, Feb 5, 2016 at 4:32 AM Lars Helge Øverland <l...@dhis2.org> wrote:

> Hi Saurabh,
>
> the link now seems to work fine. Perhaps there was a cache issue with the
> demo server, or a bug has been fixed since you tested. Let us know if this
> is still an issue.
>
>
> https://play.dhis2.org/demo/api/analytics.json?dimension=dx:GxdhnY5wmHq;p2Zxg0wcPQ3;hCYU0G5Ti2T;rXoaHGAXWy9;fM7RZGVndZE;eo73fim1b2i;tt54DiKuQ9c=pe:LAST_12_MONTHS=ou:ImspTQPwCqd=NAME=IpHINAT79UW
>
> regards,
>
> Lars
>
>
> On Sat, Dec 19, 2015 at 1:38 PM, Saurabh <saurabh.leekh...@gmail.com>
> wrote:
>
>> Hi team
>>
>> We have created some program indicators, and are using them to generate
>> reports in Pivot Table module.
>>
>> The team was trying to get a JSON response for the created pivot table,
>> but an exception comes when a JSON response is sought through the following
>> selections 'Download —>Plain data source—>JSON’.
>>
>> I checked for the same on the demo website (https://play.dhis2.org/dev),
>> and got the same exception when followed the same steps using 'Program
>> Indicators', however when ‘Indicators’ were selected and JSON response was
>> sought it worked fine.
>>
>> Have created a ‘Child Health’ favorite using program indicators on the
>> dev instance, here is the link:
>> https://play.dhis2.org/dev/api/analytics.json?dimension=dx:GxdhnY5wmHq;p2Zxg0wcPQ3;hCYU0G5Ti2T;rXoaHGAXWy9;fM7RZGVndZE;eo73fim1b2i;tt54DiKuQ9c=pe:LAST_12_MONTHS=ou:ImspTQPwCqd=NAME=IpHINAT79UW
>>
>> Requesting help on this please!
>>
>> Regards
>>
>> Saurabh
>>
>>
>> ___
>> 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
>>
>>
>
___
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

Re: [Dhis2-devs] Issue in adding 'Standard Reports' on Dashboard

[Saurabh]

Thanks Morten!

On Thu, Jan 21, 2016 at 3:11 PM, Morten Olav Hansen <morte...@gmail.com>
wrote:

> Hi
>
> This have been fixed now. Please wait about 30 min, and you can download a
> new 2.22/2.23.
>
> --
> Morten
>
> On Thu, Jan 21, 2016 at 1:06 PM, Saurabh <saurabh.leekh...@gmail.com>
> wrote:
>
>> Hi Devs
>>
>> Was trying to add a standard report on the dashboard, the reports gets
>> added and work fine, although instead of taking the report name, it prints
>> 'undefined' on the dashboard.
>>
>> Have observed the same on the dev version (2.23 snapshot) and stable
>> release (2.22).
>>
>> Attached are the screenshots for the same.
>>
>> Any help on this would be appreciated!
>>
>> Regards
>>
>> Saurabh
>>
>>
>> ___
>> 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
>>
>>
>
___
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

[Dhis2-devs] Exception when seeking JSON response of Pivot Table with Program Indicators/Event data items

[Saurabh]

Hi Devs

We have created some program indicators, and are using them to generate reports 
in Pivot Table module.

The team was trying to get a JSON response for the created pivot table, but an 
exception comes when a JSON response is sought through the following selections 
'Download —>Plain data source—>JSON’.

I checked for the same on the demo website (https://play.dhis2.org/dev 
), and got the same exception when followed the 
same steps using 'Program Indicators', however when ‘Indicators’ were selected 
and JSON response was sought it worked fine.

Have created a ‘Child Health’ favorite using program indicators on the dev 
instance, here is the link: 
https://play.dhis2.org/dev/api/analytics.json?dimension=dx:GxdhnY5wmHq;p2Zxg0wcPQ3;hCYU0G5Ti2T;rXoaHGAXWy9;fM7RZGVndZE;eo73fim1b2i;tt54DiKuQ9c=pe:LAST_12_MONTHS=ou:ImspTQPwCqd=NAME=IpHINAT79UW
 


Requesting help on this please!

Regards

Saurabh___
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