Skip to Content
avatar image
Former Member

Parameter ID :1053

Hello all..Due to the memory inconsistencies we are planning to change the parameter ID 1053 and change it to file based storage of the risk analysis data.Does this mean that all the tables which usually gets populated during the ad-hoc analysis will be lost and needed to know what are the adverse effects in doing this?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 27, 2017 at 09:14 PM

    Dear Surya,

    if you change the spool type (such as from D to F), the reports will still read the previously generated files or database records. Index tables keep track of the source of the records when the data was generated.

    Cheers, Alessandro

    Add comment
    10|10000 characters needed characters exceeded

    • Surya,

      there is no archiving functionality available. You can only clear the data from the table. For what purpose do you want to keep the old data from the risk analysis? Please note that I am talking about ad-hoc risk analysis data, not the data that is populated from the batch risk analysis to update your dashboards.

      However, the data in the tables can be cleared by running the report GRAC_DELETE_REPORT_SPOOL. You can schedule as a daily job or you can run manually anytime. This will clear the data from below temporary tables:

      • GRACSODREPDATA
      • GRACSODREPINDEX
      • GRACSODREPSTATUS

      This report will delete the data from the table space or the file system whichever you use as storage type. For best practices, refer to SAP Note "1580877 - Best practices in storage management for SoD analysis jobs".

      Regards, Alessandro