← Back to team overview

dhis2-users team mailing list archive

Re: corrupted data elements

 

If you know the UID of the data element (which seems to be the case here) ,
can't  you just delete it directly from the database? Be sure to refresh
your cache afterwards.

DELETE FROM dataelement where uid = 'yAuhfSERVSA';

You might have some other constraints which you may need to get rid of one
by one.

Not pretty, but might be the only way if you cannot simply delete it
through the user interface.

Regards,
Jason


On Fri, Oct 3, 2014 at 12:17 PM, Morten Olav Hansen <mortenoh@xxxxxxxxx>
wrote:

> You say you can't list the data elements.. is there any errors in the log?
> it should show something.
>
> --
> Morten
>
> On Fri, Oct 3, 2014 at 5:13 PM, Salimone Domingos Nhancume <
> snhancume@xxxxxxxxx> wrote:
>
>> Thanks Morten, But we are planning to migrate to version 2.15 next month
>>
>> for now in version 2.13 what would be the way to solve my problem?
>>
>> Salimone
>>
>> 2014-10-03 11:57 GMT+02:00 Morten Olav Hansen <mortenoh@xxxxxxxxx>:
>>
>>> Hi
>>>
>>> Proper CRUD operation in the web-api is not supported in 2.13, you will
>>> need to update to 2.15 or later to do that...
>>>
>>> --
>>> Morten
>>>
>>> On Fri, Oct 3, 2014 at 4:46 PM, Salimone Domingos Nhancume <
>>> snhancume@xxxxxxxxx> wrote:
>>>
>>>> Hi team;
>>>>
>>>> My DHIS2 does not load the list of Available data elements when i what
>>>> to Edit any DataSet. i think that i have some corrupted data elements.
>>>>
>>>> I tried to delete this data elements from DHIS but it does not accept
>>>> I tried also from Ubuntu terminal using this code: * curl -X DELETE -u
>>>> xxxxx:yyyyy "http://54.83.47.166/api/dataElements/yAuhfSERVSA
>>>> <http://54.83.47.166/api/dataElements/yAuhfSERVSA>"* but i have the
>>>> following error:
>>>>
>>>> *<html><head><title>Apache Tomcat/7.0.26 - Error
>>>> report</title><style><!--H1
>>>> {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:22px;}
>>>> H2
>>>> {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:16px;}
>>>> H3
>>>> {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:14px;}
>>>> BODY
>>>> {font-family:Tahoma,Arial,sans-serif;color:black;background-color:white;} B
>>>> {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;}
>>>> P
>>>> {font-family:Tahoma,Arial,sans-serif;background:white;color:black;font-size:12px;}A
>>>> {color : black;}A.name {color : black;}HR {color : #525D76;}--></style>
>>>> </head><body><h1>HTTP Status 405 - Request method 'DELETE' not
>>>> supported</h1><HR size="1" noshade="noshade"><p><b>type</b> Status
>>>> report</p><p><b>message</b> <u>Request method 'DELETE' not
>>>> supported</u></p><p><b>description</b> <u>The specified HTTP method is not
>>>> allowed for the requested resource (Request method 'DELETE' not
>>>> supported).</u></p><HR size="1" noshade="noshade"><h3>Apache
>>>> Tomcat/7.0.26</h3></body></html>user@ICAP-3GVB05J-SN:~$*I
>>>>
>>>>
>>>> I'm using DHIS version 2.13
>>>>
>>>> can anyone help me to solve this problem?
>>>>
>>>> Salimone
>>>>
>>>> _______________________________________________
>>>> 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
>>>>
>>>>
>>>
>>
>
> _______________________________________________
> 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
>
>


-- 
Jason P. Pickering
email: jason.p.pickering@xxxxxxxxx
tel:+46764147049

Follow ups

References