Skip to Content
avatar image
Former Member

How to delete mass amount of data from FF Logs?

Does anyone know a good way to delete a mass amount of data from the FF logs?

We have a large amount of data on our FF log tables and want to remove some of it.  (Our ZFFTNSLOG table has over 18 million records and the ZFFCDHDR table has over 242 million.)  I tried using the Archive function found on Administration->Archive->Delete/Download Log but because of the amount of data it will only let me delete about two weeks (roughly about 40,000 records) at a time.  Since I have about six years of data to remove, this isn't a real practical solution.

As a possible alternative, we could maybe get by with just getting rid of the change details.  Does anyone know if we can delete all of the records from the ZFFCDHDR table without messing up our FF log reporting ability?

I also looked at running the FFArchive job, but it looks like it would delete all FF data, which we don't want to do for Audit reasons.  We just want to get rid of older data.

We are on GRC 5.3 SP 18.

Thanks.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Mar 26, 2012 at 01:51 PM

    Hello,

    Please check:

    Note 1041912 - Firefighter Best
    Practice Archiving Strategy

    And section "Archived Data for Log Reports" in the configuration guide, pag. 90:

    http://service.sap.com/instguides ->  SAP BusinessObjects -> SAP BusinessObjects Governance, Risk, Compliance (GRC) -> Access Control -> SAP GRC Access Control 5.3 -> SAP GRC Access Control 5.3.

    Cheers,

    Diego.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hello Bob,

      The archiving/ deleting function is simple, and I think it isn't prepared to archive such huge number of records. I mean, the tool isn't as powerfull as archiving using tx. SARA.

      Maybe someone has faced a simmilar problem and gives you some hints, but the number of entries in the tables is very large. I don't know the number of users you're working with, but with these numbers I think that therre's a excesive use of FF.

      Anyway, I'd contact SAP Support in order to get another idea in how to solve the issue.

      Cheers,

      Diego.