Catch
Entries: 18
additional
Struct (ordered)
SQL
stringSELECT sub_category_id,sub_category_name,category_name,category_id,sub_category_description FROM VARIABLES_subcategoryList WHERE sub_category_id=53
Cause
Struct
Entries: 16
additional
Struct (ordered)
SQL
stringSELECT sub_category_id,sub_category_name,category_name,category_id,sub_category_description FROM VARIABLES_subcategoryList WHERE sub_category_id=53
Cause
Struct
Entries: 16
additional
Struct (ordered)
SQL
stringSELECT sub_category_id,sub_category_name,category_name,category_id,sub_category_description FROM VARIABLES_subcategoryList WHERE sub_category_id=53
Cause
Struct
Entries: 12
additional
Struct (ordered)
Detail
string
ErrorCode
number3401
Extended_Info
string
ExtendedInfo
string
LargeUpdateCounts
Native Array (long[])
1
number1
2
number1
3
number1
4
number1
5
number1
6
number1
7
number1
8
number1
9
number1
10
number1
11
number1
12
number1
13
number1
14
number1
15
number1
16
number1
17
number1
18
number1
19
number1
20
number1
21
number1
22
number1
23
number1
24
number1
25
number1
26
number1
27
number1
28
number1
29
number1
30
number1
31
number1
32
number1
33
number1
34
number1
35
number1
36
number1
37
number1
38
number1
39
number1
40
number1
41
number1
42
number1
43
number1
44
number1
45
number1
46
number1
47
number1
48
number1
49
number1
50
number1
51
number1
52
number1
53
number1
54
number1
55
number1
56
number1
57
number1
58
number1
59
number1
60
number1
61
number1
62
number1
63
number1
64
number1
65
number1
66
number1
67
number1
68
number1
69
number1
70
number1
71
number1
72
number1
73
number1
74
number1
75
number1
76
number1
77
number1
78
number1
79
number1
80
number1
81
number1
82
number1
83
number1
84
number1
85
number1
86
number1
87
number1
88
number1
89
number1
90
number1
91
number1
92
number1
93
number1
94
number1
95
number1
96
number1
97
number1
98
number1
99
number1
100
number1
101
number1
102
number1
103
number1
104
number1
105
number1
106
number1
107
number1
108
number1
109
number1
110
number1
111
number1
112
number1
113
number1
114
number1
115
number1
116
number1
117
number1
118
number1
119
number1
120
number1
121
number1
122
number1
123
number1
124
number1
125
number1
126
number1
127
number1
128
number1
129
number1
130
number1
131
number1
132
number1
133
number1
134
number1
135
number1
136
number1
137
number1
138
number1
139
number1
140
number1
141
number1
142
number1
143
number1
144
number1
145
number1
146
number1
147
number1
148
number1
149
number1
150
number1
151
number1
152
number1
153
number1
154
number1
155
number1
156
number1
157
number1
158
number1
159
number1
160
number1
161
number1
162
number1
163
number1
164
number1
165
number1
166
number1
167
number1
168
number1
169
number1
170
number1
171
number1
172
number1
173
number1
174
number1
175
number1
176
number1
177
number1
178
number1
179
number1
180
number1
181
number1
182
number1
183
number1
184
number1
185
number1
186
number1
187
number1
188
number1
189
number1
190
number1
191
number1
192
number1
193
number1
194
number1
195
number1
196
number1
197
number1
198
number1
199
number1
200
number1
201
number1
202
number1
203
number1
204
number1
205
number1
206
number1
207
number1
208
number1
209
number1
210
number1
211
number1
212
number1
213
number1
214
number1
215
number1
216
number1
217
number1
218
number1
219
number1
220
number1
221
number1
222
number1
223
number1
224
number1
225
number1
226
number1
227
number1
228
number1
229
number1
230
number1
231
number1
232
number1
233
number1
234
number1
235
number1
236
number1
237
number1
238
number1
239
number1
240
number1
241
number1
242
number1
243
number1
244
number1
245
number1
246
number1
247
number1
248
number1
249
number1
250
number1
251
number1
252
number1
253
number1
254
number1
255
number1
256
number1
257
number1
258
number1
259
number1
260
number1
261
number1
262
number1
263
number1
264
number1
265
number1
266
number1
267
number1
268
number1
269
number1
270
number1
271
number1
272
number1
273
number1
274
number1
275
number1
276
number1
277
number1
278
number1
279
number1
280
number1
281
number1
282
number1
283
number1
284
number1
285
number1
286
number1
287
number1
288
number1
289
number1
290
number1
291
number1
292
number1
293
number1
294
number1
295
number1
296
number1
297
number1
298
number1
299
number1
300
number1
301
number1
302
number1
303
number1
304
number1
305
number1
306
number1
307
number1
308
number1
309
number1
310
number1
311
number1
312
number1
Message
stringdata exception: string data, right truncation ; size limit: 32768 table: VARIABLES_SUBCATEGORYLIST column: PRODUCT_DESCRIPTION
SQLState
string22001
StackTrace
stringlucee.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
string782: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FROM&nbsp;VARIABLES.subcategoryList<br> 783: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;WHERE&nbsp;sub_category_id=&lt;cfqueryparam&nbsp;value=&quot;#ARGUMENTS.subcategoryID#&quot;&nbsp;&nbsp;cfsqltype=&quot;cf_sql_integer&quot;&gt;<br> <b>784: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/cfquery&gt;</b><br> 785: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfreturn&nbsp;getSubcategoryInfoBySubcategoryID&gt;<br> 786: &nbsp;&nbsp;&nbsp;&lt;/cffunction&gt;<br>
codePrintPlain
string782: FROM VARIABLES.subcategoryList 783: WHERE sub_category_id=<cfqueryparam value="#ARGUMENTS.subcategoryID#" cfsqltype="cf_sql_integer"> 784: </cfquery> 785: <cfreturn getSubcategoryInfoBySubcategoryID> 786: </cffunction>
column
number0
id
string??
line
number784
Raw_Trace
stringmodel.gateway.sitemanager_cfc$cf.udfCall2(/model/gateway/siteManager.cfc:784)
template
stringC:\sites\websam\site\model\gateway\siteManager.cfc
type
stringcfml
2
Struct
codePrintHTML
string76: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfargument&nbsp;name=&quot;siteID&quot;&nbsp;type=&quot;numeric&quot;&nbsp;required=&quot;true&quot;&gt;<br> 77: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfargument&nbsp;name=&quot;subCategoryID&quot;&nbsp;type=&quot;numeric&quot;&nbsp;required=&quot;true&quot;&gt;<br> <b>78: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfreturn&nbsp;APPLICATION.getsiteManagerGateway().getSubcategoryInfoBySubcategoryID(siteID=ARGUMENTS.siteID,subCategoryID=ARGUMENTS.subCategoryID)&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</b><br> 79: &nbsp;&nbsp;&nbsp;&lt;/cffunction&gt;<br> 80: &nbsp;&nbsp;&nbsp;<br>
codePrintPlain
string76: <cfargument name="siteID" type="numeric" required="true"> 77: <cfargument name="subCategoryID" type="numeric" required="true"> 78: <cfreturn APPLICATION.getsiteManagerGateway().getSubcategoryInfoBySubcategoryID(siteID=ARGUMENTS.siteID,subCategoryID=ARGUMENTS.subCategoryID)> 79: </cffunction> 80:
column
number0
id
string??
line
number78
Raw_Trace
stringmodel.service.sitemanager_cfc$cf.udfCall2(/model/service/siteManager.cfc:78)
template
stringC:\sites\websam\site\model\service\siteManager.cfc
type
stringcfml
3
Struct
codePrintHTML
string7: <br> 8: &lt;cfset&nbsp;VARIABLES.productList&nbsp;=&nbsp;APPLICATION.getsiteManagerService().getProductList(siteID=APPLICATION.siteDetails.site_id,deptID=SESSION.employeeDetails.dept_id,subCategoryID=&nbsp;VARIABLES.subCategoryID)/&gt;<br> <b>9: &lt;cfset&nbsp;VARIABLES.subCategoryInfo=APPLICATION.getsiteManagerService().getSubcategoryInfoBySubcategoryID(#APPLICATION.siteDetails.site_id#,#VARIABLES.subCategoryID#)&gt;</b><br> 10: &lt;cfparam&nbsp;name=&quot;VARIABLES.type&quot;&nbsp;default=&quot;hidden&quot;&gt;<br> 11: &lt;cfset&nbsp;LOCAL.totalCards&nbsp;=&nbsp;VARIABLES.productList.recordCount&gt;<br>
codePrintPlain
string7: 8: <cfset VARIABLES.productList = APPLICATION.getsiteManagerService().getProductList(siteID=APPLICATION.siteDetails.site_id,deptID=SESSION.employeeDetails.dept_id,subCategoryID= VARIABLES.subCategoryID)/> 9: <cfset VARIABLES.subCategoryInfo=APPLICATION.getsiteManagerService().getSubcategoryInfoBySubcategoryID(#APPLICATION.siteDetails.site_id#,#VARIABLES.subCategoryID#)> 10: <cfparam name="VARIABLES.type" default="hidden"> 11: <cfset LOCAL.totalCards = VARIABLES.productList.recordCount>
column
number0
id
string??
line
number9
Raw_Trace
stringlayouts.sitelayouts.siteproductlist_cfm$cf$2.call(/layouts/siteLayouts/siteProductList.cfm:9)
template
stringC:\sites\websam\site\layouts\siteLayouts\siteProductList.cfm
type
stringcfml
4
Struct
codePrintHTML
string<b>1: &lt;cfinclude&nbsp;template=&quot;../../layouts/siteLayouts/siteProductList.cfm&quot;&gt;</b><br>
codePrintPlain
string1: <cfinclude template="../../layouts/siteLayouts/siteProductList.cfm">
column
number0
id
string??
line
number1
Raw_Trace
stringviews.productview.productdetails_cfm$cf$1.call(/views/productview/productdetails.cfm:1)
template
stringC:\sites\websam\site\views\productview\productdetails.cfm
type
stringcfml
5
Struct
codePrintHTML
string1991: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;response&nbsp;=&nbsp;'';<br> 1992: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;savecontent&nbsp;variable=&quot;response&quot;&nbsp;{<br> <b>1993: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;include&nbsp;'#viewPath#';</b><br> 1994: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br> 1995: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
codePrintPlain
string1991: response = ''; 1992: savecontent variable="response" { 1993: include '#viewPath#'; 1994: } 1995: }
column
number0
id
string??
line
number1993
Raw_Trace
stringframework.one_cfc$cf.udfCallc(/framework/one.cfc:1993)
template
stringC:\sites\websam\site\framework\one.cfc
type
stringcfml
6
Struct
codePrintHTML
string919: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(&nbsp;structKeyExists(request._fw1,&nbsp;'view')&nbsp;)&nbsp;{<br> 920: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;internalFrameworkTrace(&nbsp;'rendering&nbsp;#request._fw1.view#'&nbsp;);<br> <b>921: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;out&nbsp;=&nbsp;internalView(&nbsp;request._fw1.view&nbsp;);</b><br> 922: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;else&nbsp;if&nbsp;(&nbsp;structKeyExists(request._fw1,&nbsp;'omvInProgress')&nbsp;)&nbsp;{<br> 923: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;internalFrameworkTrace(&nbsp;'viewNotFound()&nbsp;called'&nbsp;);<br>
codePrintPlain
string919: if ( structKeyExists(request._fw1, 'view') ) { 920: internalFrameworkTrace( 'rendering #request._fw1.view#' ); 921: out = internalView( request._fw1.view ); 922: } else if ( structKeyExists(request._fw1, 'omvInProgress') ) { 923: internalFrameworkTrace( 'viewNotFound() called' );
column
number0
id
string??
line
number921
Raw_Trace
stringframework.one_cfc$cf.udfCall6(/framework/one.cfc:921)
template
stringC:\sites\websam\site\framework\one.cfc
type
stringcfml
type
stringjava.sql.BatchUpdateException
UpdateCounts
Native Array (int[])
1
number1
2
number1
3
number1
4
number1
5
number1
6
number1
7
number1
8
number1
9
number1
10
number1
11
number1
12
number1
13
number1
14
number1
15
number1
16
number1
17
number1
18
number1
19
number1
20
number1
21
number1
22
number1
23
number1
24
number1
25
number1
26
number1
27
number1
28
number1
29
number1
30
number1
31
number1
32
number1
33
number1
34
number1
35
number1
36
number1
37
number1
38
number1
39
number1
40
number1
41
number1
42
number1
43
number1
44
number1
45
number1
46
number1
47
number1
48
number1
49
number1
50
number1
51
number1
52
number1
53
number1
54
number1
55
number1
56
number1
57
number1
58
number1
59
number1
60
number1
61
number1
62
number1
63
number1
64
number1
65
number1
66
number1
67
number1
68
number1
69
number1
70
number1
71
number1
72
number1
73
number1
74
number1
75
number1
76
number1
77
number1
78
number1
79
number1
80
number1
81
number1
82
number1
83
number1
84
number1
85
number1
86
number1
87
number1
88
number1
89
number1
90
number1
91
number1
92
number1
93
number1
94
number1
95
number1
96
number1
97
number1
98
number1
99
number1
100
number1
101
number1
102
number1
103
number1
104
number1
105
number1
106
number1
107
number1
108
number1
109
number1
110
number1
111
number1
112
number1
113
number1
114
number1
115
number1
116
number1
117
number1
118
number1
119
number1
120
number1
121
number1
122
number1
123
number1
124
number1
125
number1
126
number1
127
number1
128
number1
129
number1
130
number1
131
number1
132
number1
133
number1
134
number1
135
number1
136
number1
137
number1
138
number1
139
number1
140
number1
141
number1
142
number1
143
number1
144
number1
145
number1
146
number1
147
number1
148
number1
149
number1
150
number1
151
number1
152
number1
153
number1
154
number1
155
number1
156
number1
157
number1
158
number1
159
number1
160
number1
161
number1
162
number1
163
number1
164
number1
165
number1
166
number1
167
number1
168
number1
169
number1
170
number1
171
number1
172
number1
173
number1
174
number1
175
number1
176
number1
177
number1
178
number1
179
number1
180
number1
181
number1
182
number1
183
number1
184
number1
185
number1
186
number1
187
number1
188
number1
189
number1
190
number1
191
number1
192
number1
193
number1
194
number1
195
number1
196
number1
197
number1
198
number1
199
number1
200
number1
201
number1
202
number1
203
number1
204
number1
205
number1
206
number1
207
number1
208
number1
209
number1
210
number1
211
number1
212
number1
213
number1
214
number1
215
number1
216
number1
217
number1
218
number1
219
number1
220
number1
221
number1
222
number1
223
number1
224
number1
225
number1
226
number1
227
number1
228
number1
229
number1
230
number1
231
number1
232
number1
233
number1
234
number1
235
number1
236
number1
237
number1
238
number1
239
number1
240
number1
241
number1
242
number1
243
number1
244
number1
245
number1
246
number1
247
number1
248
number1
249
number1
250
number1
251
number1
252
number1
253
number1
254
number1
255
number1
256
number1
257
number1
258
number1
259
number1
260
number1
261
number1
262
number1
263
number1
264
number1
265
number1
266
number1
267
number1
268
number1
269
number1
270
number1
271
number1
272
number1
273
number1
274
number1
275
number1
276
number1
277
number1
278
number1
279
number1
280
number1
281
number1
282
number1
283
number1
284
number1
285
number1
286
number1
287
number1
288
number1
289
number1
290
number1
291
number1
292
number1
293
number1
294
number1
295
number1
296
number1
297
number1
298
number1
299
number1
300
number1
301
number1
302
number1
303
number1
304
number1
305
number1
306
number1
307
number1
308
number1
309
number1
310
number1
311
number1
312
number1
DataSource
string
Detail
stringdata exception: string data, right truncation ; size limit: 32768 table: VARIABLES_SUBCATEGORYLIST column: PRODUCT_DESCRIPTION
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringQoQ HSQLDB: error executing sql statement on query.
NativeErrorCode
number-1
queryError
stringSELECT sub_category_id,sub_category_name,category_name,category_id,sub_category_description FROM VARIABLES_subcategoryList WHERE sub_category_id=53
Sql
stringSELECT sub_category_id,sub_category_name,category_name,category_id,sub_category_description FROM VARIABLES_subcategoryList WHERE sub_category_id=53
SQLState
string
StackTrace
stringlucee.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
string782: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FROM&nbsp;VARIABLES.subcategoryList<br> 783: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;WHERE&nbsp;sub_category_id=&lt;cfqueryparam&nbsp;value=&quot;#ARGUMENTS.subcategoryID#&quot;&nbsp;&nbsp;cfsqltype=&quot;cf_sql_integer&quot;&gt;<br> <b>784: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/cfquery&gt;</b><br> 785: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfreturn&nbsp;getSubcategoryInfoBySubcategoryID&gt;<br> 786: &nbsp;&nbsp;&nbsp;&lt;/cffunction&gt;<br>
codePrintPlain
string782: FROM VARIABLES.subcategoryList 783: WHERE sub_category_id=<cfqueryparam value="#ARGUMENTS.subcategoryID#" cfsqltype="cf_sql_integer"> 784: </cfquery> 785: <cfreturn getSubcategoryInfoBySubcategoryID> 786: </cffunction>
column
number0
id
string??
line
number784
Raw_Trace
stringmodel.gateway.sitemanager_cfc$cf.udfCall2(/model/gateway/siteManager.cfc:784)
template
stringC:\sites\websam\site\model\gateway\siteManager.cfc
type
stringcfml
2
Struct
codePrintHTML
string76: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfargument&nbsp;name=&quot;siteID&quot;&nbsp;type=&quot;numeric&quot;&nbsp;required=&quot;true&quot;&gt;<br> 77: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfargument&nbsp;name=&quot;subCategoryID&quot;&nbsp;type=&quot;numeric&quot;&nbsp;required=&quot;true&quot;&gt;<br> <b>78: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfreturn&nbsp;APPLICATION.getsiteManagerGateway().getSubcategoryInfoBySubcategoryID(siteID=ARGUMENTS.siteID,subCategoryID=ARGUMENTS.subCategoryID)&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</b><br> 79: &nbsp;&nbsp;&nbsp;&lt;/cffunction&gt;<br> 80: &nbsp;&nbsp;&nbsp;<br>
codePrintPlain
string76: <cfargument name="siteID" type="numeric" required="true"> 77: <cfargument name="subCategoryID" type="numeric" required="true"> 78: <cfreturn APPLICATION.getsiteManagerGateway().getSubcategoryInfoBySubcategoryID(siteID=ARGUMENTS.siteID,subCategoryID=ARGUMENTS.subCategoryID)> 79: </cffunction> 80:
column
number0
id
string??
line
number78
Raw_Trace
stringmodel.service.sitemanager_cfc$cf.udfCall2(/model/service/siteManager.cfc:78)
template
stringC:\sites\websam\site\model\service\siteManager.cfc
type
stringcfml
3
Struct
codePrintHTML
string7: <br> 8: &lt;cfset&nbsp;VARIABLES.productList&nbsp;=&nbsp;APPLICATION.getsiteManagerService().getProductList(siteID=APPLICATION.siteDetails.site_id,deptID=SESSION.employeeDetails.dept_id,subCategoryID=&nbsp;VARIABLES.subCategoryID)/&gt;<br> <b>9: &lt;cfset&nbsp;VARIABLES.subCategoryInfo=APPLICATION.getsiteManagerService().getSubcategoryInfoBySubcategoryID(#APPLICATION.siteDetails.site_id#,#VARIABLES.subCategoryID#)&gt;</b><br> 10: &lt;cfparam&nbsp;name=&quot;VARIABLES.type&quot;&nbsp;default=&quot;hidden&quot;&gt;<br> 11: &lt;cfset&nbsp;LOCAL.totalCards&nbsp;=&nbsp;VARIABLES.productList.recordCount&gt;<br>
codePrintPlain
string7: 8: <cfset VARIABLES.productList = APPLICATION.getsiteManagerService().getProductList(siteID=APPLICATION.siteDetails.site_id,deptID=SESSION.employeeDetails.dept_id,subCategoryID= VARIABLES.subCategoryID)/> 9: <cfset VARIABLES.subCategoryInfo=APPLICATION.getsiteManagerService().getSubcategoryInfoBySubcategoryID(#APPLICATION.siteDetails.site_id#,#VARIABLES.subCategoryID#)> 10: <cfparam name="VARIABLES.type" default="hidden"> 11: <cfset LOCAL.totalCards = VARIABLES.productList.recordCount>
column
number0
id
string??
line
number9
Raw_Trace
stringlayouts.sitelayouts.siteproductlist_cfm$cf$2.call(/layouts/siteLayouts/siteProductList.cfm:9)
template
stringC:\sites\websam\site\layouts\siteLayouts\siteProductList.cfm
type
stringcfml
4
Struct
codePrintHTML
string<b>1: &lt;cfinclude&nbsp;template=&quot;../../layouts/siteLayouts/siteProductList.cfm&quot;&gt;</b><br>
codePrintPlain
string1: <cfinclude template="../../layouts/siteLayouts/siteProductList.cfm">
column
number0
id
string??
line
number1
Raw_Trace
stringviews.productview.productdetails_cfm$cf$1.call(/views/productview/productdetails.cfm:1)
template
stringC:\sites\websam\site\views\productview\productdetails.cfm
type
stringcfml
5
Struct
codePrintHTML
string1991: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;response&nbsp;=&nbsp;'';<br> 1992: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;savecontent&nbsp;variable=&quot;response&quot;&nbsp;{<br> <b>1993: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;include&nbsp;'#viewPath#';</b><br> 1994: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br> 1995: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
codePrintPlain
string1991: response = ''; 1992: savecontent variable="response" { 1993: include '#viewPath#'; 1994: } 1995: }
column
number0
id
string??
line
number1993
Raw_Trace
stringframework.one_cfc$cf.udfCallc(/framework/one.cfc:1993)
template
stringC:\sites\websam\site\framework\one.cfc
type
stringcfml
6
Struct
codePrintHTML
string919: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(&nbsp;structKeyExists(request._fw1,&nbsp;'view')&nbsp;)&nbsp;{<br> 920: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;internalFrameworkTrace(&nbsp;'rendering&nbsp;#request._fw1.view#'&nbsp;);<br> <b>921: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;out&nbsp;=&nbsp;internalView(&nbsp;request._fw1.view&nbsp;);</b><br> 922: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;else&nbsp;if&nbsp;(&nbsp;structKeyExists(request._fw1,&nbsp;'omvInProgress')&nbsp;)&nbsp;{<br> 923: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;internalFrameworkTrace(&nbsp;'viewNotFound()&nbsp;called'&nbsp;);<br>
codePrintPlain
string919: if ( structKeyExists(request._fw1, 'view') ) { 920: internalFrameworkTrace( 'rendering #request._fw1.view#' ); 921: out = internalView( request._fw1.view ); 922: } else if ( structKeyExists(request._fw1, 'omvInProgress') ) { 923: internalFrameworkTrace( 'viewNotFound() called' );
column
number0
id
string??
line
number921
Raw_Trace
stringframework.one_cfc$cf.udfCall6(/framework/one.cfc:921)
template
stringC:\sites\websam\site\framework\one.cfc
type
stringcfml
type
stringdatabase
where
string
DataSource
string
Detail
string
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringQoQ HSQLDB: error executing sql statement on query.
NativeErrorCode
number-1
queryError
stringSELECT sub_category_id,sub_category_name,category_name,category_id,sub_category_description FROM VARIABLES_subcategoryList WHERE sub_category_id=53
Sql
stringSELECT sub_category_id,sub_category_name,category_name,category_id,sub_category_description FROM VARIABLES_subcategoryList WHERE sub_category_id=53
SQLState
string
StackTrace
stringlucee.runtime.exp.IllegalQoQException: QoQ HSQLDB: error executing sql statement on query. at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:642) at lucee.runtime.db.HSQLDBHandler._execute(HSQLDBHandler.java:544) at lucee.runtime.db.HSQLDBHandler.execute(HSQLDBHandler.java:532) at lucee.runtime.tag.Query.executeQoQ(Query.java:1101) at lucee.runtime.tag.Query._doEndTag(Query.java:673) at lucee.runtime.tag.Query.doEndTag(Query.java:557) at model.gateway.sitemanager_cfc$cf.udfCall2(/model/gateway/siteManager.cfc:784) at model.gateway.sitemanager_cfc$cf.udfCall(/model/gateway/siteManager.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:723) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:595) at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:2120) at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:858) at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2107) at model.service.sitemanager_cfc$cf.udfCall2(/model/service/siteManager.cfc:78) at model.service.sitemanager_cfc$cf.udfCall(/model/service/siteManager.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:722) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:595) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2101) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:773) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:2075) at layouts.sitelayouts.siteproductlist_cfm$cf$2.call(/layouts/siteLayouts/siteProductList.cfm:9) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1112) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1006) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:987) at views.productview.productdetails_cfm$cf$1.call(/views/productview/productdetails.cfm:1) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1112) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1006) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:987) at framework.one_cfc$cf.udfCallc(/framework/one.cfc:1993) at framework.one_cfc$cf.udfCall(/framework/one.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224) at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:811) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:773) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:2075) at framework.one_cfc$cf.udfCall6(/framework/one.cfc:921) at framework.one_cfc$cf.udfCall(/framework/one.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:722) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:595) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2101) at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:477) at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:212) at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:41) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2810) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2797) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2768) at lucee.runtime.engine.Request.exe(Request.java:45) at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1109) at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1066) at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97) at lucee.loader.servlet.jakarta.CFMLServlet.service(CFMLServlet.java:52) at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:710) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:130) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:109) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:79) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:483) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:116) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:420) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:903) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1744) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:637) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:59) at java.base/java.lang.Thread.run(Unknown Source) Caused by: lucee.runtime.exp.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
string782: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FROM&nbsp;VARIABLES.subcategoryList<br> 783: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;WHERE&nbsp;sub_category_id=&lt;cfqueryparam&nbsp;value=&quot;#ARGUMENTS.subcategoryID#&quot;&nbsp;&nbsp;cfsqltype=&quot;cf_sql_integer&quot;&gt;<br> <b>784: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/cfquery&gt;</b><br> 785: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfreturn&nbsp;getSubcategoryInfoBySubcategoryID&gt;<br> 786: &nbsp;&nbsp;&nbsp;&lt;/cffunction&gt;<br>
codePrintPlain
string782: FROM VARIABLES.subcategoryList 783: WHERE sub_category_id=<cfqueryparam value="#ARGUMENTS.subcategoryID#" cfsqltype="cf_sql_integer"> 784: </cfquery> 785: <cfreturn getSubcategoryInfoBySubcategoryID> 786: </cffunction>
column
number0
id
string??
line
number784
Raw_Trace
stringmodel.gateway.sitemanager_cfc$cf.udfCall2(/model/gateway/siteManager.cfc:784)
template
stringC:\sites\websam\site\model\gateway\siteManager.cfc
type
stringcfml
2
Struct
codePrintHTML
string76: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfargument&nbsp;name=&quot;siteID&quot;&nbsp;type=&quot;numeric&quot;&nbsp;required=&quot;true&quot;&gt;<br> 77: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfargument&nbsp;name=&quot;subCategoryID&quot;&nbsp;type=&quot;numeric&quot;&nbsp;required=&quot;true&quot;&gt;<br> <b>78: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfreturn&nbsp;APPLICATION.getsiteManagerGateway().getSubcategoryInfoBySubcategoryID(siteID=ARGUMENTS.siteID,subCategoryID=ARGUMENTS.subCategoryID)&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</b><br> 79: &nbsp;&nbsp;&nbsp;&lt;/cffunction&gt;<br> 80: &nbsp;&nbsp;&nbsp;<br>
codePrintPlain
string76: <cfargument name="siteID" type="numeric" required="true"> 77: <cfargument name="subCategoryID" type="numeric" required="true"> 78: <cfreturn APPLICATION.getsiteManagerGateway().getSubcategoryInfoBySubcategoryID(siteID=ARGUMENTS.siteID,subCategoryID=ARGUMENTS.subCategoryID)> 79: </cffunction> 80:
column
number0
id
string??
line
number78
Raw_Trace
stringmodel.service.sitemanager_cfc$cf.udfCall2(/model/service/siteManager.cfc:78)
template
stringC:\sites\websam\site\model\service\siteManager.cfc
type
stringcfml
3
Struct
codePrintHTML
string7: <br> 8: &lt;cfset&nbsp;VARIABLES.productList&nbsp;=&nbsp;APPLICATION.getsiteManagerService().getProductList(siteID=APPLICATION.siteDetails.site_id,deptID=SESSION.employeeDetails.dept_id,subCategoryID=&nbsp;VARIABLES.subCategoryID)/&gt;<br> <b>9: &lt;cfset&nbsp;VARIABLES.subCategoryInfo=APPLICATION.getsiteManagerService().getSubcategoryInfoBySubcategoryID(#APPLICATION.siteDetails.site_id#,#VARIABLES.subCategoryID#)&gt;</b><br> 10: &lt;cfparam&nbsp;name=&quot;VARIABLES.type&quot;&nbsp;default=&quot;hidden&quot;&gt;<br> 11: &lt;cfset&nbsp;LOCAL.totalCards&nbsp;=&nbsp;VARIABLES.productList.recordCount&gt;<br>
codePrintPlain
string7: 8: <cfset VARIABLES.productList = APPLICATION.getsiteManagerService().getProductList(siteID=APPLICATION.siteDetails.site_id,deptID=SESSION.employeeDetails.dept_id,subCategoryID= VARIABLES.subCategoryID)/> 9: <cfset VARIABLES.subCategoryInfo=APPLICATION.getsiteManagerService().getSubcategoryInfoBySubcategoryID(#APPLICATION.siteDetails.site_id#,#VARIABLES.subCategoryID#)> 10: <cfparam name="VARIABLES.type" default="hidden"> 11: <cfset LOCAL.totalCards = VARIABLES.productList.recordCount>
column
number0
id
string??
line
number9
Raw_Trace
stringlayouts.sitelayouts.siteproductlist_cfm$cf$2.call(/layouts/siteLayouts/siteProductList.cfm:9)
template
stringC:\sites\websam\site\layouts\siteLayouts\siteProductList.cfm
type
stringcfml
4
Struct
codePrintHTML
string<b>1: &lt;cfinclude&nbsp;template=&quot;../../layouts/siteLayouts/siteProductList.cfm&quot;&gt;</b><br>
codePrintPlain
string1: <cfinclude template="../../layouts/siteLayouts/siteProductList.cfm">
column
number0
id
string??
line
number1
Raw_Trace
stringviews.productview.productdetails_cfm$cf$1.call(/views/productview/productdetails.cfm:1)
template
stringC:\sites\websam\site\views\productview\productdetails.cfm
type
stringcfml
5
Struct
codePrintHTML
string1991: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;response&nbsp;=&nbsp;'';<br> 1992: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;savecontent&nbsp;variable=&quot;response&quot;&nbsp;{<br> <b>1993: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;include&nbsp;'#viewPath#';</b><br> 1994: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br> 1995: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
codePrintPlain
string1991: response = ''; 1992: savecontent variable="response" { 1993: include '#viewPath#'; 1994: } 1995: }
column
number0
id
string??
line
number1993
Raw_Trace
stringframework.one_cfc$cf.udfCallc(/framework/one.cfc:1993)
template
stringC:\sites\websam\site\framework\one.cfc
type
stringcfml
6
Struct
codePrintHTML
string919: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(&nbsp;structKeyExists(request._fw1,&nbsp;'view')&nbsp;)&nbsp;{<br> 920: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;internalFrameworkTrace(&nbsp;'rendering&nbsp;#request._fw1.view#'&nbsp;);<br> <b>921: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;out&nbsp;=&nbsp;internalView(&nbsp;request._fw1.view&nbsp;);</b><br> 922: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;else&nbsp;if&nbsp;(&nbsp;structKeyExists(request._fw1,&nbsp;'omvInProgress')&nbsp;)&nbsp;{<br> 923: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;internalFrameworkTrace(&nbsp;'viewNotFound()&nbsp;called'&nbsp;);<br>
codePrintPlain
string919: if ( structKeyExists(request._fw1, 'view') ) { 920: internalFrameworkTrace( 'rendering #request._fw1.view#' ); 921: out = internalView( request._fw1.view ); 922: } else if ( structKeyExists(request._fw1, 'omvInProgress') ) { 923: internalFrameworkTrace( 'viewNotFound() called' );
column
number0
id
string??
line
number921
Raw_Trace
stringframework.one_cfc$cf.udfCall6(/framework/one.cfc:921)
template
stringC:\sites\websam\site\framework\one.cfc
type
stringcfml
type
stringdatabase
where
string
DataSource
string
Detail
string
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringQoQ HSQLDB: error executing sql statement on query.
name
stringonRequest
NativeErrorCode
number-1
queryError
stringSELECT sub_category_id,sub_category_name,category_name,category_id,sub_category_description FROM VARIABLES_subcategoryList WHERE sub_category_id=53
rootCause
Struct
Entries: 16
additional
Struct (ordered)
SQL
stringSELECT sub_category_id,sub_category_name,category_name,category_id,sub_category_description FROM VARIABLES_subcategoryList WHERE sub_category_id=53
Cause
Struct
Entries: 16
additional
Struct (ordered)
SQL
stringSELECT sub_category_id,sub_category_name,category_name,category_id,sub_category_description FROM VARIABLES_subcategoryList WHERE sub_category_id=53
Cause
Struct
Entries: 12
additional
Struct (ordered)
Detail
string
ErrorCode
number3401
Extended_Info
string
ExtendedInfo
string
LargeUpdateCounts
Native Array (long[])
1
number1
2
number1
3
number1
4
number1
5
number1
6
number1
7
number1
8
number1
9
number1
10
number1
11
number1
12
number1
13
number1
14
number1
15
number1
16
number1
17
number1
18
number1
19
number1
20
number1
21
number1
22
number1
23
number1
24
number1
25
number1
26
number1
27
number1
28
number1
29
number1
30
number1
31
number1
32
number1
33
number1
34
number1
35
number1
36
number1
37
number1
38
number1
39
number1
40
number1
41
number1
42
number1
43
number1
44
number1
45
number1
46
number1
47
number1
48
number1
49
number1
50
number1
51
number1
52
number1
53
number1
54
number1
55
number1
56
number1
57
number1
58
number1
59
number1
60
number1
61
number1
62
number1
63
number1
64
number1
65
number1
66
number1
67
number1
68
number1
69
number1
70
number1
71
number1
72
number1
73
number1
74
number1
75
number1
76
number1
77
number1
78
number1
79
number1
80
number1
81
number1
82
number1
83
number1
84
number1
85
number1
86
number1
87
number1
88
number1
89
number1
90
number1
91
number1
92
number1
93
number1
94
number1
95
number1
96
number1
97
number1
98
number1
99
number1
100
number1
101
number1
102
number1
103
number1
104
number1
105
number1
106
number1
107
number1
108
number1
109
number1
110
number1
111
number1
112
number1
113
number1
114
number1
115
number1
116
number1
117
number1
118
number1
119
number1
120
number1
121
number1
122
number1
123
number1
124
number1
125
number1
126
number1
127
number1
128
number1
129
number1
130
number1
131
number1
132
number1
133
number1
134
number1
135
number1
136
number1
137
number1
138
number1
139
number1
140
number1
141
number1
142
number1
143
number1
144
number1
145
number1
146
number1
147
number1
148
number1
149
number1
150
number1
151
number1
152
number1
153
number1
154
number1
155
number1
156
number1
157
number1
158
number1
159
number1
160
number1
161
number1
162
number1
163
number1
164
number1
165
number1
166
number1
167
number1
168
number1
169
number1
170
number1
171
number1
172
number1
173
number1
174
number1
175
number1
176
number1
177
number1
178
number1
179
number1
180
number1
181
number1
182
number1
183
number1
184
number1
185
number1
186
number1
187
number1
188
number1
189
number1
190
number1
191
number1
192
number1
193
number1
194
number1
195
number1
196
number1
197
number1
198
number1
199
number1
200
number1
201
number1
202
number1
203
number1
204
number1
205
number1
206
number1
207
number1
208
number1
209
number1
210
number1
211
number1
212
number1
213
number1
214
number1
215
number1
216
number1
217
number1
218
number1
219
number1
220
number1
221
number1
222
number1
223
number1
224
number1
225
number1
226
number1
227
number1
228
number1
229
number1
230
number1
231
number1
232
number1
233
number1
234
number1
235
number1
236
number1
237
number1
238
number1
239
number1
240
number1
241
number1
242
number1
243
number1
244
number1
245
number1
246
number1
247
number1
248
number1
249
number1
250
number1
251
number1
252
number1
253
number1
254
number1
255
number1
256
number1
257
number1
258
number1
259
number1
260
number1
261
number1
262
number1
263
number1
264
number1
265
number1
266
number1
267
number1
268
number1
269
number1
270
number1
271
number1
272
number1
273
number1
274
number1
275
number1
276
number1
277
number1
278
number1
279
number1
280
number1
281
number1
282
number1
283
number1
284
number1
285
number1
286
number1
287
number1
288
number1
289
number1
290
number1
291
number1
292
number1
293
number1
294
number1
295
number1
296
number1
297
number1
298
number1
299
number1
300
number1
301
number1
302
number1
303
number1
304
number1
305
number1
306
number1
307
number1
308
number1
309
number1
310
number1
311
number1
312
number1
Message
stringdata exception: string data, right truncation ; size limit: 32768 table: VARIABLES_SUBCATEGORYLIST column: PRODUCT_DESCRIPTION
SQLState
string22001
StackTrace
stringlucee.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
string782: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FROM&nbsp;VARIABLES.subcategoryList<br> 783: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;WHERE&nbsp;sub_category_id=&lt;cfqueryparam&nbsp;value=&quot;#ARGUMENTS.subcategoryID#&quot;&nbsp;&nbsp;cfsqltype=&quot;cf_sql_integer&quot;&gt;<br> <b>784: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/cfquery&gt;</b><br> 785: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfreturn&nbsp;getSubcategoryInfoBySubcategoryID&gt;<br> 786: &nbsp;&nbsp;&nbsp;&lt;/cffunction&gt;<br>
codePrintPlain
string782: FROM VARIABLES.subcategoryList 783: WHERE sub_category_id=<cfqueryparam value="#ARGUMENTS.subcategoryID#" cfsqltype="cf_sql_integer"> 784: </cfquery> 785: <cfreturn getSubcategoryInfoBySubcategoryID> 786: </cffunction>
column
number0
id
string??
line
number784
Raw_Trace
stringmodel.gateway.sitemanager_cfc$cf.udfCall2(/model/gateway/siteManager.cfc:784)
template
stringC:\sites\websam\site\model\gateway\siteManager.cfc
type
stringcfml
2
Struct
codePrintHTML
string76: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfargument&nbsp;name=&quot;siteID&quot;&nbsp;type=&quot;numeric&quot;&nbsp;required=&quot;true&quot;&gt;<br> 77: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfargument&nbsp;name=&quot;subCategoryID&quot;&nbsp;type=&quot;numeric&quot;&nbsp;required=&quot;true&quot;&gt;<br> <b>78: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfreturn&nbsp;APPLICATION.getsiteManagerGateway().getSubcategoryInfoBySubcategoryID(siteID=ARGUMENTS.siteID,subCategoryID=ARGUMENTS.subCategoryID)&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</b><br> 79: &nbsp;&nbsp;&nbsp;&lt;/cffunction&gt;<br> 80: &nbsp;&nbsp;&nbsp;<br>
codePrintPlain
string76: <cfargument name="siteID" type="numeric" required="true"> 77: <cfargument name="subCategoryID" type="numeric" required="true"> 78: <cfreturn APPLICATION.getsiteManagerGateway().getSubcategoryInfoBySubcategoryID(siteID=ARGUMENTS.siteID,subCategoryID=ARGUMENTS.subCategoryID)> 79: </cffunction> 80:
column
number0
id
string??
line
number78
Raw_Trace
stringmodel.service.sitemanager_cfc$cf.udfCall2(/model/service/siteManager.cfc:78)
template
stringC:\sites\websam\site\model\service\siteManager.cfc
type
stringcfml
3
Struct
codePrintHTML
string7: <br> 8: &lt;cfset&nbsp;VARIABLES.productList&nbsp;=&nbsp;APPLICATION.getsiteManagerService().getProductList(siteID=APPLICATION.siteDetails.site_id,deptID=SESSION.employeeDetails.dept_id,subCategoryID=&nbsp;VARIABLES.subCategoryID)/&gt;<br> <b>9: &lt;cfset&nbsp;VARIABLES.subCategoryInfo=APPLICATION.getsiteManagerService().getSubcategoryInfoBySubcategoryID(#APPLICATION.siteDetails.site_id#,#VARIABLES.subCategoryID#)&gt;</b><br> 10: &lt;cfparam&nbsp;name=&quot;VARIABLES.type&quot;&nbsp;default=&quot;hidden&quot;&gt;<br> 11: &lt;cfset&nbsp;LOCAL.totalCards&nbsp;=&nbsp;VARIABLES.productList.recordCount&gt;<br>
codePrintPlain
string7: 8: <cfset VARIABLES.productList = APPLICATION.getsiteManagerService().getProductList(siteID=APPLICATION.siteDetails.site_id,deptID=SESSION.employeeDetails.dept_id,subCategoryID= VARIABLES.subCategoryID)/> 9: <cfset VARIABLES.subCategoryInfo=APPLICATION.getsiteManagerService().getSubcategoryInfoBySubcategoryID(#APPLICATION.siteDetails.site_id#,#VARIABLES.subCategoryID#)> 10: <cfparam name="VARIABLES.type" default="hidden"> 11: <cfset LOCAL.totalCards = VARIABLES.productList.recordCount>
column
number0
id
string??
line
number9
Raw_Trace
stringlayouts.sitelayouts.siteproductlist_cfm$cf$2.call(/layouts/siteLayouts/siteProductList.cfm:9)
template
stringC:\sites\websam\site\layouts\siteLayouts\siteProductList.cfm
type
stringcfml
4
Struct
codePrintHTML
string<b>1: &lt;cfinclude&nbsp;template=&quot;../../layouts/siteLayouts/siteProductList.cfm&quot;&gt;</b><br>
codePrintPlain
string1: <cfinclude template="../../layouts/siteLayouts/siteProductList.cfm">
column
number0
id
string??
line
number1
Raw_Trace
stringviews.productview.productdetails_cfm$cf$1.call(/views/productview/productdetails.cfm:1)
template
stringC:\sites\websam\site\views\productview\productdetails.cfm
type
stringcfml
5
Struct
codePrintHTML
string1991: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;response&nbsp;=&nbsp;'';<br> 1992: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;savecontent&nbsp;variable=&quot;response&quot;&nbsp;{<br> <b>1993: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;include&nbsp;'#viewPath#';</b><br> 1994: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br> 1995: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
codePrintPlain
string1991: response = ''; 1992: savecontent variable="response" { 1993: include '#viewPath#'; 1994: } 1995: }
column
number0
id
string??
line
number1993
Raw_Trace
stringframework.one_cfc$cf.udfCallc(/framework/one.cfc:1993)
template
stringC:\sites\websam\site\framework\one.cfc
type
stringcfml
6
Struct
codePrintHTML
string919: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(&nbsp;structKeyExists(request._fw1,&nbsp;'view')&nbsp;)&nbsp;{<br> 920: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;internalFrameworkTrace(&nbsp;'rendering&nbsp;#request._fw1.view#'&nbsp;);<br> <b>921: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;out&nbsp;=&nbsp;internalView(&nbsp;request._fw1.view&nbsp;);</b><br> 922: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;else&nbsp;if&nbsp;(&nbsp;structKeyExists(request._fw1,&nbsp;'omvInProgress')&nbsp;)&nbsp;{<br> 923: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;internalFrameworkTrace(&nbsp;'viewNotFound()&nbsp;called'&nbsp;);<br>
codePrintPlain
string919: if ( structKeyExists(request._fw1, 'view') ) { 920: internalFrameworkTrace( 'rendering #request._fw1.view#' ); 921: out = internalView( request._fw1.view ); 922: } else if ( structKeyExists(request._fw1, 'omvInProgress') ) { 923: internalFrameworkTrace( 'viewNotFound() called' );
column
number0
id
string??
line
number921
Raw_Trace
stringframework.one_cfc$cf.udfCall6(/framework/one.cfc:921)
template
stringC:\sites\websam\site\framework\one.cfc
type
stringcfml
type
stringjava.sql.BatchUpdateException
UpdateCounts
Native Array (int[])
1
number1
2
number1
3
number1
4
number1
5
number1
6
number1
7
number1
8
number1
9
number1
10
number1
11
number1
12
number1
13
number1
14
number1
15
number1
16
number1
17
number1
18
number1
19
number1
20
number1
21
number1
22
number1
23
number1
24
number1
25
number1
26
number1
27
number1
28
number1
29
number1
30
number1
31
number1
32
number1
33
number1
34
number1
35
number1
36
number1
37
number1
38
number1
39
number1
40
number1
41
number1
42
number1
43
number1
44
number1
45
number1
46
number1
47
number1
48
number1
49
number1
50
number1
51
number1
52
number1
53
number1
54
number1
55
number1
56
number1
57
number1
58
number1
59
number1
60
number1
61
number1
62
number1
63
number1
64
number1
65
number1
66
number1
67
number1
68
number1
69
number1
70
number1
71
number1
72
number1
73
number1
74
number1
75
number1
76
number1
77
number1
78
number1
79
number1
80
number1
81
number1
82
number1
83
number1
84
number1
85
number1
86
number1
87
number1
88
number1
89
number1
90
number1
91
number1
92
number1
93
number1
94
number1
95
number1
96
number1
97
number1
98
number1
99
number1
100
number1
101
number1
102
number1
103
number1
104
number1
105
number1
106
number1
107
number1
108
number1
109
number1
110
number1
111
number1
112
number1
113
number1
114
number1
115
number1
116
number1
117
number1
118
number1
119
number1
120
number1
121
number1
122
number1
123
number1
124
number1
125
number1
126
number1
127
number1
128
number1
129
number1
130
number1
131
number1
132
number1
133
number1
134
number1
135
number1
136
number1
137
number1
138
number1
139
number1
140
number1
141
number1
142
number1
143
number1
144
number1
145
number1
146
number1
147
number1
148
number1
149
number1
150
number1
151
number1
152
number1
153
number1
154
number1
155
number1
156
number1
157
number1
158
number1
159
number1
160
number1
161
number1
162
number1
163
number1
164
number1
165
number1
166
number1
167
number1
168
number1
169
number1
170
number1
171
number1
172
number1
173
number1
174
number1
175
number1
176
number1
177
number1
178
number1
179
number1
180
number1
181
number1
182
number1
183
number1
184
number1
185
number1
186
number1
187
number1
188
number1
189
number1
190
number1
191
number1
192
number1
193
number1
194
number1
195
number1
196
number1
197
number1
198
number1
199
number1
200
number1
201
number1
202
number1
203
number1
204
number1
205
number1
206
number1
207
number1
208
number1
209
number1
210
number1
211
number1
212
number1
213
number1
214
number1
215
number1
216
number1
217
number1
218
number1
219
number1
220
number1
221
number1
222
number1
223
number1
224
number1
225
number1
226
number1
227
number1
228
number1
229
number1
230
number1
231
number1
232
number1
233
number1
234
number1
235
number1
236
number1
237
number1
238
number1
239
number1
240
number1
241
number1
242
number1
243
number1
244
number1
245
number1
246
number1
247
number1
248
number1
249
number1
250
number1
251
number1
252
number1
253
number1
254
number1
255
number1
256
number1
257
number1
258
number1
259
number1
260
number1
261
number1
262
number1
263
number1
264
number1
265
number1
266
number1
267
number1
268
number1
269
number1
270
number1
271
number1
272
number1
273
number1
274
number1
275
number1
276
number1
277
number1
278
number1
279
number1
280
number1
281
number1
282
number1
283
number1
284
number1
285
number1
286
number1
287
number1
288
number1
289
number1
290
number1
291
number1
292
number1
293
number1
294
number1
295
number1
296
number1
297
number1
298
number1
299
number1
300
number1
301
number1
302
number1
303
number1
304
number1
305
number1
306
number1
307
number1
308
number1
309
number1
310
number1
311
number1
312
number1
DataSource
string
Detail
stringdata exception: string data, right truncation ; size limit: 32768 table: VARIABLES_SUBCATEGORYLIST column: PRODUCT_DESCRIPTION
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringQoQ HSQLDB: error executing sql statement on query.
NativeErrorCode
number-1
queryError
stringSELECT sub_category_id,sub_category_name,category_name,category_id,sub_category_description FROM VARIABLES_subcategoryList WHERE sub_category_id=53
Sql
stringSELECT sub_category_id,sub_category_name,category_name,category_id,sub_category_description FROM VARIABLES_subcategoryList WHERE sub_category_id=53
SQLState
string
StackTrace
stringlucee.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
string782: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FROM&nbsp;VARIABLES.subcategoryList<br> 783: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;WHERE&nbsp;sub_category_id=&lt;cfqueryparam&nbsp;value=&quot;#ARGUMENTS.subcategoryID#&quot;&nbsp;&nbsp;cfsqltype=&quot;cf_sql_integer&quot;&gt;<br> <b>784: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/cfquery&gt;</b><br> 785: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfreturn&nbsp;getSubcategoryInfoBySubcategoryID&gt;<br> 786: &nbsp;&nbsp;&nbsp;&lt;/cffunction&gt;<br>
codePrintPlain
string782: FROM VARIABLES.subcategoryList 783: WHERE sub_category_id=<cfqueryparam value="#ARGUMENTS.subcategoryID#" cfsqltype="cf_sql_integer"> 784: </cfquery> 785: <cfreturn getSubcategoryInfoBySubcategoryID> 786: </cffunction>
column
number0
id
string??
line
number784
Raw_Trace
stringmodel.gateway.sitemanager_cfc$cf.udfCall2(/model/gateway/siteManager.cfc:784)
template
stringC:\sites\websam\site\model\gateway\siteManager.cfc
type
stringcfml
2
Struct
codePrintHTML
string76: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfargument&nbsp;name=&quot;siteID&quot;&nbsp;type=&quot;numeric&quot;&nbsp;required=&quot;true&quot;&gt;<br> 77: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfargument&nbsp;name=&quot;subCategoryID&quot;&nbsp;type=&quot;numeric&quot;&nbsp;required=&quot;true&quot;&gt;<br> <b>78: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfreturn&nbsp;APPLICATION.getsiteManagerGateway().getSubcategoryInfoBySubcategoryID(siteID=ARGUMENTS.siteID,subCategoryID=ARGUMENTS.subCategoryID)&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</b><br> 79: &nbsp;&nbsp;&nbsp;&lt;/cffunction&gt;<br> 80: &nbsp;&nbsp;&nbsp;<br>
codePrintPlain
string76: <cfargument name="siteID" type="numeric" required="true"> 77: <cfargument name="subCategoryID" type="numeric" required="true"> 78: <cfreturn APPLICATION.getsiteManagerGateway().getSubcategoryInfoBySubcategoryID(siteID=ARGUMENTS.siteID,subCategoryID=ARGUMENTS.subCategoryID)> 79: </cffunction> 80:
column
number0
id
string??
line
number78
Raw_Trace
stringmodel.service.sitemanager_cfc$cf.udfCall2(/model/service/siteManager.cfc:78)
template
stringC:\sites\websam\site\model\service\siteManager.cfc
type
stringcfml
3
Struct
codePrintHTML
string7: <br> 8: &lt;cfset&nbsp;VARIABLES.productList&nbsp;=&nbsp;APPLICATION.getsiteManagerService().getProductList(siteID=APPLICATION.siteDetails.site_id,deptID=SESSION.employeeDetails.dept_id,subCategoryID=&nbsp;VARIABLES.subCategoryID)/&gt;<br> <b>9: &lt;cfset&nbsp;VARIABLES.subCategoryInfo=APPLICATION.getsiteManagerService().getSubcategoryInfoBySubcategoryID(#APPLICATION.siteDetails.site_id#,#VARIABLES.subCategoryID#)&gt;</b><br> 10: &lt;cfparam&nbsp;name=&quot;VARIABLES.type&quot;&nbsp;default=&quot;hidden&quot;&gt;<br> 11: &lt;cfset&nbsp;LOCAL.totalCards&nbsp;=&nbsp;VARIABLES.productList.recordCount&gt;<br>
codePrintPlain
string7: 8: <cfset VARIABLES.productList = APPLICATION.getsiteManagerService().getProductList(siteID=APPLICATION.siteDetails.site_id,deptID=SESSION.employeeDetails.dept_id,subCategoryID= VARIABLES.subCategoryID)/> 9: <cfset VARIABLES.subCategoryInfo=APPLICATION.getsiteManagerService().getSubcategoryInfoBySubcategoryID(#APPLICATION.siteDetails.site_id#,#VARIABLES.subCategoryID#)> 10: <cfparam name="VARIABLES.type" default="hidden"> 11: <cfset LOCAL.totalCards = VARIABLES.productList.recordCount>
column
number0
id
string??
line
number9
Raw_Trace
stringlayouts.sitelayouts.siteproductlist_cfm$cf$2.call(/layouts/siteLayouts/siteProductList.cfm:9)
template
stringC:\sites\websam\site\layouts\siteLayouts\siteProductList.cfm
type
stringcfml
4
Struct
codePrintHTML
string<b>1: &lt;cfinclude&nbsp;template=&quot;../../layouts/siteLayouts/siteProductList.cfm&quot;&gt;</b><br>
codePrintPlain
string1: <cfinclude template="../../layouts/siteLayouts/siteProductList.cfm">
column
number0
id
string??
line
number1
Raw_Trace
stringviews.productview.productdetails_cfm$cf$1.call(/views/productview/productdetails.cfm:1)
template
stringC:\sites\websam\site\views\productview\productdetails.cfm
type
stringcfml
5
Struct
codePrintHTML
string1991: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;response&nbsp;=&nbsp;'';<br> 1992: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;savecontent&nbsp;variable=&quot;response&quot;&nbsp;{<br> <b>1993: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;include&nbsp;'#viewPath#';</b><br> 1994: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br> 1995: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
codePrintPlain
string1991: response = ''; 1992: savecontent variable="response" { 1993: include '#viewPath#'; 1994: } 1995: }
column
number0
id
string??
line
number1993
Raw_Trace
stringframework.one_cfc$cf.udfCallc(/framework/one.cfc:1993)
template
stringC:\sites\websam\site\framework\one.cfc
type
stringcfml
6
Struct
codePrintHTML
string919: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(&nbsp;structKeyExists(request._fw1,&nbsp;'view')&nbsp;)&nbsp;{<br> 920: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;internalFrameworkTrace(&nbsp;'rendering&nbsp;#request._fw1.view#'&nbsp;);<br> <b>921: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;out&nbsp;=&nbsp;internalView(&nbsp;request._fw1.view&nbsp;);</b><br> 922: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;else&nbsp;if&nbsp;(&nbsp;structKeyExists(request._fw1,&nbsp;'omvInProgress')&nbsp;)&nbsp;{<br> 923: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;internalFrameworkTrace(&nbsp;'viewNotFound()&nbsp;called'&nbsp;);<br>
codePrintPlain
string919: if ( structKeyExists(request._fw1, 'view') ) { 920: internalFrameworkTrace( 'rendering #request._fw1.view#' ); 921: out = internalView( request._fw1.view ); 922: } else if ( structKeyExists(request._fw1, 'omvInProgress') ) { 923: internalFrameworkTrace( 'viewNotFound() called' );
column
number0
id
string??
line
number921
Raw_Trace
stringframework.one_cfc$cf.udfCall6(/framework/one.cfc:921)
template
stringC:\sites\websam\site\framework\one.cfc
type
stringcfml
type
stringdatabase
where
string
DataSource
string
Detail
string
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringQoQ HSQLDB: error executing sql statement on query.
NativeErrorCode
number-1
queryError
stringSELECT sub_category_id,sub_category_name,category_name,category_id,sub_category_description FROM VARIABLES_subcategoryList WHERE sub_category_id=53
Sql
stringSELECT sub_category_id,sub_category_name,category_name,category_id,sub_category_description FROM VARIABLES_subcategoryList WHERE sub_category_id=53
SQLState
string
StackTrace
stringlucee.runtime.exp.IllegalQoQException: QoQ HSQLDB: error executing sql statement on query. at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:642) at lucee.runtime.db.HSQLDBHandler._execute(HSQLDBHandler.java:544) at lucee.runtime.db.HSQLDBHandler.execute(HSQLDBHandler.java:532) at lucee.runtime.tag.Query.executeQoQ(Query.java:1101) at lucee.runtime.tag.Query._doEndTag(Query.java:673) at lucee.runtime.tag.Query.doEndTag(Query.java:557) at model.gateway.sitemanager_cfc$cf.udfCall2(/model/gateway/siteManager.cfc:784) at model.gateway.sitemanager_cfc$cf.udfCall(/model/gateway/siteManager.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:723) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:595) at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:2120) at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:858) at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2107) at model.service.sitemanager_cfc$cf.udfCall2(/model/service/siteManager.cfc:78) at model.service.sitemanager_cfc$cf.udfCall(/model/service/siteManager.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:722) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:595) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2101) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:773) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:2075) at layouts.sitelayouts.siteproductlist_cfm$cf$2.call(/layouts/siteLayouts/siteProductList.cfm:9) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1112) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1006) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:987) at views.productview.productdetails_cfm$cf$1.call(/views/productview/productdetails.cfm:1) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1112) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1006) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:987) at framework.one_cfc$cf.udfCallc(/framework/one.cfc:1993) at framework.one_cfc$cf.udfCall(/framework/one.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224) at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:811) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:773) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:2075) at framework.one_cfc$cf.udfCall6(/framework/one.cfc:921) at framework.one_cfc$cf.udfCall(/framework/one.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:722) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:595) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2101) at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:477) at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:212) at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:41) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2810) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2797) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2768) at lucee.runtime.engine.Request.exe(Request.java:45) at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1109) at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1066) at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97) at lucee.loader.servlet.jakarta.CFMLServlet.service(CFMLServlet.java:52) at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:710) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:130) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:109) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:79) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:483) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:116) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:420) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:903) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1744) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:637) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:59) at java.base/java.lang.Thread.run(Unknown Source) Caused by: lucee.runtime.exp.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
string782: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FROM&nbsp;VARIABLES.subcategoryList<br> 783: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;WHERE&nbsp;sub_category_id=&lt;cfqueryparam&nbsp;value=&quot;#ARGUMENTS.subcategoryID#&quot;&nbsp;&nbsp;cfsqltype=&quot;cf_sql_integer&quot;&gt;<br> <b>784: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/cfquery&gt;</b><br> 785: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfreturn&nbsp;getSubcategoryInfoBySubcategoryID&gt;<br> 786: &nbsp;&nbsp;&nbsp;&lt;/cffunction&gt;<br>
codePrintPlain
string782: FROM VARIABLES.subcategoryList 783: WHERE sub_category_id=<cfqueryparam value="#ARGUMENTS.subcategoryID#" cfsqltype="cf_sql_integer"> 784: </cfquery> 785: <cfreturn getSubcategoryInfoBySubcategoryID> 786: </cffunction>
column
number0
id
string??
line
number784
Raw_Trace
stringmodel.gateway.sitemanager_cfc$cf.udfCall2(/model/gateway/siteManager.cfc:784)
template
stringC:\sites\websam\site\model\gateway\siteManager.cfc
type
stringcfml
2
Struct
codePrintHTML
string76: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfargument&nbsp;name=&quot;siteID&quot;&nbsp;type=&quot;numeric&quot;&nbsp;required=&quot;true&quot;&gt;<br> 77: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfargument&nbsp;name=&quot;subCategoryID&quot;&nbsp;type=&quot;numeric&quot;&nbsp;required=&quot;true&quot;&gt;<br> <b>78: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfreturn&nbsp;APPLICATION.getsiteManagerGateway().getSubcategoryInfoBySubcategoryID(siteID=ARGUMENTS.siteID,subCategoryID=ARGUMENTS.subCategoryID)&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</b><br> 79: &nbsp;&nbsp;&nbsp;&lt;/cffunction&gt;<br> 80: &nbsp;&nbsp;&nbsp;<br>
codePrintPlain
string76: <cfargument name="siteID" type="numeric" required="true"> 77: <cfargument name="subCategoryID" type="numeric" required="true"> 78: <cfreturn APPLICATION.getsiteManagerGateway().getSubcategoryInfoBySubcategoryID(siteID=ARGUMENTS.siteID,subCategoryID=ARGUMENTS.subCategoryID)> 79: </cffunction> 80:
column
number0
id
string??
line
number78
Raw_Trace
stringmodel.service.sitemanager_cfc$cf.udfCall2(/model/service/siteManager.cfc:78)
template
stringC:\sites\websam\site\model\service\siteManager.cfc
type
stringcfml
3
Struct
codePrintHTML
string7: <br> 8: &lt;cfset&nbsp;VARIABLES.productList&nbsp;=&nbsp;APPLICATION.getsiteManagerService().getProductList(siteID=APPLICATION.siteDetails.site_id,deptID=SESSION.employeeDetails.dept_id,subCategoryID=&nbsp;VARIABLES.subCategoryID)/&gt;<br> <b>9: &lt;cfset&nbsp;VARIABLES.subCategoryInfo=APPLICATION.getsiteManagerService().getSubcategoryInfoBySubcategoryID(#APPLICATION.siteDetails.site_id#,#VARIABLES.subCategoryID#)&gt;</b><br> 10: &lt;cfparam&nbsp;name=&quot;VARIABLES.type&quot;&nbsp;default=&quot;hidden&quot;&gt;<br> 11: &lt;cfset&nbsp;LOCAL.totalCards&nbsp;=&nbsp;VARIABLES.productList.recordCount&gt;<br>
codePrintPlain
string7: 8: <cfset VARIABLES.productList = APPLICATION.getsiteManagerService().getProductList(siteID=APPLICATION.siteDetails.site_id,deptID=SESSION.employeeDetails.dept_id,subCategoryID= VARIABLES.subCategoryID)/> 9: <cfset VARIABLES.subCategoryInfo=APPLICATION.getsiteManagerService().getSubcategoryInfoBySubcategoryID(#APPLICATION.siteDetails.site_id#,#VARIABLES.subCategoryID#)> 10: <cfparam name="VARIABLES.type" default="hidden"> 11: <cfset LOCAL.totalCards = VARIABLES.productList.recordCount>
column
number0
id
string??
line
number9
Raw_Trace
stringlayouts.sitelayouts.siteproductlist_cfm$cf$2.call(/layouts/siteLayouts/siteProductList.cfm:9)
template
stringC:\sites\websam\site\layouts\siteLayouts\siteProductList.cfm
type
stringcfml
4
Struct
codePrintHTML
string<b>1: &lt;cfinclude&nbsp;template=&quot;../../layouts/siteLayouts/siteProductList.cfm&quot;&gt;</b><br>
codePrintPlain
string1: <cfinclude template="../../layouts/siteLayouts/siteProductList.cfm">
column
number0
id
string??
line
number1
Raw_Trace
stringviews.productview.productdetails_cfm$cf$1.call(/views/productview/productdetails.cfm:1)
template
stringC:\sites\websam\site\views\productview\productdetails.cfm
type
stringcfml
5
Struct
codePrintHTML
string1991: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;response&nbsp;=&nbsp;'';<br> 1992: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;savecontent&nbsp;variable=&quot;response&quot;&nbsp;{<br> <b>1993: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;include&nbsp;'#viewPath#';</b><br> 1994: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br> 1995: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
codePrintPlain
string1991: response = ''; 1992: savecontent variable="response" { 1993: include '#viewPath#'; 1994: } 1995: }
column
number0
id
string??
line
number1993
Raw_Trace
stringframework.one_cfc$cf.udfCallc(/framework/one.cfc:1993)
template
stringC:\sites\websam\site\framework\one.cfc
type
stringcfml
6
Struct
codePrintHTML
string919: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(&nbsp;structKeyExists(request._fw1,&nbsp;'view')&nbsp;)&nbsp;{<br> 920: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;internalFrameworkTrace(&nbsp;'rendering&nbsp;#request._fw1.view#'&nbsp;);<br> <b>921: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;out&nbsp;=&nbsp;internalView(&nbsp;request._fw1.view&nbsp;);</b><br> 922: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;else&nbsp;if&nbsp;(&nbsp;structKeyExists(request._fw1,&nbsp;'omvInProgress')&nbsp;)&nbsp;{<br> 923: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;internalFrameworkTrace(&nbsp;'viewNotFound()&nbsp;called'&nbsp;);<br>
codePrintPlain
string919: if ( structKeyExists(request._fw1, 'view') ) { 920: internalFrameworkTrace( 'rendering #request._fw1.view#' ); 921: out = internalView( request._fw1.view ); 922: } else if ( structKeyExists(request._fw1, 'omvInProgress') ) { 923: internalFrameworkTrace( 'viewNotFound() called' );
column
number0
id
string??
line
number921
Raw_Trace
stringframework.one_cfc$cf.udfCall6(/framework/one.cfc:921)
template
stringC:\sites\websam\site\framework\one.cfc
type
stringcfml
type
stringdatabase
where
string
Sql
stringSELECT sub_category_id,sub_category_name,category_name,category_id,sub_category_description FROM VARIABLES_subcategoryList WHERE sub_category_id=53
SQLState
string
StackTrace
stringlucee.runtime.exp.IllegalQoQException: QoQ HSQLDB: error executing sql statement on query. at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:642) at lucee.runtime.db.HSQLDBHandler._execute(HSQLDBHandler.java:544) at lucee.runtime.db.HSQLDBHandler.execute(HSQLDBHandler.java:532) at lucee.runtime.tag.Query.executeQoQ(Query.java:1101) at lucee.runtime.tag.Query._doEndTag(Query.java:673) at lucee.runtime.tag.Query.doEndTag(Query.java:557) at model.gateway.sitemanager_cfc$cf.udfCall2(/model/gateway/siteManager.cfc:784) at model.gateway.sitemanager_cfc$cf.udfCall(/model/gateway/siteManager.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:723) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:595) at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:2120) at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:858) at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2107) at model.service.sitemanager_cfc$cf.udfCall2(/model/service/siteManager.cfc:78) at model.service.sitemanager_cfc$cf.udfCall(/model/service/siteManager.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:722) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:595) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2101) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:773) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:2075) at layouts.sitelayouts.siteproductlist_cfm$cf$2.call(/layouts/siteLayouts/siteProductList.cfm:9) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1112) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1006) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:987) at views.productview.productdetails_cfm$cf$1.call(/views/productview/productdetails.cfm:1) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1112) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1006) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:987) at framework.one_cfc$cf.udfCallc(/framework/one.cfc:1993) at framework.one_cfc$cf.udfCall(/framework/one.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224) at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:811) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:773) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:2075) at framework.one_cfc$cf.udfCall6(/framework/one.cfc:921) at framework.one_cfc$cf.udfCall(/framework/one.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:722) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:595) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2101) at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:477) at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:212) at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:41) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2810) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2797) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2768) at lucee.runtime.engine.Request.exe(Request.java:45) at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1109) at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1066) at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97) at lucee.loader.servlet.jakarta.CFMLServlet.service(CFMLServlet.java:52) at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:710) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:130) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:109) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:79) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:483) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:116) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:420) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:903) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1744) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:637) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:59) at java.base/java.lang.Thread.run(Unknown Source) Caused by: lucee.runtime.exp.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
string782: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FROM&nbsp;VARIABLES.subcategoryList<br> 783: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;WHERE&nbsp;sub_category_id=&lt;cfqueryparam&nbsp;value=&quot;#ARGUMENTS.subcategoryID#&quot;&nbsp;&nbsp;cfsqltype=&quot;cf_sql_integer&quot;&gt;<br> <b>784: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/cfquery&gt;</b><br> 785: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfreturn&nbsp;getSubcategoryInfoBySubcategoryID&gt;<br> 786: &nbsp;&nbsp;&nbsp;&lt;/cffunction&gt;<br>
codePrintPlain
string782: FROM VARIABLES.subcategoryList 783: WHERE sub_category_id=<cfqueryparam value="#ARGUMENTS.subcategoryID#" cfsqltype="cf_sql_integer"> 784: </cfquery> 785: <cfreturn getSubcategoryInfoBySubcategoryID> 786: </cffunction>
column
number0
id
string??
line
number784
Raw_Trace
stringmodel.gateway.sitemanager_cfc$cf.udfCall2(/model/gateway/siteManager.cfc:784)
template
stringC:\sites\websam\site\model\gateway\siteManager.cfc
type
stringcfml
2
Struct
codePrintHTML
string76: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfargument&nbsp;name=&quot;siteID&quot;&nbsp;type=&quot;numeric&quot;&nbsp;required=&quot;true&quot;&gt;<br> 77: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfargument&nbsp;name=&quot;subCategoryID&quot;&nbsp;type=&quot;numeric&quot;&nbsp;required=&quot;true&quot;&gt;<br> <b>78: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfreturn&nbsp;APPLICATION.getsiteManagerGateway().getSubcategoryInfoBySubcategoryID(siteID=ARGUMENTS.siteID,subCategoryID=ARGUMENTS.subCategoryID)&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</b><br> 79: &nbsp;&nbsp;&nbsp;&lt;/cffunction&gt;<br> 80: &nbsp;&nbsp;&nbsp;<br>
codePrintPlain
string76: <cfargument name="siteID" type="numeric" required="true"> 77: <cfargument name="subCategoryID" type="numeric" required="true"> 78: <cfreturn APPLICATION.getsiteManagerGateway().getSubcategoryInfoBySubcategoryID(siteID=ARGUMENTS.siteID,subCategoryID=ARGUMENTS.subCategoryID)> 79: </cffunction> 80:
column
number0
id
string??
line
number78
Raw_Trace
stringmodel.service.sitemanager_cfc$cf.udfCall2(/model/service/siteManager.cfc:78)
template
stringC:\sites\websam\site\model\service\siteManager.cfc
type
stringcfml
3
Struct
codePrintHTML
string7: <br> 8: &lt;cfset&nbsp;VARIABLES.productList&nbsp;=&nbsp;APPLICATION.getsiteManagerService().getProductList(siteID=APPLICATION.siteDetails.site_id,deptID=SESSION.employeeDetails.dept_id,subCategoryID=&nbsp;VARIABLES.subCategoryID)/&gt;<br> <b>9: &lt;cfset&nbsp;VARIABLES.subCategoryInfo=APPLICATION.getsiteManagerService().getSubcategoryInfoBySubcategoryID(#APPLICATION.siteDetails.site_id#,#VARIABLES.subCategoryID#)&gt;</b><br> 10: &lt;cfparam&nbsp;name=&quot;VARIABLES.type&quot;&nbsp;default=&quot;hidden&quot;&gt;<br> 11: &lt;cfset&nbsp;LOCAL.totalCards&nbsp;=&nbsp;VARIABLES.productList.recordCount&gt;<br>
codePrintPlain
string7: 8: <cfset VARIABLES.productList = APPLICATION.getsiteManagerService().getProductList(siteID=APPLICATION.siteDetails.site_id,deptID=SESSION.employeeDetails.dept_id,subCategoryID= VARIABLES.subCategoryID)/> 9: <cfset VARIABLES.subCategoryInfo=APPLICATION.getsiteManagerService().getSubcategoryInfoBySubcategoryID(#APPLICATION.siteDetails.site_id#,#VARIABLES.subCategoryID#)> 10: <cfparam name="VARIABLES.type" default="hidden"> 11: <cfset LOCAL.totalCards = VARIABLES.productList.recordCount>
column
number0
id
string??
line
number9
Raw_Trace
stringlayouts.sitelayouts.siteproductlist_cfm$cf$2.call(/layouts/siteLayouts/siteProductList.cfm:9)
template
stringC:\sites\websam\site\layouts\siteLayouts\siteProductList.cfm
type
stringcfml
4
Struct
codePrintHTML
string<b>1: &lt;cfinclude&nbsp;template=&quot;../../layouts/siteLayouts/siteProductList.cfm&quot;&gt;</b><br>
codePrintPlain
string1: <cfinclude template="../../layouts/siteLayouts/siteProductList.cfm">
column
number0
id
string??
line
number1
Raw_Trace
stringviews.productview.productdetails_cfm$cf$1.call(/views/productview/productdetails.cfm:1)
template
stringC:\sites\websam\site\views\productview\productdetails.cfm
type
stringcfml
5
Struct
codePrintHTML
string1991: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;response&nbsp;=&nbsp;'';<br> 1992: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;savecontent&nbsp;variable=&quot;response&quot;&nbsp;{<br> <b>1993: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;include&nbsp;'#viewPath#';</b><br> 1994: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br> 1995: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
codePrintPlain
string1991: response = ''; 1992: savecontent variable="response" { 1993: include '#viewPath#'; 1994: } 1995: }
column
number0
id
string??
line
number1993
Raw_Trace
stringframework.one_cfc$cf.udfCallc(/framework/one.cfc:1993)
template
stringC:\sites\websam\site\framework\one.cfc
type
stringcfml
6
Struct
codePrintHTML
string919: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(&nbsp;structKeyExists(request._fw1,&nbsp;'view')&nbsp;)&nbsp;{<br> 920: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;internalFrameworkTrace(&nbsp;'rendering&nbsp;#request._fw1.view#'&nbsp;);<br> <b>921: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;out&nbsp;=&nbsp;internalView(&nbsp;request._fw1.view&nbsp;);</b><br> 922: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;else&nbsp;if&nbsp;(&nbsp;structKeyExists(request._fw1,&nbsp;'omvInProgress')&nbsp;)&nbsp;{<br> 923: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;internalFrameworkTrace(&nbsp;'viewNotFound()&nbsp;called'&nbsp;);<br>
codePrintPlain
string919: if ( structKeyExists(request._fw1, 'view') ) { 920: internalFrameworkTrace( 'rendering #request._fw1.view#' ); 921: out = internalView( request._fw1.view ); 922: } else if ( structKeyExists(request._fw1, 'omvInProgress') ) { 923: internalFrameworkTrace( 'viewNotFound() called' );
column
number0
id
string??
line
number921
Raw_Trace
stringframework.one_cfc$cf.udfCall6(/framework/one.cfc:921)
template
stringC:\sites\websam\site\framework\one.cfc
type
stringcfml
type
stringdatabase
where
string