ERRORDATA | Catch Entries: 15 | additional | Struct (ordered) | SQL | string | DECLARE @blnUseRetailOnly bit = 0
SELECT
@blnUseRetailOnly = blnUseRetailOnly
From [icon_master].[dbo].[tbl_configurators] WITH (NOLOCK)
Where intConfigID = 11623
SELECT DISTINCT ts.intTireSpecID
,ts.intTireID
,ts.vchrPartNumber
,ts.intAccountID
,ts.intBrandID
,ts.intTireImageID
,t.vchrName
,t.vchrMarketingTitle
,t.vchrImage
,t.vchrImageLarge
,t.intBrandID
,t.txtDescription
,b.vchrName as brandName
,ts.vchrQuickDraw
,ts.vchrSize
,ts.vchrSideWall
,ts.decDiameter
,ts.decSectWidth
,ts.decAspectRatio
,ts.decDiameterInch
,ts.decWidthInch
,ts.vchrSpeedRating
,ts.chrType
,ts.chrLoadRange
,ts.intLoadIndex
,ts.decWeight
,ts.decHeight
,ts.decWidth
,ts.decLenth
,ts.intMaxLoad
,ts.vchrMaxPSI
,ts.intMaxPressure
,( 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
, 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
FROM tbl_TireSpec ts WITH (NOLOCK)
INNER JOIN tbl_Tire t on t.intTireID = ts.intTireID
INNER JOIN tbl_brand b ON ts.intBrandID = b.intID
LEFT JOIN tbl_RetailTWPNPrice r WITH (NOLOCK) ON r.vchrManuPartNumber = ts.vchrPartNumber
AND r.intConfigID = 11623
AND r.intBrandID = b.intID
WHERE b.blnActive = 1
AND ts.blnActive = 1
AND ts.intTireID = 4503
AND ts.vchrPartNumber = '35-135024AMP/CM2' |
|
| DataSource | | Detail | | ErrorCode | | Extended_Info | | ExtendedInfo | | Message | string | Connection reset by peer: socket write error |
| NativeErrorCode | | queryError | string | DECLARE @blnUseRetailOnly bit = 0
SELECT
@blnUseRetailOnly = blnUseRetailOnly
From [icon_master].[dbo].[tbl_configurators] WITH (NOLOCK)
Where intConfigID = 11623
SELECT DISTINCT ts.intTireSpecID
,ts.intTireID
,ts.vchrPartNumber
,ts.intAccountID
,ts.intBrandID
,ts.intTireImageID
,t.vchrName
,t.vchrMarketingTitle
,t.vchrImage
,t.vchrImageLarge
,t.intBrandID
,t.txtDescription
,b.vchrName as brandName
,ts.vchrQuickDraw
,ts.vchrSize
,ts.vchrSideWall
,ts.decDiameter
,ts.decSectWidth
,ts.decAspectRatio
,ts.decDiameterInch
,ts.decWidthInch
,ts.vchrSpeedRating
,ts.chrType
,ts.chrLoadRange
,ts.intLoadIndex
,ts.decWeight
,ts.decHeight
,ts.decWidth
,ts.decLenth
,ts.intMaxLoad
,ts.vchrMaxPSI
,ts.intMaxPressure
,( 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
, 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
FROM tbl_TireSpec ts WITH (NOLOCK)
INNER JOIN tbl_Tire t on t.intTireID = ts.intTireID
INNER JOIN tbl_brand b ON ts.intBrandID = b.intID
LEFT JOIN tbl_RetailTWPNPrice r WITH (NOLOCK) ON r.vchrManuPartNumber = ts.vchrPartNumber
AND r.intConfigID = 11623
AND r.intBrandID = b.intID
WHERE b.blnActive = 1
AND ts.blnActive = 1
AND ts.intTireID = 4503
AND ts.vchrPartNumber = '35-135024AMP/CM2' |
| Sql | string | DECLARE @blnUseRetailOnly bit = 0
SELECT
@blnUseRetailOnly = blnUseRetailOnly
From [icon_master].[dbo].[tbl_configurators] WITH (NOLOCK)
Where intConfigID = 11623
SELECT DISTINCT ts.intTireSpecID
,ts.intTireID
,ts.vchrPartNumber
,ts.intAccountID
,ts.intBrandID
,ts.intTireImageID
,t.vchrName
,t.vchrMarketingTitle
,t.vchrImage
,t.vchrImageLarge
,t.intBrandID
,t.txtDescription
,b.vchrName as brandName
,ts.vchrQuickDraw
,ts.vchrSize
,ts.vchrSideWall
,ts.decDiameter
,ts.decSectWidth
,ts.decAspectRatio
,ts.decDiameterInch
,ts.decWidthInch
,ts.vchrSpeedRating
,ts.chrType
,ts.chrLoadRange
,ts.intLoadIndex
,ts.decWeight
,ts.decHeight
,ts.decWidth
,ts.decLenth
,ts.intMaxLoad
,ts.vchrMaxPSI
,ts.intMaxPressure
,( 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
, 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
FROM tbl_TireSpec ts WITH (NOLOCK)
INNER JOIN tbl_Tire t on t.intTireID = ts.intTireID
INNER JOIN tbl_brand b ON ts.intBrandID = b.intID
LEFT JOIN tbl_RetailTWPNPrice r WITH (NOLOCK) ON r.vchrManuPartNumber = ts.vchrPartNumber
AND r.intConfigID = 11623
AND r.intBrandID = b.intID
WHERE b.blnActive = 1
AND ts.blnActive = 1
AND ts.intTireID = 4503
AND ts.vchrPartNumber = '35-135024AMP/CM2' |
| 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.endMessage(IOBuffer.java:3062)
at com.microsoft.sqlserver.jdbc.TDSCommand.startResponse(IOBuffer.java:6120)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:402)
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$qn8.udfCall1(/tires/queries.cfc:498)
at tires.queries_cfc$cf$qn8.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 tire_cfm$cf.call(/tire.cfm:15)
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 | 496: AND 1 = 2 <br>
497: </cfif><br>
<b>498: </cfquery></b><br>
499: <cfreturn query><br>
500: </cffunction><br>
|
| codePrintPlain | string | 496: AND 1 = 2
497: </cfif>
498: </cfquery>
499: <cfreturn query>
500: </cffunction>
|
| column | | id | | line | | Raw_Trace | string | tires.queries_cfc$cf$qn8.udfCall1(/tires/queries.cfc:498) |
| template | string | D:\WebSites\socalcustomwheels.com\tires\queries.cfc |
| type | |
| 2 | Struct | codePrintHTML | string | 13: getTireSpecsComplete = queries.getTireSpecsBySKU(<br>
14: url.id,<br>
<b>15: url.part</b><br>
16: );<br>
17: <br>
|
| codePrintPlain | string | 13: getTireSpecsComplete = queries.getTireSpecsBySKU(
14: url.id,
15: url.part
16: );
17:
|
| column | | id | | line | | Raw_Trace | string | tire_cfm$cf.call(/tire.cfm:15) |
| template | string | D:\WebSites\socalcustomwheels.com\tire.cfm |
| type | |
|
| type | | where | |
|