← Back to team overview

dhis2-users team mailing list archive

Re : [Dhis2-devs] Dear Dhis2 users how can i delete?

 

Dear all,
I 'd like to implement DHIS2-live in a community based program in a health district setting. 

For this program i need to use a name based information tool. When i want to data entry into a program stage it appears not possible to enter and save data in any data element of the form;  this message appears "operation failed-internal server error    java.lang.NullPointerException: the error details are logged"
What can i do know to solve this bugg.
Thanks any one for helping me

Alain
Burkina Faso

 
Alain KABORE, MPH

IH Specialist, 
HIS Specialist
Program Officer
Family Care International 
Burkina Faso

Tel/Fax:  50 36 93 58
Mobile:   70 26 70 43
               78 39 83 26
Skype: alainkabore

________________________________






________________________________
De : Muhire Andrew <muhireandrew@xxxxxxxxx>
À : Knut Staring <knutst@xxxxxxxxx>; Lars Helge Øverland <larshelge@xxxxxxxxx>
Cc : "dhis2-users@xxxxxxxxxxxxxxxxxxx" <dhis2-users@xxxxxxxxxxxxxxxxxxx>; "dhis2-devs@xxxxxxxxxxxxxxxxxxx" <dhis2-devs@xxxxxxxxxxxxxxxxxxx>
Envoyé le : Lundi 12 Septembre 2011 13h09
Objet : Re: [Dhis2-users] [Dhis2-devs] Dear Dhis2 users how can i delete?


Thank you all,
Great Knut its rilly good to select first and then delete because it can cause problems in case i delete  the needed data.
 




________________________________



Muhire Andrew

HMIS/Ministry of Health
andrew.muhire@xxxxxxxxxx
God is my provider.



________________________________
From: Knut Staring <knutst@xxxxxxxxx>
To: Lars Helge Øverland <larshelge@xxxxxxxxx>
Cc: Muhire Andrew <muhireandrew@xxxxxxxxx>; dhis2-users@xxxxxxxxxxxxxxxxxxx; dhis2-devs@xxxxxxxxxxxxxxxxxxx
Sent: Monday, September 12, 2011 3:56 PM
Subject: Re: [Dhis2-devs] Dear Dhis2 users how can i delete?


As a rule of thumb, it is usually wise to do a SELECT before a DELETE, so that you are 100% sure you are not deleting data you really need.


In this case:

select * from datavalue_audit where dataelementid=<id>;
select * from datavalue where dataelementid=<id>;


Knut


2011/9/12 Lars Helge Øverland <larshelge@xxxxxxxxx>

Hi Andrew,
>
>you need to remove the data with SQL in the database. Run:
>
>delete from datavalue_audit where dataelementid=<id>;
>delete from datavalue where dataelementid=<id>;
>
>and replace <id> with the dataelementid of the one you want to remove.
>
>You can then go ahead and delete the data element in the user interface.
>
>
>
>Lars
>
>_______________________________________________
>Mailing list: https://launchpad.net/~dhis2-devs
>Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>Unsubscribe : https://launchpad.net/~dhis2-devs
>
>More help   : https://help.launchpad.net/ListHelp
>


-- 

Knut Staring
Informatics, U. of Oslo
http://hisp.uio.no
+4791880522



_______________________________________________
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

Follow ups

References