SAP Knowledge Base Article - Public

2776708 - An unexpected technical error occurred when trying to publish a private version to a public version in an audit enabled model in SAP Analytics Cloud

Symptom

The following error occurs when trying to publish a private version to a public version in a data audit enabled model in SAP Analytics Cloud (SAC):

  • Sorry, we were unable to publish data from version "" to "" - Error
  • An unexpected technical error occurred

This error occurs in the Chrome developer tools:

{code: "1000", message: "An unexpected technical error occurred.", details: [{code: "43033",…}]}
code: "1000"
details: [{code: "43033",…}]
0: {code: "43033",…}
code: "43033"
message: "An error occurred during the execution of the EPM command 'action': [

{"Number":43033,"Type":2,"Text":"SQL : 'INSERT INTO \"TENANT_5\".\"t.5.Sales_Planning::AUDT_Sales_Planning\" ( \"Version.ID\", \"Account.ID\", \"Time.CALMONTH\", \"Audit__time\", \"Audit__user\", \"Audit__old__SignedData\", \"Audit__new__SignedData\", \"Audit__delta__SignedData\", \"Audit__flag\") SELECT \"Version.ID\", \"Account.ID\",\"Weeks.ID\", \"Datasource.ID\", \"Time.CALMONTH\", \"Audit__time\", \"Audit__user\", SUM(\"Audit__old__SignedData\") AS \"Audit__old__SignedData\", SUM(\"Audit__new__SignedData\") AS \"Audit__new__SignedData\", SUM(\"Audit__delta__SignedData\") AS \"Audit__delta__SignedData\", SUM(\"Audit__flag\") AS \"Audit__flag\" FROM \"_SYS_EPM_DATA\".\"3::2019-04-03 15:12:24.7930000::PDC:2::INTERNAL u:5_USER v:2 m:/t.5.Planning/Planning s:TENANT_\" GROUP BY \"Version.ID\", \"Account.ID\",\"Time.CALMONTH\", \"Audit__time\", \"Audit__user\" WITH HINT (NO_CALC_VIEW_UNFOLDING)' failed: maximum number of rows per table or partition reached: 'TENANT_5:t.5.Planning::AUDT_Planning' at /sapmnt/../trex_update.cc:3717"}]"

message: "An unexpected technical error occurred."

Environment

  • SAP Analytics Cloud 2019.6

Cause

Data auditing is enabled in the model and the audit table size was exceeded.

Resolution

This issue is currently under investigation by Development.

Workaround:

Temporarily disable auditing (Data Audit OFF) for the model in the Access and Privacy section of the Model Preferences.

See Also

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

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics , KBA , LOD-ANA , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , Problem

Product

SAP Analytics Cloud 1.0