dhis2-users team mailing list archive

[Lars Helge Øverland <larshelge@xxxxxxxxx>]

Hi Lwin,

in this case, assuming that you only have very few dataapproval records, I
would suggest you just delete these records using SQL.

Check the count of dataapproval records:

select count(*) from dataapproval;

If its very low it might be best to just remove them:

truncate table dataapproval;

After this you will be able to delete your approval level through the user
interface.

regards,

Lars

On Mon, Jun 22, 2015 at 12:46 PM, Lwinlwin Aung <lwinlwinaung720@xxxxxxxxx>
wrote:

> Dear all,
>
> I have a problem with data approval.
>
> When I tried to delete one approval level, it was stated that “Object not
> deleted because it is associated by objects of type DataApproval”. Then I
> reviewed whether this level accepted the approved data from some lower
> level organization unit. It was found in SQL view that one Org and its
> children were approved for October 2014 although *the approval status was
> not shown in data entry form and data approval form.*
>
> Have you ever had this kind of problem? How can I solve this issue?
>
> Thanks in advance.
>
>
>
> Best regards,
>
> Lwin Lwin Aung
>
>
> --
> Dr. Lwin Lwin Aung
> Health Information Division
> Department of Public Health
> Office No.(47), Nay Pyi Taw
>
>
> _______________________________________________
> 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
>
>


-- 
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
http://www.dhis2.org <https://www.dhis2.org>