Error when syncing authorizations to PFCG

[former_member59416]

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

[former_member73766 · Accepted solution]

Dear Annika

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

This should solve your issue,

Rafael

[former_member59416]

Hello all,

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

Thanks Rafael.

Regards,

Annika

[former_member197694]

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