Catch
Entries: 18
additional
Struct (ordered)
SQL
stringSELECT sub_category_id,sub_category_name,category_name,category_id,sub_category_description FROM VARIABLES_subcategoryList WHERE sub_category_id=327
Cause
Struct
Entries: 16
additional
Struct (ordered)
SQL
stringSELECT sub_category_id,sub_category_name,category_name,category_id,sub_category_description FROM VARIABLES_subcategoryList WHERE sub_category_id=327
Cause
Struct
Entries: 15
additional
Struct (ordered)
SQL
stringSELECT sub_category_id,sub_category_name,category_name,category_id,sub_category_description FROM VARIABLES_subcategoryList WHERE sub_category_id=327
DatabaseName
stringHSQL Database Engine
DatabaseVersion
string2.7.2
DriverName
stringHSQL Database Engine Driver
DriverVersion
string2.7.2
Datasource
string_queryofquerydb
DataSource
string_queryofquerydb
Detail
string
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringuser lacks privilege or object not found: SUB_CATEGORY_ID
NativeErrorCode
number-5501
queryError
stringSELECT sub_category_id,sub_category_name,category_name,category_id,sub_category_description FROM VARIABLES_subcategoryList WHERE sub_category_id=327
Sql
stringSELECT sub_category_id,sub_category_name,category_name,category_id,sub_category_description FROM VARIABLES_subcategoryList WHERE sub_category_id=327
SQLState
string42501
StackTrace
stringlucee.runtime.exp.DatabaseException: user lacks privilege or object not found: SUB_CATEGORY_ID at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source) at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source) at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:345) at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:293) at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:239) at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:623) at lucee.runtime.db.HSQLDBHandler._execute(HSQLDBHandler.java:544) at lucee.runtime.db.HSQLDBHandler.execute(HSQLDBHandler.java:532) at lucee.runtime.tag.Query.executeQoQ(Query.java:1101) at lucee.runtime.tag.Query._doEndTag(Query.java:673) at lucee.runtime.tag.Query.doEndTag(Query.java:557) at model.gateway.sitemanager_cfc$cf.udfCall2(/model/gateway/siteManager.cfc:784) at model.gateway.sitemanager_cfc$cf.udfCall(/model/gateway/siteManager.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:723) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:595) at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:2120) at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:858) at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2107) at model.service.sitemanager_cfc$cf.udfCall2(/model/service/siteManager.cfc:78) at model.service.sitemanager_cfc$cf.udfCall(/model/service/siteManager.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:722) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:595) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2101) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:773) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:2075) at layouts.sitelayouts.siteproductlist_cfm$cf$2.call(/layouts/siteLayouts/siteProductList.cfm:9) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1112) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1006) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:987) at views.productview.productdetails_cfm$cf$1.call(/views/productview/productdetails.cfm:1) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1112) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1006) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:987) at framework.one_cfc$cf.udfCallc(/framework/one.cfc:1993) at framework.one_cfc$cf.udfCall(/framework/one.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224) at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:811) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:773) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:2075) at framework.one_cfc$cf.udfCall6(/framework/one.cfc:921) at framework.one_cfc$cf.udfCall(/framework/one.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:722) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:595) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2101) at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:477) at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:212) at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:41) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2810) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2797) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2768) at lucee.runtime.engine.Request.exe(Request.java:45) at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1109) at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1066) at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97) at lucee.loader.servlet.jakarta.CFMLServlet.service(CFMLServlet.java:52) at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:710) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:130) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:109) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:79) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:483) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:116) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:420) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:903) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1744) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:637) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:59) at java.base/java.lang.Thread.run(Unknown Source)
TagContext
Array
1
Struct
codePrintHTML
string782: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FROM&nbsp;VARIABLES.subcategoryList<br> 783: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;WHERE&nbsp;sub_category_id=&lt;cfqueryparam&nbsp;value=&quot;#ARGUMENTS.subcategoryID#&quot;&nbsp;&nbsp;cfsqltype=&quot;cf_sql_integer&quot;&gt;<br> <b>784: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/cfquery&gt;</b><br> 785: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfreturn&nbsp;getSubcategoryInfoBySubcategoryID&gt;<br> 786: &nbsp;&nbsp;&nbsp;&lt;/cffunction&gt;<br>
codePrintPlain
string782: FROM VARIABLES.subcategoryList 783: WHERE sub_category_id=<cfqueryparam value="#ARGUMENTS.subcategoryID#" cfsqltype="cf_sql_integer"> 784: </cfquery> 785: <cfreturn getSubcategoryInfoBySubcategoryID> 786: </cffunction>
column
number0
id
string??
line
number784
Raw_Trace
stringmodel.gateway.sitemanager_cfc$cf.udfCall2(/model/gateway/siteManager.cfc:784)
template
stringC:\sites\websam\site\model\gateway\siteManager.cfc
type
stringcfml
2
Struct
codePrintHTML
string76: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfargument&nbsp;name=&quot;siteID&quot;&nbsp;type=&quot;numeric&quot;&nbsp;required=&quot;true&quot;&gt;<br> 77: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfargument&nbsp;name=&quot;subCategoryID&quot;&nbsp;type=&quot;numeric&quot;&nbsp;required=&quot;true&quot;&gt;<br> <b>78: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfreturn&nbsp;APPLICATION.getsiteManagerGateway().getSubcategoryInfoBySubcategoryID(siteID=ARGUMENTS.siteID,subCategoryID=ARGUMENTS.subCategoryID)&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</b><br> 79: &nbsp;&nbsp;&nbsp;&lt;/cffunction&gt;<br> 80: &nbsp;&nbsp;&nbsp;<br>
codePrintPlain
string76: <cfargument name="siteID" type="numeric" required="true"> 77: <cfargument name="subCategoryID" type="numeric" required="true"> 78: <cfreturn APPLICATION.getsiteManagerGateway().getSubcategoryInfoBySubcategoryID(siteID=ARGUMENTS.siteID,subCategoryID=ARGUMENTS.subCategoryID)> 79: </cffunction> 80:
column
number0
id
string??
line
number78
Raw_Trace
stringmodel.service.sitemanager_cfc$cf.udfCall2(/model/service/siteManager.cfc:78)
template
stringC:\sites\websam\site\model\service\siteManager.cfc
type
stringcfml
3
Struct
codePrintHTML
string7: <br> 8: &lt;cfset&nbsp;VARIABLES.productList&nbsp;=&nbsp;APPLICATION.getsiteManagerService().getProductList(siteID=APPLICATION.siteDetails.site_id,deptID=SESSION.employeeDetails.dept_id,subCategoryID=&nbsp;VARIABLES.subCategoryID)/&gt;<br> <b>9: &lt;cfset&nbsp;VARIABLES.subCategoryInfo=APPLICATION.getsiteManagerService().getSubcategoryInfoBySubcategoryID(#APPLICATION.siteDetails.site_id#,#VARIABLES.subCategoryID#)&gt;</b><br> 10: &lt;cfparam&nbsp;name=&quot;VARIABLES.type&quot;&nbsp;default=&quot;hidden&quot;&gt;<br> 11: &lt;cfset&nbsp;LOCAL.totalCards&nbsp;=&nbsp;VARIABLES.productList.recordCount&gt;<br>
codePrintPlain
string7: 8: <cfset VARIABLES.productList = APPLICATION.getsiteManagerService().getProductList(siteID=APPLICATION.siteDetails.site_id,deptID=SESSION.employeeDetails.dept_id,subCategoryID= VARIABLES.subCategoryID)/> 9: <cfset VARIABLES.subCategoryInfo=APPLICATION.getsiteManagerService().getSubcategoryInfoBySubcategoryID(#APPLICATION.siteDetails.site_id#,#VARIABLES.subCategoryID#)> 10: <cfparam name="VARIABLES.type" default="hidden"> 11: <cfset LOCAL.totalCards = VARIABLES.productList.recordCount>
column
number0
id
string??
line
number9
Raw_Trace
stringlayouts.sitelayouts.siteproductlist_cfm$cf$2.call(/layouts/siteLayouts/siteProductList.cfm:9)
template
stringC:\sites\websam\site\layouts\siteLayouts\siteProductList.cfm
type
stringcfml
4
Struct
codePrintHTML
string<b>1: &lt;cfinclude&nbsp;template=&quot;../../layouts/siteLayouts/siteProductList.cfm&quot;&gt;</b><br>
codePrintPlain
string1: <cfinclude template="../../layouts/siteLayouts/siteProductList.cfm">
column
number0
id
string??
line
number1
Raw_Trace
stringviews.productview.productdetails_cfm$cf$1.call(/views/productview/productdetails.cfm:1)
template
stringC:\sites\websam\site\views\productview\productdetails.cfm
type
stringcfml
5
Struct
codePrintHTML
string1991: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;response&nbsp;=&nbsp;'';<br> 1992: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;savecontent&nbsp;variable=&quot;response&quot;&nbsp;{<br> <b>1993: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;include&nbsp;'#viewPath#';</b><br> 1994: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br> 1995: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
codePrintPlain
string1991: response = ''; 1992: savecontent variable="response" { 1993: include '#viewPath#'; 1994: } 1995: }
column
number0
id
string??
line
number1993
Raw_Trace
stringframework.one_cfc$cf.udfCallc(/framework/one.cfc:1993)
template
stringC:\sites\websam\site\framework\one.cfc
type
stringcfml
6
Struct
codePrintHTML
string919: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(&nbsp;structKeyExists(request._fw1,&nbsp;'view')&nbsp;)&nbsp;{<br> 920: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;internalFrameworkTrace(&nbsp;'rendering&nbsp;#request._fw1.view#'&nbsp;);<br> <b>921: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;out&nbsp;=&nbsp;internalView(&nbsp;request._fw1.view&nbsp;);</b><br> 922: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;else&nbsp;if&nbsp;(&nbsp;structKeyExists(request._fw1,&nbsp;'omvInProgress')&nbsp;)&nbsp;{<br> 923: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;internalFrameworkTrace(&nbsp;'viewNotFound()&nbsp;called'&nbsp;);<br>
codePrintPlain
string919: if ( structKeyExists(request._fw1, 'view') ) { 920: internalFrameworkTrace( 'rendering #request._fw1.view#' ); 921: out = internalView( request._fw1.view ); 922: } else if ( structKeyExists(request._fw1, 'omvInProgress') ) { 923: internalFrameworkTrace( 'viewNotFound() called' );
column
number0
id
string??
line
number921
Raw_Trace
stringframework.one_cfc$cf.udfCall6(/framework/one.cfc:921)
template
stringC:\sites\websam\site\framework\one.cfc
type
stringcfml
type
stringdatabase
where
string
DataSource
string
Detail
stringuser lacks privilege or object not found: SUB_CATEGORY_ID
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringQoQ HSQLDB: error executing sql statement on query.
NativeErrorCode
number-1
queryError
stringSELECT sub_category_id,sub_category_name,category_name,category_id,sub_category_description FROM VARIABLES_subcategoryList WHERE sub_category_id=327
Sql
stringSELECT sub_category_id,sub_category_name,category_name,category_id,sub_category_description FROM VARIABLES_subcategoryList WHERE sub_category_id=327
SQLState
string
StackTrace
stringlucee.runtime.exp.IllegalQoQException: QoQ HSQLDB: error executing sql statement on query. at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:642) at lucee.runtime.db.HSQLDBHandler._execute(HSQLDBHandler.java:544) at lucee.runtime.db.HSQLDBHandler.execute(HSQLDBHandler.java:532) at lucee.runtime.tag.Query.executeQoQ(Query.java:1101) at lucee.runtime.tag.Query._doEndTag(Query.java:673) at lucee.runtime.tag.Query.doEndTag(Query.java:557) at model.gateway.sitemanager_cfc$cf.udfCall2(/model/gateway/siteManager.cfc:784) at model.gateway.sitemanager_cfc$cf.udfCall(/model/gateway/siteManager.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:723) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:595) at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:2120) at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:858) at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2107) at model.service.sitemanager_cfc$cf.udfCall2(/model/service/siteManager.cfc:78) at model.service.sitemanager_cfc$cf.udfCall(/model/service/siteManager.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:722) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:595) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2101) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:773) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:2075) at layouts.sitelayouts.siteproductlist_cfm$cf$2.call(/layouts/siteLayouts/siteProductList.cfm:9) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1112) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1006) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:987) at views.productview.productdetails_cfm$cf$1.call(/views/productview/productdetails.cfm:1) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1112) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1006) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:987) at framework.one_cfc$cf.udfCallc(/framework/one.cfc:1993) at framework.one_cfc$cf.udfCall(/framework/one.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224) at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:811) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:773) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:2075) at framework.one_cfc$cf.udfCall6(/framework/one.cfc:921) at framework.one_cfc$cf.udfCall(/framework/one.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:722) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:595) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2101) at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:477) at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:212) at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:41) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2810) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2797) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2768) at lucee.runtime.engine.Request.exe(Request.java:45) at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1109) at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1066) at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97) at lucee.loader.servlet.jakarta.CFMLServlet.service(CFMLServlet.java:52) at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:710) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:130) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:109) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:79) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:483) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:116) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:420) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:903) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1744) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:637) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:59) at java.base/java.lang.Thread.run(Unknown Source) Caused by: lucee.runtime.exp.DatabaseException: user lacks privilege or object not found: SUB_CATEGORY_ID at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source) at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source) at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:345) at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:293) at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:239) at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:623) ... 80 more
TagContext
Array
1
Struct
codePrintHTML
string782: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FROM&nbsp;VARIABLES.subcategoryList<br> 783: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;WHERE&nbsp;sub_category_id=&lt;cfqueryparam&nbsp;value=&quot;#ARGUMENTS.subcategoryID#&quot;&nbsp;&nbsp;cfsqltype=&quot;cf_sql_integer&quot;&gt;<br> <b>784: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/cfquery&gt;</b><br> 785: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfreturn&nbsp;getSubcategoryInfoBySubcategoryID&gt;<br> 786: &nbsp;&nbsp;&nbsp;&lt;/cffunction&gt;<br>
codePrintPlain
string782: FROM VARIABLES.subcategoryList 783: WHERE sub_category_id=<cfqueryparam value="#ARGUMENTS.subcategoryID#" cfsqltype="cf_sql_integer"> 784: </cfquery> 785: <cfreturn getSubcategoryInfoBySubcategoryID> 786: </cffunction>
column
number0
id
string??
line
number784
Raw_Trace
stringmodel.gateway.sitemanager_cfc$cf.udfCall2(/model/gateway/siteManager.cfc:784)
template
stringC:\sites\websam\site\model\gateway\siteManager.cfc
type
stringcfml
2
Struct
codePrintHTML
string76: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfargument&nbsp;name=&quot;siteID&quot;&nbsp;type=&quot;numeric&quot;&nbsp;required=&quot;true&quot;&gt;<br> 77: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfargument&nbsp;name=&quot;subCategoryID&quot;&nbsp;type=&quot;numeric&quot;&nbsp;required=&quot;true&quot;&gt;<br> <b>78: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfreturn&nbsp;APPLICATION.getsiteManagerGateway().getSubcategoryInfoBySubcategoryID(siteID=ARGUMENTS.siteID,subCategoryID=ARGUMENTS.subCategoryID)&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</b><br> 79: &nbsp;&nbsp;&nbsp;&lt;/cffunction&gt;<br> 80: &nbsp;&nbsp;&nbsp;<br>
codePrintPlain
string76: <cfargument name="siteID" type="numeric" required="true"> 77: <cfargument name="subCategoryID" type="numeric" required="true"> 78: <cfreturn APPLICATION.getsiteManagerGateway().getSubcategoryInfoBySubcategoryID(siteID=ARGUMENTS.siteID,subCategoryID=ARGUMENTS.subCategoryID)> 79: </cffunction> 80:
column
number0
id
string??
line
number78
Raw_Trace
stringmodel.service.sitemanager_cfc$cf.udfCall2(/model/service/siteManager.cfc:78)
template
stringC:\sites\websam\site\model\service\siteManager.cfc
type
stringcfml
3
Struct
codePrintHTML
string7: <br> 8: &lt;cfset&nbsp;VARIABLES.productList&nbsp;=&nbsp;APPLICATION.getsiteManagerService().getProductList(siteID=APPLICATION.siteDetails.site_id,deptID=SESSION.employeeDetails.dept_id,subCategoryID=&nbsp;VARIABLES.subCategoryID)/&gt;<br> <b>9: &lt;cfset&nbsp;VARIABLES.subCategoryInfo=APPLICATION.getsiteManagerService().getSubcategoryInfoBySubcategoryID(#APPLICATION.siteDetails.site_id#,#VARIABLES.subCategoryID#)&gt;</b><br> 10: &lt;cfparam&nbsp;name=&quot;VARIABLES.type&quot;&nbsp;default=&quot;hidden&quot;&gt;<br> 11: &lt;cfset&nbsp;LOCAL.totalCards&nbsp;=&nbsp;VARIABLES.productList.recordCount&gt;<br>
codePrintPlain
string7: 8: <cfset VARIABLES.productList = APPLICATION.getsiteManagerService().getProductList(siteID=APPLICATION.siteDetails.site_id,deptID=SESSION.employeeDetails.dept_id,subCategoryID= VARIABLES.subCategoryID)/> 9: <cfset VARIABLES.subCategoryInfo=APPLICATION.getsiteManagerService().getSubcategoryInfoBySubcategoryID(#APPLICATION.siteDetails.site_id#,#VARIABLES.subCategoryID#)> 10: <cfparam name="VARIABLES.type" default="hidden"> 11: <cfset LOCAL.totalCards = VARIABLES.productList.recordCount>
column
number0
id
string??
line
number9
Raw_Trace
stringlayouts.sitelayouts.siteproductlist_cfm$cf$2.call(/layouts/siteLayouts/siteProductList.cfm:9)
template
stringC:\sites\websam\site\layouts\siteLayouts\siteProductList.cfm
type
stringcfml
4
Struct
codePrintHTML
string<b>1: &lt;cfinclude&nbsp;template=&quot;../../layouts/siteLayouts/siteProductList.cfm&quot;&gt;</b><br>
codePrintPlain
string1: <cfinclude template="../../layouts/siteLayouts/siteProductList.cfm">
column
number0
id
string??
line
number1
Raw_Trace
stringviews.productview.productdetails_cfm$cf$1.call(/views/productview/productdetails.cfm:1)
template
stringC:\sites\websam\site\views\productview\productdetails.cfm
type
stringcfml
5
Struct
codePrintHTML
string1991: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;response&nbsp;=&nbsp;'';<br> 1992: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;savecontent&nbsp;variable=&quot;response&quot;&nbsp;{<br> <b>1993: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;include&nbsp;'#viewPath#';</b><br> 1994: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br> 1995: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
codePrintPlain
string1991: response = ''; 1992: savecontent variable="response" { 1993: include '#viewPath#'; 1994: } 1995: }
column
number0
id
string??
line
number1993
Raw_Trace
stringframework.one_cfc$cf.udfCallc(/framework/one.cfc:1993)
template
stringC:\sites\websam\site\framework\one.cfc
type
stringcfml
6
Struct
codePrintHTML
string919: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(&nbsp;structKeyExists(request._fw1,&nbsp;'view')&nbsp;)&nbsp;{<br> 920: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;internalFrameworkTrace(&nbsp;'rendering&nbsp;#request._fw1.view#'&nbsp;);<br> <b>921: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;out&nbsp;=&nbsp;internalView(&nbsp;request._fw1.view&nbsp;);</b><br> 922: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;else&nbsp;if&nbsp;(&nbsp;structKeyExists(request._fw1,&nbsp;'omvInProgress')&nbsp;)&nbsp;{<br> 923: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;internalFrameworkTrace(&nbsp;'viewNotFound()&nbsp;called'&nbsp;);<br>
codePrintPlain
string919: if ( structKeyExists(request._fw1, 'view') ) { 920: internalFrameworkTrace( 'rendering #request._fw1.view#' ); 921: out = internalView( request._fw1.view ); 922: } else if ( structKeyExists(request._fw1, 'omvInProgress') ) { 923: internalFrameworkTrace( 'viewNotFound() called' );
column
number0
id
string??
line
number921
Raw_Trace
stringframework.one_cfc$cf.udfCall6(/framework/one.cfc:921)
template
stringC:\sites\websam\site\framework\one.cfc
type
stringcfml
type
stringdatabase
where
string
DataSource
string
Detail
stringuser lacks privilege or object not found: SUB_CATEGORY_ID
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringQoQ HSQLDB: error executing sql statement on query.
name
stringonRequest
NativeErrorCode
number-1
queryError
stringSELECT sub_category_id,sub_category_name,category_name,category_id,sub_category_description FROM VARIABLES_subcategoryList WHERE sub_category_id=327
rootCause
Struct
Entries: 16
additional
Struct (ordered)
SQL
stringSELECT sub_category_id,sub_category_name,category_name,category_id,sub_category_description FROM VARIABLES_subcategoryList WHERE sub_category_id=327
Cause
Struct
Entries: 15
additional
Struct (ordered)
SQL
stringSELECT sub_category_id,sub_category_name,category_name,category_id,sub_category_description FROM VARIABLES_subcategoryList WHERE sub_category_id=327
DatabaseName
stringHSQL Database Engine
DatabaseVersion
string2.7.2
DriverName
stringHSQL Database Engine Driver
DriverVersion
string2.7.2
Datasource
string_queryofquerydb
DataSource
string_queryofquerydb
Detail
string
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringuser lacks privilege or object not found: SUB_CATEGORY_ID
NativeErrorCode
number-5501
queryError
stringSELECT sub_category_id,sub_category_name,category_name,category_id,sub_category_description FROM VARIABLES_subcategoryList WHERE sub_category_id=327
Sql
stringSELECT sub_category_id,sub_category_name,category_name,category_id,sub_category_description FROM VARIABLES_subcategoryList WHERE sub_category_id=327
SQLState
string42501
StackTrace
stringlucee.runtime.exp.DatabaseException: user lacks privilege or object not found: SUB_CATEGORY_ID at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source) at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source) at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:345) at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:293) at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:239) at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:623) at lucee.runtime.db.HSQLDBHandler._execute(HSQLDBHandler.java:544) at lucee.runtime.db.HSQLDBHandler.execute(HSQLDBHandler.java:532) at lucee.runtime.tag.Query.executeQoQ(Query.java:1101) at lucee.runtime.tag.Query._doEndTag(Query.java:673) at lucee.runtime.tag.Query.doEndTag(Query.java:557) at model.gateway.sitemanager_cfc$cf.udfCall2(/model/gateway/siteManager.cfc:784) at model.gateway.sitemanager_cfc$cf.udfCall(/model/gateway/siteManager.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:723) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:595) at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:2120) at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:858) at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2107) at model.service.sitemanager_cfc$cf.udfCall2(/model/service/siteManager.cfc:78) at model.service.sitemanager_cfc$cf.udfCall(/model/service/siteManager.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:722) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:595) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2101) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:773) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:2075) at layouts.sitelayouts.siteproductlist_cfm$cf$2.call(/layouts/siteLayouts/siteProductList.cfm:9) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1112) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1006) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:987) at views.productview.productdetails_cfm$cf$1.call(/views/productview/productdetails.cfm:1) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1112) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1006) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:987) at framework.one_cfc$cf.udfCallc(/framework/one.cfc:1993) at framework.one_cfc$cf.udfCall(/framework/one.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224) at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:811) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:773) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:2075) at framework.one_cfc$cf.udfCall6(/framework/one.cfc:921) at framework.one_cfc$cf.udfCall(/framework/one.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:722) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:595) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2101) at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:477) at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:212) at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:41) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2810) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2797) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2768) at lucee.runtime.engine.Request.exe(Request.java:45) at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1109) at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1066) at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97) at lucee.loader.servlet.jakarta.CFMLServlet.service(CFMLServlet.java:52) at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:710) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:130) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:109) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:79) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:483) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:116) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:420) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:903) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1744) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:637) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:59) at java.base/java.lang.Thread.run(Unknown Source)
TagContext
Array
1
Struct
codePrintHTML
string782: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FROM&nbsp;VARIABLES.subcategoryList<br> 783: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;WHERE&nbsp;sub_category_id=&lt;cfqueryparam&nbsp;value=&quot;#ARGUMENTS.subcategoryID#&quot;&nbsp;&nbsp;cfsqltype=&quot;cf_sql_integer&quot;&gt;<br> <b>784: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/cfquery&gt;</b><br> 785: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfreturn&nbsp;getSubcategoryInfoBySubcategoryID&gt;<br> 786: &nbsp;&nbsp;&nbsp;&lt;/cffunction&gt;<br>
codePrintPlain
string782: FROM VARIABLES.subcategoryList 783: WHERE sub_category_id=<cfqueryparam value="#ARGUMENTS.subcategoryID#" cfsqltype="cf_sql_integer"> 784: </cfquery> 785: <cfreturn getSubcategoryInfoBySubcategoryID> 786: </cffunction>
column
number0
id
string??
line
number784
Raw_Trace
stringmodel.gateway.sitemanager_cfc$cf.udfCall2(/model/gateway/siteManager.cfc:784)
template
stringC:\sites\websam\site\model\gateway\siteManager.cfc
type
stringcfml
2
Struct
codePrintHTML
string76: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfargument&nbsp;name=&quot;siteID&quot;&nbsp;type=&quot;numeric&quot;&nbsp;required=&quot;true&quot;&gt;<br> 77: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfargument&nbsp;name=&quot;subCategoryID&quot;&nbsp;type=&quot;numeric&quot;&nbsp;required=&quot;true&quot;&gt;<br> <b>78: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfreturn&nbsp;APPLICATION.getsiteManagerGateway().getSubcategoryInfoBySubcategoryID(siteID=ARGUMENTS.siteID,subCategoryID=ARGUMENTS.subCategoryID)&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</b><br> 79: &nbsp;&nbsp;&nbsp;&lt;/cffunction&gt;<br> 80: &nbsp;&nbsp;&nbsp;<br>
codePrintPlain
string76: <cfargument name="siteID" type="numeric" required="true"> 77: <cfargument name="subCategoryID" type="numeric" required="true"> 78: <cfreturn APPLICATION.getsiteManagerGateway().getSubcategoryInfoBySubcategoryID(siteID=ARGUMENTS.siteID,subCategoryID=ARGUMENTS.subCategoryID)> 79: </cffunction> 80:
column
number0
id
string??
line
number78
Raw_Trace
stringmodel.service.sitemanager_cfc$cf.udfCall2(/model/service/siteManager.cfc:78)
template
stringC:\sites\websam\site\model\service\siteManager.cfc
type
stringcfml
3
Struct
codePrintHTML
string7: <br> 8: &lt;cfset&nbsp;VARIABLES.productList&nbsp;=&nbsp;APPLICATION.getsiteManagerService().getProductList(siteID=APPLICATION.siteDetails.site_id,deptID=SESSION.employeeDetails.dept_id,subCategoryID=&nbsp;VARIABLES.subCategoryID)/&gt;<br> <b>9: &lt;cfset&nbsp;VARIABLES.subCategoryInfo=APPLICATION.getsiteManagerService().getSubcategoryInfoBySubcategoryID(#APPLICATION.siteDetails.site_id#,#VARIABLES.subCategoryID#)&gt;</b><br> 10: &lt;cfparam&nbsp;name=&quot;VARIABLES.type&quot;&nbsp;default=&quot;hidden&quot;&gt;<br> 11: &lt;cfset&nbsp;LOCAL.totalCards&nbsp;=&nbsp;VARIABLES.productList.recordCount&gt;<br>
codePrintPlain
string7: 8: <cfset VARIABLES.productList = APPLICATION.getsiteManagerService().getProductList(siteID=APPLICATION.siteDetails.site_id,deptID=SESSION.employeeDetails.dept_id,subCategoryID= VARIABLES.subCategoryID)/> 9: <cfset VARIABLES.subCategoryInfo=APPLICATION.getsiteManagerService().getSubcategoryInfoBySubcategoryID(#APPLICATION.siteDetails.site_id#,#VARIABLES.subCategoryID#)> 10: <cfparam name="VARIABLES.type" default="hidden"> 11: <cfset LOCAL.totalCards = VARIABLES.productList.recordCount>
column
number0
id
string??
line
number9
Raw_Trace
stringlayouts.sitelayouts.siteproductlist_cfm$cf$2.call(/layouts/siteLayouts/siteProductList.cfm:9)
template
stringC:\sites\websam\site\layouts\siteLayouts\siteProductList.cfm
type
stringcfml
4
Struct
codePrintHTML
string<b>1: &lt;cfinclude&nbsp;template=&quot;../../layouts/siteLayouts/siteProductList.cfm&quot;&gt;</b><br>
codePrintPlain
string1: <cfinclude template="../../layouts/siteLayouts/siteProductList.cfm">
column
number0
id
string??
line
number1
Raw_Trace
stringviews.productview.productdetails_cfm$cf$1.call(/views/productview/productdetails.cfm:1)
template
stringC:\sites\websam\site\views\productview\productdetails.cfm
type
stringcfml
5
Struct
codePrintHTML
string1991: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;response&nbsp;=&nbsp;'';<br> 1992: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;savecontent&nbsp;variable=&quot;response&quot;&nbsp;{<br> <b>1993: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;include&nbsp;'#viewPath#';</b><br> 1994: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br> 1995: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
codePrintPlain
string1991: response = ''; 1992: savecontent variable="response" { 1993: include '#viewPath#'; 1994: } 1995: }
column
number0
id
string??
line
number1993
Raw_Trace
stringframework.one_cfc$cf.udfCallc(/framework/one.cfc:1993)
template
stringC:\sites\websam\site\framework\one.cfc
type
stringcfml
6
Struct
codePrintHTML
string919: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(&nbsp;structKeyExists(request._fw1,&nbsp;'view')&nbsp;)&nbsp;{<br> 920: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;internalFrameworkTrace(&nbsp;'rendering&nbsp;#request._fw1.view#'&nbsp;);<br> <b>921: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;out&nbsp;=&nbsp;internalView(&nbsp;request._fw1.view&nbsp;);</b><br> 922: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;else&nbsp;if&nbsp;(&nbsp;structKeyExists(request._fw1,&nbsp;'omvInProgress')&nbsp;)&nbsp;{<br> 923: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;internalFrameworkTrace(&nbsp;'viewNotFound()&nbsp;called'&nbsp;);<br>
codePrintPlain
string919: if ( structKeyExists(request._fw1, 'view') ) { 920: internalFrameworkTrace( 'rendering #request._fw1.view#' ); 921: out = internalView( request._fw1.view ); 922: } else if ( structKeyExists(request._fw1, 'omvInProgress') ) { 923: internalFrameworkTrace( 'viewNotFound() called' );
column
number0
id
string??
line
number921
Raw_Trace
stringframework.one_cfc$cf.udfCall6(/framework/one.cfc:921)
template
stringC:\sites\websam\site\framework\one.cfc
type
stringcfml
type
stringdatabase
where
string
DataSource
string
Detail
stringuser lacks privilege or object not found: SUB_CATEGORY_ID
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringQoQ HSQLDB: error executing sql statement on query.
NativeErrorCode
number-1
queryError
stringSELECT sub_category_id,sub_category_name,category_name,category_id,sub_category_description FROM VARIABLES_subcategoryList WHERE sub_category_id=327
Sql
stringSELECT sub_category_id,sub_category_name,category_name,category_id,sub_category_description FROM VARIABLES_subcategoryList WHERE sub_category_id=327
SQLState
string
StackTrace
stringlucee.runtime.exp.IllegalQoQException: QoQ HSQLDB: error executing sql statement on query. at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:642) at lucee.runtime.db.HSQLDBHandler._execute(HSQLDBHandler.java:544) at lucee.runtime.db.HSQLDBHandler.execute(HSQLDBHandler.java:532) at lucee.runtime.tag.Query.executeQoQ(Query.java:1101) at lucee.runtime.tag.Query._doEndTag(Query.java:673) at lucee.runtime.tag.Query.doEndTag(Query.java:557) at model.gateway.sitemanager_cfc$cf.udfCall2(/model/gateway/siteManager.cfc:784) at model.gateway.sitemanager_cfc$cf.udfCall(/model/gateway/siteManager.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:723) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:595) at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:2120) at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:858) at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2107) at model.service.sitemanager_cfc$cf.udfCall2(/model/service/siteManager.cfc:78) at model.service.sitemanager_cfc$cf.udfCall(/model/service/siteManager.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:722) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:595) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2101) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:773) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:2075) at layouts.sitelayouts.siteproductlist_cfm$cf$2.call(/layouts/siteLayouts/siteProductList.cfm:9) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1112) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1006) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:987) at views.productview.productdetails_cfm$cf$1.call(/views/productview/productdetails.cfm:1) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1112) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1006) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:987) at framework.one_cfc$cf.udfCallc(/framework/one.cfc:1993) at framework.one_cfc$cf.udfCall(/framework/one.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224) at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:811) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:773) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:2075) at framework.one_cfc$cf.udfCall6(/framework/one.cfc:921) at framework.one_cfc$cf.udfCall(/framework/one.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:722) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:595) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2101) at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:477) at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:212) at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:41) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2810) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2797) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2768) at lucee.runtime.engine.Request.exe(Request.java:45) at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1109) at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1066) at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97) at lucee.loader.servlet.jakarta.CFMLServlet.service(CFMLServlet.java:52) at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:710) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:130) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:109) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:79) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:483) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:116) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:420) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:903) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1744) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:637) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:59) at java.base/java.lang.Thread.run(Unknown Source) Caused by: lucee.runtime.exp.DatabaseException: user lacks privilege or object not found: SUB_CATEGORY_ID at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source) at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source) at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:345) at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:293) at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:239) at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:623) ... 80 more
TagContext
Array
1
Struct
codePrintHTML
string782: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FROM&nbsp;VARIABLES.subcategoryList<br> 783: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;WHERE&nbsp;sub_category_id=&lt;cfqueryparam&nbsp;value=&quot;#ARGUMENTS.subcategoryID#&quot;&nbsp;&nbsp;cfsqltype=&quot;cf_sql_integer&quot;&gt;<br> <b>784: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/cfquery&gt;</b><br> 785: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfreturn&nbsp;getSubcategoryInfoBySubcategoryID&gt;<br> 786: &nbsp;&nbsp;&nbsp;&lt;/cffunction&gt;<br>
codePrintPlain
string782: FROM VARIABLES.subcategoryList 783: WHERE sub_category_id=<cfqueryparam value="#ARGUMENTS.subcategoryID#" cfsqltype="cf_sql_integer"> 784: </cfquery> 785: <cfreturn getSubcategoryInfoBySubcategoryID> 786: </cffunction>
column
number0
id
string??
line
number784
Raw_Trace
stringmodel.gateway.sitemanager_cfc$cf.udfCall2(/model/gateway/siteManager.cfc:784)
template
stringC:\sites\websam\site\model\gateway\siteManager.cfc
type
stringcfml
2
Struct
codePrintHTML
string76: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfargument&nbsp;name=&quot;siteID&quot;&nbsp;type=&quot;numeric&quot;&nbsp;required=&quot;true&quot;&gt;<br> 77: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfargument&nbsp;name=&quot;subCategoryID&quot;&nbsp;type=&quot;numeric&quot;&nbsp;required=&quot;true&quot;&gt;<br> <b>78: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfreturn&nbsp;APPLICATION.getsiteManagerGateway().getSubcategoryInfoBySubcategoryID(siteID=ARGUMENTS.siteID,subCategoryID=ARGUMENTS.subCategoryID)&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</b><br> 79: &nbsp;&nbsp;&nbsp;&lt;/cffunction&gt;<br> 80: &nbsp;&nbsp;&nbsp;<br>
codePrintPlain
string76: <cfargument name="siteID" type="numeric" required="true"> 77: <cfargument name="subCategoryID" type="numeric" required="true"> 78: <cfreturn APPLICATION.getsiteManagerGateway().getSubcategoryInfoBySubcategoryID(siteID=ARGUMENTS.siteID,subCategoryID=ARGUMENTS.subCategoryID)> 79: </cffunction> 80:
column
number0
id
string??
line
number78
Raw_Trace
stringmodel.service.sitemanager_cfc$cf.udfCall2(/model/service/siteManager.cfc:78)
template
stringC:\sites\websam\site\model\service\siteManager.cfc
type
stringcfml
3
Struct
codePrintHTML
string7: <br> 8: &lt;cfset&nbsp;VARIABLES.productList&nbsp;=&nbsp;APPLICATION.getsiteManagerService().getProductList(siteID=APPLICATION.siteDetails.site_id,deptID=SESSION.employeeDetails.dept_id,subCategoryID=&nbsp;VARIABLES.subCategoryID)/&gt;<br> <b>9: &lt;cfset&nbsp;VARIABLES.subCategoryInfo=APPLICATION.getsiteManagerService().getSubcategoryInfoBySubcategoryID(#APPLICATION.siteDetails.site_id#,#VARIABLES.subCategoryID#)&gt;</b><br> 10: &lt;cfparam&nbsp;name=&quot;VARIABLES.type&quot;&nbsp;default=&quot;hidden&quot;&gt;<br> 11: &lt;cfset&nbsp;LOCAL.totalCards&nbsp;=&nbsp;VARIABLES.productList.recordCount&gt;<br>
codePrintPlain
string7: 8: <cfset VARIABLES.productList = APPLICATION.getsiteManagerService().getProductList(siteID=APPLICATION.siteDetails.site_id,deptID=SESSION.employeeDetails.dept_id,subCategoryID= VARIABLES.subCategoryID)/> 9: <cfset VARIABLES.subCategoryInfo=APPLICATION.getsiteManagerService().getSubcategoryInfoBySubcategoryID(#APPLICATION.siteDetails.site_id#,#VARIABLES.subCategoryID#)> 10: <cfparam name="VARIABLES.type" default="hidden"> 11: <cfset LOCAL.totalCards = VARIABLES.productList.recordCount>
column
number0
id
string??
line
number9
Raw_Trace
stringlayouts.sitelayouts.siteproductlist_cfm$cf$2.call(/layouts/siteLayouts/siteProductList.cfm:9)
template
stringC:\sites\websam\site\layouts\siteLayouts\siteProductList.cfm
type
stringcfml
4
Struct
codePrintHTML
string<b>1: &lt;cfinclude&nbsp;template=&quot;../../layouts/siteLayouts/siteProductList.cfm&quot;&gt;</b><br>
codePrintPlain
string1: <cfinclude template="../../layouts/siteLayouts/siteProductList.cfm">
column
number0
id
string??
line
number1
Raw_Trace
stringviews.productview.productdetails_cfm$cf$1.call(/views/productview/productdetails.cfm:1)
template
stringC:\sites\websam\site\views\productview\productdetails.cfm
type
stringcfml
5
Struct
codePrintHTML
string1991: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;response&nbsp;=&nbsp;'';<br> 1992: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;savecontent&nbsp;variable=&quot;response&quot;&nbsp;{<br> <b>1993: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;include&nbsp;'#viewPath#';</b><br> 1994: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br> 1995: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
codePrintPlain
string1991: response = ''; 1992: savecontent variable="response" { 1993: include '#viewPath#'; 1994: } 1995: }
column
number0
id
string??
line
number1993
Raw_Trace
stringframework.one_cfc$cf.udfCallc(/framework/one.cfc:1993)
template
stringC:\sites\websam\site\framework\one.cfc
type
stringcfml
6
Struct
codePrintHTML
string919: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(&nbsp;structKeyExists(request._fw1,&nbsp;'view')&nbsp;)&nbsp;{<br> 920: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;internalFrameworkTrace(&nbsp;'rendering&nbsp;#request._fw1.view#'&nbsp;);<br> <b>921: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;out&nbsp;=&nbsp;internalView(&nbsp;request._fw1.view&nbsp;);</b><br> 922: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;else&nbsp;if&nbsp;(&nbsp;structKeyExists(request._fw1,&nbsp;'omvInProgress')&nbsp;)&nbsp;{<br> 923: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;internalFrameworkTrace(&nbsp;'viewNotFound()&nbsp;called'&nbsp;);<br>
codePrintPlain
string919: if ( structKeyExists(request._fw1, 'view') ) { 920: internalFrameworkTrace( 'rendering #request._fw1.view#' ); 921: out = internalView( request._fw1.view ); 922: } else if ( structKeyExists(request._fw1, 'omvInProgress') ) { 923: internalFrameworkTrace( 'viewNotFound() called' );
column
number0
id
string??
line
number921
Raw_Trace
stringframework.one_cfc$cf.udfCall6(/framework/one.cfc:921)
template
stringC:\sites\websam\site\framework\one.cfc
type
stringcfml
type
stringdatabase
where
string
Sql
stringSELECT sub_category_id,sub_category_name,category_name,category_id,sub_category_description FROM VARIABLES_subcategoryList WHERE sub_category_id=327
SQLState
string
StackTrace
stringlucee.runtime.exp.IllegalQoQException: QoQ HSQLDB: error executing sql statement on query. at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:642) at lucee.runtime.db.HSQLDBHandler._execute(HSQLDBHandler.java:544) at lucee.runtime.db.HSQLDBHandler.execute(HSQLDBHandler.java:532) at lucee.runtime.tag.Query.executeQoQ(Query.java:1101) at lucee.runtime.tag.Query._doEndTag(Query.java:673) at lucee.runtime.tag.Query.doEndTag(Query.java:557) at model.gateway.sitemanager_cfc$cf.udfCall2(/model/gateway/siteManager.cfc:784) at model.gateway.sitemanager_cfc$cf.udfCall(/model/gateway/siteManager.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:723) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:595) at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:2120) at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:858) at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2107) at model.service.sitemanager_cfc$cf.udfCall2(/model/service/siteManager.cfc:78) at model.service.sitemanager_cfc$cf.udfCall(/model/service/siteManager.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:722) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:595) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2101) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:773) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:2075) at layouts.sitelayouts.siteproductlist_cfm$cf$2.call(/layouts/siteLayouts/siteProductList.cfm:9) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1112) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1006) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:987) at views.productview.productdetails_cfm$cf$1.call(/views/productview/productdetails.cfm:1) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1112) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1006) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:987) at framework.one_cfc$cf.udfCallc(/framework/one.cfc:1993) at framework.one_cfc$cf.udfCall(/framework/one.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224) at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:811) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:773) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:2075) at framework.one_cfc$cf.udfCall6(/framework/one.cfc:921) at framework.one_cfc$cf.udfCall(/framework/one.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:722) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:595) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2101) at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:477) at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:212) at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:41) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2810) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2797) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2768) at lucee.runtime.engine.Request.exe(Request.java:45) at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1109) at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1066) at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97) at lucee.loader.servlet.jakarta.CFMLServlet.service(CFMLServlet.java:52) at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:710) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:130) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:109) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:79) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:483) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:116) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:420) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:903) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1744) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:637) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:59) at java.base/java.lang.Thread.run(Unknown Source) Caused by: lucee.runtime.exp.DatabaseException: user lacks privilege or object not found: SUB_CATEGORY_ID at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source) at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source) at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:345) at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:293) at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:239) at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:623) ... 80 more
TagContext
Array
1
Struct
codePrintHTML
string782: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FROM&nbsp;VARIABLES.subcategoryList<br> 783: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;WHERE&nbsp;sub_category_id=&lt;cfqueryparam&nbsp;value=&quot;#ARGUMENTS.subcategoryID#&quot;&nbsp;&nbsp;cfsqltype=&quot;cf_sql_integer&quot;&gt;<br> <b>784: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/cfquery&gt;</b><br> 785: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfreturn&nbsp;getSubcategoryInfoBySubcategoryID&gt;<br> 786: &nbsp;&nbsp;&nbsp;&lt;/cffunction&gt;<br>
codePrintPlain
string782: FROM VARIABLES.subcategoryList 783: WHERE sub_category_id=<cfqueryparam value="#ARGUMENTS.subcategoryID#" cfsqltype="cf_sql_integer"> 784: </cfquery> 785: <cfreturn getSubcategoryInfoBySubcategoryID> 786: </cffunction>
column
number0
id
string??
line
number784
Raw_Trace
stringmodel.gateway.sitemanager_cfc$cf.udfCall2(/model/gateway/siteManager.cfc:784)
template
stringC:\sites\websam\site\model\gateway\siteManager.cfc
type
stringcfml
2
Struct
codePrintHTML
string76: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfargument&nbsp;name=&quot;siteID&quot;&nbsp;type=&quot;numeric&quot;&nbsp;required=&quot;true&quot;&gt;<br> 77: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfargument&nbsp;name=&quot;subCategoryID&quot;&nbsp;type=&quot;numeric&quot;&nbsp;required=&quot;true&quot;&gt;<br> <b>78: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfreturn&nbsp;APPLICATION.getsiteManagerGateway().getSubcategoryInfoBySubcategoryID(siteID=ARGUMENTS.siteID,subCategoryID=ARGUMENTS.subCategoryID)&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</b><br> 79: &nbsp;&nbsp;&nbsp;&lt;/cffunction&gt;<br> 80: &nbsp;&nbsp;&nbsp;<br>
codePrintPlain
string76: <cfargument name="siteID" type="numeric" required="true"> 77: <cfargument name="subCategoryID" type="numeric" required="true"> 78: <cfreturn APPLICATION.getsiteManagerGateway().getSubcategoryInfoBySubcategoryID(siteID=ARGUMENTS.siteID,subCategoryID=ARGUMENTS.subCategoryID)> 79: </cffunction> 80:
column
number0
id
string??
line
number78
Raw_Trace
stringmodel.service.sitemanager_cfc$cf.udfCall2(/model/service/siteManager.cfc:78)
template
stringC:\sites\websam\site\model\service\siteManager.cfc
type
stringcfml
3
Struct
codePrintHTML
string7: <br> 8: &lt;cfset&nbsp;VARIABLES.productList&nbsp;=&nbsp;APPLICATION.getsiteManagerService().getProductList(siteID=APPLICATION.siteDetails.site_id,deptID=SESSION.employeeDetails.dept_id,subCategoryID=&nbsp;VARIABLES.subCategoryID)/&gt;<br> <b>9: &lt;cfset&nbsp;VARIABLES.subCategoryInfo=APPLICATION.getsiteManagerService().getSubcategoryInfoBySubcategoryID(#APPLICATION.siteDetails.site_id#,#VARIABLES.subCategoryID#)&gt;</b><br> 10: &lt;cfparam&nbsp;name=&quot;VARIABLES.type&quot;&nbsp;default=&quot;hidden&quot;&gt;<br> 11: &lt;cfset&nbsp;LOCAL.totalCards&nbsp;=&nbsp;VARIABLES.productList.recordCount&gt;<br>
codePrintPlain
string7: 8: <cfset VARIABLES.productList = APPLICATION.getsiteManagerService().getProductList(siteID=APPLICATION.siteDetails.site_id,deptID=SESSION.employeeDetails.dept_id,subCategoryID= VARIABLES.subCategoryID)/> 9: <cfset VARIABLES.subCategoryInfo=APPLICATION.getsiteManagerService().getSubcategoryInfoBySubcategoryID(#APPLICATION.siteDetails.site_id#,#VARIABLES.subCategoryID#)> 10: <cfparam name="VARIABLES.type" default="hidden"> 11: <cfset LOCAL.totalCards = VARIABLES.productList.recordCount>
column
number0
id
string??
line
number9
Raw_Trace
stringlayouts.sitelayouts.siteproductlist_cfm$cf$2.call(/layouts/siteLayouts/siteProductList.cfm:9)
template
stringC:\sites\websam\site\layouts\siteLayouts\siteProductList.cfm
type
stringcfml
4
Struct
codePrintHTML
string<b>1: &lt;cfinclude&nbsp;template=&quot;../../layouts/siteLayouts/siteProductList.cfm&quot;&gt;</b><br>
codePrintPlain
string1: <cfinclude template="../../layouts/siteLayouts/siteProductList.cfm">
column
number0
id
string??
line
number1
Raw_Trace
stringviews.productview.productdetails_cfm$cf$1.call(/views/productview/productdetails.cfm:1)
template
stringC:\sites\websam\site\views\productview\productdetails.cfm
type
stringcfml
5
Struct
codePrintHTML
string1991: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;response&nbsp;=&nbsp;'';<br> 1992: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;savecontent&nbsp;variable=&quot;response&quot;&nbsp;{<br> <b>1993: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;include&nbsp;'#viewPath#';</b><br> 1994: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br> 1995: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
codePrintPlain
string1991: response = ''; 1992: savecontent variable="response" { 1993: include '#viewPath#'; 1994: } 1995: }
column
number0
id
string??
line
number1993
Raw_Trace
stringframework.one_cfc$cf.udfCallc(/framework/one.cfc:1993)
template
stringC:\sites\websam\site\framework\one.cfc
type
stringcfml
6
Struct
codePrintHTML
string919: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(&nbsp;structKeyExists(request._fw1,&nbsp;'view')&nbsp;)&nbsp;{<br> 920: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;internalFrameworkTrace(&nbsp;'rendering&nbsp;#request._fw1.view#'&nbsp;);<br> <b>921: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;out&nbsp;=&nbsp;internalView(&nbsp;request._fw1.view&nbsp;);</b><br> 922: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;else&nbsp;if&nbsp;(&nbsp;structKeyExists(request._fw1,&nbsp;'omvInProgress')&nbsp;)&nbsp;{<br> 923: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;internalFrameworkTrace(&nbsp;'viewNotFound()&nbsp;called'&nbsp;);<br>
codePrintPlain
string919: if ( structKeyExists(request._fw1, 'view') ) { 920: internalFrameworkTrace( 'rendering #request._fw1.view#' ); 921: out = internalView( request._fw1.view ); 922: } else if ( structKeyExists(request._fw1, 'omvInProgress') ) { 923: internalFrameworkTrace( 'viewNotFound() called' );
column
number0
id
string??
line
number921
Raw_Trace
stringframework.one_cfc$cf.udfCall6(/framework/one.cfc:921)
template
stringC:\sites\websam\site\framework\one.cfc
type
stringcfml
type
stringdatabase
where
string