SAP Knowledge Base Article - Public

3033754 - Connection Times out when importing a large amount of data to a model in SAP Analytics Cloud (SAC)

Symptom

In SAP Analytics Cloud, when a user imports data into a model via the interactive workflow, if the data volume is large and the system is under load, the browser may display an error message of “Application Server Error”.  This error occurs because the HTTP connection between the browser and the SAC service is disconnected when the processing of the import takes longer than the timeout period.

Environment

  • SAP Analytics Cloud (Enterprise) 2021

Reproducing the Issue

  1. Create a new model
  2. Choose a large amount of data
  3. Get the error "Application Server Error" 

Cause

When this issue occurs, the backend processing of the data import will continue even though the HTTP connection is dropped.  As such, it is advised that the user do the following:

  1. Exit the user interface
  2. Wait for a few minutes
  3. Come back to the model to check whether the imported data is effected in the model. 

    During this period of time, the user should not open the draft data source to attempt another import.

Resolution

It is also recommended to use a background job instead of the interactive workflow for large amounts of data.  Either schedue a job to run at specific time, or using the refresh job operation.  For data coming from files, consider putting the files on File Server or Google Drive, as both of these storage method support scheduling of data import jobs.

See Also

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

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, import, connection, time, out , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0