Skip to Content
avatar image
Former Member

Error when syncing authorizations to PFCG

Hello Experts,

We are on SAP Access Control 10.0, SP16, and use the Business Role Management component to maintain and create security roles. We have encountered an error when trying to sync authorizations with PFCG in the back-end ECC system. The ABAP error states "The ABAP/4 Open SQL array insert results in duplicate database records, records in the data base".

ST22 error:

Short text
    The ABAP/4 Open SQL array insert results in duplicate database records.

What happened?
    Error in the ABAP Application Program

    The current ABAP program "CL_GRAC_MODEL_ROLE============CP" had to be
     terminated because it has
    come across a statement that unfortunately cannot be executed.

We are trying to add new transactions to a role that was previously created outside of GRC and imported using the role import function. We get the error when trying to sync authorizations to the back-end ECC system in the Maintain Authorization stage in the role creation process. This is the first time we have seen this error and have not had any issues adding transactions to other roles.  I have checked both the front-end in GRC and table GRACROLE but don't see any duplications of the role.

Does anyone know what is causing this error and how to correct?

Thank you in advance for any assistance.

Annika

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Sep 17, 2015 at 08:07 PM

    Dear Annika

    Please view blog http://scn.sap.com/community/grc/blog/2015/09/06/pfcg-synchronization-dump

    This should solve your issue,

    Rafael

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 30, 2015 at 12:36 PM

    Hello all,

    We applied noted 2057990 as suggested in the blog and it resolved our issue.

    Thanks Rafael.

    Regards,

    Annika

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 17, 2015 at 08:30 PM

    Hello Annika,

    check and apply the below note for correction GRC10.0 SP16,but it is not released to customers

    2033279    AC BRM 10.0 :Issue while performing Authorization sync.

    Regards

    Baithi

    Add comment
    10|10000 characters needed characters exceeded