SAP Knowledge Base Article - Public

3001566 - Unique constraint violation for table TENANT_2:sap.fpa.services.calendar::Calendar.CAL_OBJECT_MEMBER in SAP Analytics Cloud for Planning (SAC)

Symptom

The following error occurs when you try to delete a user in SAP Analytics Cloud for Planning (SAC):

  • dberror(PreparedStatement.executeUpdate): 301 - unique constraint violated: search table error: "TENANT_2"."sap.fpa.services.calendar.sql::transferAll": line 212 col 5 (at pos 9388): [301] (range 3) unique constraint violated exception: unique constraint violated: TrexUpdate failed on table 'TENANT_2:sap.fpa.services.calendar::Calendar.CAL_OBJECT_MEMBER' with error: unique constraint violation for table TENANT_2:sap.fpa.services.calendar::Calendar.CAL_OBJECT_MEMBERen, constraint='$trexexternalkey$', key value='32,CD2BA2F20CB8E352F40239442052244A;16,$DELETED_USER$10', pos=0, indexname=_SYS_TREE_CS_#181685_#0_#P0, rc=55

Environment

  • SAP Analytics Cloud (Enterprise) 2020.21.11

Cause

This issue is a product defect.

Resolution

The fix will be included in 2021.03.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Sac, Acquisition, Model, Connect, Story, Tenant, Import, Failed, Using, Working , KBA , LOD-ANA-ADM , SAC Administration , LOD-ANA-PL-PRO , Planning Process, Input Task , Problem

Product

SAP Analytics Cloud 1.0