Lucee 5.1.0.34 Error (database)
Message
Detail An error has occurred during the full-text query. Common causes include: word-breaking errors or timeout, FDHOST permissions/ACL issues, service account missing privileges, malfunctioning IFilters, communication channel issues with FDHost and sqlservr.exe, etc.
SQL declare @CatID int set @CatID=62
declare @SubID int set @SubID=101
declare @KW nvarchar(255) set @KW='%'
select * from (
select Head_ID,Field_Name,Field_Descrip,Field_Seq,max(Field_Money) as Field_Money,Field_Value
, count(distinct link_id) as ProdCount
from cwMod_CustomFields_Head (nolock)
inner join cwMod_CustomFields_Detail (nolock) on Head_ID=cwMod_CustomFields_Head.ID
where link_table='cw_products'
and (not Field_Hidden=1)
and Field_Value > ''
and (Field_Type not in ('int','numeric','money') or Field_Money > 0)
and Link_ID in (select Product_ID from cw_products where product_on_web=1 and not product_archive=1

and (@CatId=0 or exists (select product2category_product_id from cw_product_categories_primary (nolock) where product2category_category_id=@CatID and product2category_product_id=Link_ID))
and (@SubID=0 or exists (select product2secondary_product_id from cw_product_categories_secondary (nolock) where product2secondary_secondary_id=@SubID and product2secondary_product_id=Link_ID))
and (@KW='%' or FreeText((product_name,product_keywords),@KW))
)
group by Field_Seq,Field_Name,Head_ID,Field_Descrip,Field_Value
) a
order by Field_Seq,Field_Name,ProdCount desc,Field_Money,Field_Value
DatabaseName Microsoft SQL Server
DatabaseVersion 11.00.2100
DriverName Microsoft JDBC Driver 4.0 for SQL Server
DriverVersion 4.0.2206.100
Datasource NormansLiquors
Stacktrace The Error Occurred in
D:\RootWebsites\www.NormansLiquors.com\PageHeader.cfm: line 215
213: ) a
214: order by Field_Seq,Field_Name,ProdCount desc,Field_Money,Field_Value
215: </cfquery>
216: <cfset AltPfx="">
217: <cfif request.cwpage.categoryID gt 0><cfset AltPfx &="&Category=#request.cwpage.categoryID#"></cfif>

called from D:\RootWebsites\www.NormansLiquors.com\product.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.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
  at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)
  at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404)
  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 lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:308)
  at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:272)
  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 pageheader_cfm$cf.call(/PageHeader.cfm:215)
  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 product_cfm$cf.call(/product.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 10/22/17 11:34:59 AM EDT