Thread: Monthly Maintence Question

I am running version 8.0.1.2 and receive the following error when trying to run the Monthly Maint option on our test server. (trying to clean up the data before moving the site to live next week) Any advice on how to correct this error would be very helpful.

Error:

Code:

Server Error in '/' Application.
--------------------------------------------------------------------------------

Cannot find the object "CustomerSession" because it does not exist or you do not have permissions. 
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: Cannot find the object "CustomerSession" because it does not exist or you do not have permissions.

Source Error: 


Line 126:                                   DB.CreateSQLParameter("@PurgeDeletedRecords", SqlDbType.TinyInt, 1, CommonLogic.IIF(PurgeDeletedRecords.Checked, 1, 0), ParameterDirection.Input)
Line 127:                                };
Line 128:            DB.ExecuteStoredProcInt("dbo.aspdnsf_MonthlyMaintenance", spa);
Line 129:
Line 130:            if (SaveSettings.Checked)
 

Source File: d:\WebRoot\ASPDNSF_v2-74\Web\Admin\monthlymaintenance.aspx.cs    Line: 128 

Stack Trace: 


[SqlException (0x80131904): Cannot find the object "CustomerSession" because it does not exist or you do not have permissions.]
   AspDotNetStorefrontCore.DB.ExecuteStoredProcInt(String StoredProcName, SqlParameter[] spa) +354
   AspDotNetStorefrontAdmin.monthlymaintenance.GOButton_Click(Object sender, EventArgs e) in d:\WebRoot\ASPDNSF_v2-74\Web\Admin\monthlymaintenance.aspx.cs:128
   System.Web.UI.WebControls.Button.OnClick(EventArgs e) +111
   System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +110
   System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565

 


--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.3082; ASP.NET Version:2.0.50727.3082

This is due to a permissions issue with the user you are using in your web.config file to connect to your database, or a schema issue because your tables do not belong to dbo, or your database is missing the table completely (which in this case I don't think is occurring because there would be other issues on the site as well).

Thank you. fixed it and worked like a charm. was a permission issue.

Does this user need Sysadmin level in order to do Monthly Maintenance?

Regards,

You'll need dbowner

that did it. Thank you.