5 Replies Latest reply on Feb 11, 2007 7:40 AM by BKBK

    60 seconds timeout

    EmmanuelRuiz
      I am running a code that stores data in memory and then queries a DB via a QofQ.

      After exactly 60 seconds I get an error of type: "Page cannot be displayed"....I have researched this type of error and cannot find anything relevant.

      Any clues. I have tried adding the default cfadmin timeout to e.g. 180 to no avail.

        • 1. Re: 60 seconds timeout
          Dmadzia Level 1
          60 seconds is the default Page timeout. If your queries are taking longer than 60 seconds, then you have a problem. You need to add indexes to the DB or you are loading too much data/too many records.

          To get around this timeout, you can append the variable RequestTimeout to the page link as in
          MyQuerypage.cfm?RequestTimeout=300
          where 300 is the number of seconds or in your page, add:
          <cfsetting RequestTimeout = "300">

          Hope that helps.
          • 2. Re: 60 seconds timeout
            EmmanuelRuiz Level 1
            I've already tried that. It does not seem to take it into account.
            • 3. Re: 60 seconds timeout
              Level 7
              To get around this timeout, you can append the variable RequestTimeout
              to the page link as in MyQuerypage.cfm?RequestTimeout=300 where 300 is
              the number of seconds or in your page, add: <cfsetting RequestTimeout =
              "300">


              I just want to clarify that the ?RequestTimeout=xxx option has be
              deprecated in the latest versions of CF in favor of the <cfsetting
              requestTimeout = xxx> option. So, unless you are using an older version
              of CF, you should use the latter option.
              • 4. Re: 60 seconds timeout
                Level 7
                > After exactly 60 seconds I get an error of type: "Page cannot be
                > displayed"....I have researched this type of error and cannot find anything
                > relevant.

                Is this in IE? You might want to switch off "friendly error messages" to
                see if it gives you anything better.

                I'd also break down your code to find out which bit is causing the timeout.


                > num6,num10,num14,num21,num25,num29,num36,num40,num44,num51,num55,num59,num66,num
                > 70,num74,
                > num4,num7,num11,num13,num15,num17,num19,num16,num1,num12,

                Jeez. That's an interesting schema you've got there. It doesn't *look*
                very normalised. Is it? Could it be (more ~)?


                > <cfloop query="getRec">

                How many records is this likely to be?

                --
                Adam
                • 5. Re: 60 seconds timeout
                  BKBK Adobe Community Professional & MVP
                  > After exactly 60 seconds I get an error of type: "Page cannot be displayed"
                  "Exactly 60 seconds" most likely means that, in the Coldfusion Administrator, Server Settings => Settings => Timeout Requests after(seconds) is configured to 60. Delete all the timeout attributes, for example, in cfquery tags, clear the caches in the Coldfusion Administrator and set the request timeout to an appropriate value.

                  > I have tried adding the default cfadmin timeout to e.g. 180 to no avail.
                  Did you press the button to Submit Changes? Restart Coldfusion to refresh everything? As a last, nay, desperate, measure, you could edit the system file C:\CFusionMX7\lib\neo-rumtime.xml. Set the value of timeoutRequestTimeLimit to 180.0