unhandled exception error ProductDataSource.NarrowSearch

[acuser777]

I'm having hard time figuring out this error i just started having couple of hours ago...
basically, when i click on any of the category on the left of default page, it give me error. I click on product search link, i still get the error. however, default page have some featured items, click on any of those does go through and shows the product just find.
I've a test copy of ablecommerce running on my machine and this one works just fine (this copy is also linked to same database).
i copied few of associated file aspx and c# files to production from my test copy. but production still gives error.
there are no modifications done on any of these pages. please see errors below and advice what could be wrong...

error through categorysearch.aspx

ERROR 2009-09-18 22:11:11,116 52018ms Object a - An error has occured at http://www.localhost.com/CategorySearch.aspx?CategoryId=15
System.Web.HttpUnhandledException: Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.NullReferenceException: Object reference not set to an instance of an object.
at CommerceBuilder.Common.LSDecimal.ToString(String format)
at CommerceBuilder.Common.LSDecimal.ToString(String format, IFormatProvider provider)
at System.Text.StringBuilder.AppendFormat(IFormatProvider provider, String format, Object[] args)
at System.String.Format(IFormatProvider provider, String format, Object[] args)
at CommerceBuilder.Products.ProductDataSource.NarrowSearch(String keyword, Int32 categoryId, Int32 manufacturerId, LSDecimal lowPrice, LSDecimal highPrice, Int32 maximumRows, Int32 startRowIndex, String sortExpression)
at ConLib_CategoryGridPage.BindProductList() in d:\WebSites\HALLOWEEN\ConLib\CategoryGridPage.ascx.cs:line 261
at ConLib_CategoryGridPage.BindSearchResultsPanel() in d:\WebSites\HALLOWEEN\ConLib\CategoryGridPage.ascx.cs:line 236
at ConLib_CategoryGridPage.BindPage() in d:\WebSites\HALLOWEEN\ConLib\CategoryGridPage.ascx.cs:line 113
at ConLib_CategoryGridPage.Page_Load(Object sender, EventArgs e) in d:\WebSites\HALLOWEEN\ConLib\CategoryGridPage.ascx.cs:line 183
at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)
at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
--- End of inner exception stack trace ---
at System.Web.UI.Page.HandleError(Exception e)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest()
at System.Web.UI.Page.ProcessRequest(HttpContext context)
at ASP.categorysearch_aspx.ProcessRequest(HttpContext context) in c:\WINDOWS\Microsoft.NET\Framework64\v2.0.50727\Temporary ASP.NET Files\root\8b777c4c\91a9ba78\App_Web_ujufaqyw.9.cs:line 0
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)



error through search.aspx error...

ERROR 2009-09-18 22:13:08,691 169593ms Object a - An error has occured at http://www.localhost.com/Search.aspx
System.Web.HttpUnhandledException: Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.NullReferenceException: Object reference not set to an instance of an object.
at CommerceBuilder.Common.LSDecimal.ToString(String format)
at CommerceBuilder.Common.LSDecimal.ToString(String format, IFormatProvider provider)
at System.Text.StringBuilder.AppendFormat(IFormatProvider provider, String format, Object[] args)
at System.String.Format(IFormatProvider provider, String format, Object[] args)
at CommerceBuilder.Products.ProductDataSource.NarrowSearch(String keyword, Int32 categoryId, Int32 manufacturerId, LSDecimal lowPrice, LSDecimal highPrice, Int32 maximumRows, Int32 startRowIndex, String sortExpression)
at ConLib_SearchPage.BindProductList() in d:\WebSites\HALLOWEEN\ConLib\SearchPage.ascx.cs:line 165
at ConLib_SearchPage.BindSearchResultsPanel() in d:\WebSites\HALLOWEEN\ConLib\SearchPage.ascx.cs:line 128
at ConLib_SearchPage.Page_Load(Object sender, EventArgs e) in d:\WebSites\HALLOWEEN\ConLib\SearchPage.ascx.cs:line 86
at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)
at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
--- End of inner exception stack trace ---
at System.Web.UI.Page.HandleError(Exception e)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest()
at System.Web.UI.Page.ProcessRequest(HttpContext context)
at ASP.search_aspx.ProcessRequest(HttpContext context) in c:\WINDOWS\Microsoft.NET\Framework64\v2.0.50727\Temporary ASP.NET Files\root\8b777c4c\91a9ba78\App_Web_ujufaqyw.17.cs:line 0
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

[AbleMods]

The search code works fine by in the standard install. Have you made modifications to the search page(s)?

[acuser777]

No, there are no modifications...

[acuser777]

exception is being raised by this function in commercebuilder - CommerceBuilder.Products.ProductDataSource.NarrowSearch(...) and looks like exception is raised while formatting some string....


at CommerceBuilder.Common.LSDecimal.ToString(String format)
at CommerceBuilder.Common.LSDecimal.ToString(String format, IFormatProvider provider)
at System.Text.StringBuilder.AppendFormat(IFormatProvider provider, String format, Object[] args)
at System.String.Format(IFormatProvider provider, String format, Object[] args)
at CommerceBuilder.Products.ProductDataSource.NarrowSearch(String keyword, Int32 categoryId, Int32 manufacturerId, LSDecimal lowPrice, LSDecimal highPrice, Int32 maximumRows, Int32 startRowIndex, String sortExpression)

i'm using ac 7.03 commercebulider.dll build 12912

[acuser777]

ok. I reverted commercebuilder.dll back to build 12624. it works now.

AbleCommerce mods - please advice what is the resolution to this issue... why i'm getting issues with new build??

thanks

[jmestep]

I just put the 12912 dll in my test site and am not getting the error. Try checking each of the components of the search page against the install where 12912 works- sidebars, headers, etc.