on 04-03-2015 12:13 AM
Hi Experts,
We are facing the following issue: Access Management dashboard User / Role Analysis data empty and we are on SAP GRC AC 10.1 SP6
Issue in Detail: Log in to NWBC, navigate to Reports and Analytics tab, click User Analysis or Role Analysis.Dashboard will load and display, click on any of the risk level (Critical, High, Low, Medium, No Violations). A New Window pop up with the selections, but there are no data shown (e.g. High selected):
When Performing the Batch Risk Analysis job, it was terminated prematurely:
In ST22 we are getting following Runtime error: DBSQL_DUPLICATE_KEY_ERROR, Exception errorCX_SY_OPEN_SQL_DB ERROR
We have also applied the following note 2042012 - Batch Risk Analysis throws error DBIF_RSQL_SQL_ERRROR, but no luck.
Request your inputs in resolving the above issue.
Regards,
Venugopal
Hello,
Try to implement the below Notes
2078162 - DBIF_RSQL_SQL_ERROR in Batch Risk Analysis
1929810 - HTTP_NO_MEMORY error while running batch risk analysis
2090933 - Risk Analysis throws error DBIF_RSQL_SQL_ERROR
2079107 - Issues with Role Analysis Dashboard
Regards
Baithi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Venugopal,
Your batch risk analysis job does not complete right?
Dont think its issue with SP6 i was using before i moved to SP08.
can you please post details, ask you basis as well about space.
it seems it go completed then later after few hours it was terminated.
on top of it just run for few users only.
REgards,
Prasant
Dear Prasant,
How are you? it has been been long time we never spoke, I hope everything is going well at your end.
In our DEV and Quality we don't have issue with the Batch Risk Analysis job and dashboard drill down have no issues.
In PRD initial Batch Risk Analysis job was successful, After that when ever we schedule a job its getting terminated. We have already discussed with basis team about the space and they have checked and updated that still the space is there in the database.
Yesterday we have installed the following SAP Notes “2079107 - Issues with Role Analysis Dashboard” and “2101381 - Risk Violations Dashboard drilldown for system ALL not
possible “ and we have not tested the outcome at will check and updated the status as soon as we check.
What else can we check in the system or any other SAP notes which will help us in resolving the batch risk analysis terminate issue.
Regards,
Venugopal Ireni
Hi All,
Glad to inform you that SAP has provided the following Note "2152723 - Batch Risk Analysis ending in SAPSQL_ARRAY_INSERT_DUPREC" for the above issue.
We have implemented and tested, now it is working fine. Once again I would like to thank everyone for your inputs.
Regards,
Venugopal Ireni
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.