Question Re: Purging old data from audit database in Technology Q&A

Purging old data from audit database

Former Member — Wed, 13 Feb 2013 16:04:53 GMT

We are using Business Objects 4.0. Our database team is complaining that the audit database is too large. Does anyone know of a setting in the audit database that will archive data or clear out old data? Is this a setting I need to make on the audit database or is it a setting to change in the CMC?

Thanks for any suggestions/input!

Re: Purging old data from audit database

DayaJha — Wed, 13 Feb 2013 16:34:27 GMT

Hi Gary,

New Features:

SAP BI 4.0 it will be possible to remove history from the audit database, via a parameter "delete events older than (days)".

However this is not possible in BOE XI 3.1 or lower.

For your reference see the SAP BusinessObjects BI Platform 4.0 Administration Improvements:

http://events.asug.com/2012BOUC/0510_SAP_BusinessObjects_BI_Platform_4_0_Administration_Improvements.pdf

Hope this help you as well. After completion of your activity please close the thread.

Thanks,

Daya

Re: Purging old data from audit database

Former Member — Wed, 13 Feb 2013 18:08:36 GMT

Thank you, Daya. That was what I was looking for!

Gary

Re: Purging old data from audit database

former_member190903 — Mon, 14 Jul 2014 23:11:12 GMT

Did it work? It's my understanding that for large customers, this method will cause you issues. For example, our Event Detail table has grown to 349M rows in 4 months. That's over 10 times what it was on XI 3.1. We have dashoards that refresh every 10 minutes, but no way to exclude those from audits, so it's growing about 6,000 rows every 5 minutes. Any solutions?

Re: Purging old data from audit database

Former Member — Wed, 15 Oct 2014 17:16:10 GMT

Thanks Daya,

It was really helpful.