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 ws.intWheelImageID
,ws.intBrandID as brandID
,ws.decDiameter
,ws.decWidth
,ws.vchrPartNumber
,ws.vchrFinish
,ws.intFinishID
,(Replace(Replace(CAST(ws.decDiameter AS Varchar(20)),'.00',''),'.0','') + 'x' + Replace(Replace(CAST(ws.decWidth AS Varchar(20)),'.00',''),'.0','' )) AS vchrSize
,ws.vchrBoltPat1
,ws.vchrBoltPat2
,ws.decBore
,ws.vchrOffset
,ws.decWeight
,CEILING(ws.decWeight / 0.0022046) as weightInGrams
,ws.vchrCapNumber
,ws.intLoadRate
,ws.decBSM
,wi.intLugs
,Coalesce(( SELECT[vchrDistSKU]
FROM [tbl_DistPartNumbers] d
WHERE d.vchrPartNumber = ws.vchrPartNumber
AND d.intwheelID = ws.intWheelID
AND d.[intTypeID] = 1
),'') as ArticleNumber
,( CASE
WHEN @blnUseRetailOnly = 1 THEN Coalesce(r.[decRetailPrice],0)
WHEN Coalesce(r.[decRetailPrice],0) = 0 AND Coalesce(ws.monMapPrice,0) = 0 THEN Coalesce(ws.monPrice,0)
WHEN Coalesce(r.[decRetailPrice],0) >= Coalesce(ws.monMapPrice,0) THEN Coalesce(r.[decRetailPrice],0)
WHEN Coalesce(r.[decRetailPrice],0) <= Coalesce(ws.monMapPrice,0) THEN Coalesce(ws.monMapPrice,0)
ELSE Coalesce(ws.monPrice,0)
END
) AS monDisplayPrice
,Coalesce((SELECT Top 1 [decPrice] FROM [dbo].[tbl_PromoPrice]
WHERE [intBrandID] = ws.intBrandID
AND [vchrPartNumber] = ws. [vchrPartNumber]
AND GetDate() Between [dtDateFrom] AND [dtDateTo]
),0.00) as decSalePrice
FROM tbl_wheelspec ws WITH (NOLOCK)
INNER JOIN tbl_wheelImage wi WITH (NOLOCK) ON wi.intWheelImageID = ws.intWheelImageID
LEFT JOIN [dbo].[tbl_RetailTWPNPrice] r on r.vchrManuPartNumber = ws.vchrPartNumber
AND r.intConfigID = 11623
AND r.intBrandID = ws.intBrandID
WHERE ws.intWheelID = 1777
AND ws.intFinishID = 5093
AND decDiameter <> 0
ORDER BY decDiameter, decWidth, vchrFinish, vchrPartNumber, vchrBoltPat1, vchrOffset |
|
| DataSource | | Detail | | ErrorCode | | Extended_Info | | ExtendedInfo | | Message | | NativeErrorCode | | queryError | string | DECLARE @blnUseRetailOnly bit = 0
SELECT @blnUseRetailOnly = blnUseRetailOnly
From [icon_master].[dbo].[tbl_configurators] WITH (NOLOCK)
Where intConfigID = 11623
SELECT DISTINCT ws.intWheelImageID
,ws.intBrandID as brandID
,ws.decDiameter
,ws.decWidth
,ws.vchrPartNumber
,ws.vchrFinish
,ws.intFinishID
,(Replace(Replace(CAST(ws.decDiameter AS Varchar(20)),'.00',''),'.0','') + 'x' + Replace(Replace(CAST(ws.decWidth AS Varchar(20)),'.00',''),'.0','' )) AS vchrSize
,ws.vchrBoltPat1
,ws.vchrBoltPat2
,ws.decBore
,ws.vchrOffset
,ws.decWeight
,CEILING(ws.decWeight / 0.0022046) as weightInGrams
,ws.vchrCapNumber
,ws.intLoadRate
,ws.decBSM
,wi.intLugs
,Coalesce(( SELECT[vchrDistSKU]
FROM [tbl_DistPartNumbers] d
WHERE d.vchrPartNumber = ws.vchrPartNumber
AND d.intwheelID = ws.intWheelID
AND d.[intTypeID] = 1
),'') as ArticleNumber
,( CASE
WHEN @blnUseRetailOnly = 1 THEN Coalesce(r.[decRetailPrice],0)
WHEN Coalesce(r.[decRetailPrice],0) = 0 AND Coalesce(ws.monMapPrice,0) = 0 THEN Coalesce(ws.monPrice,0)
WHEN Coalesce(r.[decRetailPrice],0) >= Coalesce(ws.monMapPrice,0) THEN Coalesce(r.[decRetailPrice],0)
WHEN Coalesce(r.[decRetailPrice],0) <= Coalesce(ws.monMapPrice,0) THEN Coalesce(ws.monMapPrice,0)
ELSE Coalesce(ws.monPrice,0)
END
) AS monDisplayPrice
,Coalesce((SELECT Top 1 [decPrice] FROM [dbo].[tbl_PromoPrice]
WHERE [intBrandID] = ws.intBrandID
AND [vchrPartNumber] = ws. [vchrPartNumber]
AND GetDate() Between [dtDateFrom] AND [dtDateTo]
),0.00) as decSalePrice
FROM tbl_wheelspec ws WITH (NOLOCK)
INNER JOIN tbl_wheelImage wi WITH (NOLOCK) ON wi.intWheelImageID = ws.intWheelImageID
LEFT JOIN [dbo].[tbl_RetailTWPNPrice] r on r.vchrManuPartNumber = ws.vchrPartNumber
AND r.intConfigID = 11623
AND r.intBrandID = ws.intBrandID
WHERE ws.intWheelID = 1777
AND ws.intFinishID = 5093
AND decDiameter <> 0
ORDER BY decDiameter, decWidth, vchrFinish, vchrPartNumber, vchrBoltPat1, vchrOffset |
| Sql | string | DECLARE @blnUseRetailOnly bit = 0
SELECT @blnUseRetailOnly = blnUseRetailOnly
From [icon_master].[dbo].[tbl_configurators] WITH (NOLOCK)
Where intConfigID = 11623
SELECT DISTINCT ws.intWheelImageID
,ws.intBrandID as brandID
,ws.decDiameter
,ws.decWidth
,ws.vchrPartNumber
,ws.vchrFinish
,ws.intFinishID
,(Replace(Replace(CAST(ws.decDiameter AS Varchar(20)),'.00',''),'.0','') + 'x' + Replace(Replace(CAST(ws.decWidth AS Varchar(20)),'.00',''),'.0','' )) AS vchrSize
,ws.vchrBoltPat1
,ws.vchrBoltPat2
,ws.decBore
,ws.vchrOffset
,ws.decWeight
,CEILING(ws.decWeight / 0.0022046) as weightInGrams
,ws.vchrCapNumber
,ws.intLoadRate
,ws.decBSM
,wi.intLugs
,Coalesce(( SELECT[vchrDistSKU]
FROM [tbl_DistPartNumbers] d
WHERE d.vchrPartNumber = ws.vchrPartNumber
AND d.intwheelID = ws.intWheelID
AND d.[intTypeID] = 1
),'') as ArticleNumber
,( CASE
WHEN @blnUseRetailOnly = 1 THEN Coalesce(r.[decRetailPrice],0)
WHEN Coalesce(r.[decRetailPrice],0) = 0 AND Coalesce(ws.monMapPrice,0) = 0 THEN Coalesce(ws.monPrice,0)
WHEN Coalesce(r.[decRetailPrice],0) >= Coalesce(ws.monMapPrice,0) THEN Coalesce(r.[decRetailPrice],0)
WHEN Coalesce(r.[decRetailPrice],0) <= Coalesce(ws.monMapPrice,0) THEN Coalesce(ws.monMapPrice,0)
ELSE Coalesce(ws.monPrice,0)
END
) AS monDisplayPrice
,Coalesce((SELECT Top 1 [decPrice] FROM [dbo].[tbl_PromoPrice]
WHERE [intBrandID] = ws.intBrandID
AND [vchrPartNumber] = ws. [vchrPartNumber]
AND GetDate() Between [dtDateFrom] AND [dtDateTo]
),0.00) as decSalePrice
FROM tbl_wheelspec ws WITH (NOLOCK)
INNER JOIN tbl_wheelImage wi WITH (NOLOCK) ON wi.intWheelImageID = ws.intWheelImageID
LEFT JOIN [dbo].[tbl_RetailTWPNPrice] r on r.vchrManuPartNumber = ws.vchrPartNumber
AND r.intConfigID = 11623
AND r.intBrandID = ws.intBrandID
WHERE ws.intWheelID = 1777
AND ws.intFinishID = 5093
AND decDiameter <> 0
ORDER BY decDiameter, decWidth, vchrFinish, vchrPartNumber, vchrBoltPat1, vchrOffset |
| SQLState | | StackTrace | string | lucee.runtime.exp.DatabaseException: Connection reset
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.read(IOBuffer.java:1789)
at com.microsoft.sqlserver.jdbc.TDSReader.readPacket(IOBuffer.java:4881)
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 wheels.queries_cfc$cf.udfCall3(/wheels/queries.cfc:1315)
at wheels.queries_cfc$cf.udfCall(/wheels/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 wheel_cfm$cf.call(/wheel.cfm:163)
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 | 1313: AND decDiameter <> 0<br>
1314: <br>
<b>1315: ORDER BY <cfif arguments['priceOrder'] neq ''>monDisplayPrice,</cfif>decDiameter, decWidth, vchrFinish, vchrPartNumber, vchrBoltPat1, vchrOffset<!---,decMapPrice DESC, decRetailPrice---></b><br>
1316: </cfquery><br>
1317: <cfreturn query><br>
|
| codePrintPlain | string | 1313: AND decDiameter <> 0
1314:
1315: ORDER BY <cfif arguments['priceOrder'] neq ''>monDisplayPrice,</cfif>decDiameter, decWidth, vchrFinish, vchrPartNumber, vchrBoltPat1, vchrOffset<!---,decMapPrice DESC, decRetailPrice--->
1316: </cfquery>
1317: <cfreturn query>
|
| column | | id | | line | | Raw_Trace | string | wheels.queries_cfc$cf.udfCall3(/wheels/queries.cfc:1315) |
| template | string | D:\WebSites\socalcustomwheels.com\wheels\queries.cfc |
| type | |
| 2 | Struct | codePrintHTML | string | 161: <br>
162: getSpecs = queries.getWheelSpecs(wheelInfo.intWheelImageID);<br>
<b>163: getSpecs = queries.getTabSpecs(wheelInfo.intWheelID,wheelInfo.intFinishID)</b><br>
164: <br>
165: // pricing<br>
|
| codePrintPlain | string | 161:
162: getSpecs = queries.getWheelSpecs(wheelInfo.intWheelImageID);
163: getSpecs = queries.getTabSpecs(wheelInfo.intWheelID,wheelInfo.intFinishID)
164:
165: // pricing
|
| column | | id | | line | | Raw_Trace | string | wheel_cfm$cf.call(/wheel.cfm:163) |
| template | string | D:\WebSites\socalcustomwheels.com\wheel.cfm |
| type | |
|
| type | | where | |
|