We were running the BA Execution Server on a Windows 2012 VM in three environments (Test, Acceptance and Production).
In the Test environment we upgraded the Windows Server 2012 to Windows Server 2019 and the BA Execution Server was running like a dream.
Unfortunately, after doing the same upgrade in the Acceptance environment (2012 to 2019), the BA Execution Server will start, but reports are not fully rendering. We get the same error message each and every time:
Error occured when opening report: System.Runtime.InteropServices.COMException (0x800A03EC): Microsoft Excel cannot access the file 'C:\IFS_BAES\Work\1064471\SER_1.xlsx'. There are several possible reasons:
• The file name or path does not exist.
• The file is being used by another program.
• The workbook you are trying to save has the same name as a currently open workbook.
at Microsoft.Office.Interop.Excel.Workbooks.Open(String Filename, Object UpdateLinks, Object ReadOnly, Object Format, Object Password, Object WriteResPassword, Object IgnoreReadOnlyRecommended, Object Origin, Object Delimiter, Object Editable, Object Notify, Object Converter, Object AddToMru, Object Local, Object CorruptLoad)
at Ifs.Application.BusinessAnalytics.Rendering.ReportRenderer.MergeDsrdtoExcelFile()
Has anyone ever come across the same error and if so, how was it solved?
After connecting the Test BA Execution Server to the IFS Acceptance environment the same report does get rendered.
Any suggestions are more than welcome.
