Audit Log Purge

[rhart]

It's so slow and there's no feedback at all.

Purging 2 months of logs and has been running for 8hrs now, there 5 years to purge.

[MikeLockwood · Accepted solution]

The only way that I know of to monitor progress is to query the number of rows in the AUDITRECORD table - which can be done while it's running.

Agree that there should be some progress feedback - possible that it's stuck.

[rhart]

yeah it was stuck, thanks you're a legend

[HJ1]

What do you need to do if & when it's stuck..?   😄

[rhart]

Try to stop it using windchill wt.util.jmx.SMJconsole or else restart the MS. The cause was missing indexes in my case

[HJ1]

I restarted 'everything'... users started reporting the system is not responding.

Yet another doomsday tool this Audit Log Purge  😁