3761379 - Unique constraint violation error while creating or saving scoped/custom role shows - SAP datasphere

Error while creating a custom role; saving the role fails with: "Failed to execute executeBatch. Component = PreparedStatement. Reason = unique constraint violated: Table(sap.fpa.services.security::Security.T_TaskAccess_), Index(_SYS_TREE_CS_#..._#0_#P0) with error: unique constraint violation for table sap.fpa.services.security::Security.T_TaskAccess_en, key: UID=the id already exists; indexname=_SYS_TREE_CS_#..._#0_#P0"

SAP Analytics Cloud

SAP Datasphere

1. Open Security.
2. Go to Roles and add a new scoped role.
3. Choose any template.
4. Try to save the role (the save fails with the unique constraint violation error).

• The solution of this issue is currently under investigation. Please follow this KBA for updates.
• [Last Update on 08:30am UTC, Jun 2] The root cause of the issue has been identified. Development team is currently working on the fix.

scoped role, custom role, role creation, save role fails, unique constraint violated, t_taskaccess, preparedstatement, executeBatch, security roles, index _SYS_TREE, unique constraint violation, datasphere, hana database, role template, cannot save role , KBA , LOD-ANA-LS , Licensing and Full User Equivalent , DS-SEC-AUTZ , Authorizations (Locks, etc.) , Problem