Page 1 of 1
Install error
Posted: Wed Feb 18, 2009 11:22 am
by jdarby
After the install script creates the database and proceeds to configure2.aspx, i receive the following error instead of configure2.aspx:
Code: Select all
Server Error in '/store' Application.
SELECT permission denied on object 'ac_Stores', database 'hahsstore', 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: SELECT permission denied on object 'ac_Stores', database 'hahsstore', 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): SELECT permission denied on object 'ac_Stores', database 'hahsstore', schema 'dbo'.]
CommerceBuilder.Common.Token.get_Instance() +463
CommerceBuilder.Stores.AuditEventDataSource.CountForStore() +9
CommerceBuilder.Services.AbleCommerceHttpModule.Init(HttpApplication context) +230
System.Web.HttpApplication.InitModulesCommon() +66
System.Web.HttpApplication.InitInternal(HttpContext context, HttpApplicationState state, MethodInfo[] handlers) +814
System.Web.HttpApplicationFactory.GetNormalApplicationInstance(HttpContext context) +243
System.Web.HttpApplicationFactory.GetApplicationInstance(HttpContext context) +106
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +340
Version Information: Microsoft .NET Framework Version:2.0.50727.832; ASP.NET Version:2.0.50727.832
Re: Install error
Posted: Wed Feb 18, 2009 11:32 am
by mazhar
sounds like some user rights problem. Verify that user have proper rights.
http://help.ablecommerce.com/installati ... sp.net.htm
Re: Install error
Posted: Wed Feb 18, 2009 11:37 am
by jdarby
looks like i had brainfart and didn't set the SQL permissions correctly. all good!
Re: Install error
Posted: Wed Feb 18, 2009 11:43 am
by mazhar
sounds great

Re: Install error
Posted: Wed Feb 18, 2009 11:52 am
by jdarby
Ok, i just did a fresh install of 7.0 and i am upgrading to 7.0.2. When I'm at upgrade.aspx and initiate the database upgrade, the following error displays:
Code: Select all
Server Error in '/' Application.
Server cannot set status after HTTP headers have been sent.
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.Web.HttpException: Server cannot set status after HTTP headers have been sent.
Source Error:
The source code that generated this unhandled exception can only be shown when compiled in debug mode. To enable this, please follow one of the below steps, then request the URL:
1. Add a "Debug=true" directive at the top of the file that generated the error. Example:
<%@ Page Language="C#" Debug="true" %>
or:
2) Add the following section to the configuration file of your application:
<configuration>
<system.web>
<compilation debug="true"/>
</system.web>
</configuration>
Note that this second technique will cause all files within a given application to be compiled in debug mode. The first technique will cause only that particular file to be compiled in debug mode.
Important: Running applications in debug mode does incur a memory/performance overhead. You should make sure that an application has debugging disabled before deploying into production scenario.
Stack Trace:
[HttpException (0x80004005): Server cannot set status after HTTP headers have been sent.]
System.Web.HttpResponse.set_StatusCode(Int32 value) +3296761
System.Web.HttpResponse.set_Status(String value) +185
CommerceBuilder.Configuration.b.a() +1271
CommerceBuilder.Configuration.TokenBase.get_Database() +14
Install_Upgrade.RunSqlScript(String dbScriptFile, List`1 errorList) +95
Install_Upgrade.UpgradeButton_Click(Object sender, EventArgs e) +434
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +105
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +107
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102
Re: Install error
Posted: Wed Feb 18, 2009 11:55 am
by mazhar
Edit your web.config file and locate the following line of code
and turn on the debug
Now it will list the detail error.
Re: Install error
Posted: Wed Feb 18, 2009 11:59 am
by jdarby
ok, done. here is what now displays:
Code: Select all
Server Error in '/' Application.
Server cannot set status after HTTP headers have been sent.
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.Web.HttpException: Server cannot set status after HTTP headers have been sent.
Source Error:
Line 129: //SETUP DATABASE CONNECTION
Line 130: int errorCount = 0;
Line 131: Database database = Token.Instance.Database;
Line 132: //LOOP THE COMANDS AND RUN ON DB
Line 133: foreach (string sql in commands)
Source File: d:\Inetpub\Www_root\HAHSDev\Install\Upgrade.aspx.cs Line: 131
Stack Trace:
[HttpException (0x80004005): Server cannot set status after HTTP headers have been sent.]
System.Web.HttpResponse.set_StatusCode(Int32 value) +3296761
System.Web.HttpResponse.set_Status(String value) +185
CommerceBuilder.Configuration.b.a() +1271
CommerceBuilder.Configuration.TokenBase.get_Database() +14
Install_Upgrade.RunSqlScript(String dbScriptFile, List`1 errorList) in d:\Inetpub\Www_root\HAHSDev\Install\Upgrade.aspx.cs:131
Install_Upgrade.UpgradeButton_Click(Object sender, EventArgs e) in d:\Inetpub\Www_root\HAHSDev\Install\Upgrade.aspx.cs:71
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +105
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +107
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102
Version Information: Microsoft .NET Framework Version:2.0.50727.832; ASP.NET Version:2.0.50727.832
Re: Install error
Posted: Wed Feb 18, 2009 12:15 pm
by mazhar
That's strange. Haven't any prior knowledge of this. Have a look at this thread
http://blogs.msdn.com/webtopics/
Re: Install error
Posted: Wed Feb 18, 2009 12:16 pm
by jdarby
This is only happening during the upgrade to 7.0.2. The install of 7.0 worked fine.