Skip to main content
A
Anonymous
May 26, 2006
Question

Page not found error

  • May 26, 2006
  • 2 replies
  • 223 views
I've just upgraded from CF 5.0 to CF MX 7.0. One of my CF scripts that includes looping through a DB query does not work well anymore. Under CF 5.0 on Win 2K it worked fine. Now under CF MX 7.0 on Win 2003 it starts off fine (displays page header) but then seems to timeout and then browser displays a page not found error. If I then run it again right away, it works fine. I know the query takes a long time (large DB with a complex view).

I've tried changing the query timeout, and I've turned off the timeout in CF administrator, but I still get the same problem.

There must be some IIS 6.0 setting that needs to be changed. I've played with some settings in the metabase, but they had no effect either.

Has anyone seen this problem before? If so, what was the cure?

Thanks.

Lloyd.
This topic has been closed for replies.

2 replies

D
Dan_Bracuk
Inspiring
May 29, 2006
Now that I see how you solved it, we have experienced something similar. What we found was, on long jobs, if the browser has nothing to do for a couple of minutes, it will send another http request and the job starts again. We solved our problem with the occasional flush.

In your case, flushing a space each time through the loop might give you more spaces than you really want on the final web page. You might want to use the mod operator to reduce the flush to every hundreth iteration or so.
A
Anonymous
May 27, 2006
I found a solution by flushing a space out to the browser for every loop through the query. That seems to keep the browser from timing out. Go figure.

Thanks.

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