Bug in Commerce Server Catalog procedure ctlg_GetFTSQuery

I was facing below issue with Commerce Catalog search and while debugging i found that it’s a bug in ctlg_GetFTSQuery procedure. To fix this issue i modifed

IF @IsVirtualCatalog = 1 or  @SQLClause < 1

to

IF @IsVirtualCatalog = 1 or Len( @SQLClause) < 1

    Inner Exception
    ---------------
    Type : System.Data.SqlClient.SqlException, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
    Message : Conversion failed when converting the nvarchar value '[DefinitionName] = 'PartNumberProduct' AND ([IsVisible] = 1 )' to data type int.
    Source : .Net SqlClient Data Provider
    Help link : 
    Errors : System.Data.SqlClient.SqlErrorCollection
    Class : 16
    LineNumber : 29
    Number : 245
    Procedure : ctlg_GetFTSQuery
    Server : 
    State : 1
Advertisements

About Rajan
I am Rajan Garg working as a Senior Software Engineer in a company. I am working on the Microsoft technologies.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: