Catch
Entries: 18 |
| additional | | Struct (ordered) | | SQL | | string | SELECT sub_category_id,sub_category_name,category_name,category_id,sub_category_description
FROM VARIABLES_subcategoryList
WHERE sub_category_id=63 |
|
|
| Cause | Struct
Entries: 16 | | additional | | Struct (ordered) | | SQL | | string | SELECT sub_category_id,sub_category_name,category_name,category_id,sub_category_description
FROM VARIABLES_subcategoryList
WHERE sub_category_id=63 |
|
| | Cause | Struct
Entries: 16 | | additional | | Struct (ordered) | | SQL | | string | SELECT sub_category_id,sub_category_name,category_name,category_id,sub_category_description
FROM VARIABLES_subcategoryList
WHERE sub_category_id=63 |
|
| | Cause | Struct
Entries: 12 | | additional | | | Detail | | | ErrorCode | | | Extended_Info | | | ExtendedInfo | | | LargeUpdateCounts | | Native Array (long[]) | | 1 | | | 2 | | | 3 | | | 4 | | | 5 | | | 6 | | | 7 | | | 8 | | | 9 | | | 10 | | | 11 | | | 12 | | | 13 | | | 14 | | | 15 | | | 16 | | | 17 | | | 18 | | | 19 | | | 20 | | | 21 | | | 22 | | | 23 | | | 24 | | | 25 | | | 26 | | | 27 | | | 28 | | | 29 | | | 30 | | | 31 | | | 32 | | | 33 | | | 34 | | | 35 | | | 36 | | | 37 | | | 38 | | | 39 | | | 40 | | | 41 | | | 42 | | | 43 | | | 44 | | | 45 | | | 46 | | | 47 | | | 48 | | | 49 | | | 50 | | | 51 | | | 52 | | | 53 | | | 54 | | | 55 | | | 56 | | | 57 | | | 58 | | | 59 | | | 60 | | | 61 | | | 62 | | | 63 | | | 64 | | | 65 | | | 66 | | | 67 | | | 68 | | | 69 | | | 70 | | | 71 | | | 72 | | | 73 | | | 74 | | | 75 | | | 76 | | | 77 | | | 78 | | | 79 | | | 80 | | | 81 | | | 82 | | | 83 | | | 84 | | | 85 | | | 86 | | | 87 | | | 88 | | | 89 | | | 90 | | | 91 | | | 92 | | | 93 | | | 94 | | | 95 | | | 96 | | | 97 | | | 98 | | | 99 | | | 100 | | | 101 | | | 102 | | | 103 | | | 104 | | | 105 | | | 106 | | | 107 | | | 108 | | | 109 | | | 110 | | | 111 | | | 112 | | | 113 | | | 114 | | | 115 | | | 116 | | | 117 | | | 118 | | | 119 | | | 120 | | | 121 | | | 122 | | | 123 | | | 124 | | | 125 | | | 126 | | | 127 | | | 128 | | | 129 | | | 130 | | | 131 | | | 132 | | | 133 | | | 134 | | | 135 | | | 136 | | | 137 | | | 138 | | | 139 | | | 140 | | | 141 | | | 142 | | | 143 | | | 144 | | | 145 | | | 146 | | | 147 | | | 148 | | | 149 | | | 150 | | | 151 | | | 152 | | | 153 | | | 154 | | | 155 | | | 156 | | | 157 | | | 158 | | | 159 | | | 160 | | | 161 | | | 162 | | | 163 | | | 164 | | | 165 | | | 166 | | | 167 | | | 168 | | | 169 | | | 170 | | | 171 | | | 172 | | | 173 | | | 174 | | | 175 | | | 176 | | | 177 | | | 178 | | | 179 | | | 180 | | | 181 | | | 182 | | | 183 | | | 184 | | | 185 | | | 186 | | | 187 | | | 188 | | | 189 | | | 190 | | | 191 | | | 192 | | | 193 | | | 194 | | | 195 | | | 196 | | | 197 | | | 198 | | | 199 | | | 200 | | | 201 | | | 202 | | | 203 | | | 204 | | | 205 | | | 206 | | | 207 | | | 208 | | | 209 | | | 210 | | | 211 | | | 212 | | | 213 | | | 214 | | | 215 | | | 216 | | | 217 | | | 218 | | | 219 | | | 220 | | | 221 | | | 222 | | | 223 | | | 224 | | | 225 | | | 226 | | | 227 | | | 228 | | | 229 | | | 230 | | | 231 | | | 232 | | | 233 | | | 234 | | | 235 | | | 236 | | | 237 | | | 238 | | | 239 | | | 240 | | | 241 | | | 242 | | | 243 | | | 244 | | | 245 | | | 246 | | | 247 | | | 248 | | | 249 | | | 250 | | | 251 | | | 252 | | | 253 | | | 254 | | | 255 | | | 256 | | | 257 | | | 258 | | | 259 | | | 260 | | | 261 | | | 262 | | | 263 | | | 264 | | | 265 | | | 266 | | | 267 | | | 268 | | | 269 | | | 270 | | | 271 | | | 272 | | | 273 | | | 274 | | | 275 | | | 276 | | | 277 | | | 278 | | | 279 | | | 280 | | | 281 | | | 282 | | | 283 | | | 284 | | | 285 | | | 286 | | | 287 | | | 288 | | | 289 | | | 290 | | | 291 | | | 292 | | | 293 | | | 294 | | | 295 | | | 296 | | | 297 | | | 298 | | | 299 | | | 300 | | | 301 | | | 302 | | | 303 | | | 304 | | | 305 | | | 306 | | | 307 | | | 308 | | | 309 | | | 310 | | | 311 | | | 312 | |
| | Message | | string | data exception: string data, right truncation ; size limit: 32768 table: VARIABLES_SUBCATEGORYLIST column: PRODUCT_DESCRIPTION |
| | SQLState | | | StackTrace | | string | lucee.runtime.exp.NativeException: data exception: string data, right truncation ; size limit: 32768 table: VARIABLES_SUBCATEGORYLIST column: PRODUCT_DESCRIPTION
at org.hsqldb.jdbc.JDBCPreparedStatement.executeBatch(Unknown Source)
at lucee.runtime.db.HSQLDBHandler.populateTable(HSQLDBHandler.java:260)
at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:617)
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: java.sql.BatchUpdateException: data exception: string data, right truncation ; size limit: 32768 table: VARIABLES_SUBCATEGORYLIST column: PRODUCT_DESCRIPTION
... 83 more
|
| | TagContext | | Array | | 1 | | Struct | | codePrintHTML | | string | 782: FROM VARIABLES.subcategoryList<br>
783: WHERE sub_category_id=<cfqueryparam value="#ARGUMENTS.subcategoryID#" cfsqltype="cf_sql_integer"><br>
<b>784: </cfquery></b><br>
785: <cfreturn getSubcategoryInfoBySubcategoryID><br>
786: </cffunction><br>
|
| | codePrintPlain | | string | 782: FROM VARIABLES.subcategoryList
783: WHERE sub_category_id=<cfqueryparam value="#ARGUMENTS.subcategoryID#" cfsqltype="cf_sql_integer">
784: </cfquery>
785: <cfreturn getSubcategoryInfoBySubcategoryID>
786: </cffunction>
|
| | column | | | id | | | line | | | Raw_Trace | | string | model.gateway.sitemanager_cfc$cf.udfCall2(/model/gateway/siteManager.cfc:784) |
| | template | | string | C:\sites\websam\site\model\gateway\siteManager.cfc |
| | type | |
| | 2 | | Struct | | codePrintHTML | | string | 76: <cfargument name="siteID" type="numeric" required="true"><br>
77: <cfargument name="subCategoryID" type="numeric" required="true"><br>
<b>78: <cfreturn APPLICATION.getsiteManagerGateway().getSubcategoryInfoBySubcategoryID(siteID=ARGUMENTS.siteID,subCategoryID=ARGUMENTS.subCategoryID)> </b><br>
79: </cffunction><br>
80: <br>
|
| | codePrintPlain | | string | 76: <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 | | | id | | | line | | | Raw_Trace | | string | model.service.sitemanager_cfc$cf.udfCall2(/model/service/siteManager.cfc:78) |
| | template | | string | C:\sites\websam\site\model\service\siteManager.cfc |
| | type | |
| | 3 | | Struct | | codePrintHTML | | string | 7: <br>
8: <cfset VARIABLES.productList = APPLICATION.getsiteManagerService().getProductList(siteID=APPLICATION.siteDetails.site_id,deptID=SESSION.employeeDetails.dept_id,subCategoryID= VARIABLES.subCategoryID)/><br>
<b>9: <cfset VARIABLES.subCategoryInfo=APPLICATION.getsiteManagerService().getSubcategoryInfoBySubcategoryID(#APPLICATION.siteDetails.site_id#,#VARIABLES.subCategoryID#)></b><br>
10: <cfparam name="VARIABLES.type" default="hidden"><br>
11: <cfset LOCAL.totalCards = VARIABLES.productList.recordCount><br>
|
| | codePrintPlain | | string | 7:
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 | | | id | | | line | | | Raw_Trace | | string | layouts.sitelayouts.siteproductlist_cfm$cf$2.call(/layouts/siteLayouts/siteProductList.cfm:9) |
| | template | | string | C:\sites\websam\site\layouts\siteLayouts\siteProductList.cfm |
| | type | |
| | 4 | | Struct | | codePrintHTML | | string | <b>1: <cfinclude template="../../layouts/siteLayouts/siteProductList.cfm"></b><br>
|
| | codePrintPlain | | string | 1: <cfinclude template="../../layouts/siteLayouts/siteProductList.cfm">
|
| | column | | | id | | | line | | | Raw_Trace | | string | views.productview.productdetails_cfm$cf$1.call(/views/productview/productdetails.cfm:1) |
| | template | | string | C:\sites\websam\site\views\productview\productdetails.cfm |
| | type | |
| | 5 | | Struct | | codePrintHTML | | string | 1991: response = '';<br>
1992: savecontent variable="response" {<br>
<b>1993: include '#viewPath#';</b><br>
1994: }<br>
1995: }<br>
|
| | codePrintPlain | | string | 1991: response = '';
1992: savecontent variable="response" {
1993: include '#viewPath#';
1994: }
1995: }
|
| | column | | | id | | | line | | | Raw_Trace | | string | framework.one_cfc$cf.udfCallc(/framework/one.cfc:1993) |
| | template | | string | C:\sites\websam\site\framework\one.cfc |
| | type | |
| | 6 | | Struct | | codePrintHTML | | string | 919: if ( structKeyExists(request._fw1, 'view') ) {<br>
920: internalFrameworkTrace( 'rendering #request._fw1.view#' );<br>
<b>921: out = internalView( request._fw1.view );</b><br>
922: } else if ( structKeyExists(request._fw1, 'omvInProgress') ) {<br>
923: internalFrameworkTrace( 'viewNotFound() called' );<br>
|
| | codePrintPlain | | string | 919: 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 | | | id | | | line | | | Raw_Trace | | string | framework.one_cfc$cf.udfCall6(/framework/one.cfc:921) |
| | template | | string | C:\sites\websam\site\framework\one.cfc |
| | type | |
|
| | type | | string | java.sql.BatchUpdateException |
| | UpdateCounts | | Native Array (int[]) | | 1 | | | 2 | | | 3 | | | 4 | | | 5 | | | 6 | | | 7 | | | 8 | | | 9 | | | 10 | | | 11 | | | 12 | | | 13 | | | 14 | | | 15 | | | 16 | | | 17 | | | 18 | | | 19 | | | 20 | | | 21 | | | 22 | | | 23 | | | 24 | | | 25 | | | 26 | | | 27 | | | 28 | | | 29 | | | 30 | | | 31 | | | 32 | | | 33 | | | 34 | | | 35 | | | 36 | | | 37 | | | 38 | | | 39 | | | 40 | | | 41 | | | 42 | | | 43 | | | 44 | | | 45 | | | 46 | | | 47 | | | 48 | | | 49 | | | 50 | | | 51 | | | 52 | | | 53 | | | 54 | | | 55 | | | 56 | | | 57 | | | 58 | | | 59 | | | 60 | | | 61 | | | 62 | | | 63 | | | 64 | | | 65 | | | 66 | | | 67 | | | 68 | | | 69 | | | 70 | | | 71 | | | 72 | | | 73 | | | 74 | | | 75 | | | 76 | | | 77 | | | 78 | | | 79 | | | 80 | | | 81 | | | 82 | | | 83 | | | 84 | | | 85 | | | 86 | | | 87 | | | 88 | | | 89 | | | 90 | | | 91 | | | 92 | | | 93 | | | 94 | | | 95 | | | 96 | | | 97 | | | 98 | | | 99 | | | 100 | | | 101 | | | 102 | | | 103 | | | 104 | | | 105 | | | 106 | | | 107 | | | 108 | | | 109 | | | 110 | | | 111 | | | 112 | | | 113 | | | 114 | | | 115 | | | 116 | | | 117 | | | 118 | | | 119 | | | 120 | | | 121 | | | 122 | | | 123 | | | 124 | | | 125 | | | 126 | | | 127 | | | 128 | | | 129 | | | 130 | | | 131 | | | 132 | | | 133 | | | 134 | | | 135 | | | 136 | | | 137 | | | 138 | | | 139 | | | 140 | | | 141 | | | 142 | | | 143 | | | 144 | | | 145 | | | 146 | | | 147 | | | 148 | | | 149 | | | 150 | | | 151 | | | 152 | | | 153 | | | 154 | | | 155 | | | 156 | | | 157 | | | 158 | | | 159 | | | 160 | | | 161 | | | 162 | | | 163 | | | 164 | | | 165 | | | 166 | | | 167 | | | 168 | | | 169 | | | 170 | | | 171 | | | 172 | | | 173 | | | 174 | | | 175 | | | 176 | | | 177 | | | 178 | | | 179 | | | 180 | | | 181 | | | 182 | | | 183 | | | 184 | | | 185 | | | 186 | | | 187 | | | 188 | | | 189 | | | 190 | | | 191 | | | 192 | | | 193 | | | 194 | | | 195 | | | 196 | | | 197 | | | 198 | | | 199 | | | 200 | | | 201 | | | 202 | | | 203 | | | 204 | | | 205 | | | 206 | | | 207 | | | 208 | | | 209 | | | 210 | | | 211 | | | 212 | | | 213 | | | 214 | | | 215 | | | 216 | | | 217 | | | 218 | | | 219 | | | 220 | | | 221 | | | 222 | | | 223 | | | 224 | | | 225 | | | 226 | | | 227 | | | 228 | | | 229 | | | 230 | | | 231 | | | 232 | | | 233 | | | 234 | | | 235 | | | 236 | | | 237 | | | 238 | | | 239 | | | 240 | | | 241 | | | 242 | | | 243 | | | 244 | | | 245 | | | 246 | | | 247 | | | 248 | | | 249 | | | 250 | | | 251 | | | 252 | | | 253 | | | 254 | | | 255 | | | 256 | | | 257 | | | 258 | | | 259 | | | 260 | | | 261 | | | 262 | | | 263 | | | 264 | | | 265 | | | 266 | | | 267 | | | 268 | | | 269 | | | 270 | | | 271 | | | 272 | | | 273 | | | 274 | | | 275 | | | 276 | | | 277 | | | 278 | | | 279 | | | 280 | | | 281 | | | 282 | | | 283 | | | 284 | | | 285 | | | 286 | | | 287 | | | 288 | | | 289 | | | 290 | | | 291 | | | 292 | | | 293 | | | 294 | | | 295 | | | 296 | | | 297 | | | 298 | | | 299 | | | 300 | | | 301 | | | 302 | | | 303 | | | 304 | | | 305 | | | 306 | | | 307 | | | 308 | | | 309 | | | 310 | | | 311 | | | 312 | |
|
| | DataSource | | | Detail | | string | data exception: string data, right truncation ; size limit: 32768 table: VARIABLES_SUBCATEGORYLIST column: PRODUCT_DESCRIPTION |
| | ErrorCode | | | Extended_Info | | | ExtendedInfo | | | Message | | string | QoQ HSQLDB: error executing sql statement on query. |
| | NativeErrorCode | | | queryError | | string | SELECT sub_category_id,sub_category_name,category_name,category_id,sub_category_description
FROM VARIABLES_subcategoryList
WHERE sub_category_id=63 |
| | Sql | | string | SELECT sub_category_id,sub_category_name,category_name,category_id,sub_category_description
FROM VARIABLES_subcategoryList
WHERE sub_category_id=63 |
| | SQLState | | | StackTrace | | string | lucee.runtime.exp.IllegalQoQException: QoQ HSQLDB: error executing sql statement on query.
at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:636)
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: java.sql.BatchUpdateException: data exception: string data, right truncation ; size limit: 32768 table: VARIABLES_SUBCATEGORYLIST column: PRODUCT_DESCRIPTION
at org.hsqldb.jdbc.JDBCPreparedStatement.executeBatch(Unknown Source)
at lucee.runtime.db.HSQLDBHandler.populateTable(HSQLDBHandler.java:260)
at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:617)
... 80 more
|
| | TagContext | | Array | | 1 | | Struct | | codePrintHTML | | string | 782: FROM VARIABLES.subcategoryList<br>
783: WHERE sub_category_id=<cfqueryparam value="#ARGUMENTS.subcategoryID#" cfsqltype="cf_sql_integer"><br>
<b>784: </cfquery></b><br>
785: <cfreturn getSubcategoryInfoBySubcategoryID><br>
786: </cffunction><br>
|
| | codePrintPlain | | string | 782: FROM VARIABLES.subcategoryList
783: WHERE sub_category_id=<cfqueryparam value="#ARGUMENTS.subcategoryID#" cfsqltype="cf_sql_integer">
784: </cfquery>
785: <cfreturn getSubcategoryInfoBySubcategoryID>
786: </cffunction>
|
| | column | | | id | | | line | | | Raw_Trace | | string | model.gateway.sitemanager_cfc$cf.udfCall2(/model/gateway/siteManager.cfc:784) |
| | template | | string | C:\sites\websam\site\model\gateway\siteManager.cfc |
| | type | |
| | 2 | | Struct | | codePrintHTML | | string | 76: <cfargument name="siteID" type="numeric" required="true"><br>
77: <cfargument name="subCategoryID" type="numeric" required="true"><br>
<b>78: <cfreturn APPLICATION.getsiteManagerGateway().getSubcategoryInfoBySubcategoryID(siteID=ARGUMENTS.siteID,subCategoryID=ARGUMENTS.subCategoryID)> </b><br>
79: </cffunction><br>
80: <br>
|
| | codePrintPlain | | string | 76: <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 | | | id | | | line | | | Raw_Trace | | string | model.service.sitemanager_cfc$cf.udfCall2(/model/service/siteManager.cfc:78) |
| | template | | string | C:\sites\websam\site\model\service\siteManager.cfc |
| | type | |
| | 3 | | Struct | | codePrintHTML | | string | 7: <br>
8: <cfset VARIABLES.productList = APPLICATION.getsiteManagerService().getProductList(siteID=APPLICATION.siteDetails.site_id,deptID=SESSION.employeeDetails.dept_id,subCategoryID= VARIABLES.subCategoryID)/><br>
<b>9: <cfset VARIABLES.subCategoryInfo=APPLICATION.getsiteManagerService().getSubcategoryInfoBySubcategoryID(#APPLICATION.siteDetails.site_id#,#VARIABLES.subCategoryID#)></b><br>
10: <cfparam name="VARIABLES.type" default="hidden"><br>
11: <cfset LOCAL.totalCards = VARIABLES.productList.recordCount><br>
|
| | codePrintPlain | | string | 7:
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 | | | id | | | line | | | Raw_Trace | | string | layouts.sitelayouts.siteproductlist_cfm$cf$2.call(/layouts/siteLayouts/siteProductList.cfm:9) |
| | template | | string | C:\sites\websam\site\layouts\siteLayouts\siteProductList.cfm |
| | type | |
| | 4 | | Struct | | codePrintHTML | | string | <b>1: <cfinclude template="../../layouts/siteLayouts/siteProductList.cfm"></b><br>
|
| | codePrintPlain | | string | 1: <cfinclude template="../../layouts/siteLayouts/siteProductList.cfm">
|
| | column | | | id | | | line | | | Raw_Trace | | string | views.productview.productdetails_cfm$cf$1.call(/views/productview/productdetails.cfm:1) |
| | template | | string | C:\sites\websam\site\views\productview\productdetails.cfm |
| | type | |
| | 5 | | Struct | | codePrintHTML | | string | 1991: response = '';<br>
1992: savecontent variable="response" {<br>
<b>1993: include '#viewPath#';</b><br>
1994: }<br>
1995: }<br>
|
| | codePrintPlain | | string | 1991: response = '';
1992: savecontent variable="response" {
1993: include '#viewPath#';
1994: }
1995: }
|
| | column | | | id | | | line | | | Raw_Trace | | string | framework.one_cfc$cf.udfCallc(/framework/one.cfc:1993) |
| | template | | string | C:\sites\websam\site\framework\one.cfc |
| | type | |
| | 6 | | Struct | | codePrintHTML | | string | 919: if ( structKeyExists(request._fw1, 'view') ) {<br>
920: internalFrameworkTrace( 'rendering #request._fw1.view#' );<br>
<b>921: out = internalView( request._fw1.view );</b><br>
922: } else if ( structKeyExists(request._fw1, 'omvInProgress') ) {<br>
923: internalFrameworkTrace( 'viewNotFound() called' );<br>
|
| | codePrintPlain | | string | 919: 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 | | | id | | | line | | | Raw_Trace | | string | framework.one_cfc$cf.udfCall6(/framework/one.cfc:921) |
| | template | | string | C:\sites\websam\site\framework\one.cfc |
| | type | |
|
| | type | | | where | |
| | DataSource | | | Detail | | | ErrorCode | | | Extended_Info | | | ExtendedInfo | | | Message | | string | QoQ HSQLDB: error executing sql statement on query. |
| | NativeErrorCode | | | queryError | | string | SELECT sub_category_id,sub_category_name,category_name,category_id,sub_category_description
FROM VARIABLES_subcategoryList
WHERE sub_category_id=63 |
| | Sql | | string | SELECT sub_category_id,sub_category_name,category_name,category_id,sub_category_description
FROM VARIABLES_subcategoryList
WHERE sub_category_id=63 |
| | SQLState | | | StackTrace | | string | lucee.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.IllegalQoQException: QoQ HSQLDB: error executing sql statement on query.
at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:636)
... 80 more
Caused by: java.sql.BatchUpdateException: data exception: string data, right truncation ; size limit: 32768 table: VARIABLES_SUBCATEGORYLIST column: PRODUCT_DESCRIPTION
at org.hsqldb.jdbc.JDBCPreparedStatement.executeBatch(Unknown Source)
at lucee.runtime.db.HSQLDBHandler.populateTable(HSQLDBHandler.java:260)
at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:617)
... 80 more
|
| | TagContext | | Array | | 1 | | Struct | | codePrintHTML | | string | 782: FROM VARIABLES.subcategoryList<br>
783: WHERE sub_category_id=<cfqueryparam value="#ARGUMENTS.subcategoryID#" cfsqltype="cf_sql_integer"><br>
<b>784: </cfquery></b><br>
785: <cfreturn getSubcategoryInfoBySubcategoryID><br>
786: </cffunction><br>
|
| | codePrintPlain | | string | 782: FROM VARIABLES.subcategoryList
783: WHERE sub_category_id=<cfqueryparam value="#ARGUMENTS.subcategoryID#" cfsqltype="cf_sql_integer">
784: </cfquery>
785: <cfreturn getSubcategoryInfoBySubcategoryID>
786: </cffunction>
|
| | column | | | id | | | line | | | Raw_Trace | | string | model.gateway.sitemanager_cfc$cf.udfCall2(/model/gateway/siteManager.cfc:784) |
| | template | | string | C:\sites\websam\site\model\gateway\siteManager.cfc |
| | type | |
| | 2 | | Struct | | codePrintHTML | | string | 76: <cfargument name="siteID" type="numeric" required="true"><br>
77: <cfargument name="subCategoryID" type="numeric" required="true"><br>
<b>78: <cfreturn APPLICATION.getsiteManagerGateway().getSubcategoryInfoBySubcategoryID(siteID=ARGUMENTS.siteID,subCategoryID=ARGUMENTS.subCategoryID)> </b><br>
79: </cffunction><br>
80: <br>
|
| | codePrintPlain | | string | 76: <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 | | | id | | | line | | | Raw_Trace | | string | model.service.sitemanager_cfc$cf.udfCall2(/model/service/siteManager.cfc:78) |
| | template | | string | C:\sites\websam\site\model\service\siteManager.cfc |
| | type | |
| | 3 | | Struct | | codePrintHTML | | string | 7: <br>
8: <cfset VARIABLES.productList = APPLICATION.getsiteManagerService().getProductList(siteID=APPLICATION.siteDetails.site_id,deptID=SESSION.employeeDetails.dept_id,subCategoryID= VARIABLES.subCategoryID)/><br>
<b>9: <cfset VARIABLES.subCategoryInfo=APPLICATION.getsiteManagerService().getSubcategoryInfoBySubcategoryID(#APPLICATION.siteDetails.site_id#,#VARIABLES.subCategoryID#)></b><br>
10: <cfparam name="VARIABLES.type" default="hidden"><br>
11: <cfset LOCAL.totalCards = VARIABLES.productList.recordCount><br>
|
| | codePrintPlain | | string | 7:
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 | | | id | | | line | | | Raw_Trace | | string | layouts.sitelayouts.siteproductlist_cfm$cf$2.call(/layouts/siteLayouts/siteProductList.cfm:9) |
| | template | | string | C:\sites\websam\site\layouts\siteLayouts\siteProductList.cfm |
| | type | |
| | 4 | | Struct | | codePrintHTML | | string | <b>1: <cfinclude template="../../layouts/siteLayouts/siteProductList.cfm"></b><br>
|
| | codePrintPlain | | string | 1: <cfinclude template="../../layouts/siteLayouts/siteProductList.cfm">
|
| | column | | | id | | | line | | | Raw_Trace | | string | views.productview.productdetails_cfm$cf$1.call(/views/productview/productdetails.cfm:1) |
| | template | | string | C:\sites\websam\site\views\productview\productdetails.cfm |
| | type | |
| | 5 | | Struct | | codePrintHTML | | string | 1991: response = '';<br>
1992: savecontent variable="response" {<br>
<b>1993: include '#viewPath#';</b><br>
1994: }<br>
1995: }<br>
|
| | codePrintPlain | | string | 1991: response = '';
1992: savecontent variable="response" {
1993: include '#viewPath#';
1994: }
1995: }
|
| | column | | | id | | | line | | | Raw_Trace | | string | framework.one_cfc$cf.udfCallc(/framework/one.cfc:1993) |
| | template | | string | C:\sites\websam\site\framework\one.cfc |
| | type | |
| | 6 | | Struct | | codePrintHTML | | string | 919: if ( structKeyExists(request._fw1, 'view') ) {<br>
920: internalFrameworkTrace( 'rendering #request._fw1.view#' );<br>
<b>921: out = internalView( request._fw1.view );</b><br>
922: } else if ( structKeyExists(request._fw1, 'omvInProgress') ) {<br>
923: internalFrameworkTrace( 'viewNotFound() called' );<br>
|
| | codePrintPlain | | string | 919: 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 | | | id | | | line | | | Raw_Trace | | string | framework.one_cfc$cf.udfCall6(/framework/one.cfc:921) |
| | template | | string | C:\sites\websam\site\framework\one.cfc |
| | type | |
|
| | type | | | where | |
|
| DataSource | |
| Detail | |
| ErrorCode | |
| Extended_Info | |
| ExtendedInfo | |
| Message | | string | QoQ HSQLDB: error executing sql statement on query. |
|
| name | |
| NativeErrorCode | |
| queryError | | string | SELECT sub_category_id,sub_category_name,category_name,category_id,sub_category_description
FROM VARIABLES_subcategoryList
WHERE sub_category_id=63 |
|
| rootCause | Struct
Entries: 16 | | additional | | Struct (ordered) | | SQL | | string | SELECT sub_category_id,sub_category_name,category_name,category_id,sub_category_description
FROM VARIABLES_subcategoryList
WHERE sub_category_id=63 |
|
| | Cause | Struct
Entries: 16 | | additional | | Struct (ordered) | | SQL | | string | SELECT sub_category_id,sub_category_name,category_name,category_id,sub_category_description
FROM VARIABLES_subcategoryList
WHERE sub_category_id=63 |
|
| | Cause | Struct
Entries: 12 | | additional | | | Detail | | | ErrorCode | | | Extended_Info | | | ExtendedInfo | | | LargeUpdateCounts | | Native Array (long[]) | | 1 | | | 2 | | | 3 | | | 4 | | | 5 | | | 6 | | | 7 | | | 8 | | | 9 | | | 10 | | | 11 | | | 12 | | | 13 | | | 14 | | | 15 | | | 16 | | | 17 | | | 18 | | | 19 | | | 20 | | | 21 | | | 22 | | | 23 | | | 24 | | | 25 | | | 26 | | | 27 | | | 28 | | | 29 | | | 30 | | | 31 | | | 32 | | | 33 | | | 34 | | | 35 | | | 36 | | | 37 | | | 38 | | | 39 | | | 40 | | | 41 | | | 42 | | | 43 | | | 44 | | | 45 | | | 46 | | | 47 | | | 48 | | | 49 | | | 50 | | | 51 | | | 52 | | | 53 | | | 54 | | | 55 | | | 56 | | | 57 | | | 58 | | | 59 | | | 60 | | | 61 | | | 62 | | | 63 | | | 64 | | | 65 | | | 66 | | | 67 | | | 68 | | | 69 | | | 70 | | | 71 | | | 72 | | | 73 | | | 74 | | | 75 | | | 76 | | | 77 | | | 78 | | | 79 | | | 80 | | | 81 | | | 82 | | | 83 | | | 84 | | | 85 | | | 86 | | | 87 | | | 88 | | | 89 | | | 90 | | | 91 | | | 92 | | | 93 | | | 94 | | | 95 | | | 96 | | | 97 | | | 98 | | | 99 | | | 100 | | | 101 | | | 102 | | | 103 | | | 104 | | | 105 | | | 106 | | | 107 | | | 108 | | | 109 | | | 110 | | | 111 | | | 112 | | | 113 | | | 114 | | | 115 | | | 116 | | | 117 | | | 118 | | | 119 | | | 120 | | | 121 | | | 122 | | | 123 | | | 124 | | | 125 | | | 126 | | | 127 | | | 128 | | | 129 | | | 130 | | | 131 | | | 132 | | | 133 | | | 134 | | | 135 | | | 136 | | | 137 | | | 138 | | | 139 | | | 140 | | | 141 | | | 142 | | | 143 | | | 144 | | | 145 | | | 146 | | | 147 | | | 148 | | | 149 | | | 150 | | | 151 | | | 152 | | | 153 | | | 154 | | | 155 | | | 156 | | | 157 | | | 158 | | | 159 | | | 160 | | | 161 | | | 162 | | | 163 | | | 164 | | | 165 | | | 166 | | | 167 | | | 168 | | | 169 | | | 170 | | | 171 | | | 172 | | | 173 | | | 174 | | | 175 | | | 176 | | | 177 | | | 178 | | | 179 | | | 180 | | | 181 | | | 182 | | | 183 | | | 184 | | | 185 | | | 186 | | | 187 | | | 188 | | | 189 | | | 190 | | | 191 | | | 192 | | | 193 | | | 194 | | | 195 | | | 196 | | | 197 | | | 198 | | | 199 | | | 200 | | | 201 | | | 202 | | | 203 | | | 204 | | | 205 | | | 206 | | | 207 | | | 208 | | | 209 | | | 210 | | | 211 | | | 212 | | | 213 | | | 214 | | | 215 | | | 216 | | | 217 | | | 218 | | | 219 | | | 220 | | | 221 | | | 222 | | | 223 | | | 224 | | | 225 | | | 226 | | | 227 | | | 228 | | | 229 | | | 230 | | | 231 | | | 232 | | | 233 | | | 234 | | | 235 | | | 236 | | | 237 | | | 238 | | | 239 | | | 240 | | | 241 | | | 242 | | | 243 | | | 244 | | | 245 | | | 246 | | | 247 | | | 248 | | | 249 | | | 250 | | | 251 | | | 252 | | | 253 | | | 254 | | | 255 | | | 256 | | | 257 | | | 258 | | | 259 | | | 260 | | | 261 | | | 262 | | | 263 | | | 264 | | | 265 | | | 266 | | | 267 | | | 268 | | | 269 | | | 270 | | | 271 | | | 272 | | | 273 | | | 274 | | | 275 | | | 276 | | | 277 | | | 278 | | | 279 | | | 280 | | | 281 | | | 282 | | | 283 | | | 284 | | | 285 | | | 286 | | | 287 | | | 288 | | | 289 | | | 290 | | | 291 | | | 292 | | | 293 | | | 294 | | | 295 | | | 296 | | | 297 | | | 298 | | | 299 | | | 300 | | | 301 | | | 302 | | | 303 | | | 304 | | | 305 | | | 306 | | | 307 | | | 308 | | | 309 | | | 310 | | | 311 | | | 312 | |
| | Message | | string | data exception: string data, right truncation ; size limit: 32768 table: VARIABLES_SUBCATEGORYLIST column: PRODUCT_DESCRIPTION |
| | SQLState | | | StackTrace | | string | lucee.runtime.exp.NativeException: data exception: string data, right truncation ; size limit: 32768 table: VARIABLES_SUBCATEGORYLIST column: PRODUCT_DESCRIPTION
at org.hsqldb.jdbc.JDBCPreparedStatement.executeBatch(Unknown Source)
at lucee.runtime.db.HSQLDBHandler.populateTable(HSQLDBHandler.java:260)
at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:617)
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: java.sql.BatchUpdateException: data exception: string data, right truncation ; size limit: 32768 table: VARIABLES_SUBCATEGORYLIST column: PRODUCT_DESCRIPTION
... 83 more
|
| | TagContext | | Array | | 1 | | Struct | | codePrintHTML | | string | 782: FROM VARIABLES.subcategoryList<br>
783: WHERE sub_category_id=<cfqueryparam value="#ARGUMENTS.subcategoryID#" cfsqltype="cf_sql_integer"><br>
<b>784: </cfquery></b><br>
785: <cfreturn getSubcategoryInfoBySubcategoryID><br>
786: </cffunction><br>
|
| | codePrintPlain | | string | 782: FROM VARIABLES.subcategoryList
783: WHERE sub_category_id=<cfqueryparam value="#ARGUMENTS.subcategoryID#" cfsqltype="cf_sql_integer">
784: </cfquery>
785: <cfreturn getSubcategoryInfoBySubcategoryID>
786: </cffunction>
|
| | column | | | id | | | line | | | Raw_Trace | | string | model.gateway.sitemanager_cfc$cf.udfCall2(/model/gateway/siteManager.cfc:784) |
| | template | | string | C:\sites\websam\site\model\gateway\siteManager.cfc |
| | type | |
| | 2 | | Struct | | codePrintHTML | | string | 76: <cfargument name="siteID" type="numeric" required="true"><br>
77: <cfargument name="subCategoryID" type="numeric" required="true"><br>
<b>78: <cfreturn APPLICATION.getsiteManagerGateway().getSubcategoryInfoBySubcategoryID(siteID=ARGUMENTS.siteID,subCategoryID=ARGUMENTS.subCategoryID)> </b><br>
79: </cffunction><br>
80: <br>
|
| | codePrintPlain | | string | 76: <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 | | | id | | | line | | | Raw_Trace | | string | model.service.sitemanager_cfc$cf.udfCall2(/model/service/siteManager.cfc:78) |
| | template | | string | C:\sites\websam\site\model\service\siteManager.cfc |
| | type | |
| | 3 | | Struct | | codePrintHTML | | string | 7: <br>
8: <cfset VARIABLES.productList = APPLICATION.getsiteManagerService().getProductList(siteID=APPLICATION.siteDetails.site_id,deptID=SESSION.employeeDetails.dept_id,subCategoryID= VARIABLES.subCategoryID)/><br>
<b>9: <cfset VARIABLES.subCategoryInfo=APPLICATION.getsiteManagerService().getSubcategoryInfoBySubcategoryID(#APPLICATION.siteDetails.site_id#,#VARIABLES.subCategoryID#)></b><br>
10: <cfparam name="VARIABLES.type" default="hidden"><br>
11: <cfset LOCAL.totalCards = VARIABLES.productList.recordCount><br>
|
| | codePrintPlain | | string | 7:
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 | | | id | | | line | | | Raw_Trace | | string | layouts.sitelayouts.siteproductlist_cfm$cf$2.call(/layouts/siteLayouts/siteProductList.cfm:9) |
| | template | | string | C:\sites\websam\site\layouts\siteLayouts\siteProductList.cfm |
| | type | |
| | 4 | | Struct | | codePrintHTML | | string | <b>1: <cfinclude template="../../layouts/siteLayouts/siteProductList.cfm"></b><br>
|
| | codePrintPlain | | string | 1: <cfinclude template="../../layouts/siteLayouts/siteProductList.cfm">
|
| | column | | | id | | | line | | | Raw_Trace | | string | views.productview.productdetails_cfm$cf$1.call(/views/productview/productdetails.cfm:1) |
| | template | | string | C:\sites\websam\site\views\productview\productdetails.cfm |
| | type | |
| | 5 | | Struct | | codePrintHTML | | string | 1991: response = '';<br>
1992: savecontent variable="response" {<br>
<b>1993: include '#viewPath#';</b><br>
1994: }<br>
1995: }<br>
|
| | codePrintPlain | | string | 1991: response = '';
1992: savecontent variable="response" {
1993: include '#viewPath#';
1994: }
1995: }
|
| | column | | | id | | | line | | | Raw_Trace | | string | framework.one_cfc$cf.udfCallc(/framework/one.cfc:1993) |
| | template | | string | C:\sites\websam\site\framework\one.cfc |
| | type | |
| | 6 | | Struct | | codePrintHTML | | string | 919: if ( structKeyExists(request._fw1, 'view') ) {<br>
920: internalFrameworkTrace( 'rendering #request._fw1.view#' );<br>
<b>921: out = internalView( request._fw1.view );</b><br>
922: } else if ( structKeyExists(request._fw1, 'omvInProgress') ) {<br>
923: internalFrameworkTrace( 'viewNotFound() called' );<br>
|
| | codePrintPlain | | string | 919: 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 | | | id | | | line | | | Raw_Trace | | string | framework.one_cfc$cf.udfCall6(/framework/one.cfc:921) |
| | template | | string | C:\sites\websam\site\framework\one.cfc |
| | type | |
|
| | type | | string | java.sql.BatchUpdateException |
| | UpdateCounts | | Native Array (int[]) | | 1 | | | 2 | | | 3 | | | 4 | | | 5 | | | 6 | | | 7 | | | 8 | | | 9 | | | 10 | | | 11 | | | 12 | | | 13 | | | 14 | | | 15 | | | 16 | | | 17 | | | 18 | | | 19 | | | 20 | | | 21 | | | 22 | | | 23 | | | 24 | | | 25 | | | 26 | | | 27 | | | 28 | | | 29 | | | 30 | | | 31 | | | 32 | | | 33 | | | 34 | | | 35 | | | 36 | | | 37 | | | 38 | | | 39 | | | 40 | | | 41 | | | 42 | | | 43 | | | 44 | | | 45 | | | 46 | | | 47 | | | 48 | | | 49 | | | 50 | | | 51 | | | 52 | | | 53 | | | 54 | | | 55 | | | 56 | | | 57 | | | 58 | | | 59 | | | 60 | | | 61 | | | 62 | | | 63 | | | 64 | | | 65 | | | 66 | | | 67 | | | 68 | | | 69 | | | 70 | | | 71 | | | 72 | | | 73 | | | 74 | | | 75 | | | 76 | | | 77 | | | 78 | | | 79 | | | 80 | | | 81 | | | 82 | | | 83 | | | 84 | | | 85 | | | 86 | | | 87 | | | 88 | | | 89 | | | 90 | | | 91 | | | 92 | | | 93 | | | 94 | | | 95 | | | 96 | | | 97 | | | 98 | | | 99 | | | 100 | | | 101 | | | 102 | | | 103 | | | 104 | | | 105 | | | 106 | | | 107 | | | 108 | | | 109 | | | 110 | | | 111 | | | 112 | | | 113 | | | 114 | | | 115 | | | 116 | | | 117 | | | 118 | | | 119 | | | 120 | | | 121 | | | 122 | | | 123 | | | 124 | | | 125 | | | 126 | | | 127 | | | 128 | | | 129 | | | 130 | | | 131 | | | 132 | | | 133 | | | 134 | | | 135 | | | 136 | | | 137 | | | 138 | | | 139 | | | 140 | | | 141 | | | 142 | | | 143 | | | 144 | | | 145 | | | 146 | | | 147 | | | 148 | | | 149 | | | 150 | | | 151 | | | 152 | | | 153 | | | 154 | | | 155 | | | 156 | | | 157 | | | 158 | | | 159 | | | 160 | | | 161 | | | 162 | | | 163 | | | 164 | | | 165 | | | 166 | | | 167 | | | 168 | | | 169 | | | 170 | | | 171 | | | 172 | | | 173 | | | 174 | | | 175 | | | 176 | | | 177 | | | 178 | | | 179 | | | 180 | | | 181 | | | 182 | | | 183 | | | 184 | | | 185 | | | 186 | | | 187 | | | 188 | | | 189 | | | 190 | | | 191 | | | 192 | | | 193 | | | 194 | | | 195 | | | 196 | | | 197 | | | 198 | | | 199 | | | 200 | | | 201 | | | 202 | | | 203 | | | 204 | | | 205 | | | 206 | | | 207 | | | 208 | | | 209 | | | 210 | | | 211 | | | 212 | | | 213 | | | 214 | | | 215 | | | 216 | | | 217 | | | 218 | | | 219 | | | 220 | | | 221 | | | 222 | | | 223 | | | 224 | | | 225 | | | 226 | | | 227 | | | 228 | | | 229 | | | 230 | | | 231 | | | 232 | | | 233 | | | 234 | | | 235 | | | 236 | | | 237 | | | 238 | | | 239 | | | 240 | | | 241 | | | 242 | | | 243 | | | 244 | | | 245 | | | 246 | | | 247 | | | 248 | | | 249 | | | 250 | | | 251 | | | 252 | | | 253 | | | 254 | | | 255 | | | 256 | | | 257 | | | 258 | | | 259 | | | 260 | | | 261 | | | 262 | | | 263 | | | 264 | | | 265 | | | 266 | | | 267 | | | 268 | | | 269 | | | 270 | | | 271 | | | 272 | | | 273 | | | 274 | | | 275 | | | 276 | | | 277 | | | 278 | | | 279 | | | 280 | | | 281 | | | 282 | | | 283 | | | 284 | | | 285 | | | 286 | | | 287 | | | 288 | | | 289 | | | 290 | | | 291 | | | 292 | | | 293 | | | 294 | | | 295 | | | 296 | | | 297 | | | 298 | | | 299 | | | 300 | | | 301 | | | 302 | | | 303 | | | 304 | | | 305 | | | 306 | | | 307 | | | 308 | | | 309 | | | 310 | | | 311 | | | 312 | |
|
| | DataSource | | | Detail | | string | data exception: string data, right truncation ; size limit: 32768 table: VARIABLES_SUBCATEGORYLIST column: PRODUCT_DESCRIPTION |
| | ErrorCode | | | Extended_Info | | | ExtendedInfo | | | Message | | string | QoQ HSQLDB: error executing sql statement on query. |
| | NativeErrorCode | | | queryError | | string | SELECT sub_category_id,sub_category_name,category_name,category_id,sub_category_description
FROM VARIABLES_subcategoryList
WHERE sub_category_id=63 |
| | Sql | | string | SELECT sub_category_id,sub_category_name,category_name,category_id,sub_category_description
FROM VARIABLES_subcategoryList
WHERE sub_category_id=63 |
| | SQLState | | | StackTrace | | string | lucee.runtime.exp.IllegalQoQException: QoQ HSQLDB: error executing sql statement on query.
at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:636)
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: java.sql.BatchUpdateException: data exception: string data, right truncation ; size limit: 32768 table: VARIABLES_SUBCATEGORYLIST column: PRODUCT_DESCRIPTION
at org.hsqldb.jdbc.JDBCPreparedStatement.executeBatch(Unknown Source)
at lucee.runtime.db.HSQLDBHandler.populateTable(HSQLDBHandler.java:260)
at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:617)
... 80 more
|
| | TagContext | | Array | | 1 | | Struct | | codePrintHTML | | string | 782: FROM VARIABLES.subcategoryList<br>
783: WHERE sub_category_id=<cfqueryparam value="#ARGUMENTS.subcategoryID#" cfsqltype="cf_sql_integer"><br>
<b>784: </cfquery></b><br>
785: <cfreturn getSubcategoryInfoBySubcategoryID><br>
786: </cffunction><br>
|
| | codePrintPlain | | string | 782: FROM VARIABLES.subcategoryList
783: WHERE sub_category_id=<cfqueryparam value="#ARGUMENTS.subcategoryID#" cfsqltype="cf_sql_integer">
784: </cfquery>
785: <cfreturn getSubcategoryInfoBySubcategoryID>
786: </cffunction>
|
| | column | | | id | | | line | | | Raw_Trace | | string | model.gateway.sitemanager_cfc$cf.udfCall2(/model/gateway/siteManager.cfc:784) |
| | template | | string | C:\sites\websam\site\model\gateway\siteManager.cfc |
| | type | |
| | 2 | | Struct | | codePrintHTML | | string | 76: <cfargument name="siteID" type="numeric" required="true"><br>
77: <cfargument name="subCategoryID" type="numeric" required="true"><br>
<b>78: <cfreturn APPLICATION.getsiteManagerGateway().getSubcategoryInfoBySubcategoryID(siteID=ARGUMENTS.siteID,subCategoryID=ARGUMENTS.subCategoryID)> </b><br>
79: </cffunction><br>
80: <br>
|
| | codePrintPlain | | string | 76: <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 | | | id | | | line | | | Raw_Trace | | string | model.service.sitemanager_cfc$cf.udfCall2(/model/service/siteManager.cfc:78) |
| | template | | string | C:\sites\websam\site\model\service\siteManager.cfc |
| | type | |
| | 3 | | Struct | | codePrintHTML | | string | 7: <br>
8: <cfset VARIABLES.productList = APPLICATION.getsiteManagerService().getProductList(siteID=APPLICATION.siteDetails.site_id,deptID=SESSION.employeeDetails.dept_id,subCategoryID= VARIABLES.subCategoryID)/><br>
<b>9: <cfset VARIABLES.subCategoryInfo=APPLICATION.getsiteManagerService().getSubcategoryInfoBySubcategoryID(#APPLICATION.siteDetails.site_id#,#VARIABLES.subCategoryID#)></b><br>
10: <cfparam name="VARIABLES.type" default="hidden"><br>
11: <cfset LOCAL.totalCards = VARIABLES.productList.recordCount><br>
|
| | codePrintPlain | | string | 7:
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 | | | id | | | line | | | Raw_Trace | | string | layouts.sitelayouts.siteproductlist_cfm$cf$2.call(/layouts/siteLayouts/siteProductList.cfm:9) |
| | template | | string | C:\sites\websam\site\layouts\siteLayouts\siteProductList.cfm |
| | type | |
| | 4 | | Struct | | codePrintHTML | | string | <b>1: <cfinclude template="../../layouts/siteLayouts/siteProductList.cfm"></b><br>
|
| | codePrintPlain | | string | 1: <cfinclude template="../../layouts/siteLayouts/siteProductList.cfm">
|
| | column | | | id | | | line | | | Raw_Trace | | string | views.productview.productdetails_cfm$cf$1.call(/views/productview/productdetails.cfm:1) |
| | template | | string | C:\sites\websam\site\views\productview\productdetails.cfm |
| | type | |
| | 5 | | Struct | | codePrintHTML | | string | 1991: response = '';<br>
1992: savecontent variable="response" {<br>
<b>1993: include '#viewPath#';</b><br>
1994: }<br>
1995: }<br>
|
| | codePrintPlain | | string | 1991: response = '';
1992: savecontent variable="response" {
1993: include '#viewPath#';
1994: }
1995: }
|
| | column | | | id | | | line | | | Raw_Trace | | string | framework.one_cfc$cf.udfCallc(/framework/one.cfc:1993) |
| | template | | string | C:\sites\websam\site\framework\one.cfc |
| | type | |
| | 6 | | Struct | | codePrintHTML | | string | 919: if ( structKeyExists(request._fw1, 'view') ) {<br>
920: internalFrameworkTrace( 'rendering #request._fw1.view#' );<br>
<b>921: out = internalView( request._fw1.view );</b><br>
922: } else if ( structKeyExists(request._fw1, 'omvInProgress') ) {<br>
923: internalFrameworkTrace( 'viewNotFound() called' );<br>
|
| | codePrintPlain | | string | 919: 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 | | | id | | | line | | | Raw_Trace | | string | framework.one_cfc$cf.udfCall6(/framework/one.cfc:921) |
| | template | | string | C:\sites\websam\site\framework\one.cfc |
| | type | |
|
| | type | | | where | |
| | DataSource | | | Detail | | | ErrorCode | | | Extended_Info | | | ExtendedInfo | | | Message | | string | QoQ HSQLDB: error executing sql statement on query. |
| | NativeErrorCode | | | queryError | | string | SELECT sub_category_id,sub_category_name,category_name,category_id,sub_category_description
FROM VARIABLES_subcategoryList
WHERE sub_category_id=63 |
| | Sql | | string | SELECT sub_category_id,sub_category_name,category_name,category_id,sub_category_description
FROM VARIABLES_subcategoryList
WHERE sub_category_id=63 |
| | SQLState | | | StackTrace | | string | lucee.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.IllegalQoQException: QoQ HSQLDB: error executing sql statement on query.
at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:636)
... 80 more
Caused by: java.sql.BatchUpdateException: data exception: string data, right truncation ; size limit: 32768 table: VARIABLES_SUBCATEGORYLIST column: PRODUCT_DESCRIPTION
at org.hsqldb.jdbc.JDBCPreparedStatement.executeBatch(Unknown Source)
at lucee.runtime.db.HSQLDBHandler.populateTable(HSQLDBHandler.java:260)
at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:617)
... 80 more
|
| | TagContext | | Array | | 1 | | Struct | | codePrintHTML | | string | 782: FROM VARIABLES.subcategoryList<br>
783: WHERE sub_category_id=<cfqueryparam value="#ARGUMENTS.subcategoryID#" cfsqltype="cf_sql_integer"><br>
<b>784: </cfquery></b><br>
785: <cfreturn getSubcategoryInfoBySubcategoryID><br>
786: </cffunction><br>
|
| | codePrintPlain | | string | 782: FROM VARIABLES.subcategoryList
783: WHERE sub_category_id=<cfqueryparam value="#ARGUMENTS.subcategoryID#" cfsqltype="cf_sql_integer">
784: </cfquery>
785: <cfreturn getSubcategoryInfoBySubcategoryID>
786: </cffunction>
|
| | column | | | id | | | line | | | Raw_Trace | | string | model.gateway.sitemanager_cfc$cf.udfCall2(/model/gateway/siteManager.cfc:784) |
| | template | | string | C:\sites\websam\site\model\gateway\siteManager.cfc |
| | type | |
| | 2 | | Struct | | codePrintHTML | | string | 76: <cfargument name="siteID" type="numeric" required="true"><br>
77: <cfargument name="subCategoryID" type="numeric" required="true"><br>
<b>78: <cfreturn APPLICATION.getsiteManagerGateway().getSubcategoryInfoBySubcategoryID(siteID=ARGUMENTS.siteID,subCategoryID=ARGUMENTS.subCategoryID)> </b><br>
79: </cffunction><br>
80: <br>
|
| | codePrintPlain | | string | 76: <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 | | | id | | | line | | | Raw_Trace | | string | model.service.sitemanager_cfc$cf.udfCall2(/model/service/siteManager.cfc:78) |
| | template | | string | C:\sites\websam\site\model\service\siteManager.cfc |
| | type | |
| | 3 | | Struct | | codePrintHTML | | string | 7: <br>
8: <cfset VARIABLES.productList = APPLICATION.getsiteManagerService().getProductList(siteID=APPLICATION.siteDetails.site_id,deptID=SESSION.employeeDetails.dept_id,subCategoryID= VARIABLES.subCategoryID)/><br>
<b>9: <cfset VARIABLES.subCategoryInfo=APPLICATION.getsiteManagerService().getSubcategoryInfoBySubcategoryID(#APPLICATION.siteDetails.site_id#,#VARIABLES.subCategoryID#)></b><br>
10: <cfparam name="VARIABLES.type" default="hidden"><br>
11: <cfset LOCAL.totalCards = VARIABLES.productList.recordCount><br>
|
| | codePrintPlain | | string | 7:
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 | | | id | | | line | | | Raw_Trace | | string | layouts.sitelayouts.siteproductlist_cfm$cf$2.call(/layouts/siteLayouts/siteProductList.cfm:9) |
| | template | | string | C:\sites\websam\site\layouts\siteLayouts\siteProductList.cfm |
| | type | |
| | 4 | | Struct | | codePrintHTML | | string | <b>1: <cfinclude template="../../layouts/siteLayouts/siteProductList.cfm"></b><br>
|
| | codePrintPlain | | string | 1: <cfinclude template="../../layouts/siteLayouts/siteProductList.cfm">
|
| | column | | | id | | | line | | | Raw_Trace | | string | views.productview.productdetails_cfm$cf$1.call(/views/productview/productdetails.cfm:1) |
| | template | | string | C:\sites\websam\site\views\productview\productdetails.cfm |
| | type | |
| | 5 | | Struct | | codePrintHTML | | string | 1991: response = '';<br>
1992: savecontent variable="response" {<br>
<b>1993: include '#viewPath#';</b><br>
1994: }<br>
1995: }<br>
|
| | codePrintPlain | | string | 1991: response = '';
1992: savecontent variable="response" {
1993: include '#viewPath#';
1994: }
1995: }
|
| | column | | | id | | | line | | | Raw_Trace | | string | framework.one_cfc$cf.udfCallc(/framework/one.cfc:1993) |
| | template | | string | C:\sites\websam\site\framework\one.cfc |
| | type | |
| | 6 | | Struct | | codePrintHTML | | string | 919: if ( structKeyExists(request._fw1, 'view') ) {<br>
920: internalFrameworkTrace( 'rendering #request._fw1.view#' );<br>
<b>921: out = internalView( request._fw1.view );</b><br>
922: } else if ( structKeyExists(request._fw1, 'omvInProgress') ) {<br>
923: internalFrameworkTrace( 'viewNotFound() called' );<br>
|
| | codePrintPlain | | string | 919: 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 | | | id | | | line | | | Raw_Trace | | string | framework.one_cfc$cf.udfCall6(/framework/one.cfc:921) |
| | template | | string | C:\sites\websam\site\framework\one.cfc |
| | type | |
|
| | type | | | where | |
|
| Sql | | string | SELECT sub_category_id,sub_category_name,category_name,category_id,sub_category_description
FROM VARIABLES_subcategoryList
WHERE sub_category_id=63 |
|
| SQLState | |
| StackTrace | | string | lucee.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.IllegalQoQException: QoQ HSQLDB: error executing sql statement on query.
at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:636)
... 80 more
Caused by: java.sql.BatchUpdateException: data exception: string data, right truncation ; size limit: 32768 table: VARIABLES_SUBCATEGORYLIST column: PRODUCT_DESCRIPTION
at org.hsqldb.jdbc.JDBCPreparedStatement.executeBatch(Unknown Source)
at lucee.runtime.db.HSQLDBHandler.populateTable(HSQLDBHandler.java:260)
at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:617)
... 80 more
|
|
| TagContext | | Array | | 1 | | Struct | | codePrintHTML | | string | 782: FROM VARIABLES.subcategoryList<br>
783: WHERE sub_category_id=<cfqueryparam value="#ARGUMENTS.subcategoryID#" cfsqltype="cf_sql_integer"><br>
<b>784: </cfquery></b><br>
785: <cfreturn getSubcategoryInfoBySubcategoryID><br>
786: </cffunction><br>
|
| | codePrintPlain | | string | 782: FROM VARIABLES.subcategoryList
783: WHERE sub_category_id=<cfqueryparam value="#ARGUMENTS.subcategoryID#" cfsqltype="cf_sql_integer">
784: </cfquery>
785: <cfreturn getSubcategoryInfoBySubcategoryID>
786: </cffunction>
|
| | column | | | id | | | line | | | Raw_Trace | | string | model.gateway.sitemanager_cfc$cf.udfCall2(/model/gateway/siteManager.cfc:784) |
| | template | | string | C:\sites\websam\site\model\gateway\siteManager.cfc |
| | type | |
| | 2 | | Struct | | codePrintHTML | | string | 76: <cfargument name="siteID" type="numeric" required="true"><br>
77: <cfargument name="subCategoryID" type="numeric" required="true"><br>
<b>78: <cfreturn APPLICATION.getsiteManagerGateway().getSubcategoryInfoBySubcategoryID(siteID=ARGUMENTS.siteID,subCategoryID=ARGUMENTS.subCategoryID)> </b><br>
79: </cffunction><br>
80: <br>
|
| | codePrintPlain | | string | 76: <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 | | | id | | | line | | | Raw_Trace | | string | model.service.sitemanager_cfc$cf.udfCall2(/model/service/siteManager.cfc:78) |
| | template | | string | C:\sites\websam\site\model\service\siteManager.cfc |
| | type | |
| | 3 | | Struct | | codePrintHTML | | string | 7: <br>
8: <cfset VARIABLES.productList = APPLICATION.getsiteManagerService().getProductList(siteID=APPLICATION.siteDetails.site_id,deptID=SESSION.employeeDetails.dept_id,subCategoryID= VARIABLES.subCategoryID)/><br>
<b>9: <cfset VARIABLES.subCategoryInfo=APPLICATION.getsiteManagerService().getSubcategoryInfoBySubcategoryID(#APPLICATION.siteDetails.site_id#,#VARIABLES.subCategoryID#)></b><br>
10: <cfparam name="VARIABLES.type" default="hidden"><br>
11: <cfset LOCAL.totalCards = VARIABLES.productList.recordCount><br>
|
| | codePrintPlain | | string | 7:
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 | | | id | | | line | | | Raw_Trace | | string | layouts.sitelayouts.siteproductlist_cfm$cf$2.call(/layouts/siteLayouts/siteProductList.cfm:9) |
| | template | | string | C:\sites\websam\site\layouts\siteLayouts\siteProductList.cfm |
| | type | |
| | 4 | | Struct | | codePrintHTML | | string | <b>1: <cfinclude template="../../layouts/siteLayouts/siteProductList.cfm"></b><br>
|
| | codePrintPlain | | string | 1: <cfinclude template="../../layouts/siteLayouts/siteProductList.cfm">
|
| | column | | | id | | | line | | | Raw_Trace | | string | views.productview.productdetails_cfm$cf$1.call(/views/productview/productdetails.cfm:1) |
| | template | | string | C:\sites\websam\site\views\productview\productdetails.cfm |
| | type | |
| | 5 | | Struct | | codePrintHTML | | string | 1991: response = '';<br>
1992: savecontent variable="response" {<br>
<b>1993: include '#viewPath#';</b><br>
1994: }<br>
1995: }<br>
|
| | codePrintPlain | | string | 1991: response = '';
1992: savecontent variable="response" {
1993: include '#viewPath#';
1994: }
1995: }
|
| | column | | | id | | | line | | | Raw_Trace | | string | framework.one_cfc$cf.udfCallc(/framework/one.cfc:1993) |
| | template | | string | C:\sites\websam\site\framework\one.cfc |
| | type | |
| | 6 | | Struct | | codePrintHTML | | string | 919: if ( structKeyExists(request._fw1, 'view') ) {<br>
920: internalFrameworkTrace( 'rendering #request._fw1.view#' );<br>
<b>921: out = internalView( request._fw1.view );</b><br>
922: } else if ( structKeyExists(request._fw1, 'omvInProgress') ) {<br>
923: internalFrameworkTrace( 'viewNotFound() called' );<br>
|
| | codePrintPlain | | string | 919: 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 | | | id | | | line | | | Raw_Trace | | string | framework.one_cfc$cf.udfCall6(/framework/one.cfc:921) |
| | template | | string | C:\sites\websam\site\framework\one.cfc |
| | type | |
|
|
| type | |
| where | |