Deleting DataElement is very slow in DHIS 2.23 and 2.22

Support - Assistance technique
1

Hello,

While removing some of the un used data elements from DHIS we have noticed that it takes around 15 minutes to delete a data element in both DHIS 2.22 and 2.23 (latest). But, we see this issue to be fixed in the latest DHIS 2.25 in play demo.

So, could you please back port the fix to DHIS 2.23 and 2.22.

Thanks,
Poulami/Jhansi

2

Hi

Which endpoint are you using to delete? could you try with preheatCache=false?

···

On Thu, Nov 17, 2016 at 11:54 AM, jhansi jhansirk@thoughtworks.com wrote:

Hello,

While removing some of the un used data elements from DHIS we have noticed that it takes around 15 minutes to delete a data element in both DHIS 2.22 and 2.23 (latest). But, we see this issue to be fixed in the latest DHIS 2.25 in play demo.

So, could you please back port the fix to DHIS 2.23 and 2.22.

Thanks,

Poulami/Jhansi

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

–

Morten Olav Hansen

Senior Engineer, DHIS 2

University of Oslo

http://www.dhis2.org

3

Thanks Morten,

We are removing the dataElement using the DHIS UI, which internally is using DELETE ‘/dataElement/{dataElementId}’ API. We have also tried by adding preheatCache=false request params but, it still takes very long time (~15 mins) to delete.

Thanks,
Poulami/Jhansi

···

On Thu, Nov 17, 2016 at 11:54 AM, jhansi jhansirk@thoughtworks.com wrote:

Hello,

While removing some of the un used data elements from DHIS we have noticed that it takes around 15 minutes to delete a data element in both DHIS 2.22 and 2.23 (latest). But, we see this issue to be fixed in the latest DHIS 2.25 in play demo.

So, could you please back port the fix to DHIS 2.23 and 2.22.

Thanks,

Poulami/Jhansi

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

–

Morten Olav Hansen

Senior Engineer, DHIS 2

University of Oslo

http://www.dhis2.org

4

Hi Jhansi,

in 2.24 we implemented a completely new version of the metadata importer/manager, so this is not something that can easily be back-ported. Any chance you could upgrade to DHIS version 2.25?

regards,

Lars

···

On Thu, Nov 17, 2016 at 11:41 AM, jhansi jhansirk@thoughtworks.com wrote:

Thanks Morten,

We are removing the dataElement using the DHIS UI, which internally is using DELETE ‘/dataElement/{dataElementId}’ API. We have also tried by adding preheatCache=false request params but, it still takes very long time (~15 mins) to delete.

Thanks,
Poulami/Jhansi

On 17-Nov-2016, at 11:06 am, Morten Olav Hansen morten@dhis2.org wrote:

Hi

Which endpoint are you using to delete? could you try with preheatCache=false?

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

–

–

Morten Olav Hansen

Senior Engineer, DHIS 2

University of Oslo

http://www.dhis2.org

On Thu, Nov 17, 2016 at 11:54 AM, jhansi jhansirk@thoughtworks.com wrote:

Hello,

While removing some of the un used data elements from DHIS we have noticed that it takes around 15 minutes to delete a data element in both DHIS 2.22 and 2.23 (latest). But, we see this issue to be fixed in the latest DHIS 2.25 in play demo.

So, could you please back port the fix to DHIS 2.23 and 2.22.

Thanks,

Poulami/Jhansi

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

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

5

Ok, have you tried upgrading your DHIS 2 version? not sure if this is related to your own metadata, or DHIS itself. I can’t remember a time when it ever took that long.

Other than that, I would need a database dump to investigate… there is a bit of cleanup done internally when an object is deleted, but unless you have an extreme amount of data sets, or groups… it shouldn’t really take that long

···

On Thu, Nov 17, 2016 at 5:41 PM, jhansi jhansirk@thoughtworks.com wrote:

Thanks Morten,

We are removing the dataElement using the DHIS UI, which internally is using DELETE ‘/dataElement/{dataElementId}’ API. We have also tried by adding preheatCache=false request params but, it still takes very long time (~15 mins) to delete.

Thanks,
Poulami/Jhansi

On 17-Nov-2016, at 11:06 am, Morten Olav Hansen morten@dhis2.org wrote:

Hi

Which endpoint are you using to delete? could you try with preheatCache=false?

–

Morten Olav Hansen

Senior Engineer, DHIS 2

University of Oslo

http://www.dhis2.org

–

Morten Olav Hansen

Senior Engineer, DHIS 2

University of Oslo

http://www.dhis2.org

On Thu, Nov 17, 2016 at 11:54 AM, jhansi jhansirk@thoughtworks.com wrote:

Hello,

While removing some of the un used data elements from DHIS we have noticed that it takes around 15 minutes to delete a data element in both DHIS 2.22 and 2.23 (latest). But, we see this issue to be fixed in the latest DHIS 2.25 in play demo.

So, could you please back port the fix to DHIS 2.23 and 2.22.

Thanks,

Poulami/Jhansi

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