Symptom
- Scheduled BW loads are failing from SAC with “SAP Analytics Cloud error : {"errorCode":"PLUGIN_ERROR","isUserError":false}Correlation ID: FCF59E60-29B4-4055-aE10-7D5307A86B218B”
Environment
- SAP Analytics Cloud (Enterprise) 2021.7.19 (Client) and 2021.7.17 (Server)
Reproducing the Issue
- Log on to the SAC tenant
- Search x model
- Switch to Data management.
=> The following error can be observed in the job history.
“SAP Analytics Cloud error : {"errorCode":"PLUGIN_ERROR","isUserError":false}Correlation ID: FCF59E60-29B4-4055-aE10-7D5307A86B218B”
Cause
- The cloud agent runs out of memory when acquiring large queries from BW to SAC
- Older versions of the cloud agent prior to 1.0.303 showed relatively bad scaling and the only way to import larger data sets was by increasing the BW result set size limit and also the memory of the tomcat server.
Resolution
- Update the cloud agent to the latest version (version 1.0.303 or later version)
- From version 1.0.303 on, we use the BW result set size limit to restrict the amount of data loaded by the cloud agent to 5 million cells at a time. If that limit is exceeded, the values of each characteristic will be read separately and used a filter values to split the fill data set into smaller chunks. With this improved read behavior, the stability, scalability and resource consumption of BW acquisition could be improved. In particular, the cloud agent is able to acquire large data sets with the default result set size limit of 500,000 data cells (key figure values) with relatively low memory settings in the 1 GB range.
- Although we still recommend allocating more memory to the cloud agent to allow parallel processing of several requests.
See Also
- 569847 - 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?
- Search for SAP Analytics Cloud content using Google or Bing:
- https://www.google.ca/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
- https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
- Note: Add relevant text or warning/error messages to the text search field to filter results.
- SAP Analytics Cloud > Learning > Data Connections
- 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, sap analyst cloud, connected, failure, stopped, sap analyst cloud , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem