Skip to main content
A
Anonymous
January 28, 2010
Question

ColdFusion8 Request Completes In Server Monitor But Never Returns In The Web Page?

  • January 28, 2010
  • 3 replies
  • 937 views

Good Morning,

I have a Web-based report that is run at the end of each semester and compiles a lot of student data. When I make a request to the page, the Cold Fusion Admin Server Monitor shows the queries complete, then shows the request complete soon after at about 450 seconds, but the page never returns in IE (the browser tab continues to show a spinning circle for about an hour). Most of the time is taken up by one particular loop of dynamically generated queries to an Oracle DB. The generated sql runs perfectly from another program when I retrieve the sql from the Server Monitor. The Cold Fusion server responds to my other requests when I open other CF Web sites hosted by this server, so I know the server is not hung. I have request timeouts set in Application.cfm and again at the top of the report template to 4800 seconds. Session timeout is set to 100 minutes. The loop of queries is within a try/catch and the catch is set to email me the cfcatch data (which also worked well when I was designing and testing the sql).

Do you know why the page never returns?

Thanks For Your Time,

Nate

    This topic has been closed for replies.

    3 replies

    BKBK
    Community Expert
    BKBKCommunity Expert
    Community Expert
    January 30, 2010

    Some things to do, that might possibly help:

    1) Verify that your application is using the Application.cfm that you think it is. In fact, consider converting to Application.cfc.

    2) Turn debugging off in the Coldfusion Administrator.

    3) Switch server monitoring off in the Administrator.

    A
    Adam Cameron.
    Inspiring
    January 28, 2010

    What web server are you using?  I presume IIS or Apache.  What happens if you try the same request via the inbuilt JWS?

    Do you get the same thing in your dev environment as on your live environment?

    Is there anything in the CF or JRun logs indicating a problem with the request?

    --

    Adam

    A
    Anonymous
    January 29, 2010

    I am using IIS 6.0. I have not tried the inbuilt JWS - are referring to a non-IIS, Java Web Server that comes with ColdFusion8, or do you mean "Java Web Start" which I have not used? If Java Web Start, how would I run the request?  I get the same behavior in my test and production environment - both CF8. The Last Modified dates on the CF Logs all show dates of a few days ago or older, so no help there (Debugging & Logging > Log Files). I found nothing in the JRun logs (C:\ColdFusion8\runtime\logs) or W3SVC logs (C:\Web Logs\W3SVC1) of any concern. I can run the report and get a successful response when I limit to a particular subject, which cuts the amount of possible data about in half when compared to not limiting to a particular subject.

    Thank You,

    Nate

    A
    Adam Cameron.
    Inspiring
    January 29, 2010
    I am using IIS 6.0. I have not tried the inbuilt JWS - are referring to a non-IIS, Java Web Server that comes with ColdFusion8,

    Yes.  The JRun Web Server.  The one that ships with JRun.   I just want to rule out the possibility of it being a problem with communications between CF and the web server.

    --

    Adam

    D
    Dan_Bracuk
    Inspiring
    January 28, 2010

    You might be returning more data than the browser can handle.

    A
    Anonymous
    January 29, 2010

    What is the limit of data the browser can handle? I searched and found perhaps a max buffer (or total limit?) of 4MB but that looks like an ASP limit and not an IIS 6.0 Web server limit.  I can run the report and get a successful response when I filter to a particular subject. I have a version of the report that preceded this one and which I built this new report from, and the largest single file when I run the previous report becomes a *.htm file at 5,052 KB (via IE > Save As > Web Page Complete). The new report is designed to be a moderate fraction of the size of the previous report, and I expect it to be less than 5,052 KB. In testing I limited to a particular subject representing about half of the possible data and the size of the largest file in the newer report is 689 KB.

    Anything I am overlooking?

    Thanks,

    Nate

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices