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
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.
SAP Knowledge Base Article - Preview