3018242 - Removing Role From User via HANA or GRC Can Cause Cyclic Dependency Error

This error occurs in HANA 2.0 SP05 only and under these three circumstances.

• Remove a role from a user in GRC
• Remove a user in GRC
• Remove a role within HANA

Below are the error messages that will be encountered from one of the above circumstances.

When running "SAP_PI_GRC"."Change_User_Roles_SV" which calls REVOKE_ACTIVATED_ROLE and cause the cyclic dependency error message;
transaction rolled back by an internal error: "SAP_PI_GRC"."Change_User_Roles_SV": line 137 col 21 (at pos 6222): Cyclic dependency found in a runtime procedure: Not allowed to call/modify runtime pro

While removing the Roles from user in GRC, we are getting the error message;
transaction rolled back by an internal error: "SAP_PI_GRC"."Change_User_Roles_SV": line 99 col 21 (at pos 3816): Cyclic dependency found in a runtime procedure: Not allowed to call/modify runtime pro

Try to remove a a HANA role using Access Request it is failing with
'transaction rolled back by an internal error: "SAP_PI_GRC"."Change_User_Roles_SV": line 103 col 21 (at pos 3936): Cyclic dependency found in a runtime procedure: Not allowed to call/modify runtime procedure SAP_PI_GRC.Change_User_Roles_SV during its execution'.

Error Log in Index Server :
EmbeddedAPI EAPICommon.cc(00158) : [SQL-129] unexpected exception at handleException_: exception=ERROR [CODE-129] transaction rolled back by an internal error: Cyclic dependency found in a runtime procedure: Not allowed to call/modify runtime procedure SAP_PI_GRC.Change_User_Roles_SV during its executionexception 1: no.71000129 (ptime/query/plan_executor/dml/qe_proc_call.cc:357) TID: 9847 Cyclic dependency found in a runtime procedure: Not allowed to call/modify runtime procedure SAP_PI_GRC.Change_User_Roles_SV during its execution NO exception throw location recorded. Stack generation suppressed.exception type information: - 0: public ptime::PtimeError@0x7f2245f566a8 SI - 0: public ptime::PtimeException@0x7f2245f56708 SI - 0: public ltt_adp::exception@0x7f2245f56630 SI - 0: public ltt::exception@0x7f223fcbac90

EmbeddedAPI Connection.cc(00463) : ERROR [CODE-129] transaction rolled back by an internal error: Cyclic dependency found in a runtime procedure: Not allowed to call/modify runtime procedure SAP_PI_GRC.Change_User_Roles_SV during its executionexception 1: no.71000129 (ptime/query/plan_executor/dml/qe_proc_call.cc:357) TID: 9847 Cyclic dependency found in a runtime procedure: Not allowed to call/modify runtime procedure SAP_PI_GRC.Change_User_Roles_SV during its executionNO exception throw location recorded.

HANA 2.0 SP05 GA - HANA 2.0 SP05 PL4

HANA, GRC, Cyclic dependency , KBA , HAN-DB-SEC , SAP HANA Security & User Management , GRC-SAC-BRM , Business Role Management , Problem