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
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
···
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
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 knutst@gmail.com 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 apreeti@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-users@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
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
···
On Wed, Jun 6, 2018 at 4:28 PM, Preeti Ajgaonkar apreeti@thoughtworks.com wrote:
Hey Knut, this is a Tracker type data element, it does not have any rows in datavalue table.
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
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.mifthah@gmail.com | Skype: nayeem.a.m | LinkedIn: linkedin.com/in/nayeemam
On Wed, Jun 6, 2018 at 3:45 PM, Knut Staring knutst@gmail.com 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 apreeti@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-users@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
–
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 n.mifthah@gmail.com 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.mifthah@gmail.com | Skype: nayeem.a.m | LinkedIn: linkedin.com/in/nayeemam
On Wed, Jun 6, 2018 at 4:28 PM, Preeti Ajgaonkar apreeti@thoughtworks.com wrote:
Hey Knut, this is a Tracker type data element, it does not have any rows in datavalue table.
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
On Wed, Jun 6, 2018 at 3:45 PM, Knut Staring knutst@gmail.com 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 apreeti@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-users@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
–
Thanks
Preeti Ajgaonkar