When trying to open workbook with the Excel add-in you may encounter performance issues or even an error message:
Unexpected error in server communication; session needs to be closed
Message was: The remote server returned an error: (500) Internal Server Error.
Reproducing the Issue
- Logon to the ByD Excel Addin
- Select Open > All Workbooks
It takes a long time to open your workbook or even fails with the above error.
The workbook contains a report which has been designed in the ByD UI and has selection parameters which have been added via Add Fields in the report. This is not advisable as it consumes too much performance internally.
Instead if you want to add some characteristics as selections, you can do it in the report wizard itself. Please convert as many selections fields as possible of such report from Add Fields to selections via the Report wizard (Step 4 > Use as Variable) and then add this report into the workbook. This should improve the performance.
KBA , LOD-CRM-EMP , Employee , How To