SAP Knowledge Base Article - Public

3045868 - Error: "dberror(PreparedStatement.executeUpdate): 301 - unique constraint violated: TrexUpdate failed on table ... " occurs when copying model to another folder on SAC

Symptom

  • Error: "dberror(PreparedStatement.executeUpdate): 301 - unique constraint violated: TrexUpdate failed on table ... " occurs when copying model to another folder on SAC
  • This issue happens on particular model
  • Error message in HTTP log (HAR file):
  1. message: "dberror(PreparedStatement.executeUpdate): 301 - unique constraint violated: TrexUpdate failed on table 'TENANT_B:sap.fpa.services.modeling.cube_::Cube_.CROSS_FORMULA' with error: unique constraint violation in self check for table TENANT_B:sap.fpa.services.modeling.cube_::Cube_.CROSS_FORMULAen, constraint='$trexexternalkey$', udiv='57,t.B.C6NSSWIQE2SS2IRXTT27QURG1S:C6NSSWIQE2SS2IRXTT27QURG1S;42,t.B.C6NSSWIQE2SS2IRXTT27QURG1S:DIVA_TM_AMT;7,9999996', pos=1497, indexname=_SYS_TREE_CS_#45956355_#0_#P0, rc=55"

Environment

  • SAP Analytics Cloud 2021.2.15

Reproducing the Issue

  1. Logon SAC.
  2. Copy model to another folder.

Cause

This issue is currently under investigation by development.

Resolution

This issue is currently under investigation by development.

See Also

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

Keywords

Copy model, 301 - unique constraint violated, particular model, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud all versions