Are you sure that the app on production is submitting the right date when the user selects "May 1st, 2004" ??
Brian
From: Earl, George
To: CF-Talk
Sent: Monday, June 21, 2004 8:31 AM
Subject: Unresponsive requests - very strange
I have a very strange and frustrating problem -
We are running CF 5.0 on Windows 2000, Oracle 8i, and the Merant ODBC
drivers that ship with CF (we have had problems with the Oracle native
drivers).
We have a reporting application that submits requests with 5 queries to
Oracle and then massages the answer sets into a report before sending it
back to the browser.
There are 7 x 4 x 4 x 3 different ways the reports can be requested (by
choosing different combinations of radio buttons and dates from dropdown
boxes), and all work fine except for one report which will time out every
single time ONLY on our production web server and ONLY when using week and
month ending dates starting this past May . . .
I can run the problem report from our production web server, accessing
production data, with any dates after April 30 and it will time out every
time and write an unresponsive request message in the server.log file. Dates
before May 1 work fine.
I can run the problem report from our development and integration servers,
also accessing production data, with any dates after April 30 (and before
May 1) and it works fine every time!
So it appears that the problem is not with the data.
I have compared cfm and date files between the different environments using
WinMerge and everything appears to be identical except for the expected
differences in references to data sources in the different environments . .
. and when I switch these differences to point to production data, the
reports work.
So it appears it is not something in the code.
Any thoughts on what might be causing this problem ONLY on the production
server and ONLY with dates starting on May 1? Where would you look next to
try to find the source of this problem?
Thanks!
George
[EMAIL PROTECTED]
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
