I'm having a problem with the CatalogWebService. When I try to create
a discount with the discount manager, I get that the discount was not
created because " " does not exist in the system.

The error says something like "Execution of a full-text operation
failed. A clause of the query contained only ignored words." in the
event viewer. I don't have any ignored words, I enabled all the fields
of the ProductCatalog table in the FullText Index.

Any thoughts?
Jason

Here is the error in the event viewer:

An exception occurred in the 'CatalogWebService' Web service.
Exception details follow:

Microsoft.CommerceServer.SearchException: Search failed. --->
System.Data.SqlClient.SqlException: Execution of a full-text operation
failed. A clause of the query contained only ignored words.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
behavior)
at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(Com
mandBehavior
behavior)
at System.Data.Common.DbDataAdapter.FillFromCommand(Object data,
Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand
command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String
srcTable)
at Microsoft.CatalogServer.Internal.SqlHelper.ExecuteDataset(SqlConnection
connection, CommandType commandType, String commandText,
CatalogDataSetType catalogDataSetType, SqlParameter[]
commandParameters, String outParameterName, Object& outParameterValue)
at Microsoft.CatalogServer.Internal.SqlHelper.ExecuteDataset(String
connectionString, CommandType commandType, String commandText,
SqlParameter[] commandParameters, CatalogDataSetType
catalogDataSetType, String outParameterName, Object&
outParameterValue)
at Microsoft.CatalogServer.Internal.SqlHelper.ExecuteDataset(String
connectionString, String spName, Object[] parameterValues,
CatalogDataSetType catalogDataSetType, String outParameterName,
Object& outParameterValue)
at Microsoft.CatalogServer.Internal.SqlHelper.ExecuteDataset(CatalogExecutio
nContext
catalogExecutionContext, String spName, Object[] parameterValues,
CatalogDataSetType catalogDataSetType, String outParameterName,
Object& outParameterValue)
at Microsoft.CatalogServer.Internal.CommonHelpers.Search(CatalogExecutionCon
text
catalogExecutionContext, StringCollection catalogsToSearchCollection,
String sqlClause, String ftsPhrase, String language,
CatalogSearchOptions searchOptions, JoinTableInformation
joinTableInformation, Int32& totalRecords, Boolean returnTotalRecords)
--- End of inner exception stack trace ---
at Microsoft.CatalogServer.Internal.CommonHelpers.Search(CatalogExecutionCon
text
catalogExecutionContext, StringCollection catalogsToSearchCollection,
String sqlClause, String ftsPhrase, String language,
CatalogSearchOptions searchOptions, JoinTableInformation
joinTableInformation, Int32& totalRecords, Boolean returnTotalRecords)
at Microsoft.CatalogServer.Internal.CommonHelpers.Search(CatalogExecutionCon
text
catalogExecutionContext, StringCollection catalogsToSearchCollection,
String sqlClause, String ftsPhrase, String language,
CatalogSearchOptions searchOptions, JoinTableInformation
joinTableInformation)
at Microsoft.CatalogServer.Internal.CatalogContext.Search(CatalogExecutionCo
ntext
catalogExecutionContext, StringCollection catalogsToSearch, String
sqlClause, String ftsPhrase, String language, CatalogSearchOptions
searchOptions, JoinTableInformation joinTableInformation)
at Microsoft.CatalogServer.Admin.CatalogContext.Search(CatalogExecutionConte
xt
catalogExecutionContext, StringCollection catalogsToSearch, String
sqlClause, String ftsPhrase, String language, CatalogSearchOptions
searchOptions, JoinTableInformation joinTableInformation)
at Microsoft.CatalogServer.Runtime.CatalogSearch.Search(Int32&
totalRecords, Boolean returnTotalRecords)
at Microsoft.CatalogServer.Runtime.CatalogSearch.Search()
at Microsoft.CatalogServer.WebService.CatalogWebService.Search(CatalogSearch
Parameters
catalogSearchParameters, CatalogSearchOptions searchOptions)

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.

[ Post a follow-up to this message ]

Can you give more information about the repro steps for this issue?  Which
options were selected during the Wizard operation?

Also, are you sure you're on the final version of FP1 (not the beta)?

SQL Server does report this error any time your query contains only ignored
works (like 'a' or 'and').  In the final release of FP1 we give a better
user experience when the user tries this.  The user should never see the
exception directly.

-djm
--
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2004 Microsoft Corporation.  All rights
reserved.

