I have an application hosted at Windows server 2008R2
with IIS7
with MS Excel2013 32bit
.
This application uses Excel application to convert excel sheets to webpages.
It works fine until user keeps using it.
but if no user uses application for an hour or two and use it again the application throws error while opening excel application
And if I restart IIS it starts working fine.
here is the exception I get
System.Runtime.InteropServices.COMException (0x8000401A)
I am not being able to figure out the reason behind it.
This is a common issue with Web applications when not initialized after receiving of the first request started. Try the following
Create a scheduled task to start the application if it is not already running. such as through powershell
$appPath = "c:\mypath"
& $appPath "arg1"
Install Always Running assuming you have IIS 7.5
User contributions licensed under CC BY-SA 3.0