The SELECT permission was denied on the object 'Season', database 'iombowls_results', schema 'dbo'.

Server Error in '/' Application.

The SELECT permission was denied on the object 'Season', database 'iombowls_results', schema 'dbo'.

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.Data.SqlClient.SqlException: The SELECT permission was denied on the object 'Season', database 'iombowls_results', schema 'dbo'.

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:


[SqlException (0x80131904): The SELECT permission was denied on the object 'Season', database 'iombowls_results', schema 'dbo'.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +2586154
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +6039974
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +297
   System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4477
   System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +59
   System.Data.SqlClient.SqlDataReader.get_MetaData() +91
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) +446
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) +2698
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) +1611
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +65
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +251
   System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +43
   System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() +14
   NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd) +298
   NHibernate.Loader.Loader.GetResultSet(IDbCommand st, Boolean autoDiscoverTypes, Boolean callable, RowSelection selection, ISessionImplementor session) +240
   NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies, IResultTransformer forcedResultTransformer) +450
   NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies, IResultTransformer forcedResultTransformer) +129
   NHibernate.Loader.Loader.LoadEntity(ISessionImplementor session, Object id, IType identifierType, Object optionalObject, String optionalEntityName, Object optionalIdentifier, IEntityPersister persister) +260

[GenericADOException: could not load an entity: [Com.BinaryBracket.BowlsResults.Data.Competition#965][SQL: SELECT competitio0_.ID as ID1_8_4_, competitio0_.AuditDate as AuditD2_8_4_, competitio0_.AuditPrincipalID as AuditP3_8_4_, competitio0_.CompetitionOrganiserID as Compet4_8_4_, competitio0_.CompetitionScopeID as Compet5_8_4_, competitio0_.CompetitionFormatID as Compet6_8_4_, competitio0_.AgeGroupID as AgeGro7_8_4_, competitio0_.GenderID as Gender8_8_4_, competitio0_.AssociationID as Associ9_8_4_, competitio0_.Name as Name10_8_4_, competitio0_.Sponsor as Spons11_8_4_, competitio0_.StartDate as Start12_8_4_, competitio0_.EndDate as EndDa13_8_4_, competitio0_.PlayerMeritTableCalculationEngineID as Playe14_8_4_, competitio0_.CompetitionHeaderID as Compe15_8_4_, competitio0_.OrganisingClubID as Organ16_8_4_, competitio0_.VenueClubID as Venue17_8_4_, competitio0_.SeasonID as Seaso18_8_4_, competitio1_.ID as ID1_7_0_, competitio1_.Name as Name2_7_0_, competitio1_.AssociationID as Associ3_7_0_, competitio1_.ShortName as ShortN4_7_0_, competitio1_.Priority as Priori5_7_0_, club2_.ID as ID1_1_1_, club2_.Name as Name2_1_1_, club2_.AssociationID as Associ3_1_1_, club2_.AuditDate as AuditD4_1_1_, club2_.AuditPrincipalID as AuditP5_1_1_, club2_.PitchID as PitchI6_1_1_, club3_.ID as ID1_1_2_, club3_.Name as Name2_1_2_, club3_.AssociationID as Associ3_1_2_, club3_.AuditDate as AuditD4_1_2_, club3_.AuditPrincipalID as AuditP5_1_2_, club3_.PitchID as PitchI6_1_2_, season4_.ID as ID1_53_3_, season4_.StartDate as Start2_53_3_, season4_.EndDate as EndDa3_53_3_, season4_.DisplayName as Displ4_53_3_ FROM [Competition] competitio0_ left outer join [CompetitionHeader] competitio1_ on competitio0_.CompetitionHeaderID=competitio1_.ID left outer join [Club] club2_ on competitio0_.OrganisingClubID=club2_.ID left outer join [Club] club3_ on competitio0_.VenueClubID=club3_.ID left outer join [Season] season4_ on competitio0_.SeasonID=season4_.ID WHERE competitio0_.ID=?]]
   NHibernate.Loader.Loader.LoadEntity(ISessionImplementor session, Object id, IType identifierType, Object optionalObject, String optionalEntityName, Object optionalIdentifier, IEntityPersister persister) +392
   NHibernate.Loader.Entity.AbstractEntityLoader.Load(ISessionImplementor session, Object id, Object optionalObject, Object optionalId) +49
   NHibernate.Loader.Entity.AbstractEntityLoader.Load(Object id, Object optionalObject, ISessionImplementor session) +18
   NHibernate.Persister.Entity.AbstractEntityPersister.Load(Object id, Object optionalObject, LockMode lockMode, ISessionImplementor session) +103
   NHibernate.Event.Default.DefaultLoadEventListener.LoadFromDatasource(LoadEvent event, IEntityPersister persister, EntityKey keyToLoad, LoadType options) +136
   NHibernate.Event.Default.DefaultLoadEventListener.DoLoad(LoadEvent event, IEntityPersister persister, EntityKey keyToLoad, LoadType options) +470
   NHibernate.Event.Default.DefaultLoadEventListener.Load(LoadEvent event, IEntityPersister persister, EntityKey keyToLoad, LoadType options) +93
   NHibernate.Event.Default.DefaultLoadEventListener.ProxyOrLoad(LoadEvent event, IEntityPersister persister, EntityKey keyToLoad, LoadType options) +270
   NHibernate.Event.Default.DefaultLoadEventListener.OnLoad(LoadEvent event, LoadType loadType) +366
   NHibernate.Impl.SessionImpl.FireLoad(LoadEvent event, LoadType loadType) +319
   NHibernate.Impl.SessionImpl.Get(String entityName, Object id) +344
   NHibernate.Impl.SessionImpl.Get(Type entityClass, Object id) +288
   NHibernate.Impl.SessionImpl.Get(Object id) +322
   Com.BinaryBracket.BowlsResults.DataAccess.Provider.DataAccessProvider.SessionGet(Object id) in C:\BinaryBracket\Repos\platform-v1\Platform\Source\DataAccess\Provider\DataAccessProvider.cs:49
   Com.BinaryBracket.BowlsResults.DataAccess.BaseIdentityRepository`2.Get(TIdentifierField id) in C:\BinaryBracket\Repos\platform-v1\Platform\Source\DataAccess\BaseIdentityRepository.cs:28
   Com.BinaryBracket.BowlsResults.DataAccess.CompetitionRepository.Get(Int16 id) in C:\BinaryBracket\Repos\platform-v1\Platform\Source\DataAccess\CompetitionRepository.cs:20
   Com.BinaryBracket.BowlsResults.Business.Retrieval.Queries.GetCompetitionSummaryQuery.Get(Int32 competitionID) in C:\BinaryBracket\Repos\platform-v1\Platform\Source\OriginalBusiness\Retrieval\Queries\GetCompetitionSummaryQuery.cs:16
   Com.BinaryBracket.BowlsResults.Business.Retrieval.RetrievalManager.GetCompetitionSummary(Int32 competitionID) in C:\BinaryBracket\Repos\platform-v1\Platform\Source\OriginalBusiness\Retrieval\RetrievalManager.cs:477
   Com.BinaryBracket.BowlsResults.Business.Retrieval.Assemblers.Statistics.CareerPlayerCompetitionStatisticDetailDtoAssembler.ToDto(CareerPlayerStatistic data, IRetrievalManager manager) in C:\BinaryBracket\Repos\platform-v1\Platform\Source\OriginalBusiness\Retrieval\Assemblers\Statistics\CareerPlayerCompetitionStatisticDetailDtoAssembler.cs:18
   Com.BinaryBracket.BowlsResults.Business.Retrieval.Assemblers.Statistics.<>c__DisplayClass0_0.<ToDtoList>b__0(CareerPlayerStatistic data) in C:\BinaryBracket\Repos\platform-v1\Platform\Source\OriginalBusiness\Retrieval\Assemblers\Statistics\CareerPlayerCompetitionStatisticDetailDtoAssembler.cs:11
   System.Linq.WhereSelectEnumerableIterator`2.MoveNext() +167
   System.Collections.Generic.List`1..ctor(IEnumerable`1 collection) +246
   System.Linq.Enumerable.ToList(IEnumerable`1 source) +61
   Com.BinaryBracket.BowlsResults.Business.Retrieval.Assemblers.Statistics.CareerPlayerCompetitionStatisticDetailDtoAssembler.ToDtoList(IEnumerable`1 list, IRetrievalManager manager) in C:\BinaryBracket\Repos\platform-v1\Platform\Source\OriginalBusiness\Retrieval\Assemblers\Statistics\CareerPlayerCompetitionStatisticDetailDtoAssembler.cs:11
   Com.BinaryBracket.BowlsResults.Business.Retrieval.Assemblers.Statistics.CareerPlayerStatisticSummaryDtoAssembler.Assemble(IRetrievalManager manager, IEnumerable`1 list, PlayerDto playerDto) in C:\BinaryBracket\Repos\platform-v1\Platform\Source\OriginalBusiness\Retrieval\Assemblers\Statistics\CareerPlayerStatisticSummaryDtoAssembler.cs:31
   Com.BinaryBracket.BowlsResults.Business.Retrieval.Queries.CareerPlayerStatisticQuery.GetByAssociations(Int32 playerID, IEnumerable`1 associationIDs) in C:\BinaryBracket\Repos\platform-v1\Platform\Source\OriginalBusiness\Retrieval\Queries\CareerPlayerStatisticQuery.cs:32
   Com.BinaryBracket.BowlsResults.Business.Retrieval.RetrievalManager.GetCareerPlayerStatistic(Int32 playerID, IEnumerable`1 associationIDs) in C:\BinaryBracket\Repos\platform-v1\Platform\Source\OriginalBusiness\Retrieval\RetrievalManager.cs:297
   Com.BinaryBracket.BowlsResults.Business.Retrieval.Actions.PlayerSummaryAction.Execute(Int32 playerID, Int32 pageSize) in C:\BinaryBracket\Repos\platform-v1\Platform\Source\OriginalBusiness\Retrieval\Actions\PlayerSummaryAction.cs:48
   Com.BinaryBracket.BowlsResults.Web.RetrievalService.Statistics.PageServlets.StatisticsPageServlet.GetPlayerSummary(Int32 playerID) in C:\BinaryBracket\Repos\platform-v1\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\Repos\core\Source\Servlets\ServletHandler.cs:344
   Com.BinaryBracket.Servlets.ServletHandler.GetServletMethodResponseXml() in C:\BinaryBracket\Repos\core\Source\Servlets\ServletHandler.cs:468
   Com.BinaryBracket.Servlets.ServletHandler.ExecuteMethod() in C:\BinaryBracket\Repos\core\Source\Servlets\ServletHandler.cs:392
   Com.BinaryBracket.Servlets.ServletHandler.ExecuteRequest() in C:\BinaryBracket\Repos\core\Source\Servlets\ServletHandler.cs:109
   Com.BinaryBracket.Servlets.ServletHandler.ProcessRequest() in C:\BinaryBracket\Repos\core\Source\Servlets\ServletHandler.cs:93
   Com.BinaryBracket.Servlets.PageServletHandler.ProcessPageRequest(ServletContext context, String pageUri) in C:\BinaryBracket\Repos\core\Source\Servlets\PageServletHandler.cs:70
   Com.BinaryBracket.Servlets.PageServletHandler.ProcessRequest(HttpContext context) in C:\BinaryBracket\Repos\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

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