Server Error in '/' Application.

SearchTerm

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.IndexOutOfRangeException: SearchTerm

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[IndexOutOfRangeException: SearchTerm]
   System.Data.ProviderBase.FieldNameLookup.GetOrdinal(String fieldName) +2158731
   System.Data.SqlClient.SqlDataReader.GetOrdinal(String name) +141
   NHibernate.Type.NullableType.NullSafeGet(IDataReader rs, String name) +57
   NHibernate.Persister.Entity.AbstractEntityPersister.Hydrate(IDataReader rs, Object id, Object obj, ILoadable rootLoadable, String[][] suffixedPropertyColumns, Boolean allProperties, ISessionImplementor session) +1340
   NHibernate.Loader.Loader.LoadFromResultSet(IDataReader rs, Int32 i, Object obj, String instanceClass, EntityKey key, String rowIdAlias, LockMode lockMode, ILoadable rootPersister, ISessionImplementor session) +533
   NHibernate.Loader.Loader.InstanceNotYetLoaded(IDataReader dr, Int32 i, ILoadable persister, EntityKey key, LockMode lockMode, String rowIdAlias, EntityKey optionalObjectKey, Object optionalObject, IList hydratedObjects, ISessionImplementor session) +245
   NHibernate.Loader.Loader.GetRow(IDataReader rs, ILoadable[] persisters, EntityKey[] keys, Object optionalObject, EntityKey optionalObjectKey, LockMode[] lockModes, IList hydratedObjects, ISessionImplementor session) +631
   NHibernate.Loader.Loader.GetRowFromResultSet(IDataReader resultSet, ISessionImplementor session, QueryParameters queryParameters, LockMode[] lockModeArray, EntityKey optionalObjectKey, IList hydratedObjects, EntityKey[] keys, Boolean returnProxies) +405
   NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) +1346
   NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) +217
   NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) +160

[GenericADOException: could not execute query
[ select top 6 t.*  from csc_product t  inner join csc_ProductPrice pp on pp.ProductID=t.ProductID where  pp.PriceGroupID=@p0  AND  t.productcode in (select p.productcode from csc_Product p  inner join csc_ProductParent cs on cs.ProductID=p.ProductID inner join csc_CategoryRelation cr on cr.CategoryID=cs.CategoryID  where p.Status & 2 = 0 and ((cs.CategoryID=@p1 AND cr.SeniorityID='00000000-0000-0000-0000-000000000000') OR cr.SeniorityID=@p1)) order by t.DisplayOrder DESC,  t.ProductCode ASC ]
  Name:CategoryID - Value:4d934c65-d504-49a4-9b98-41d6a30ea281  Name:PriceGroupID - Value:eb06341f-3602-4054-b38a-d5bf676baebc
[SQL: select top 6 t.*  from csc_product t  inner join csc_ProductPrice pp on pp.ProductID=t.ProductID where  pp.PriceGroupID=@p0  AND  t.productcode in (select p.productcode from csc_Product p  inner join csc_ProductParent cs on cs.ProductID=p.ProductID inner join csc_CategoryRelation cr on cr.CategoryID=cs.CategoryID  where p.Status & 2 = 0 and ((cs.CategoryID=@p1 AND cr.SeniorityID='00000000-0000-0000-0000-000000000000') OR cr.SeniorityID=@p1)) order by t.DisplayOrder DESC,  t.ProductCode ASC]]
   NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) +497
   NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) +23
   NHibernate.Impl.SessionImpl.ListCustomQuery(ICustomQuery customQuery, QueryParameters queryParameters, IList results) +265
   NHibernate.Impl.SessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters, IList results) +177
   NHibernate.Impl.SessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters) +177
   NHibernate.Impl.SqlQueryImpl.List() +213
   CyberEcom.CSC.Business.ProductManager.GetProducts(Category category, Boolean includeSubCategories, IList`1 displayValues, PriceRange range, SiteUser user, Manufacturer manufacturer, ProductOrderBy orderBy, Int32 pageIndex, Int32 pageSize, Int32 maxResult, Int32& count, Nullable`1 includeHidden) in D:\CyberStore\Sybott.ESW\src\CyberEcom.CSC.Business\Product\ProductManager.cs:3701
   Controls_Product_ProductInCategory.Page_Load(Object sender, EventArgs e) +1568
   System.Web.UI.Control.OnLoad(EventArgs e) +108
   System.Web.UI.Control.LoadRecursive() +90
   System.Web.UI.Control.LoadRecursive() +185
   System.Web.UI.Control.LoadRecursive() +185
   System.Web.UI.Control.LoadRecursive() +185
   System.Web.UI.Control.LoadRecursive() +185
   System.Web.UI.Control.LoadRecursive() +185
   System.Web.UI.Control.LoadRecursive() +185
   System.Web.UI.Control.LoadRecursive() +185
   System.Web.UI.Control.LoadRecursive() +185
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1533


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.8.4700.0