Skip to Content
avatar image
Former Member

Clean up of Rsec Auth change Logs (RSEC_VAL)

Analysis auth change Log table RSEC_VAL can grow very fast and if not cleaned up regularly could lead to other issues where RSECADMIN cannot be executed and it will time out.

Does anyone know of SAP Reports that can be routinely scheduled as a housekeeping job or any other suggestions to keep it clean ?

Thanks,

Farah

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Jun 29, 2009 at 03:33 PM

    Hi,

    Can you try to delete few logs and let me know if you are getting the same dump. Please post the abap dump if you can.

    Thanks

    Manik

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      SAP did not mention any other approach besides what we are doing to generate the authorizations. This is a standard process and standard programs are used to generate the authorizations loaded from different source systems.

      I would think SAP should consider providing some way of deleting or atleast archiving and deleting these logs so we do not overflow the change Log tables.

      We may not be the only unique customers trying to use this process and coming across this kind of an issue.

      Farah

  • avatar image
    Former Member
    Oct 09, 2009 at 09:13 AM

    Hi Farah,

    Development is aware of this issue, however I cannot give you any further information on when/if a deletion option can be provided.

    The response in the message is correct, it is ok to delete old entries from this table with your own program according to your business requirement. It is not necessary to delete the whole table, only the entries that are considered old from your side.

    Best Regards,

    Vincent

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 29, 2009 at 05:37 PM

    Sounds like a customer-exit which is using a variable as a authorization value and the variable values have not been carefully chosen or are "triggered" on each navigation step.

    Check CMOD for a customer-exit. It sounds like you are not "only" using the buffer but also generating the authorization on each (or many) authorization checks.

    Just a guess...

    Cheers,

    Julius

    ps: You cannot add attachments. This does not work because of load balancing. The easiest way is to use a "link" capability of your own and post the link in the thread here. Better is to post only the relevant parts of the dump. If all else fails, you can send it to me and I can "load" it for you.

    Add comment
    10|10000 characters needed characters exceeded