[OverflowException: Value was either too large or too small for an unsigned byte.]
System.Convert.ToByte(Int16 value) +5912946
System.Int16.System.IConvertible.ToByte(IFormatProvider provider) +13
System.Convert.ToByte(Object value) +31
NHibernate.Type.ByteType.Get(IDataReader rs, Int32 index) +36
NHibernate.Type.NullableType.NullSafeGet(IDataReader rs, String name) +87
NHibernate.Type.NullableType.NullSafeGet(IDataReader rs, String[] names, ISessionImplementor session, Object owner) +21
NHibernate.Type.AbstractType.Hydrate(IDataReader rs, String[] names, ISessionImplementor session, Object owner) +19
NHibernate.Persister.Entity.AbstractEntityPersister.Hydrate(IDataReader rs, Object id, Object obj, ILoadable rootLoadable, String[][] suffixedPropertyColumns, Boolean allProperties, ISessionImplementor session) +970
NHibernate.Loader.Loader.LoadFromResultSet(IDataReader rs, Int32 i, Object obj, String instanceClass, EntityKey key, String rowIdAlias, LockMode lockMode, ILoadable rootPersister, ISessionImplementor session) +308
NHibernate.Loader.Loader.InstanceNotYetLoaded(IDataReader dr, Int32 i, ILoadable persister, EntityKey key, LockMode lockMode, String rowIdAlias, EntityKey optionalObjectKey, Object optionalObject, IList hydratedObjects, ISessionImplementor session) +139
NHibernate.Loader.Loader.GetRow(IDataReader rs, ILoadable[] persisters, EntityKey[] keys, Object optionalObject, EntityKey optionalObjectKey, LockMode[] lockModes, IList hydratedObjects, ISessionImplementor session) +298
NHibernate.Loader.Loader.GetRowFromResultSet(IDataReader resultSet, ISessionImplementor session, QueryParameters queryParameters, LockMode[] lockModeArray, EntityKey optionalObjectKey, IList hydratedObjects, EntityKey[] keys, Boolean returnProxies, IResultTransformer forcedResultTransformer) +150
NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies, IResultTransformer forcedResultTransformer) +1045
NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies, IResultTransformer forcedResultTransformer) +129
NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters, IResultTransformer forcedResultTransformer) +138
[GenericADOException: could not execute query
[ select game0_.ID as ID1_13_0_, players1_.ID as ID1_15_1_, player2_.ID as ID1_37_2_, game0_.AssociationID as Assoc3_13_0_, game0_.SeasonID as Seaso4_13_0_, game0_.GameVariationID as GameV5_13_0_, game0_.GameCalculationEngineID as GameC6_13_0_, game0_.Date as Date7_13_0_, game0_.HomeHandicap as HomeH8_13_0_, game0_.AwayHandicap as AwayH9_13_0_, game0_.HomeScore as Home10_13_0_, game0_.HomeWalkover as Home11_13_0_, game0_.AwayScore as Away12_13_0_, game0_.AwayWalkover as Away13_13_0_, game0_.Completed as Comp14_13_0_, game0_.GameStatusID as Game15_13_0_, game0_.HomeResultTypeID as Home16_13_0_, game0_.AwayResultTypeID as Away17_13_0_, game0_.VenueTypeID as Venu18_13_0_, game0_.AuditDate as Audi19_13_0_, game0_.AuditPrincipalID as Audi20_13_0_, game0_.PitchID as Pitc21_13_0_, game0_.GameFormatID as GameF2_13_0_, players1_.ResultTypeID as Resul3_15_1_, players1_.GameID as GameI4_15_1_, players1_.PlayerID as Playe5_15_1_, players1_.SideID as SideI2_15_1_, players1_.GameID as GameI4_15_0__, players1_.ID as ID1_15_0__, player2_.Forename as Foren2_37_2_, player2_.Surname as Surna3_37_2_, player2_.GenderID as Gende4_37_2_, player2_.RegistrationID as Regis5_37_2_, player2_.AlternativeRegistrationID as Alter6_37_2_, player2_.Internal as Inter7_37_2_, player2_.AuditDate as Audit8_37_2_, player2_.AuditPrincipalID as Audit9_37_2_ from [Game] game0_ left outer join [GameXPlayer] players1_ on game0_.ID=players1_.GameID left outer join [Player] player2_ on players1_.PlayerID=player2_.ID where (game0_.ID in (select teammatchp3_.GameID from [TeamMatchPlayers] teammatchp3_ where teammatchp3_.PlayerID=@p0)) and game0_.Completed=1 and game0_.Date>=@p1 and game0_.Date<=@p2 ]
Name:p1 - Value:5 Name:p2 - Value:20/04/2021 23:59:59 Name:p3 - Value:20/04/2024 23:59:59
[SQL: select game0_.ID as ID1_13_0_, players1_.ID as ID1_15_1_, player2_.ID as ID1_37_2_, game0_.AssociationID as Assoc3_13_0_, game0_.SeasonID as Seaso4_13_0_, game0_.GameVariationID as GameV5_13_0_, game0_.GameCalculationEngineID as GameC6_13_0_, game0_.Date as Date7_13_0_, game0_.HomeHandicap as HomeH8_13_0_, game0_.AwayHandicap as AwayH9_13_0_, game0_.HomeScore as Home10_13_0_, game0_.HomeWalkover as Home11_13_0_, game0_.AwayScore as Away12_13_0_, game0_.AwayWalkover as Away13_13_0_, game0_.Completed as Comp14_13_0_, game0_.GameStatusID as Game15_13_0_, game0_.HomeResultTypeID as Home16_13_0_, game0_.AwayResultTypeID as Away17_13_0_, game0_.VenueTypeID as Venu18_13_0_, game0_.AuditDate as Audi19_13_0_, game0_.AuditPrincipalID as Audi20_13_0_, game0_.PitchID as Pitc21_13_0_, game0_.GameFormatID as GameF2_13_0_, players1_.ResultTypeID as Resul3_15_1_, players1_.GameID as GameI4_15_1_, players1_.PlayerID as Playe5_15_1_, players1_.SideID as SideI2_15_1_, players1_.GameID as GameI4_15_0__, players1_.ID as ID1_15_0__, player2_.Forename as Foren2_37_2_, player2_.Surname as Surna3_37_2_, player2_.GenderID as Gende4_37_2_, player2_.RegistrationID as Regis5_37_2_, player2_.AlternativeRegistrationID as Alter6_37_2_, player2_.Internal as Inter7_37_2_, player2_.AuditDate as Audit8_37_2_, player2_.AuditPrincipalID as Audit9_37_2_ from [Game] game0_ left outer join [GameXPlayer] players1_ on game0_.ID=players1_.GameID left outer join [Player] player2_ on players1_.PlayerID=player2_.ID where (game0_.ID in (select teammatchp3_.GameID from [TeamMatchPlayers] teammatchp3_ where teammatchp3_.PlayerID=@p0)) and game0_.Completed=1 and game0_.Date>=@p1 and game0_.Date<=@p2]]
NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters, IResultTransformer forcedResultTransformer) +225
NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) +20
NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces, IType[] resultTypes) +76
NHibernate.Loader.Hql.QueryLoader.List(ISessionImplementor session, QueryParameters queryParameters) +51
NHibernate.Hql.Ast.ANTLR.QueryTranslatorImpl.List(ISessionImplementor session, QueryParameters queryParameters) +244
NHibernate.Engine.Query.HQLQueryPlan.PerformList(QueryParameters queryParameters, ISessionImplementor session, IList results) +382
NHibernate.Impl.SessionImpl.List(IQueryExpression queryExpression, QueryParameters queryParameters, IList results) +389
NHibernate.Impl.AbstractSessionImpl.List(IQueryExpression queryExpression, QueryParameters parameters) +144
NHibernate.Impl.AbstractQueryImpl2.List() +117
NHibernate.Linq.DefaultQueryProvider.ExecuteQuery(NhLinqExpression nhLinqExpression, IQuery query, NhLinqExpression nhQuery) +36
NHibernate.Linq.DefaultQueryProvider.Execute(Expression expression) +52
NHibernate.Linq.DefaultQueryProvider.Execute(Expression expression) +37
Remotion.Linq.QueryableBase`1.GetEnumerator() +53
System.Collections.Generic.List`1..ctor(IEnumerable`1 collection) +174
System.Linq.Enumerable.ToList(IEnumerable`1 source) +61
Com.BinaryBracket.BowlsResults.DataAccess.GameRepository.GetAllByPlayerAndDateRange(Int32 playerID, DateTime start, DateTime end) in C:\BinaryBracket\development\bowlsresults\Platform\Source\DataAccess\GameRepository.cs:180
Com.BinaryBracket.BowlsResults.Business.Retrieval.Actions.PlayerSummaryAction.PopulateBestWorst(CareerPlayerAssociationStatisticDto response, Int32 playerID, IEnumerable`1 associationIDs) in C:\BinaryBracket\development\bowlsresults\Platform\Source\OriginalBusiness\Retrieval\Actions\PlayerSummaryAction.cs:77
Com.BinaryBracket.BowlsResults.Business.Retrieval.Actions.PlayerSummaryAction.Execute(Int32 playerID, Int32 pageSize) in C:\BinaryBracket\development\bowlsresults\Platform\Source\OriginalBusiness\Retrieval\Actions\PlayerSummaryAction.cs:55
Com.BinaryBracket.BowlsResults.Business.Retrieval.RetrievalManager.GetPlayerSummary(Int32 playerID) in C:\BinaryBracket\development\bowlsresults\Platform\Source\OriginalBusiness\Retrieval\RetrievalManager.cs:394
Com.BinaryBracket.BowlsResults.Web.RetrievalService.Statistics.PageServlets.StatisticsPageServlet.GetPlayerSummary(Int32 playerID) in C:\BinaryBracket\development\bowlsresults\Web\Source\RetrievalService\Statistics\PageServlets\StatisticsPageServlet.cs:152
[TargetInvocationException: Exception has been thrown by the target of an invocation.]
Com.BinaryBracket.Servlets.ServletHandler.InvokeServletMethod() in C:\BinaryBracket\development\core\Source\Servlets\ServletHandler.cs:344
Com.BinaryBracket.Servlets.ServletHandler.GetServletMethodResponseXml() in C:\BinaryBracket\development\core\Source\Servlets\ServletHandler.cs:468
Com.BinaryBracket.Servlets.ServletHandler.ExecuteMethod() in C:\BinaryBracket\development\core\Source\Servlets\ServletHandler.cs:392
Com.BinaryBracket.Servlets.ServletHandler.ExecuteRequest() in C:\BinaryBracket\development\core\Source\Servlets\ServletHandler.cs:109
Com.BinaryBracket.Servlets.ServletHandler.ProcessRequest() in C:\BinaryBracket\development\core\Source\Servlets\ServletHandler.cs:93
Com.BinaryBracket.Servlets.PageServletHandler.ProcessPageRequest(ServletContext context, String pageUri) in C:\BinaryBracket\development\core\Source\Servlets\PageServletHandler.cs:70
Com.BinaryBracket.Servlets.PageServletHandler.ProcessRequest(HttpContext context) in C:\BinaryBracket\development\core\Source\Servlets\PageServletHandler.cs:56
System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +195
System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) +50
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +73
|