Lucee 5.1.0.34 Error (database)
Message
Detail Connection reset by peer: socket write error
SQL SELECT SUM(cart_sku_qty) AS CartCount, cart_custcart_id
FROM cw_cart c, cw_skus s
WHERE c.cart_custcart_id ='20171119040878117'
AND s.sku_id = c.cart_sku_id
AND NOT c.cart_sku_id = 0
AND NOT c.cart_sku_id IS NULL
AND NOT c.cart_sku_qty = 0
AND NOT s.sku_on_web = 0
GROUP BY cart_custcart_id
Stacktrace The Error Occurred in
D:\RootWebsites\www.NormansLiquors.com\cw4\cwapp\func\cw-func-cart.cfm: line 1069
1067: AND NOT s.sku_on_web = 0
1068: GROUP BY cart_custcart_id
1069: </cfquery>
1070:
1071: <cfif isNumeric(rsCartCount.cartCount)>

called from D:\RootWebsites\www.NormansLiquors.com\cw4\cwapp\mod\cw-mod-customerlinks.cfm: line 47
called from D:\RootWebsites\www.NormansLiquors.com\cw4\cwapp\inc\cw-inc-cartlinks.cfm: line 45
called from D:\RootWebsites\www.NormansLiquors.com\cw4\cwapp\inc\cw-inc-pagestart.cfm: line 20
called from D:\RootWebsites\www.NormansLiquors.com\PageHeader.cfm: line 14
called from D:\RootWebsites\www.NormansLiquors.com\productlist.cfm: line 16
called from D:\RootWebsites\www.NormansLiquors.com\Utility\odi.cfc: line 93
Java Stacktrace lucee.runtime.exp.DatabaseException:
  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.TDSCommand.startResponse(IOBuffer.java:6106)
  at com.microsoft.sqlserver.jdbc.SQLServerConnection$1ConnectionCommand.doExecute(SQLServerConnection.java:1756)
  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.SQLServerConnection.connectionCommand(SQLServerConnection.java:1761)
  at com.microsoft.sqlserver.jdbc.SQLServerConnection.setMaxRows(SQLServerConnection.java:203)
  at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:742)
  at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:689)
  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.SQLServerStatement.execute(SQLServerStatement.java:662)
  at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:300)
  at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:263)
  at lucee.runtime.type.QueryImpl.(QueryImpl.java:218)
  at lucee.runtime.tag.Query.executeDatasoure(Query.java:834)
  at lucee.runtime.tag.Query.doEndTag(Query.java:594)
  at cw4.cwapp.func.cw_func_cart_cfm495$cf.udfCall2(/cw4/cwapp/func/cw-func-cart.cfm:1069)
  at cw4.cwapp.func.cw_func_cart_cfm495$cf.udfCall(/cw4/cwapp/func/cw-func-cart.cfm)
  at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:105)
  at lucee.runtime.type.UDFImpl._call(UDFImpl.java:337)
  at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:210)
  at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:781)
  at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:814)
  at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1614)
  at cw4.cwapp.mod.cw_mod_customerlinks_cfm450$cf.call(/cw4/cwapp/mod/cw-mod-customerlinks.cfm:47)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:918)
  at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:833)
  at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:828)
  at lucee.runtime.tag.CFTag.doInclude(CFTag.java:324)
  at lucee.runtime.tag.CFTag.cfmlStartTag(CFTag.java:246)
  at lucee.runtime.tag.CFTag.doStartTag(CFTag.java:178)
  at cw4.cwapp.inc.cw_inc_cartlinks_cfm450$cf.call(/cw4/cwapp/inc/cw-inc-cartlinks.cfm:45)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:918)
  at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:833)
  at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:828)
  at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:819)
  at cw4.cwapp.inc.cw_inc_pagestart_cfm450$cf.call(/cw4/cwapp/inc/cw-inc-pagestart.cfm:20)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:918)
  at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:833)
  at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:828)
  at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:819)
  at pageheader_cfm$cf.call(/PageHeader.cfm:14)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:918)
  at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:833)
  at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:828)
  at lucee.runtime.tag.CFTag.doInclude(CFTag.java:324)
  at lucee.runtime.tag.CFTag.cfmlStartTag(CFTag.java:246)
  at lucee.runtime.tag.CFTag.doStartTag(CFTag.java:178)
  at productlist_cfm$cf.call(/productlist.cfm:16)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:918)
  at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:833)
  at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:828)
  at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:819)
  at utility.odi_cfc$cf.udfCall1(/Utility/ODI.cfc:93)
  at utility.odi_cfc$cf.udfCall(/Utility/ODI.cfc)
  at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:105)
  at lucee.runtime.type.UDFImpl._call(UDFImpl.java:337)
  at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)
  at lucee.runtime.ComponentImpl._call(ComponentImpl.java:692)
  at lucee.runtime.ComponentImpl._call(ComponentImpl.java:575)
  at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1898)
  at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:422)
  at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:224)
  at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:43)
  at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2293)
  at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2284)
  at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2252)
  at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:891)
  at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:102)
  at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:62)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
  at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
  at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
  at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:108)
  at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
  at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
  at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
  at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
  at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349)
  at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:476)
  at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
  at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:802)
  at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1410)
  at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
  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)
 
Timestamp 11/19/17 4:56:09 PM EST