3547943 - Fail to save any change for dimension table of public dimension in SAP Analytics Cloud (SAC)

• Fail to add a member, delete description or other properties with a public dimension. The error message is 'dberror(PreparedStatement.executeUpdate): 689 - duplicate rowid matched during merge into: "TENANT_B"."(DO statement)": line 71 col 9 (at pos 4814): duplicate rowid matched by the search condition '.

SAP Analytics Cloud (SAC) 2024.21.7

1. Login SAC.
2. Open the public dimension.
3. Add a member and try to save.
4. Fail with error: dberror(PreparedStatement.executeUpdate): '689 - duplicate rowid matched during merge into: "TENANT_B"."(DO statement)": line 71 col 9 (at pos 4814): duplicate rowid matched by the search condition'.

This issue has been fixed by development.

This issue has been fixed by development.

• 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?
• Need More Help? Contact Support or visit the solution finder today!

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,Model, property, dimension table, master data , KBA , LOD-ANA-ML , SAC Modelling , Problem