ERRORDATA | Catch Entries: 15 | additional | Struct (ordered) | SQL | string | DECLARE @intPage int = 7;
DECLARE @intPageSize int = 36
DECLARE @blnUseRetailOnly bit = 0
SELECT
@blnUseRetailOnly = blnUseRetailOnly
From [icon_master].[dbo].[tbl_configurators] WITH (NOLOCK)
Where intConfigID = 11623
SELECT *,
overall_count = COUNT(*) OVER()
FROM (
SELECT DISTINCT
t.vchrName
,t.intTireID
,t.vchrMarketingTitle
,t.vchrImage
,t.vchrImageLarge
,t.intBrandID
,b.vchrName AS brandName
,b.vchrImage AS brandImage
,b.vchrThumbnail AS brandLogo
,( CASE
WHEN @blnUseRetailOnly = 1 THEN Coalesce(r.[decRetailPrice],0)
WHEN Coalesce(r.[decRetailPrice],0) = 0 AND Coalesce(ts.monMapPrice,0) = 0 THEN Coalesce(ts.monPrice,0)
WHEN Coalesce(r.[decRetailPrice],0) >= Coalesce(ts.monMapPrice,0) THEN Coalesce(r.[decRetailPrice],0)
WHEN Coalesce(r.[decRetailPrice],0) <= Coalesce(ts.monMapPrice,0) THEN Coalesce(ts.monMapPrice,0)
ELSE Coalesce(ts.monPrice,0)
END
) AS monDisplayPrice
,ts.vchrSize
,ts.vchrPartNumber
,ts.decSectWidth
,ts.intTireSpecID
,ts.monPrice
,ts.monMapPrice
,0 AS blnIsStag
,ts.[vchrSize] as RearSize
,ts.monPrice as RearmonPrice
,ts.monMapPrice As RearmonMapPrice
,ts.vchrPartNumber as RearPartNumber
,Coalesce((SELECT top 1 i.[intQTY] FROM [icon_front].[dbo].[tbl_ICF_TireInventory] i WHERE i.vchrPartNumber = ts.[vchrPartNumber] AND i.intBrandID = t.intBrandID ) ,-1)AS [intQTY]
,Coalesce((SELECT Top 1 [decPrice] FROM [dbo].[tbl_PromoPrice]
WHERE [intBrandID] = ts.intBrandID
AND [vchrPartNumber] = ts.[vchrPartNumber]
AND GetDate() Between [dtDateFrom] AND [dtDateTo]
),0.00) as decPromoPrice
,(CASE
WHEN @blnUseRetailOnly = 1 AND Coalesce(r.[decRetailPrice],0) = 0 THEN 999999
WHEN @blnUseRetailOnly = 1 AND Coalesce(r.[decRetailPrice],0) > 0 THEN Coalesce(r.[decRetailPrice],0)
WHEN Coalesce(r.[decRetailPrice],0) = 0 AND Coalesce(ts.monMapPrice,0) = 0 and Coalesce(ts.monPrice,0) = 0 THEN 99999
WHEN Coalesce(r.[decRetailPrice],0) = 0 AND Coalesce(ts.monMapPrice,0) = 0 and Coalesce(ts.monPrice,0) > 0 THEN Coalesce(ts.monPrice,0)
WHEN Coalesce(r.[decRetailPrice],0) > Coalesce(ts.monMapPrice,0) THEN Coalesce(r.[decRetailPrice],0)
WHEN Coalesce(r.[decRetailPrice],0) < Coalesce(ts.monMapPrice,0) THEN Coalesce(ts.monMapPrice,0)
WHEN Coalesce(ts.monPrice,0) > 0 THEN Coalesce(ts.monPrice,0)
ELSE 99999
END
) as intCustomSortOrder
FROM tbl_tire t WITH (NOLOCK)
INNER JOIN tbl_tireSpec ts WITH (NOLOCK) on ts.intTireID = t.intTireID
INNER JOIN tbl_brand b WITH (NOLOCK) ON b.intID = t.intBrandID
AND b.blnActive = 1
AND b.intTypeID = 3
INNER JOIN tbl_brandConfig bc WITH (NOLOCK) ON bc.intBrandID = b.intID
AND bc.intConfigID = 11623
LEFT JOIN [dbo].[tbl_RetailTWPNPrice] r on r.vchrManuPartNumber = ts.vchrPartNumber
AND r.intConfigID = 11623
AND r.intBrandID = b.intID
WHERE t.blnActive = 1
AND ts.decDiameter IN (18)
) a
WHERE EXISTS ( SELECT tvt.intTireTypeID
FROM [dbo].[Tbl_TireVehicleTypes] tvt WITH (NOLOCK)
WHERE tvt.intTireID = a.intTireID
AND tvt.intVehicleTireTypeID IN (12,3,2)
)
ORDER BY intCustomSortOrder, intQTY DESC , brandName, vchrSize, VCHRNAME
OFFSET (@intPage - 1) * @intPageSize ROWS
FETCH NEXT @intPageSize ROWS ONLY |
|
| DataSource | | Detail | | ErrorCode | | Extended_Info | | ExtendedInfo | | Message | string | Connection reset by peer: socket write error |
| NativeErrorCode | | queryError | string | DECLARE @intPage int = 7;
DECLARE @intPageSize int = 36
DECLARE @blnUseRetailOnly bit = 0
SELECT
@blnUseRetailOnly = blnUseRetailOnly
From [icon_master].[dbo].[tbl_configurators] WITH (NOLOCK)
Where intConfigID = 11623
SELECT *,
overall_count = COUNT(*) OVER()
FROM (
SELECT DISTINCT
t.vchrName
,t.intTireID
,t.vchrMarketingTitle
,t.vchrImage
,t.vchrImageLarge
,t.intBrandID
,b.vchrName AS brandName
,b.vchrImage AS brandImage
,b.vchrThumbnail AS brandLogo
,( CASE
WHEN @blnUseRetailOnly = 1 THEN Coalesce(r.[decRetailPrice],0)
WHEN Coalesce(r.[decRetailPrice],0) = 0 AND Coalesce(ts.monMapPrice,0) = 0 THEN Coalesce(ts.monPrice,0)
WHEN Coalesce(r.[decRetailPrice],0) >= Coalesce(ts.monMapPrice,0) THEN Coalesce(r.[decRetailPrice],0)
WHEN Coalesce(r.[decRetailPrice],0) <= Coalesce(ts.monMapPrice,0) THEN Coalesce(ts.monMapPrice,0)
ELSE Coalesce(ts.monPrice,0)
END
) AS monDisplayPrice
,ts.vchrSize
,ts.vchrPartNumber
,ts.decSectWidth
,ts.intTireSpecID
,ts.monPrice
,ts.monMapPrice
,0 AS blnIsStag
,ts.[vchrSize] as RearSize
,ts.monPrice as RearmonPrice
,ts.monMapPrice As RearmonMapPrice
,ts.vchrPartNumber as RearPartNumber
,Coalesce((SELECT top 1 i.[intQTY] FROM [icon_front].[dbo].[tbl_ICF_TireInventory] i WHERE i.vchrPartNumber = ts.[vchrPartNumber] AND i.intBrandID = t.intBrandID ) ,-1)AS [intQTY]
,Coalesce((SELECT Top 1 [decPrice] FROM [dbo].[tbl_PromoPrice]
WHERE [intBrandID] = ts.intBrandID
AND [vchrPartNumber] = ts.[vchrPartNumber]
AND GetDate() Between [dtDateFrom] AND [dtDateTo]
),0.00) as decPromoPrice
,(CASE
WHEN @blnUseRetailOnly = 1 AND Coalesce(r.[decRetailPrice],0) = 0 THEN 999999
WHEN @blnUseRetailOnly = 1 AND Coalesce(r.[decRetailPrice],0) > 0 THEN Coalesce(r.[decRetailPrice],0)
WHEN Coalesce(r.[decRetailPrice],0) = 0 AND Coalesce(ts.monMapPrice,0) = 0 and Coalesce(ts.monPrice,0) = 0 THEN 99999
WHEN Coalesce(r.[decRetailPrice],0) = 0 AND Coalesce(ts.monMapPrice,0) = 0 and Coalesce(ts.monPrice,0) > 0 THEN Coalesce(ts.monPrice,0)
WHEN Coalesce(r.[decRetailPrice],0) > Coalesce(ts.monMapPrice,0) THEN Coalesce(r.[decRetailPrice],0)
WHEN Coalesce(r.[decRetailPrice],0) < Coalesce(ts.monMapPrice,0) THEN Coalesce(ts.monMapPrice,0)
WHEN Coalesce(ts.monPrice,0) > 0 THEN Coalesce(ts.monPrice,0)
ELSE 99999
END
) as intCustomSortOrder
FROM tbl_tire t WITH (NOLOCK)
INNER JOIN tbl_tireSpec ts WITH (NOLOCK) on ts.intTireID = t.intTireID
INNER JOIN tbl_brand b WITH (NOLOCK) ON b.intID = t.intBrandID
AND b.blnActive = 1
AND b.intTypeID = 3
INNER JOIN tbl_brandConfig bc WITH (NOLOCK) ON bc.intBrandID = b.intID
AND bc.intConfigID = 11623
LEFT JOIN [dbo].[tbl_RetailTWPNPrice] r on r.vchrManuPartNumber = ts.vchrPartNumber
AND r.intConfigID = 11623
AND r.intBrandID = b.intID
WHERE t.blnActive = 1
AND ts.decDiameter IN (18)
) a
WHERE EXISTS ( SELECT tvt.intTireTypeID
FROM [dbo].[Tbl_TireVehicleTypes] tvt WITH (NOLOCK)
WHERE tvt.intTireID = a.intTireID
AND tvt.intVehicleTireTypeID IN (12,3,2)
)
ORDER BY intCustomSortOrder, intQTY DESC , brandName, vchrSize, VCHRNAME
OFFSET (@intPage - 1) * @intPageSize ROWS
FETCH NEXT @intPageSize ROWS ONLY |
| Sql | string | DECLARE @intPage int = 7;
DECLARE @intPageSize int = 36
DECLARE @blnUseRetailOnly bit = 0
SELECT
@blnUseRetailOnly = blnUseRetailOnly
From [icon_master].[dbo].[tbl_configurators] WITH (NOLOCK)
Where intConfigID = 11623
SELECT *,
overall_count = COUNT(*) OVER()
FROM (
SELECT DISTINCT
t.vchrName
,t.intTireID
,t.vchrMarketingTitle
,t.vchrImage
,t.vchrImageLarge
,t.intBrandID
,b.vchrName AS brandName
,b.vchrImage AS brandImage
,b.vchrThumbnail AS brandLogo
,( CASE
WHEN @blnUseRetailOnly = 1 THEN Coalesce(r.[decRetailPrice],0)
WHEN Coalesce(r.[decRetailPrice],0) = 0 AND Coalesce(ts.monMapPrice,0) = 0 THEN Coalesce(ts.monPrice,0)
WHEN Coalesce(r.[decRetailPrice],0) >= Coalesce(ts.monMapPrice,0) THEN Coalesce(r.[decRetailPrice],0)
WHEN Coalesce(r.[decRetailPrice],0) <= Coalesce(ts.monMapPrice,0) THEN Coalesce(ts.monMapPrice,0)
ELSE Coalesce(ts.monPrice,0)
END
) AS monDisplayPrice
,ts.vchrSize
,ts.vchrPartNumber
,ts.decSectWidth
,ts.intTireSpecID
,ts.monPrice
,ts.monMapPrice
,0 AS blnIsStag
,ts.[vchrSize] as RearSize
,ts.monPrice as RearmonPrice
,ts.monMapPrice As RearmonMapPrice
,ts.vchrPartNumber as RearPartNumber
,Coalesce((SELECT top 1 i.[intQTY] FROM [icon_front].[dbo].[tbl_ICF_TireInventory] i WHERE i.vchrPartNumber = ts.[vchrPartNumber] AND i.intBrandID = t.intBrandID ) ,-1)AS [intQTY]
,Coalesce((SELECT Top 1 [decPrice] FROM [dbo].[tbl_PromoPrice]
WHERE [intBrandID] = ts.intBrandID
AND [vchrPartNumber] = ts.[vchrPartNumber]
AND GetDate() Between [dtDateFrom] AND [dtDateTo]
),0.00) as decPromoPrice
,(CASE
WHEN @blnUseRetailOnly = 1 AND Coalesce(r.[decRetailPrice],0) = 0 THEN 999999
WHEN @blnUseRetailOnly = 1 AND Coalesce(r.[decRetailPrice],0) > 0 THEN Coalesce(r.[decRetailPrice],0)
WHEN Coalesce(r.[decRetailPrice],0) = 0 AND Coalesce(ts.monMapPrice,0) = 0 and Coalesce(ts.monPrice,0) = 0 THEN 99999
WHEN Coalesce(r.[decRetailPrice],0) = 0 AND Coalesce(ts.monMapPrice,0) = 0 and Coalesce(ts.monPrice,0) > 0 THEN Coalesce(ts.monPrice,0)
WHEN Coalesce(r.[decRetailPrice],0) > Coalesce(ts.monMapPrice,0) THEN Coalesce(r.[decRetailPrice],0)
WHEN Coalesce(r.[decRetailPrice],0) < Coalesce(ts.monMapPrice,0) THEN Coalesce(ts.monMapPrice,0)
WHEN Coalesce(ts.monPrice,0) > 0 THEN Coalesce(ts.monPrice,0)
ELSE 99999
END
) as intCustomSortOrder
FROM tbl_tire t WITH (NOLOCK)
INNER JOIN tbl_tireSpec ts WITH (NOLOCK) on ts.intTireID = t.intTireID
INNER JOIN tbl_brand b WITH (NOLOCK) ON b.intID = t.intBrandID
AND b.blnActive = 1
AND b.intTypeID = 3
INNER JOIN tbl_brandConfig bc WITH (NOLOCK) ON bc.intBrandID = b.intID
AND bc.intConfigID = 11623
LEFT JOIN [dbo].[tbl_RetailTWPNPrice] r on r.vchrManuPartNumber = ts.vchrPartNumber
AND r.intConfigID = 11623
AND r.intBrandID = b.intID
WHERE t.blnActive = 1
AND ts.decDiameter IN (18)
) a
WHERE EXISTS ( SELECT tvt.intTireTypeID
FROM [dbo].[Tbl_TireVehicleTypes] tvt WITH (NOLOCK)
WHERE tvt.intTireID = a.intTireID
AND tvt.intVehicleTireTypeID IN (12,3,2)
)
ORDER BY intCustomSortOrder, intQTY DESC , brandName, vchrSize, VCHRNAME
OFFSET (@intPage - 1) * @intPageSize ROWS
FETCH NEXT @intPageSize ROWS ONLY |
| SQLState | | StackTrace | string | lucee.runtime.exp.DatabaseException: Connection reset by peer: socket write error
at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:1667)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:1654)
at com.microsoft.sqlserver.jdbc.TDSChannel.write(IOBuffer.java:1805)
at com.microsoft.sqlserver.jdbc.TDSWriter.flush(IOBuffer.java:3581)
at com.microsoft.sqlserver.jdbc.TDSWriter.writePacket(IOBuffer.java:3482)
at com.microsoft.sqlserver.jdbc.TDSWriter.writeBytes(IOBuffer.java:3216)
at com.microsoft.sqlserver.jdbc.TDSWriter.writeString(IOBuffer.java:3290)
at com.microsoft.sqlserver.jdbc.TDSWriter.writeRPCStringUnicode(IOBuffer.java:3878)
at com.microsoft.sqlserver.jdbc.TDSWriter.writeRPCStringUnicode(IOBuffer.java:3835)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.buildPrepExecParams(SQLServerPreparedStatement.java:543)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doPrepExec(SQLServerPreparedStatement.java:618)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:400)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:332)
at com.seefusion.PreparedStatementImpl.execute(PreparedStatementImpl.java:99)
at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:328)
at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:296)
at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:235)
at lucee.runtime.tag.Query.executeDatasoure(Query.java:1135)
at lucee.runtime.tag.Query._doEndTag(Query.java:700)
at lucee.runtime.tag.Query.doEndTag(Query.java:566)
at tires.queries_cfc$cf$rmz.udfCall1(/tires/queries.cfc:202)
at tires.queries_cfc$cf$rmz.udfCall(/tires/queries.cfc)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:350)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:698)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586)
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1933)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787)
at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1775)
at tires.default_cfm$cf.call(/tires/default.cfm:83)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1056)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:948)
at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:219)
at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:44)
at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2493)
at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2478)
at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2449)
at lucee.runtime.engine.Request.exe(Request.java:45)
at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1216)
at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1162)
at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97)
at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:51)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.seefusion.Filter.doFilter(Filter.java:109)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:217)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
at com.seefusion.SeeFusionValve.invoke(SeeFusionValve.java:52)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:518)
at org.apache.coyote.ajp.AbstractAjpProcessor.process(AbstractAjpProcessor.java:844)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:673)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1500)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1456)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
|
| TagContext | Array | 1 | Struct | codePrintHTML | string | 200: OFFSET (@intPage - 1) * @intPageSize ROWS<br>
201: FETCH NEXT @intPageSize ROWS ONLY<br>
<b>202: </cfquery></b><br>
203: <br>
204: <cfreturn query><br>
|
| codePrintPlain | string | 200: OFFSET (@intPage - 1) * @intPageSize ROWS
201: FETCH NEXT @intPageSize ROWS ONLY
202: </cfquery>
203:
204: <cfreturn query>
|
| column | | id | | line | | Raw_Trace | string | tires.queries_cfc$cf$rmz.udfCall1(/tires/queries.cfc:202) |
| template | string | D:\WebSites\socalcustomwheels.com\tires\queries.cfc |
| type | |
| 2 | Struct | codePrintHTML | string | 81: #url.type#,<br>
82: #url.tvtypes#,<br>
<b>83: url.search</b><br>
84: <br>
85: );<br>
|
| codePrintPlain | string | 81: #url.type#,
82: #url.tvtypes#,
83: url.search
84:
85: );
|
| column | | id | | line | | Raw_Trace | string | tires.default_cfm$cf.call(/tires/default.cfm:83) |
| template | string | D:\WebSites\socalcustomwheels.com\tires\default.cfm |
| type | |
|
| type | | where | |
|