Symptom
- {"code":null,"message":"Internal Server Error","details":null} message arises in SAP Analytics Cloud (SAC) while trying to examine data in a story on top of Live BW model.
- Widgets in SAC show: "Unable to retrieve data from the datasource".
- Complex BW query is being executed with large amount of data, but no dump or HTTP(S) error seen on NW backend.
- Errors coming in Chrome Developer Tool:
- GetResponse requests return with status code: "500 Internal Server Error"
- and with error message "500 Connection Timed Out"
Environment
- SAP Analytics Cloud
- Live Data model on a NetWeaver based backend system
Reproducing the Issue
- Add the Live Data model to a story.
- Create a chart and observe the error.
Cause
- Due to refreshing large amount of data (depending on the volume, capacity of server...), the ICM processing (PROCTIMEOUT) timeout setting is set too low.The processing timeout specifies the timeout between sending an HTTP request and receiving an HTTP response.
- The ICM processing timeout setting (PROCTIMEOUT) defines the processing timeout for communicating with the back end (work process) and needs to be kept alive during this period of time for processing. For more information refer to: Configuration of the Web Dispatcher Server Port
Resolution
- Increasing the "TIMEOUT" and "PROCTIMEOUT" will keep the connection open.
- Refer to SAP Note 824554 related to ICM and SAP Web Dispatcher Timeout Parameters and Timeout Options for ICM and Web Dispatcher for more information.
See Also
- 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*)
Your feedback is important to help us improve our knowledge base.
Keywords
SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, code, null, message, Internal Server Error, details, null,large , ICM, PROCTIMEOUT, HTTP, icm/conn_timeout , KBA , LOD-ANA , SAP Analytics Cloud (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , BC-CST-IC , Internet Communication Manager , Problem