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 1 = 2 |
|
| DataSource | | Detail | | ErrorCode | | Extended_Info | | ExtendedInfo | | Message | string | SQL Server did not return a response. The connection has been closed. |
| 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 1 = 2 |
| 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 1 = 2 |
| SQLState | | StackTrace | string | lucee.runtime.exp.DatabaseException: SQL Server did not return a response. The connection has been closed.
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.TDSReader.readPacket(IOBuffer.java:4844)
at com.microsoft.sqlserver.jdbc.TDSCommand.startResponse(IOBuffer.java:6150)
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$qns.udfCall1(/tires/queries.cfc:498)
at tires.queries_cfc$cf$qns.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 package_cfm$cf.call(/package.cfm:92)
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$qns.udfCall1(/tires/queries.cfc:498) |
| template | string | D:\WebSites\socalcustomwheels.com\tires\queries.cfc |
| type | |
| 2 | Struct | codePrintHTML | string | 90: <br>
91: tireSpecInfo = tireQueries.getTireSpecsBySKU(0,'',url.tireSpec);<br>
<b>92: tireSpecInfoRear = tireQueries.getTireSpecsBySKU(0,'',url.rtspec);</b><br>
93: <br>
94: isStaggered = false;<br>
|
| codePrintPlain | string | 90:
91: tireSpecInfo = tireQueries.getTireSpecsBySKU(0,'',url.tireSpec);
92: tireSpecInfoRear = tireQueries.getTireSpecsBySKU(0,'',url.rtspec);
93:
94: isStaggered = false;
|
| column | | id | | line | | Raw_Trace | string | package_cfm$cf.call(/package.cfm:92) |
| template | string | D:\WebSites\socalcustomwheels.com\package.cfm |
| type | |
|
| type | | where | |
|