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=325 |
|
|
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=325 |
|
| 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=325 |
|
| 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=325 |
| Sql | string | SELECT sub_category_id,sub_category_name,category_name,category_id,sub_category_description
FROM VARIABLES_subcategoryList
WHERE sub_category_id=325 |
| 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=325 |
| Sql | string | SELECT sub_category_id,sub_category_name,category_name,category_id,sub_category_description
FROM VARIABLES_subcategoryList
WHERE sub_category_id=325 |
| 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=325 |
|
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=325 |
|
| 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=325 |
|
| 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=325 |
| Sql | string | SELECT sub_category_id,sub_category_name,category_name,category_id,sub_category_description
FROM VARIABLES_subcategoryList
WHERE sub_category_id=325 |
| 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=325 |
| Sql | string | SELECT sub_category_id,sub_category_name,category_name,category_id,sub_category_description
FROM VARIABLES_subcategoryList
WHERE sub_category_id=325 |
| 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=325 |
|
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 | |