Skip to Content
0

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

Feb 10, 2017 at 03:06 PM

40

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Dell Stinnett-Christy Feb 10, 2017 at 03:10 PM
0

Which service pack of 4.1 are you running?

-Dell

Show 1 Share
10 |10000 characters needed characters left characters exceeded

its 4.1 SP5

0
AMIT KUMAR
Feb 10, 2017 at 03:13 PM
0

check this sap note.

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

Share
10 |10000 characters needed characters left characters exceeded