SAP Knowledge Base Article - Public

3088798 - "502 Bad Gateway" error when you paste huge numbers of cells into a story in SAP Analytics Cloud for Planning (SAC)

Symptom

The following error occurs in SAP Analytics Cloud for Planning (SAC):

  • When you paste a huge number of cells at once in a story, after several minutes, you see an error "502 Bad Gateway: Registered endpoint failed to handle the request."

Environment

  • SAP Analytics Cloud (Enterprise) 2021.14.2

Reproducing the Issue

  1. Open a story.
  2. Copy large amounts of values from an Excel file and paste into this story.

Cause

The specific paste operation that you are trying to perform is very large and therefore takes a lot of time to be processed. Unfortunately such large operations may run into a timeout so you see the error.
However, the database still continues processing the task until it's done. You will see the successful result when you refresh the view manually after a few minutes.

Resolution

You will see the successful result when you refresh the view manually after a few minutes.
However, our advise is to split your operation into smaller chunks, i.e. just paste half of the columns at once and afterwards paste the second part of your data. This should be sufficient to finish the task within timeout.
Furthermore, if your workflow does not require to process the data in an external tool, we would suggest to use the mass data entry feature, which is intended to change many data cells individually and then have them processed in one go at the end.

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, Sac, Acquisition, Model, Connect, Story, Tenant, Import, Failed, Using, Working, copy and paste, pasting, input data, enter data, mass data entry mode, process data, cannot get data from the datasource, data source , KBA , LOD-ANA-PL-DIS , Distribute, Spreading, Assign, Copy & Paste , LOD-ANA-PL-DE , Data Entry and Mass Data Entry , Problem

Product

SAP Analytics Cloud 1.0