SAP Knowledge Base Article - Preview

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

Symptom

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"


Read more...

Environment

SAP Analytics Cloud

SAP Datasphere

Product

SAP Analytics Cloud all versions

Keywords

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

About this page

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

Search for additional results

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