cancel
Showing results for 
Search instead for 
Did you mean: 

Access Management dashboard User / Role Analysis data empty issue

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member197694
Active Contributor
0 Kudos

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

Former Member
0 Kudos

HI Srinivas,

Thank you so much for your quick response.

We have already tried by implementing the following note 2078162 but no luck.

We will try with the other notes that you have mentioned and get back to you.

Regrds,

Venugopal

Former Member
0 Kudos

Hi Srinivas,

We have implemented the above mentioned notes, unfortunately the issue still exists.

Regards,

Venugopal

former_member193066
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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

japneet_singh2
Active Participant
0 Kudos

Hi Venugopal,

What is the value of the parameter 1120?

BR, JP

Former Member
0 Kudos

Hi Japneet,

The parameter Value is 1000.

Regards,

Venugopal

Former Member
0 Kudos

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

Answers (0)