unhandled exception error ProductDataSource.NarrowSearch
Posted: Fri Sep 18, 2009 10:27 pm
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)
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)