Status/Resolution/Reason: Closed/Fixed/
Reporter/Name(from Bugbase): Hee Lee / Hee Lee (Hee Lee)
Created: 06/30/2016
Components: Caching
Versions: 11.0
Failure Type: Crash
Found In Build/Fixed In Build: CF11_Final /
Priority/Frequency: Critical / All users will encounter
Locale/System: English / Windows 7 SP1
Vote Count: 0
Problem Description:
Application.cfc:
...
<cfset application.gateway.gwFrqntData = createObject("component","#application.cfcpath.gateway#.FrqntDataGW").init()>
...
FrqntDataGW.cfc:
<cfcomponent>
<cfquery name="rsSiteCdLst" datasource="#application.datasource#" cachedwithin="#CreateTimeSpan(1,0,0,0)#" >
select distinct OfficeCode as sitecd
from view_office
order by OfficeCode
</cfquery>
</cfcomponent>
Steps to Reproduce: Not able to reproduce
Actual Result: Exception as follows:
Message: Variable RSSITECDLST is undefined.
StackTrace: coldfusion.runtime.UndefinedVariableException: Variable RSSITECDLST is undefined. at coldfusion.runtime.CfJspPage._get(CfJspPage.java:314) at coldfusion.runtime.CfJspPage._get(CfJspPage.java:298) at coldfusion.runtime.CfJspPage._autoscalarize(CfJspPage.java:1532) at coldfusion.runtime.CfJspPage._autoscalarize(CfJspPage.java:1494) at cfFrqntDataGW2ecfc1824034440$funcINIT._factor1(D:\WEB_APPS\ITAMS\gateway\FrqntDataGW.cfc:66) at cfFrqntDataGW2ecfc1824034440$funcINIT.runFunction(D:\WEB_APPS\ITAMS\gateway\FrqntDataGW.cfc:10) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:383) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:334) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:231) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:643) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:432) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:402) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2483) at cfapplication2ecfc799244199$funcONAPPLICATIONSTART.runFunction(D:\WEB_APPS\ITAMS\application.cfc:243) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:383) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:334) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:231) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:643) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:432) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:402) ... See the attached text file for the entire stacktrace
Expected Result: Should retrieve a list of site codes in the query called RSSITECDLST.
Any Workarounds:
We protected the query result into cache region as follows:
<cfset rsSiteCdLst = cacheGet("APP_rsSiteCdLst", application.cacheRegion)>
<cfif Not isDefined("rsSiteCdLst") or isNull(rsSiteCdLst)>
<cfquery name="rsSiteCdLst" datasource="#application.datasource#" cachedwithin="#CreateTimeSpan(1,0,0,0)#" cacheRegion="#application.cacheRegion#" cacheID="APP_rsSiteCdLst">
select distinct OfficeCode as sitecd
from view_office
order by OfficeCode
</cfquery>
</cfif>
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 4169935
External Customer Info:
External Company:
External Customer Name: Hee Lee
External Customer Email:
External Test Config: My Hardware and Environment details:Attachments:
Comments: