Skip to Content
avatar image
Former Member

How to delete old records in Audit database?

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

5 Answers

  • Best Answer
    Jun 03, 2015 at 03:47 PM

    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?

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 03, 2015 at 03:59 PM

    Arvind,

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

    Ajay


    Add comment
    10|10000 characters needed characters exceeded

  • Jun 03, 2015 at 04:12 PM

    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 😉

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 03, 2015 at 06:32 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Jawahar Konduru

      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

  • avatar image
    Former Member
    Jun 04, 2015 at 10:27 AM

    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

    Add comment
    10|10000 characters needed characters exceeded