Skip to Content
avatar image
Former Member

BOBJ 4.1 Auditing records not getting cleared despite CMC setting of 120 days

Hi All,

We are seeing disk space alerts for auditing db in prod. We already have this setting in CMC to delete the events older than 120 days. But when i query against ADS_EVENT, i see 5 million records.

select * from dbo.ADS_EVENT order by Start_Time -->gives me records from 2015-06-15 which is weird. Am i missing something , else can we clear the records from ADS_EVENT and ADS_EVENT_DETAILS.

delete from dbo.ADS_EVENT where Start_Time between 01-01-2015' and '01-06-2016'.

Would there be any issues if we manually delete the records just from these two tables.. while there are some other auditing tables , would there be any missing in synch between the auditing tables? please help us here!!

Environment: SAP BO 4.1

Auditing db: sql server 2008.

Thanks,

Satya

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Feb 10, 2017 at 03:10 PM

    Which service pack of 4.1 are you running?

    -Dell

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 10, 2017 at 03:13 PM

    check this sap note.

    2257580 - Audit data is not deleted automatically even auto-deletion is set properly in Central Management Console

    Add comment
    10|10000 characters needed characters exceeded