How to delete old records in Audit database?

[Former Member]

Hello Members,

We have a requirement to remove old data in our auditing database as the audit database schema has reached 85 % of capacity. What criterion has to be kept in mind to perform this activity.

As there are couple of tables what should be our consideration. Should the data to be deleted be in sync with the time stamp? Is it advisable to remove data only from a particular table?

Need your inputs.

Thanks,

Arvind Pandalai

[former_member185603 · Accepted solution]

if you are in 4.0, you can setup the days in auditing section. So it will delete all the data older than the days you specified.

For 3.1, check this KB.

1581890  - Does BusinessObjects Enterprise support to clean up audit database?

[Former Member]

Hello Members,

Everything looks great now. The matter was only because of TNS. Once it was updated.. the data could be pushed to database.

Coming back to original query, would it be a good practice to purge data belonging to only particular table in Audit database?

Wouldn't it impact data integrity of the server if we purge data only for few columns rather than all selected columns?

Please share your thoughts.

Regards,

Arvind

[former_member185603]

That was the reason SAP said one of the KB article, this practice is not supported in 3.1

[Former Member]

Hello Everyone,

Thank you for your pointers.

I am using BO 3.1 SP3. We have about 6-7 tables in Audit database in BO 3.1 I believe. Can we actually restrict data in these tables specifically. I know the answer would be Yes....But would that data be of any use if we delete data only for a particular table and not from all tables.

Hope you are getting that.

Just to add, I have a 2 CMS cluster environment of BO 3.1 and implemented auditing with oracle Db .

I find that there are no logs getting generated in the auditing folder in installation directory of BO.

Post configuration, I do see the tables got generated in oracle, however no records found....

Any clues on this.

Thanks,

Arvind Pandalai

[Former Member]

Note: When I say no logs I meant no text files in the auditing folder at all for in both servers where CMS is available.

Drivers and DSN have been created in both servers and test results have given positive results of connection with database.

[former_member185603]

Do you see any errors in logging folder related to Auditing?

Some time data is not written if there is a tablespace issue. Check with your DBA , how the schema was setup?

[Former Member]

Hello Jawahar,

I have not been successful in finding any useful traces. As far as tablespace issue is concerned we can negate it.

Reasons: 1. It has been clarified that there is enough space available. Checked with DBA earlier.

               2. The logs themselves are not available in Auditing folder. and this is the actual pain we are facing.

Initiated CMS and Connection server .ini tracing just now. Will update them soon.

Regards,

Arvind

[Former Member]

Hello All,

Finally got it...where I went wrong

All the options for Audit event setting in all services were unselected.

Selected a couple of them and can find the log files getting generated in Auditing folder. For now the data is not being pushed across to the database. However I believe the issue is with TNS entries now...probably...will ensure that the correct ones are updated and see further..

Will keep the thread opened with the solutions I found.

Please do share your inputs on what can be the checks we can make so that audit data log gets pushed to database.

Regards,

Arvind

[former_member205064]

All the records are in ADS_EVENT and ADS_EVENT_DETAIL. in BI4

You can delete the Data from these Tables

For 3.1

1480761 - How to purge or cleanup old data from the BusinessObjects Enterprise XI 3.1 Audit Database

One know issue in BI4 which is worth knowing:-

2114027 - Oracle UNDO tablespace is consuming up when BI is deleting Auditing records

Rest you know everything Arvind

[CdnConnection]

Arvind,

    In BI 4.x, it is possible through the CMC.   See screenshot below

Ajay