Error calling ExcelConversionService.convertToExcel Failed to generate Excel file Internal Server Error

When trying to export to excel from any munis program, the following error is thrown:
Error calling ExcelConversionService.convertToExcel(): Failed to generate Excel file. Internal Server Error. Check error log for more info.

• Munis ERP

• Office Excel

• Mail Merge

The munisOfficeExcel and munisOfficeMailMerge Applications were configured as virtual directories.

Please note this error has additional potential causes: Munis Unable to Export to Excel - Error calling ExcelConversionService.convertToExcel Failed to generate Excel file Internal Server Error

1. Connect to the Application Server as tylerservice

2. Open IIS

3. Expand the Default Web Site 

4. Navigate the following directory: <env> → munis → munisOfficeMailMerge

   1. Can also be munisOfficeExcel if mail merge is not an issue

   2. Example: prod → munis → munisOfficeMailMerge

5. Right-click on munisOfficeMailMerge

   1. Note: This is ONLY if the mail merge shows as a file icon. If it shows as a globe icon, that means it is already an application. Proceed to additional information for further troubleshooting.

6. Select convert to an application

7. Select the <env>.munisOfficeMailMerge application pool

8. Click ok

If browsing to the munisOfficeMailMerge URL out of IIS and into a browser, it should throw a 500 error.

At the end of the URL, append /swagger and the API Calls will populate for testing.

• If the /swagger URL throws this error: HTTP Error 500.31 - ANCM Failed to Find Native Dependencies

  • Install server prequisites: Install Server Prerequisites in Tyler Deploy

  • If the issue persists after prerequisites are installed: Munis Unable to Export to Excel - Error calling ExcelConversionService.convertToExcel Failed to generate Excel file Internal Server Error