System.IndexOutOfRangeException
: 
CultureId

NHibernate.Exceptions.GenericADOException: could not execute query
[ 
WITH EntityList ([EntityID], [OwnerEntityId], [EntityTypeId], [Entity], [Level])
AS
(
    SELECT	e.EntityID as Id, e.OwnerEntityId, EntityTypeId, e.Entity, 1 as [Level] 
    FROM	[fn_UserStoresByBrand](@p0, DEFAULT) e

UNION ALL

    SELECT e.EntityID as Id, e.OwnerEntityId, e.EntityTypeId, e.Entity, [Level] + 1
    FROM	tbEntity e
    JOIN	EntityList el on el.OwnerEntityId = e.EntityId
    WHERE	e.EntityTypeID >= @p1 
    AND		[Level] < 4
)
SELECT DISTINCT e.EntityId
              , e.Entity
              , e.OwnerEntityId
              , e.EntityTypeId
              , coalesce(e.Timezone, s.TimeZone, '') as TimeZone
              , coalesce(e.TimeZoneOffsetHours, s.TimeZoneOffsetHours, null) as TimeZoneOffsetHours
              , e.[Status]
              , l.Title as CultureName
              , e.CalendarId
              , e.Currency
              , e.LiveStatusId
              , e.StoreNumber
              , e.City
              , e.State
			  , e.ShortDateFormat
			  , e.LongDateFormat
              , e.CanZeroSuggestedQty
              , e.CanEditBuildTo
FROM EntityList
INNER JOIN tbEntity e ON EntityList.EntityID = e.EntityID
INNER JOIN tbSystem s ON 1 = 1
INNER JOIN tbLocalisation l ON (l.LocalisationID = e.CultureID 
            -- OR If no Culture (i.e. 0 or NULL) then use Culture from tbSystem
            OR ((e.CultureID = 0 OR e.CultureID IS NULL) AND l.LocalisationID = s.CultureId))  ]
  Name:userId - Value:883626  Name:entityTypeId - Value:4
[SQL: 
WITH EntityList ([EntityID], [OwnerEntityId], [EntityTypeId], [Entity], [Level])
AS
(
    SELECT	e.EntityID as Id, e.OwnerEntityId, EntityTypeId, e.Entity, 1 as [Level] 
    FROM	[fn_UserStoresByBrand](@p0, DEFAULT) e

UNION ALL

    SELECT e.EntityID as Id, e.OwnerEntityId, e.EntityTypeId, e.Entity, [Level] + 1
    FROM	tbEntity e
    JOIN	EntityList el on el.OwnerEntityId = e.EntityId
    WHERE	e.EntityTypeID >= @p1 
    AND		[Level] < 4
)
SELECT DISTINCT e.EntityId
              , e.Entity
              , e.OwnerEntityId
              , e.EntityTypeId
              , coalesce(e.Timezone, s.TimeZone, '') as TimeZone
              , coalesce(e.TimeZoneOffsetHours, s.TimeZoneOffsetHours, null) as TimeZoneOffsetHours
              , e.[Status]
              , l.Title as CultureName
              , e.CalendarId
              , e.Currency
              , e.LiveStatusId
              , e.StoreNumber
              , e.City
              , e.State
			  , e.ShortDateFormat
			  , e.LongDateFormat
              , e.CanZeroSuggestedQty
              , e.CanEditBuildTo
FROM EntityList
INNER JOIN tbEntity e ON EntityList.EntityID = e.EntityID
INNER JOIN tbSystem s ON 1 = 1
INNER JOIN tbLocalisation l ON (l.LocalisationID = e.CultureID 
            -- OR If no Culture (i.e. 0 or NULL) then use Culture from tbSystem
            OR ((e.CultureID = 0 OR e.CultureID IS NULL) AND l.LocalisationID = s.CultureId)) ] ---> System.IndexOutOfRangeException: CultureId
   at System.Data.ProviderBase.FieldNameLookup.GetOrdinal(String fieldName)
   at System.Data.SqlClient.SqlDataReader.GetOrdinal(String name)
   at NHibernate.Type.NullableType.NullSafeGet(DbDataReader rs, String name, ISessionImplementor session)
   at NHibernate.Persister.Entity.AbstractEntityPersister.Hydrate(DbDataReader rs, Object id, Object obj, ILoadable rootLoadable, String[][] suffixedPropertyColumns, Boolean allProperties, ISessionImplementor session)
   at NHibernate.Loader.Loader.LoadFromResultSet(DbDataReader rs, Int32 i, Object obj, String instanceClass, EntityKey key, LockMode lockMode, ILoadable rootPersister, ISessionImplementor session)
   at NHibernate.Loader.Loader.InstanceNotYetLoaded(DbDataReader dr, Int32 i, ILoadable persister, EntityKey key, LockMode lockMode, EntityKey optionalObjectKey, Object optionalObject, IList hydratedObjects, ISessionImplementor session)
   at NHibernate.Loader.Loader.GetRow(DbDataReader rs, ILoadable[] persisters, EntityKey[] keys, Object optionalObject, EntityKey optionalObjectKey, LockMode[] lockModes, IList hydratedObjects, ISessionImplementor session, Boolean mustLoadMissingEntity)
   at NHibernate.Loader.Loader.GetRowFromResultSet(DbDataReader resultSet, ISessionImplementor session, QueryParameters queryParameters, LockMode[] lockModeArray, EntityKey optionalObjectKey, IList hydratedObjects, EntityKey[] keys, Boolean returnProxies, IResultTransformer forcedResultTransformer)
   at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies, IResultTransformer forcedResultTransformer)
   at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies, IResultTransformer forcedResultTransformer)
   at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters, IResultTransformer forcedResultTransformer)
   --- End of inner exception stack trace ---
   at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters, IResultTransformer forcedResultTransformer)
   at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters)
   at NHibernate.Impl.SessionImpl.ListCustomQuery(ICustomQuery customQuery, QueryParameters queryParameters, IList results)
   at NHibernate.Impl.AbstractSessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters, IList results)
   at NHibernate.Impl.AbstractSessionImpl.List[T](NativeSQLQuerySpecification spec, QueryParameters queryParameters)
   at NHibernate.Impl.SqlQueryImpl.List[T]()
   at Mx.Administration.Services.QueryServices.EntityQueryService.GetEntitiesHierarchyForUser(Int64 userId, Int64 entityTypeId)
   at Mx.Web.UI.Areas.Core.Api.EntityController.GetEntitiesByEntityType(EntityType entityTypeId)
   at lambda_method(Closure , Object , Object[] )
   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass10.<GetExecutor>b__9(Object instance, Object[] methodParameters)
   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ExecuteAsync(HttpControllerContext controllerContext, IDictionary`2 arguments, CancellationToken cancellationToken)
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Controllers.ApiControllerActionInvoker.<InvokeActionAsyncCore>d__0.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Filters.ActionFilterAttribute.<ExecuteActionFilterAsyncCore>d__0.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Filters.ActionFilterAttribute.<ExecuteActionFilterAsyncCore>d__0.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d__2.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Filters.AuthorizationFilterAttribute.<ExecuteAuthorizationFilterAsyncCore>d__2.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Filters.AuthorizationFilterAttribute.<ExecuteAuthorizationFilterAsyncCore>d__2.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Controllers.ExceptionFilterResult.<ExecuteAsync>d__0.MoveNext()