06-02-2021, 11:56 PM
(This post was last modified: 06-14-2021, 07:20 PM by alex.trejo@tttnet.com.mx.)
Delphi 10.2.3
IW 14.2.6
After migrating from IW10, our ISAPI dll is hanging after user exports a report to XLS (via EMS Advanced Data Export 4.16.0.2) and then terminates the session or TimeOut happen. Both events trigger a TerminateAndRedirect. No new users can log into the application and this problem is only resolved doing a recycle in IIS. We have tried everything possible and find no reason of this behaviour. This app had been working fine for years. The problem does not appear if running as exe, only as dll with IIS. We even tried going all the way to IW 15.2.20, same thing happens. Any help would be greatly appreciated.
UPDATE. We also use Templates in this app. Since the form that produces this report allows download of xls (via SendFile) Form LockOnSubmit is set to False.
Yesterday in one of our trial & error tests, we took the template of that form out and the error seemed to go away, but NO, it continues
UPDATE 2. We moved the QExport component from the UserSessionUnit where it originally was to the unit where the user generates the export. When the user exits that form after generating the XLS export the session of the user hangs, but the other logged in users can continue to work. When leaving the form there is a Form.Release, and there the session hangs. It seems that QExport component leaves something open that Intraweb cannot dispose of.
UPDATE 3. EMS, the makers of the component, say that it is not a problem of component, but something that IW is not able to handle. We are out of options.
Can you help us understand the problem and -most important - how to find the culprit and solve it?
Best regards.
IW 14.2.6
After migrating from IW10, our ISAPI dll is hanging after user exports a report to XLS (via EMS Advanced Data Export 4.16.0.2) and then terminates the session or TimeOut happen. Both events trigger a TerminateAndRedirect. No new users can log into the application and this problem is only resolved doing a recycle in IIS. We have tried everything possible and find no reason of this behaviour. This app had been working fine for years. The problem does not appear if running as exe, only as dll with IIS. We even tried going all the way to IW 15.2.20, same thing happens. Any help would be greatly appreciated.
UPDATE. We also use Templates in this app. Since the form that produces this report allows download of xls (via SendFile) Form LockOnSubmit is set to False.
Yesterday in one of our trial & error tests, we took the template of that form out and the error seemed to go away, but NO, it continues
UPDATE 2. We moved the QExport component from the UserSessionUnit where it originally was to the unit where the user generates the export. When the user exits that form after generating the XLS export the session of the user hangs, but the other logged in users can continue to work. When leaving the form there is a Form.Release, and there the session hangs. It seems that QExport component leaves something open that Intraweb cannot dispose of.
UPDATE 3. EMS, the makers of the component, say that it is not a problem of component, but something that IW is not able to handle. We are out of options.
Can you help us understand the problem and -most important - how to find the culprit and solve it?
Best regards.