Hoping someone can give me a little bit of help with a application crash/timeout using IIS. The below works fine using stand-alone deployment - this is only an issue in my production IIS environment. ekkkk (please help)
This is reproducible every time I do the same operation - which is using a component to export a dataset to excel (the component is EMS Advanced data export)
All I do is call execute on this component to take what I have in the dataset (5 records) and output it to excel.
I have one modal form - with the export component and a grid - all code is local to the form, apart from the dataset which is located on a datamodule.
This application has EnableSynchronousOperations := true;
I am using SSL https
1.All records are outputted correctly to the excel file (xlsx) and the file exist where I expect on the file system. It opens perfectly well.
2.As soon as the .execute method is called, I immediately call UniSession.SendFile(_FilePath, ExtractFileName(_FilePath)); This also excutes and allows me to "download" the xlsx and the contents is fine.
3.It is at his point the application becomes unresponsive, I call modalresult := mrok on the form and nothing happens.
This is the error I am getting from windows event viewer -