SAP Knowledge Base Article - Public

3456536 - Error while trying to run reports from Excel using the SAP Add-In

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

  1. Try to run reports from Excel using the SAP Add-In.
  2. 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

Product

SAP Business ByDesign all versions ; SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications all versions