Server Error in '/' Application.

The SELECT permission was denied on the object 'adproduct', database 'bronze_br_adstore', schema 'br_adstore'.

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 'adproduct', database 'bronze_br_adstore', schema 'br_adstore'.

Source Error:


Line 75:             {
Line 76:                 case br_product_const_Class.enum_lookup_item_type.asin:
Line 77:                     return (from adp in Data_Context_Adstore.adproducts where adp.asin == slookup && adp.dateupdated >= olderthandiscard select adp).FirstOrDefault();
Line 78:                 case br_product_const_Class.enum_lookup_item_type.ean:
Line 79:                     return (from adp in Data_Context_Adstore.adproducts where adp.ean == slookup && adp.dateupdated >= olderthandiscard select adp).FirstOrDefault();

Source File: c:\inetpub\vhosts\chicago6.com\httpdocs\App_Code\Bronze\Database\Appl\Adstore\Linq\br_adproduct_Class.cs    Line: 77

Stack Trace:


[SqlException (0x80131904): The SELECT permission was denied on the object 'adproduct', database 'bronze_br_adstore', schema 'br_adstore'.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +3335264
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +334
   System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4679
   System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +89
   System.Data.SqlClient.SqlDataReader.get_MetaData() +101
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) +624
   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) +3392
   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) +725
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +84
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +312
   System.Data.Linq.SqlClient.SqlProvider.Execute(Expression query, QueryInfo queryInfo, IObjectReaderFactory factory, Object[] parentArgs, Object[] userArgs, ICompiledSubQuery[] subQueries, Object lastResult) +515
   System.Data.Linq.SqlClient.SqlProvider.ExecuteAll(Expression query, QueryInfo[] queryInfos, IObjectReaderFactory factory, Object[] userArguments, ICompiledSubQuery[] subQueries) +189
   System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression query) +428
   System.Data.Linq.DataQuery`1.System.Linq.IQueryProvider.Execute(Expression expression) +51
   Bronze.Database.Appl.Adstore.Linq.br_adproduct_Class.Get_Adproduct_From_Id(String slookup, enum_lookup_item_type lookuptype, DateTime olderthandiscard) in c:\inetpub\vhosts\chicago6.com\httpdocs\App_Code\Bronze\Database\Appl\Adstore\Linq\br_adproduct_Class.cs:77
   Bronze.Database.Appl.Adstore.Appl.br_adstore_appl_Class.Get_Adproduct_From_Id(String lookupitemid, enum_lookup_item_type lookupitemtype, DateTime olderthandiscard) in c:\inetpub\vhosts\chicago6.com\httpdocs\App_Code\Bronze\Database\Appl\Adstore\Appl\br_adstore_appl_Class.cs:50
   Bronze.Appl.Product.br_product_retrieve_Class.From_Storage_Get_Request_Lookup(br_product_retrieve_result_Class prr) in c:\inetpub\vhosts\chicago6.com\httpdocs\App_Code\Bronze\Appl\Product\br_product_retrieve_Class.cs:294
   Bronze.Appl.Product.br_product_retrieve_Class.From_Storage_Get_Request(br_product_retrieve_result_Class prr) in c:\inetpub\vhosts\chicago6.com\httpdocs\App_Code\Bronze\Appl\Product\br_product_retrieve_Class.cs:281
   Bronze.Appl.Product.br_product_retrieve_Class.Get_Request_Process_From_Storage_Date_New_Enough(List`1& listfromstorage, br_product_retrieve_result_Class prr, DateTime datehowoldgetfromapi) in c:\inetpub\vhosts\chicago6.com\httpdocs\App_Code\Bronze\Appl\Product\br_product_retrieve_Class.cs:546
   Bronze.Appl.Product.br_product_retrieve_Class.Get_Request_Process_From(br_product_retrieve_result_Class prr, Int32 numretries, Int32 whenfromstorage, DateTime datehowoldfromstoragenewenough) in c:\inetpub\vhosts\chicago6.com\httpdocs\App_Code\Bronze\Appl\Product\br_product_retrieve_Class.cs:455
   Bronze.Appl.Product.br_product_retrieve_Class.Get_Request_Process(br_product_retrieve_result_Class prr) in c:\inetpub\vhosts\chicago6.com\httpdocs\App_Code\Bronze\Appl\Product\br_product_retrieve_Class.cs:421
   Bronze.Appl.Product.br_product_retrieve_Class.Get_Request_Process(br_product_retrieve_result_Class& prr, String lookupitemid, enum_lookup_item_type lookupitemtype, String category, String keywords, String moreparameters) in c:\inetpub\vhosts\chicago6.com\httpdocs\App_Code\Bronze\Appl\Product\br_product_retrieve_Class.cs:400
   Bronze.Appl.Product.br_product_retrieve_Class.Get_Request_Lookup(br_product_retrieve_result_Class& prr, String lookupitemid, enum_lookup_item_type lookupitemtype) in c:\inetpub\vhosts\chicago6.com\httpdocs\App_Code\Bronze\Appl\Product\br_product_retrieve_Class.cs:374
   Bronze.Website.Webpage.Appl.Adstore.br_webpage_adstore_Class.Load_Lookup() in c:\inetpub\vhosts\chicago6.com\httpdocs\App_Code\Bronze\Website\Webpage\Appl\Adstore\br_webpage_adstore_Class.cs:803
   Bronze.Website.Webpage.Appl.Adstore.br_webpage_adstore_Class.Load() in c:\inetpub\vhosts\chicago6.com\httpdocs\App_Code\Bronze\Website\Webpage\Appl\Adstore\br_webpage_adstore_Class.cs:792
   Bronze.Website.Webpage.Appl.Adstore.br_webpage_adstore_Class.Show_Lookup_Items(br_product_item_list_Class list, Int32 howmany) in c:\inetpub\vhosts\chicago6.com\httpdocs\App_Code\Bronze\Website\Webpage\Appl\Adstore\br_webpage_adstore_Class.cs:1215
   Bronze.Website.Webpage.Appl.Adstore.br_webpage_adstore_Class.Show_Lookup(br_product_item_list_Class list, Int32 howmany) in c:\inetpub\vhosts\chicago6.com\httpdocs\App_Code\Bronze\Website\Webpage\Appl\Adstore\br_webpage_adstore_Class.cs:1201
   Bronze.Website.Webpage.Appl.Adstore.br_webpage_adstore_Class.Show_Lookup(Int32 howmany) in c:\inetpub\vhosts\chicago6.com\httpdocs\App_Code\Bronze\Website\Webpage\Appl\Adstore\br_webpage_adstore_Class.cs:1191
   Bronze.Website.Webpage.Appl.Adstore.br_webpage_adstore_Class.Show_Lookup() in c:\inetpub\vhosts\chicago6.com\httpdocs\App_Code\Bronze\Website\Webpage\Appl\Adstore\br_webpage_adstore_Class.cs:1181
   Bronze.Website.Webpage.Webcontrol.br_adstore_Control.Render_Lookup(HtmlTextWriter writer) in c:\inetpub\vhosts\chicago6.com\httpdocs\App_Code\Bronze\Website\Webpage\Webcontrol\br_adstore_Control.cs:255
   Bronze.Website.Webpage.Webcontrol.br_adstore_Control.RenderBeginTag(HtmlTextWriter writer) in c:\inetpub\vhosts\chicago6.com\httpdocs\App_Code\Bronze\Website\Webpage\Webcontrol\br_adstore_Control.cs:270
   System.Web.UI.WebControls.WebControl.Render(HtmlTextWriter writer) +31
   System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +80
   Bronze.Website.Page_br.br_composite_control_Class.Render_Control(HtmlTextWriter writer) in c:\inetpub\vhosts\chicago6.com\httpdocs\App_Code\Bronze\Website\Page_br\br_composite_control_Class.cs:97
   Bronze.Website.Page_br.br_composite_control_Class.RenderControl(HtmlTextWriter writer) in c:\inetpub\vhosts\chicago6.com\httpdocs\App_Code\Bronze\Website\Page_br\br_composite_control_Class.cs:108
   System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +169
   System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +80
   System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +169
   System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +80
   System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +169
   System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +80
   System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +169
   System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +80
   System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +169
   System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +80
   System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +169
   System.Web.UI.WebControls.WebControl.RenderContents(HtmlTextWriter writer) +15
   Bronze.Website.Webpage.Webcontrol.br_layout_Control.RenderContents(HtmlTextWriter writer) in c:\inetpub\vhosts\chicago6.com\httpdocs\App_Code\Bronze\Website\Webpage\Webcontrol\br_layout_Control.cs:1041
   System.Web.UI.WebControls.WebControl.Render(HtmlTextWriter writer) +50
   System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +80
   Bronze.Website.Page_br.br_composite_control_Class.Render_Control(HtmlTextWriter writer) in c:\inetpub\vhosts\chicago6.com\httpdocs\App_Code\Bronze\Website\Page_br\br_composite_control_Class.cs:97
   Bronze.Website.Page_br.br_composite_control_Class.RenderControl(HtmlTextWriter writer) in c:\inetpub\vhosts\chicago6.com\httpdocs\App_Code\Bronze\Website\Page_br\br_composite_control_Class.cs:108
   System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +169
   System.Web.UI.HtmlControls.HtmlForm.RenderChildren(HtmlTextWriter writer) +11662591
   Bronze.Website.Webpage.Webcontrol.br_form_Control.RenderChildren(HtmlTextWriter writer) in c:\inetpub\vhosts\chicago6.com\httpdocs\App_Code\Bronze\Website\Webpage\Webcontrol\br_form_Control.cs:50
   System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) +47
   System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +80
   System.Web.UI.HtmlControls.HtmlForm.RenderControl(HtmlTextWriter writer) +53
   ASP.v_v1_p_page_master_page_master_standard_base_master.__Render__control1(HtmlTextWriter __w, Control parameterContainer) in c:\inetpub\vhosts\chicago6.com\httpdocs\v\v1\p\page_master\page_master_standard_base.master:8
   System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +276
   System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +80
   System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +169
   System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +80
   System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +169
   System.Web.UI.Page.Render(HtmlTextWriter writer) +40
   Bronze.Website.Page_br.br_page_Class.Render(HtmlTextWriter writer) in c:\inetpub\vhosts\chicago6.com\httpdocs\App_Code\Bronze\Website\Page_br\br_page_Class.cs:975
   Bronze.Website.Webpage.Main.br_webpage_Class.Render(HtmlTextWriter writer) in c:\inetpub\vhosts\chicago6.com\httpdocs\App_Code\Bronze\Website\Webpage\Main\br_webpage_Class.cs:1582
   System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +80
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4239


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