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

Code: Select all

<compilation debug="false" 
and turn on the debug

Code: Select all

<compilation debug="true" 
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.