Search Failed
When using the Search functionality with the Starter Site I am generating an error. I have added a custom property to the Product List - which works fine when I go through the built in navigation. I have also added the property in the propertiesToReturn parameter of web.config. So, I don't think the problem lies there as well as the error seems to state some type of join error. I have included the message from the Event Viewer below.
Please Advise
Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1309
Date: 11/27/2006
Time: 10:23:19 AM
User: N/A
Computer: SHUTTLE
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 11/27/2006 10:23:19 AM
Event time (UTC): 11/27/2006 3:23:19 PM
Event ID: b8aaba4b533944efb552a1bcdfac7f2f
Event sequence: 23
Event occurrence: 1
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/1/Root/DEPOTB2B-2-128091145639429336
Trust level: Full
Application Virtual Path: /DEPOTB2B
Application Path: C:\Inetpub\wwwroot\DEPOTB2B\
Machine name: SHUTTLE
Process information:
Process ID: 240
Process name: w3wp.exe
Account name: XCELSOFTWARE\CSRunTimeUser
Exception information:
Exception type: CatalogDatabaseException
Exception message: Search failed.
Request information:
Request URL:https://192.168.1.72/DEPOTB2B/Search.aspx
Request path: /DEPOTB2B/Search.aspx
User host address: 192.168.1.122
User:jdipilato@xcelsoftware.com
Is authenticated: True
Authentication Type: Forms
Thread account name: XCELSOFTWARE\CSRunTimeUser
Thread information:
Thread ID: 12
Thread account name: XCELSOFTWARE\CSRunTimeUser
Is impersonating: False
Stack trace: at Microsoft.CommerceServer.Catalog.Internal.CommonHelpers.Search(CatalogExecutionContext executionContext, StringCollection catalogsToSearchCollection, String sqlClause, String ftsPhrase, String advancedFtsPhrase, String language, CatalogSearchOptions searchOptions, InventoryOptions inventoryOptions, JoinTableInformation joinTableInformation, String categoryClause, Boolean recursive, Int32& totalRecords, Boolean returnTotalRecords)
at Microsoft.CommerceServer.Catalog.Internal.CommonHelpers.Search(CatalogExecutionContext executionContext, StringCollection catalogsToSearchCollection, String sqlClause, String ftsPhrase, String advancedFtsPhrase, String language, CatalogSearchOptions searchOptions, InventoryOptions inventoryOptions, JoinTableInformation joinTableInformation, String categoryClause, Boolean recursive, Int32& totalRecords)
at Microsoft.CommerceServer.Catalog.Internal.CatalogContext.Search(CatalogExecutionContext catalogExecutionContext, StringCollection catalogsToSearch, String sqlClause, String ftsPhrase, String advancedFtsPhrase, String language, CatalogSearchOptions searchOptions, InventoryOptions inventoryOptions, JoinTableInformation joinTableInformation, String categoryClause, Boolean recursive, Int32& totalRecords)
at Microsoft.CommerceServer.Catalog.Internal.CatalogSearch.Search(Int32& totalRecords, Boolean returnTotalRecords)
at Microsoft.CommerceServer.Catalog.Internal.CatalogServerContextBase.SearchWithCount(CatalogSearchParameters catalogSearchParameters, CatalogSearchOptions searchOptions, InventoryOptions inventoryOptions, JoinTableInformation joinTableInformation, Int32& totalRecords)
at Microsoft.CommerceServer.Catalog.CatalogSearch.Search(Int32& totalRecords)
at CommerceComponents.FreeTextSearchDataSource.ExecuteSearch(Int32& totalRecords)
at CommerceComponents.CatalogDataSource.CatalogSearchDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments)
at System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback)
at System.Web.UI.WebControls.DataBoundControl.PerformSelect()
at System.Web.UI.WebControls.BaseDataBoundControl.DataBind()
at System.Web.UI.WebControls.GridView.DataBind()
at System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound()
at System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls()
at System.Web.UI.Control.EnsureChildControls()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
Custom event details:
For more information, see Help and Support Center athttp://go.microsoft.com/fwlink/events.asp.