--------------------
From: jasonsirota@gmail.com (Jason Sirota)
Newsgroups: microsoft.public.commerceserver.general
Subject: Error in CatalogWebService when creating Discount
Date: 11 Jun 2004 11:08:38 -0700
Organization: http://groups.google.com
Lines: 83
Message-ID: <12e66dac.0406111008.504ac617@posting.google.com>
NNTP-Posting-Host: 216.103.134.129
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1086977319 6512 127.0.0.1 (11 Jun 2004 18:08:39
GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 11 Jun 2004 18:08:39 +0000 (UTC)
Path:
cpmsftngxa10.phx.gbl!TK2MSFTFEED01.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.s
ul.t-online.de!t-online.de!fr.ip.ndsoftware.net!proxad.net!postnews1.google.
com!not-for-mail
Xref: cpmsftngxa10.phx.gbl microsoft.public.commerceserver.general:13976
X-Tomcat-NG: microsoft.public.commerceserver.general

I'm having a problem with the CatalogWebService. When I try to create
a discount with the discount manager, I get that the discount was not
created because " " does not exist in the system.

The error says something like "Execution of a full-text operation
failed. A clause of the query contained only ignored words." in the
event viewer. I don't have any ignored words, I enabled all the fields
of the ProductCatalog table in the FullText Index.

Any thoughts?
Jason

Here is the error in the event viewer:

An exception occurred in the 'CatalogWebService' Web service.
Exception details follow:

Microsoft.CommerceServer.SearchException: Search failed. --->
System.Data.SqlClient.SqlException: Execution of a full-text operation
failed. A clause of the query contained only ignored words.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
behavior)
at
System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(Comman
dBehavior
behavior)
at System.Data.Common.DbDataAdapter.FillFromCommand(Object data,
Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand
command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String
srcTable)
at
Microsoft.CatalogServer.Internal.SqlHelper.ExecuteDataset(SqlConnection
connection, CommandType commandType, String commandText,
CatalogDataSetType catalogDataSetType, SqlParameter[]
commandParameters, String outParameterName, Object& outParameterValue)
at Microsoft.CatalogServer.Internal.SqlHelper.ExecuteDataset(String
connectionString, CommandType commandType, String commandText,
SqlParameter[] commandParameters, CatalogDataSetType
catalogDataSetType, String outParameterName, Object&
outParameterValue)
at Microsoft.CatalogServer.Internal.SqlHelper.ExecuteDataset(String
connectionString, String spName, Object[] parameterValues,
CatalogDataSetType catalogDataSetType, String outParameterName,
Object& outParameterValue)
at
Microsoft.CatalogServer.Internal.SqlHelper.ExecuteDataset(CatalogExecutionCo
ntext
catalogExecutionContext, String spName, Object[] parameterValues,
CatalogDataSetType catalogDataSetType, String outParameterName,
Object& outParameterValue)
at
Microsoft.CatalogServer.Internal.CommonHelpers.Search(CatalogExecutionContex
t
catalogExecutionContext, StringCollection catalogsToSearchCollection,
String sqlClause, String ftsPhrase, String language,
CatalogSearchOptions searchOptions, JoinTableInformation
joinTableInformation, Int32& totalRecords, Boolean returnTotalRecords)
--- End of inner exception stack trace ---
at
Microsoft.CatalogServer.Internal.CommonHelpers.Search(CatalogExecutionContex
t
catalogExecutionContext, StringCollection catalogsToSearchCollection,
String sqlClause, String ftsPhrase, String language,
CatalogSearchOptions searchOptions, JoinTableInformation
joinTableInformation, Int32& totalRecords, Boolean returnTotalRecords)
at
Microsoft.CatalogServer.Internal.CommonHelpers.Search(CatalogExecutionContex
t
catalogExecutionContext, StringCollection catalogsToSearchCollection,
String sqlClause, String ftsPhrase, String language,
CatalogSearchOptions searchOptions, JoinTableInformation
joinTableInformation)
at
Microsoft.CatalogServer.Internal.CatalogContext.Search(CatalogExecutionConte
xt
catalogExecutionContext, StringCollection catalogsToSearch, String
sqlClause, String ftsPhrase, String language, CatalogSearchOptions
searchOptions, JoinTableInformation joinTableInformation)
at
Microsoft.CatalogServer.Admin.CatalogContext.Search(CatalogExecutionContext
catalogExecutionContext, StringCollection catalogsToSearch, String
sqlClause, String ftsPhrase, String language, CatalogSearchOptions
searchOptions, JoinTableInformation joinTableInformation)
at Microsoft.CatalogServer.Runtime.CatalogSearch.Search(Int32&
totalRecords, Boolean returnTotalRecords)
at Microsoft.CatalogServer.Runtime.CatalogSearch.Search()
at
Microsoft.CatalogServer.WebService.CatalogWebService.Search(CatalogSearchPar
ameters
catalogSearchParameters, CatalogSearchOptions searchOptions)

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.

[ Post a follow-up to this message ]