SAP Knowledge Base Article - Public

2749953 - Error when clicking Data Manipulation mode based on an .xlsx document in SAP Analytics Cloud & SAP Digital Boardroom

Symptom

The following error message occurs in SAP Analytics Cloud (SAC) when clicking on Data Manipulation Mode on a model based on an .xlsx document:

  • dberror($.hdb.Connection.executeQuery): 391 - SQL error, server error code: 391. invalidated view:

Environment

  • SAP Analytics Cloud 2019.1.1

Reproducing the Issue

  1. Log in to SAP Analytics cloud
  2. Create a story based on an .xlsx document
  3. In the story, click data view
  4. Select the datasource and click Data Manipulation Mode
  5. Observe the error

Cause

This issue is currently under investigation by Development.

Resolution

Recreate the model making sure that a measure is selected.

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 (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predicitive , Problem

Product

SAP Analytics Cloud 1.0