← Back to team overview

dhis2-users team mailing list archive

Re: [Dhis2-devs]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 <n.mifthah@xxxxxxxxx>
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@xxxxxxxxx    |    Skype: nayeem.a.m    |   LinkedIn:
> linkedin.com/in/nayeemam
> ​
>
> On Wed, Jun 6, 2018 at 4:28 PM, Preeti Ajgaonkar <apreeti@xxxxxxxxxxxxxxxx
> > 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 <knutst@xxxxxxxxx> 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@xxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxx
>>>> 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-users@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>


-- 
Thanks
Preeti Ajgaonkar

References