Skip to Content
avatar image
Former Member

Access Management dashboard User / Role Analysis data empty issue

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Apr 03, 2015 at 07:05 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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