SAP Knowledge Base Article - Preview

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

Symptom

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.


Read more...

Environment

HANA 2.0 SP05 GA - HANA 2.0 SP05 PL4

Keywords

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.