SAP Knowledge Base Article - Public

3544378 - Issue refreshing public dimension tables

Symptom

When refreshing a public dimension table the following error is displayed:

  • "XXXX : Failed to execute SELECT * FROM \"EXTERNAL_SERVICE_STAGING\".\"sap.fpa_data::0154268e0568415c98f423dd8c821aa1\" WHERE IS_HEADER_ROW_INDICATOR=1. Component = HdbConnection. Reason = invalid table name: Could not find table/view sap.fpa_data::0154268e0568415c98f423dd8c821aa1 in schema EXTERNAL_SERVICE_STAGING: line 1 col 43 (at pos 42)"

Environment

SAP Analytics Cloud

Reproducing the Issue

  1. Open a public dimension table of your choice
  2. Go to Data Management
  3. Run a refresh job

Cause

This issue was caused by a product defect.

Resolution

This was fixed in a subsequent Analytics patch.

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, sap analyst cloud , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem

Product

SAP Analytics Cloud all versions