We've been getting weird errors in our sites. I just can't explain it.. If
this was a previous version of coldfusion I would've guessed some problem
with locking, but from what I've read, you don't need to lock anymore as
much in MX.
We have a few pages that consistently show up in error logs (our own catch
all log). And I can't reproduce the error, although it's happened to me on
a few occasions. Basically a page would crash saying some variable is not
defined. Upon refresh, everything is fine.
We use application scoped cfc for database access. Those are set upon
application startup and not reloaded until I say so.
The page would make a call to the cfc to get the data (as a query). Then it
goes through that query and does whatever is needed.
An error is saying that a certain field is not defined in a query (it's
always in the select statement). The latest error I got was
Element HTMLDATE is undefined in HTML.
The call to the CFC is
<cfinvoke component="#application.cfcHtml#"
method="getHtmlContent"
returnVariable="html"
groupId="#request.thisSes.site.groupId#"
htmlTypeId="#variables.intelCenter.htmlTypeId#"
rowCount="999"
orderBy="htmlDate"
getText="1">
The code where the crash occurs is
#dateFormat(dateAdd('s', html.htmlDate, application.startDate),
'mm.dd.yyyy')#<br>
The query is
select top #arguments.rowCount#
h.htmlId,
h.htmlText,
h.htmlTypeId,
h.htmlDate,
h.name as htmlName,
<cfif
val(arguments.getTextExcerpt) or val(arguments.getText)>
h.htmlTextExcerpt,
</cfif>
<cfif
val(arguments.getText)>
h.htmlText,
</cfif>
h.isActive,
h.sysCreationDate,
h.sysModDate,
ht.name as htmlTypeName,
h.homepageShow,
h.isArchived
from
htmlMVC as h with (nolock)
<snip>
As you can see the htmlDate is always selected. I don't understand why it
would sometimes fail? Any suggestions, comments would be appreciated.
Russ
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210974
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
