Recently, my ColdFusion application.log has started showing a few messages
like this:
"Error","TID=1060","08/28/02","09:42:04","CFSCHEDULE","unknown exception
condition<P> PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag<p>The
error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (167:4) to (167:79) in the template
file EYOSCHEDULER.CFM.</p><P><P>Date/Time: 08/28/02 05:00:31<BR>Browser:
CFSCHEDULE<BR>Query String: RequestTimeout=5000<P>"
Some further analysis shows that at the same time that the error was logged
in my coldfusion server application.log file, there was also an entry in my
Win 2K server's event viewer application.log file :
Event Type: Information
Event Source: DrWatson
Event Category: None
Event ID: 4097
Date: 8/28/2002
Time: 9:42:09 AM
User: N/A
Description:
The application, , generated an application error The error occurred on
08/28/2002 @ 09:42:09.323 The exception generated was c0000005 at address
00000000 (<nosymbols>)
I am running CF 4.5.1 SP2 Professional on Win 2K Server, with IIS 5 and SQL
2000 DB. However, it doesn't have the latest version of MDAC
installed on it. Could that be causing these errors to happen ? Should I
install the latest MDAC on my production web server ?
A search on the ColdFusion Support Forums also shows me the above pcode
errors may happen due to not using the cflock tag.
"Whenever you access (read or write) Application, Server, or Session
variables in an application, you should use the CFLOCK tag. CFLOCK provides
borders around the variable access, which in turn ensures the integrity of
shared data. Using CFLOCK guarantees that multiple concurrently executing
requests do not manipulate shared data structures, files, or CFXs in an
inconsistent manner."
The template in the above case reads a few application variables and
repeatedly calls a CFX tag (upto 5000 times), as follows :
<cfquery name="generalquery" datasource="#dns#" username="#ua#"
password="#pwd#">
------ query goes here ---
</cfquery>
where #dns#, #ua# and #pwd# are application variables defined in my
application.cfm file.
<cfloop query="generalquery">
--- cfx tag call goes here ---
</cfloop>
Should there be a CFLOCK around :
a) the cfquery declaration ?
b) the cfx call ? Note that the same CFX tag is used by other applications
on my website as well.
c) Each of them ?
Hope someone can help me on this one.
Vishal.
______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
