Audit table in dhis have 350 GB Size

[Ravikumar]

Dear All,

can we delete the data from audit table to decrease the size of table?,If we delete the data from audit table any impact of dhis flow in version 2.37.

Thanks in advance.

Thanks & Regards,
Ravikumar

[sami.oracle10g (Sami Yassin)]

of course, check this post. I am sure will help you

Clear Audit Log

Hi Pamod Deleting audit logs kinda defeats the purpose of having them to start with, but it’s all logged in the table called ‘trackedentitydatavalueaudit’ in the database… so you could manually clean it up there.

···

On Thu, Mar 10, 2016 at 4:03 AM, Markus Bekken <a href="mailto:markus.bekken@gmail.com">markus.bekken@gmail.com</a> wrote: Hi Pamod, when the event has an audit log there is currently no means of deleting it through the api(and therefore not from the apps).…

[didate (Mamadou Lamarana)]

Hello,

I want to reopen this topic because we have the same issue, the size of the audit table of our tracker instance is growing to fast.

What I understand is that the audit table keep configurations changes.

Can we delete its contents without any risk ?

@sami.oracle10g 's response talk about data auditing tables like datavalueaudit, trackedentitydatavalueaudit … but here the issue is with the table nammed “audit” that audit the configuration.

Regards