Re: [Dhis2-devs] Error while creating an event report with many options in DHIS 2.26 and DHIS 2.27
Looping in Marta.
On Wed, Dec 20, 2017 at 3:27 PM, Preeti Ajgaonkar
wrote:
> Hi,
>
> In DHIS 2.26 and DHIS 2.27, we encountered the following error in the POST
> call while creating an event report with a data element that has many
> options in the filter.
>
> {"httpStatus":"Internal Server Error","httpStatusCode":500,"
> status":"ERROR","message":"ERROR: value too long for type character
> varying(255)"}
>
> We were only able to add 21 options to the filter and save the report in
> our case. Adding more than 21 options displayed the above error. We are
> suspecting that this is caused by the 'filter' parameter, when it crosses
> the 255 characters threshold (see below).
>
> rows
> :[{dimension: "aee50bae73b", items: [],…}]
>
> 0:{dimension: "aee50bae73b", items: [],…}
>
> dimension:"aee50bae73b"
> filter:"IN:ae5824ee166;af88bde6615;a4e5da8828d;a342292ba70;a8b2ff2daf1;
> ab81f48f895;a0c83d60c8d;a440a1a53ec;af99d73c133;af80977531e;af430c7dd91;
> aecabb2c41d;a31fd3b9ffd;a8be7cafaeb;ad4969e1f34;a76e39e60dc;ab99d76f26c;
> aecdba37c76;af294a21e9f;a4b890e3441;a5c5340a7ee;a0d75d2c0b6"
> items:[]
> name:"Primary Diagnosis at ICU Discharge - Discharge - Intensive Care
> Ward"
>
>
> We also tried to replicate this in DHIS play. Though we were not able to
> create the event report in DHIS play as well, the error reported was
> different (See attached screenshot). Could you please confirm if this is a
> bug?
>
> --
> Thanks
> Preeti Ajgaonkar
>
___
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] Re: Field dataElementCategory missing in the reportTables API response in DHIS 2.27
Hi DHIS Team, We are awaiting response for this issue. Thanks Preeti On Thu, Feb 1, 2018 at 3:33 PM, Kumar Shahdeo wrote: > Hi DHIS Team, > > Could you please give some update on this. > > Thanks > Gaurav > > > On Wed, Jan 31, 2018 at 7:11 PM, Kumar Shahdeo > wrote: > >> Hi DHIS Team, >> >> In DHIS 2.26, as a response to reportTables API, we were getting >> *dataElementCategory* field under *categoryOptions, *However in DHIS >> 2.27 we are not getting *dataElementCategory *in the response*.* >> We are hitting the same endpoint and requesting for same fields with >> versioned 2.25 APIs in DHIS 2.27 as we used to do with DHIS 2.26. >> >> Is this an intentional change or a bug ? >> >> We have configured a pivot table with the following filters : Org Unit, >> Category. Our application is not able to identify the Category in DHIS >> 2.27, since we rely on *dataElementCategory *field. >> >> -- >> Kumar Gaurav Nath Shahdeo >> Developer >> Email gaura...@thoughtworks.com >> Telephone +91 9160688935 <+91+9160688935> >> [image: ThoughtWorks] >> <http://www.thoughtworks.com/?utm_campaign=kumar-gaurav%20nath%20shahdeo-signature&utm_medium=email&utm_source=thoughtworks-email-signature-generator> >> > > > > -- > Kumar Gaurav Nath Shahdeo > Developer > Email gaura...@thoughtworks.com > Telephone +91 9160688935 <+91+9160688935> > [image: ThoughtWorks] > <http://www.thoughtworks.com/?utm_campaign=kumar-gaurav%20nath%20shahdeo-signature&utm_medium=email&utm_source=thoughtworks-email-signature-generator> > -- Thanks Preeti Ajgaonkar ___ 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] [Dhis2-users] Program Indicator using data from multiple event stages to find TEA
Hi Aaron, Could you try by setting the analytics type to 'Events' and then filter all the events by Program stage id/Program stage name variable? Please let me know if this serves as a workaround for your blocker. Thanks Preeti A On Thu, Feb 8, 2018 at 8:19 PM, Aaron C White wrote: > Hi all, > > I'm trying to create a program indicator (or just query to the API > directly) that evaluates conditions on data elements from two different > event stages and then be used to find a relevant tracked entity attribute. > > From the docs, it seems that a program indicator type of enrollment would > be most appropriate, but this only works at the aggregate level and not at > an individual tracked entity instance level. When I use an event type > indicator, I don't receive any values back because the indicator definition > contains data from two stages. > > Am I correct in this assessment? Any thoughts on how to get around this? > > I've been testing on a v2.28 instance. A similar reference example from > the demo server would be the "Weight gain(in g) between birth and last > postnatal for Child Programme" program indicator. The one change would be > that I want to see the weight gain for individual TEIs and view a TEA based > on the weight gain amount instead of the average over all tracked entity > instances. > > Thanks in advance, > > Aaron > > -- > Aaron C. White > 919.522.5585 > > ___ > Mailing list: https://launchpad.net/~dhis2-users > Post to : dhis2-us...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-users > More help : https://help.launchpad.net/ListHelp > > -- Thanks Preeti Ajgaonkar ___ 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] [Dhis-devs][DHIS 2.27]Discrepancy in distribution of data in monthly reports as per EPI weeks
Hi team, Ever since we have upgraded to DHIS 2.27 and started using EPI weeks for distribution of data in any reports, we have noticed a discrepancy in the data for the months starting on a Friday. For e.g. data for W44 to W48 should be attributed to Nov 2017 as per the EPI week rule, but W48 data it is attributed to Dec 2017 (which starts on a Friday). See screenshots below Monthly [image: Inline image 1] Weekly [image: Inline image 3] *Expected* November 2017 - 398 December 2017 - 458 *Actual* November 2017 - 495 December 2017 - 361 Similar issue is observed from W31 - W35 where the data should for W35 should be counted as part of Aug 2017 but it appears in Sep 2017(which also starts on a Friday). Monthly [image: Inline image 1] Weekly [image: Inline image 4] *Expected* August 2017 - 614 September 2017 - 452 *Actual* August 2017 - 499 September 2017 - 567 I am expecting the same thing to happen in Apr-May 2018. Any leads on this would be appreciated. -- Thanks Preeti Ajgaonkar ___ 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] [Dhis-devs][DHIS 2.27]Discrepancy in distribution of data in monthly reports as per EPI weeks
Apologies, the figures for expected and actual values for the months of Nov and Dec 2017 should be as follows *Expected* November 2017 - 495 December 2017 - 361 *Actual* November 2017 - 398 December 2017 - 458 Thanks Preeti A On Fri, Mar 2, 2018 at 12:08 PM, Preeti Ajgaonkar wrote: > Hi team, > > Ever since we have upgraded to DHIS 2.27 and started using EPI weeks for > distribution of data in any reports, we have noticed a discrepancy in the > data for the months starting on a Friday. > > For e.g. data for W44 to W48 should be attributed to Nov 2017 as per the > EPI week rule, but W48 data it is attributed to Dec 2017 (which starts on a > Friday). See screenshots below > > Monthly > [image: Inline image 1] > > Weekly > [image: Inline image 3] > > *Expected* > November 2017 - 398 > December 2017 - 458 > > *Actual* > November 2017 - 495 > December 2017 - 361 > > Similar issue is observed from W31 - W35 where the data should for W35 > should be counted as part of Aug 2017 but it appears in Sep 2017(which also > starts on a Friday). > > Monthly > [image: Inline image 1] > > > Weekly > [image: Inline image 4] > > *Expected* > August 2017 - 614 > September 2017 - 452 > > *Actual* > August 2017 - 499 > September 2017 - 567 > > I am expecting the same thing to happen in Apr-May 2018. > > Any leads on this would be appreciated. > > -- > Thanks > Preeti Ajgaonkar > -- Thanks Preeti Ajgaonkar ___ 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] Error while deleting a data element
Hi, I am receiving a *504-Gateway-Timeout* exception whenever I try to delete any of the data elements in DHIS 2.27. The DELETE https://hmis-qa.ehealthunit.org/api/27/dataElements/a6a1a84029f call runs for a long time and finally fails with the above error in console and '*undefined was not deleted*' error in the UI. There is no error in the server log as well. Could anyone help me know how to get this issue resolved? -- Thanks Preeti Ajgaonkar ___ 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] [Dhis2-users] Error while deleting a data element
Hey Knut, this is a Tracker type data element, it does not have any rows in datavalue table. On Wed, Jun 6, 2018 at 3:45 PM, Knut Staring wrote: > I don't know what the issue would be, but have you checked that there is > nothing in the datavalue table with this dataelementid? > > Knut > > On Wed, Jun 6, 2018 at 12:14 PM Preeti Ajgaonkar > wrote: > >> Hi, >> >> I am receiving a *504-Gateway-Timeout* exception whenever I try to >> delete any of the data elements in DHIS 2.27. The DELETE >> https://hmis-qa.ehealthunit.org/api/27/dataElements/a6a1a84029f call >> runs for a long time and finally fails with the above error in console and >> '*undefined >> was not deleted*' error in the UI. There is no error in the server log >> as well. Could anyone help me know how to get this issue resolved? >> >> -- >> Thanks >> Preeti Ajgaonkar >> ___ >> Mailing list: https://launchpad.net/~dhis2-users >> Post to : dhis2-us...@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~dhis2-users >> More help : https://help.launchpad.net/ListHelp >> > > > -- > Knut Staring > > Department of Information, Evidence and Research > World Health Organization, Geneva, Switzerland > Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522 > Skype: knutstar > -- Thanks Preeti Ajgaonkar ___ 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] [Dhis2-users] Error while deleting a data element
Hi Nayeem Thank you for your suggestion. The association of data element from the programs and program stages was removed. Removing foreign key references from trackedentitydataelementdimension, dataelementtranslations, dataelementattributevaluestables helped in deleting the data element. On Thu, Jun 7, 2018 at 12:07 PM, Nayeem Al Mifthah wrote: > Dear Preeti > Tracker data values are in separate table. Could you please- > >- Check that this data element is not assigned in any program or >program stage >- Tracker data values are stored in separate table named tracked >entity data value please check that table >- Check audit tables for tracked entity data value named >trackedentitydatavalueaudit > > > > *Nayeem Al Mifthah* > *Health Information Systems Specialist* > Support to the National HMIS > MIS, Directorate General of Health Services, Ministry of Health and Family > Welfare, Bangladesh > Telephone: +880-2-58816459|Fax: +880-2-58813875|Mobile: > +88-01914 030 574 > Email: n.mift...@gmail.com|Skype: nayeem.a.m| LinkedIn: > linkedin.com/in/nayeemam > > > On Wed, Jun 6, 2018 at 4:28 PM, Preeti Ajgaonkar > wrote: > >> Hey Knut, this is a Tracker type data element, it does not have any rows >> in datavalue table. >> >> On Wed, Jun 6, 2018 at 3:45 PM, Knut Staring wrote: >> >>> I don't know what the issue would be, but have you checked that there is >>> nothing in the datavalue table with this dataelementid? >>> >>> Knut >>> >>> On Wed, Jun 6, 2018 at 12:14 PM Preeti Ajgaonkar < >>> apre...@thoughtworks.com> wrote: >>> >>>> Hi, >>>> >>>> I am receiving a *504-Gateway-Timeout* exception whenever I try to >>>> delete any of the data elements in DHIS 2.27. The DELETE >>>> https://hmis-qa.ehealthunit.org/api/27/dataElements/a6a1a84029f call >>>> runs for a long time and finally fails with the above error in console and >>>> '*undefined >>>> was not deleted*' error in the UI. There is no error in the server log >>>> as well. Could anyone help me know how to get this issue resolved? >>>> >>>> -- >>>> Thanks >>>> Preeti Ajgaonkar >>>> ___ >>>> Mailing list: https://launchpad.net/~dhis2-users >>>> Post to : dhis2-us...@lists.launchpad.net >>>> Unsubscribe : https://launchpad.net/~dhis2-users >>>> More help : https://help.launchpad.net/ListHelp >>>> >>> >>> >>> -- >>> Knut Staring >>> >>> Department of Information, Evidence and Research >>> World Health Organization, Geneva, Switzerland >>> Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522 >>> Skype: knutstar >>> >> >> >> >> -- >> Thanks >> Preeti Ajgaonkar >> >> ___ >> Mailing list: https://launchpad.net/~dhis2-users >> Post to : dhis2-us...@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~dhis2-users >> More help : https://help.launchpad.net/ListHelp >> >> > -- Thanks Preeti Ajgaonkar ___ 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] Unapproved data is visible for users not assigned the "View Unapproved Data" permission
Hi team, Recently we have been noticing that users who have not been assigned with the "View unapproved data" permission are able to see unapproved data in reporting apps i.e. Pivot tables, Data Visualizers and event reports. We have been seeing this since DHIS 2.27 onwards. Could you please let us know if this could be a bug or if there is any resolution to this? -- Thanks Preeti Ajgaonkar ___ 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
