SAP Knowledge Base Article - Public

2687611 - Some users cannot be deleted in SAP Analytics Cloud

Symptom

  • Some users from the Users menu cannot be deleted in SAP Analytics Cloud.
  • After trying to delete a user, the user disappears for some seconds and then it shows up again. 
  • The following error message can be observed in the Google Developer Tool: 
    "dberror(PreparedStatement.executeUpdate): 301 - unique constraint violated: search table error: "TENANT_O"."sap.fpa.services.calendar.sql::transferAll"

Environment

  • SAP Analytics Cloud 2018.15.2 
  • SAP Cloud Identity (default)

Reproducing the Issue

  1. Logon to SAC.
  2. Navigate to Main Menu >> Security >> Users.
  3. Try to delete a user.
  4. Notice that after some seconds the user appears in the list after deleting it.

Cause

This issue is caused by a product defect.

Resolution

This issue has been fixed in Wave 2018.19.

See Also

Your feedback is important to help us improve our knowledge base.
Please rate how useful you found this article by using the star rating feature at the beginning of this article.
Thank you.

Keywords

SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, user, deletion, remove, appear, show up, visible , KBA , LOD-ANA , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , Problem

Product

SAP Analytics Cloud 1.0