Hi All,
I have a server based application created in Delphi which allows the client to download financial reports from my web page. The reports are created according to the inputs (Start and End Date) supplied by the user. If the user requests information for a large period of time (say over 3 months of data) the web server causes the ‘HTTP 500 Internal Server Error’. However data requested for three months or less works fine. The server based application does take a long time (2-4 min) to create these reports as it goes through several functions and procedures.
If I were to remove certain functions or procedures from the main code it works regardless of the time period and creates the reports for the user to download. However these functions/procedures are required to create the complete report and hence cannot be omitted from the code. What i don’t understand is the fact that this works when data is requested for short interval of time and not for longer intervals which takes nearly 4 min to bring the HTTP 500 Internal Server Error web page. It looks like when the server based application is called to create the report (which it does – the loading bar at the bottom of Internet explorer progress slowly ) it runs in the background and finally when its ready to be send as an attachment for the user to download it loses its Response property or something.
I have been playing with this for over a week to find a way around this problem. Does anybody have any idea on how I can over come this issue?
I use Apache HTTP server.
Regards,
Vinzmen
I have a server based application created in Delphi which allows the client to download financial reports from my web page. The reports are created according to the inputs (Start and End Date) supplied by the user. If the user requests information for a large period of time (say over 3 months of data) the web server causes the ‘HTTP 500 Internal Server Error’. However data requested for three months or less works fine. The server based application does take a long time (2-4 min) to create these reports as it goes through several functions and procedures.
If I were to remove certain functions or procedures from the main code it works regardless of the time period and creates the reports for the user to download. However these functions/procedures are required to create the complete report and hence cannot be omitted from the code. What i don’t understand is the fact that this works when data is requested for short interval of time and not for longer intervals which takes nearly 4 min to bring the HTTP 500 Internal Server Error web page. It looks like when the server based application is called to create the report (which it does – the loading bar at the bottom of Internet explorer progress slowly ) it runs in the background and finally when its ready to be send as an attachment for the user to download it loses its Response property or something.
I have been playing with this for over a week to find a way around this problem. Does anybody have any idea on how I can over come this issue?
I use Apache HTTP server.
Regards,
Vinzmen