2406669 - Error:"SERVER_ERROR_500 An error occurred in Connection Server service: GC overhead limit exceeded" occurs when trying to import large data from a BW connection to SAC

The following errors occurs when trying to import data from a BW connection/query in SAP Analytics Cloud (SAC):

• SERVER_ERROR_500 An error occurred in Connection Server service: GC overhead limit exceeded (max heap: #### MB)
• An internal server error occurred in SAP Analytics cloud agent: Result set is too large; data retrieval restricted by configuration

SAP Analytics Cloud

1. Configure SAP Analytics Cloud for On Premise data acquisition.
2. Create a connection to an On Premise data source.
3. Attempt to acquire data from the On Premise data source.
4. Notice the error.

The Java Virtual Machine hosting the SAP Analytics Cloud Agent service is unable to garbage collect effectively.

Increase the "-Xmx" setting for the Tomcat server hosting the SAP Analytics Cloud Agent.

If using Windows complete the following steps:

1. Navigate to /<Tomcatinstallationdirectory>/bin/Tomcat8w.exe and click Java - Java Options. 
2. Change Initial Memory Pool to at least 1024MB
3. Change Maximum Memory Pool to at least 2048MB.

Alternatively, in this example "-Xmx" is increased to "2048 MB". The specific value should be based on your available memory.

1. Browse to your Tomcat bin directory
2. On Linux notice "catalina.sh" and look for "setenv.sh"
• Create or edit existing setenv.sh
• Add line export CATALINA_OPTS="$CATALINA_OPTS -Xmx2048m"
• Save setenv.sh
• Start Tomcat using command catalina.sh run and notice the updated value of -Xmx
3. On Windows notice "catalina.bat" and look for "setenv.bat"
• Create or edit existing "setenv.bat"
• Add line set CATALINA_OPTS="%CATALINA_OPTS% -Xmx2048m"
• Save "setenv.bat"
• Start Tomcat using command "catalina.bat" run and notice the updated value of -Xmx

• 2450684 - An error occurred in the BW service: GC overhead limit exceeded when running an import in SAP Analytics Cloud
• How to find User Assistance for SAP Analytics Cloud?
• Ask a question on the SAP Community!
• 2487011 - What information do I need to provide when opening incidents with SAP Analytics Cloud (Hint: Use component LOD-ANA*)
• SAP Analytics Cloud > Learning > Guided Playlists

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

EPM, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, loud for Planning, EPM-ODS, Cloud for Analytics, C4P, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, HCP, C4A, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJ, BOBJcloud, BOCloud., BICloud, BO Cloud, tomcat, java, jvm, jdk, memory, gc, garbage collection, sac , KBA , to release memory , the -xmx setting from the java tab. , -xmx sac sap analytics cloud , launch tomcat configuration and update t , LOD-ANA , SAP Analytics Cloud (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predictive , Problem