problem with data approval

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

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@gmail.com 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@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

http://www.dhis2.org