on 09-20-2010 4:47 PM
Hi all,
we have scheduled a Risk Analysys at permission level with 2.000 users. Looking at report log we see that each user is processed in around 2 seconds. The system seems to be freezed at 41% to a specific user. Now it is working on this single user since 2 hours.
Any suggestions to uderstand why it happens ?
What can we look at ?
Andrea
First of all check the Directory where you are storing the RTA extracts to get populated in RAR analysis engine. Also check the Batch Job daemon from your browser by using the url: http://<servername>:port/webdynpro/dispatcher/virsa/ccappcomp/BgJobStart?debug=1
Next check can be at connector level. Try to generate the Rule Set for all the Rule Ids. If the Rule set generation also takes longer time than earlier cases then you may need to check the following notes and their suggestions:
[Note 1121978 - Recommended settings to improve peformance risk analysis|https://websmp130.sap-ag.de/sap%28bD1lbiZjPTAwMQ==%29/bc/bsp/spn/sapnotes/index2.htm?numm=0001121978&nlang=E]
[Note 986997 - Risk Analysis & Remediation tuning for optimal performance|https://websmp130.sap-ag.de/sap%28bD1lbiZjPTAwMQ==%29/bc/bsp/spn/sapnotes/index2.htm?numm=0000986997&nlang=E]
Also based on the DB you are using you may need to check some other notes as well. For e.g.:
1313116 - Performance issues when running Risk Analysis in RAR w/MaxDB
Also to be in the safer side make sure that you are on the updated support pack level. Like SP 14 atleast for AC 5.2 or SP 8 for AC 5.3
Regards,
Dipanjan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
We will try.
Thank you for the tip.
Andrea
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi David,
thank you for your post.
We are not considering SAP_ALL.
The system will become slow in a random way. Even with some users having few roles, it takes more than one hour for a single user.
If we perform a foreground risk analysis (via informer TAB) for a user which is processed in 2 hour in background, the output is on the screen after 2 minutes.
Use USER GROUPS is a workaround.
We will investigate...
Andrea
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Andrea
Has the user got a SAP_ALL type access which may slow the report down I think?
Does the log show any previous attempts have failed and why? 2000 users is a bit of an ask for RAR but it should manage it - we had 1.2 million conflicts for one end market which overflowed onto the XML output
If the report isn't timing out or running out of memory (way out of my depth on these two but do remember having problems early on), then it may pay to break the report down into user groups if you have those or by ID ranges set to run in the background at quiet times of the day.
Edited by: David Berry on Sep 20, 2010 7:21 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.