SAP Knowledge Base Article - Public

2573993 - Database error: dberror(PreparedStatement.executeUpdate): 301 - unique constraint violated when you try to make a change to a dimension property (attribute), identifier (ID), description or hierarchy value in SAP Analytics Cloud (BOC)

Symptom

The following error occurs  in SAP Analytics Cloud when you try to make a change to a dimension property (attribute), identifier (ID), description or hierarchy value:

  • Database error: dberror(PreparedStatement.executeUpdate): 301 - unique constraint violated: Table(t.8::MSTR_<Dimension>C5B8255A45437F9CE10000000A78A056)
  • Error de base de datos: dberror(PreparedStatement.executeUpdate): 301 - unique constraint violated: Table(t.3::MSTR_<Dimension>5712F5ABEC6D63FE10000000A68988A)

    04-Dec-17 1-30-25 PM.png

Environment

  • SAP Analytics Cloud 2017.23.1

Resolution

This issue is resolved in version 2018.01

Workaround: 

  1. Open the dimension in the modeler.
  2. Save the model without making any changes and get the message "Model X has been updated successfully".
  3. You can then modify the dimension (ID, property / attribute).

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

EPM, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Hana Cloud for Planning, EPM-ODS, Cloud for Analytics, C4P, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, HCP, C4A, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJ, BOBJcloud, BOCloud., BICloud, BO Cloud, connecting, conecting, conectando, conexão, modelo, SBOC, SAC, SAP BusinessObjects Cloud, Business Objects, SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics , KBA , unique constraint violation when changin , LOD-ANA , SAP Analytics Cloud (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predictive , Problem

Product

SAP Analytics Cloud 1.0