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
- Set and configure Import universe connection in SAP Analytics Cloud.
- Create a Import Universe query, make sure the query will return big data volume. (e.g. more than 300,000 rows and 100 columns)
- 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
- 3243214 - Unable to acquire data from SBOP BI Universe when using SAP Analytics Cloud Agent (or Simple Deployment KIT) version 1.0.353/1.0.354 and higher
- 2450684 - An error occurred in the BW service: GC overhead limit exceeded when running an import in SAP Analytics Cloud
- 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
- Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
- 2487011 - What information do I need to provide when opening an incident for SAP Analytics Cloud?
- SAP Analytics Cloud > Learning > Guided Playlists
- SAP Analytics Cloud > Learning > Guided Playlists > Getting Support
- Need More Help? Contact Support or visit the solution finder today!
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