SAP Knowledge Base Article - Public

3002825 - Cannot add additional Date Dimension in a Model created by a User who is not the Model Owner in SAP Analytics Cloud (SAC) & SAP Digital Boardroom


When attempting to add an additional date dimension by a user who is not the model owner and whose language settings are set to German, the following error occurs when trying to save the model:

dberror(PreparedStatement.executeUpdate): 301 - unique constraint violated: TrexUpdate failed on table '' with error: unique constraint violation for table$delta_1$en, constraint='$trexexternalkey$', key value='40,t.2.C3Z8EUCJTNOP5HDXYRXG1IJDA8:Bratwurst;2,YM;2,en', pos=3, indexname=_SYS_TREE_CS_#177001_#0_#P0, rc=55


  • SAP Analytics Cloud (Enterprise) 2021.1.0

Reproducing the Issue

  1. Create and save a model.
  2. Under the edit toolbar click on add new dimension.
  3. Provide a name, select the type as Date and then click save.
  4. Afterwards click the save button under the general toolbar.
  5. Observe the error that the model cannot be saved.


This issue is currently under investigation by development.


This issue is currently under investigation by development.

See Also

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


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, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem


SAP Analytics Cloud 1.0