Skip to Content

Delete all table entries filled by batch risk analysis

Hi experts,

Is there any mechanism to increase the performance of Batch risk Analysis in 101. When we schedule, it is taking almost 5 days to complete in full sync. I maintained config parameter riskanalysis value 20- for paralle processing

Performance- batch, user, role, profile- 1000.

Now we have few changes in ruleset, again generated rules and again we ran the BATCH RISK ANALYSIS in FULL SYNC mode. Its taking too much time.. for 10 users it took 1 day. We had 10 lak violations. But still 10 users in 1 day .. we had almost 5000 users ....cnt imagine..

So is their any approach to handle these kind of scenarios?

I thought to delete the tables filled during the BRA job, but dnt find any program except GRAC RULE DELETE and delete_all program(only to delete rules). How to remove the data filled by batch risk analysis or the data in reports. Is their any program to clear the offline data??

Do it cause any inconsistencies in application??

Regards,

Ravi

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Posted on Jul 21, 2016 at 11:24 AM

    Update the Maintain Exclude Objects for Batch Risk Analysis. Are you running all system in 1 Variant or stepped variant. Exclude unwanted users / roles / profiles / user groups.

    Further assist the exclusions by Variant in the Batch risk analysis job itself.

    Does the 20 parallel processes match whats available in RZ11 parameter rdisp/wp_no_btc or a quick check in SM50 will show you available BTC processes. If these are less than 20, then the setting in AC SPRO will reduced to actual BTC availability

    What value do you have for Risk Analysis 1035? I have experimented with this as we have 170k users and increasing this made it worse. But our Full user sync across 6 SoX systems takes 13hrs. Before fine tuning it took about 8 days

    Regards

    Barry Drakes

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 04, 2015 at 09:50 PM

    Hello Ravi,

    I believe the first thing to do is to remove critical roles and profiles from the job run.

    There is an SAP note to improve the performance. It is for GRC 10.1.

    2170543 - Batch Risk Analysis Performance

    Regards,
    Fernando

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 05, 2015 at 07:55 AM

    GRAC_DELETE_REPORT_SPOOL, with application type SODRP


    regards

    plaban

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.