Symptom
Error while trying to run reports from Excel using the SAP Add-In:
- Unexpected error in server communication; session needs to be closed
Message was: The remote server returned an error: (500) Internal Server Error.
(Exception System.Net.WebException)
Environment
- SAP Business ByDesign
- SAP Cloud for Customer
Reproducing the Issue
- Try to run reports from Excel using the SAP Add-In.
- SAP is failing to complete the download and giving me the following error message:
SAP Business ByDesign - Connect --- "Unexpected error in server communication : session needs to be closed. Message was: The remove server returned an error: (500) Internal Server Error. (Exception System.Net.WebException)"
Cause
SAP C4C has an add-in for Excel; which provides a chance to create/update business objects depending on needs. After installation if there is something corrupted in your template or on template's structure, eventually you will get the Error: (500) Internal Server Error as output.
Resolution
Please, follow the steps outlined in the post below:
SAP C4C Excel Add-In: (500) Internal Server Error Solution <https://community.sap.com/t5/crm-and-cx-blogs-by-members/sap-c4c-excel-add-in-500-internal-server-error-solution/ba-p/13352030>
Keywords
SAP Add-In; Excel; Unexpected error in server communication; 500 Internal Server Error; Reports , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Problem