SAP Knowledge Base Article - Public

3290741 - Unable to export a table after the SAP Analytics Cloud (SAC) upgrade

Symptom

The following behavior occurs in SAP Analytics Cloud (SAC):

  • When you try to export a table to csv or excel from a story, you get error "The current widget is already exporting, or there are more than 20 exports started. Please wait for a few minutes and try again."
  • In case you don't get the above error, SAC shows an alert under notification as the report is exporting 0% and nothing happens even after 30 mins. So you have to click on cancel eventually.
  • This table is with the BW live connection or BPC live connection.
  • This issue happens after the SAC version upgrade

Environment

  • SAP Analytics Cloud (Enterprise) 2022, 2023
  • SAP Business Warehouse

Cause

The root cause of the issue is an incorrect "parent index" (required to render hierarchical structures) returned by the BW server and a recent change in the table grid export on client side. Both together ends up in an endless Javascript loop.

The issue becomes observable with recent SAC version update because with older versions the "parent index" was not used on client side at all.

Resolution

Install the BW note 3041816 - INA: Incorrect parent indexes for flat presentation (value instead of -1) in the BW system.

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, Sac, Acquisition, Model, Connect, Story, Tenant, Import, Failed, Using, Working, 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, https://hcs.cloud.saphttps://hanacloudservices.cloud.saphttps://cloudanalytics.accounts.ondemand.comhttps://hanacloudservices-us.accounts.ondemand.comhttps://www.sap.comhttps://help.sap.com, predictive analytics (analysis), data analysis (analytics) tools, analytics tools, sap analytics cloud, data literacy, advanced analytics, data democratization, analytics software, real time analytics, self service analytics, advanced data analytics, analytics as a service, analytics cloud / cloud analytics, saas analytics, cloud bi, enterprise planning, cloud data analytics, cloud based analytics, analytics cloud platform, modern analytics, real time analysis, cloud analytics solution(s), what is sap analytics cloud, cloud analytics tools, analytics in the cloud, cloud analytics software, .csv, point of view, exporting, all, local file, progress, hung, hang, loop , KBA , LOD-ANA-TAB , Table , LOD-ANA-DES , Story Design & Visualizations , BW-BEX-OT-BICS-INA , BW INA provider , Problem

Product

SAP Analytics Cloud 1.0