SAP Knowledge Base Article - Public

2908834 - "A bad request was made to SAP Analytics Cloud agent" error happens when trying to import large data set from SAP Universe in SAP Analytics Cloud

Symptom

  • "A bad request was made to SAP Analytics Cloud agent" error happens when trying to import large data set from SAP Universe in SAP Analytics Cloud
  • The error is seen when the data set is large (e.g. 300,000 rows * 100 columns). If the data volume is small then no error happens.

Environment

  • SAP Analytics Cloud (Enterprise) 2020.2
  • SAP Analytics Cloud Kit 1.0.269

Reproducing the Issue

  1. Set and configure Import universe connection in SAP Analytics Cloud.
  2. Create a Import Universe query, make sure the query will return big data volume. (e.g. more than 300,000 rows and 100 columns)
  3. Run the query and finally the query failed as A bad request was made to SAP Analytics Cloud agent

Cause

For the Tomcat where SAP Analytics Cloud Agent is deployed, the parameter Maximum memory pool is too small to allow big data acquisition.

Resolution

Increase the Maximum memory pool parameter of Apache Tomcat to higher value.

Refer 2450684 to which documented the same solution.

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, big, large, huge, million, count , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0