Symptom
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 'TENANT_2:sap.fpa.services.modeling.dimension::Dimension.HIERARCHYT' with error: unique constraint violation for table TENANT_2:sap.fpa.services.modeling.dimension::Dimension.HIERARCHYT$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
Environment
- SAP Analytics Cloud (Enterprise) 2021.1.0
Reproducing the Issue
- Create and save a model.
- Under the edit toolbar click on add new dimension.
- Provide a name, select the type as Date and then click save.
- Afterwards click the save button under the general toolbar.
- Observe the error that the model cannot be saved.
Cause
This issue is currently under investigation by development.
Resolution
This issue is currently under investigation by development.
See Also
- 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
- Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
- 2487011 - What information do I need to provide when opening an incident for SAP Analytics Cloud?
- 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
- Search for SAP Analytics Cloud content using Google or Bing:
- https://www.google.ca/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
- https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
- Note: Add relevant text or warning/error messages to the text search field to filter results.
- SAP Analytics Cloud > Learning > Data Connections
- SAP Analytics Cloud > Learning > Guided Playlists
- SAP Analytics Cloud > Learning > Guided Playlists > Getting Support
- Need More Help? Contact Support or visit the solution finder today!
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, 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 , Model, Story Design & Visualizations , Problem