Please help ... AC7 crash / sql error
Posted: Thu Aug 20, 2009 11:24 am
Platform: Win 2k3 server, MSSQL 2000, separate servers
Originally installed AC7 RC3 on a dev webserver with local ip=public ip. Dev license was for public ip. Everything worked fine. Customized it quite a bit ($$). Accessed the site, admin via public ip.
Later (after an attack), we added a Juniper firewall, changed public ip addresses of all the servers to a local subnet, and pointed the public ip to local ip in the dns.
Our existing 5 year old CF site (uses same sql server as AC7) works fine after the aforementioned changes. Therefore network is setup correctly, firewall policies setup correctly, etc.
However AC7 crashed with the sql timeout error page. Cannot get any page to open - always stops at the error shown below.
Best regards
Phil
888-522-3472
Originally installed AC7 RC3 on a dev webserver with local ip=public ip. Dev license was for public ip. Everything worked fine. Customized it quite a bit ($$). Accessed the site, admin via public ip.
Later (after an attack), we added a Juniper firewall, changed public ip addresses of all the servers to a local subnet, and pointed the public ip to local ip in the dns.
Our existing 5 year old CF site (uses same sql server as AC7) works fine after the aforementioned changes. Therefore network is setup correctly, firewall policies setup correctly, etc.
However AC7 crashed with the sql timeout error page. Cannot get any page to open - always stops at the error shown below.
Please help. This forum is my only recourse. If I can't get this fixed I'll end up paying the boss the cost of AC7 so he can shop for another solution. I had recommended AC7.Server Error in '/' Application.
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
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: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
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): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.]
CommerceBuilder.Common.Token.get_Instance() +463
CommerceBuilder.Stores.AuditEventDataSource.CountForStore() +9
CommerceBuilder.Services.AbleCommerceHttpModule.Init(HttpApplication context) +230
System.Web.HttpApplication.InitModules() +267
System.Web.HttpApplication.InitInternal(HttpContext context, HttpApplicationState state, MethodInfo[] handlers) +1251
System.Web.HttpApplicationFactory.GetNormalApplicationInstance(HttpContext context) +243
System.Web.HttpApplicationFactory.GetApplicationInstance(HttpContext context) +106
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +214
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42
Best regards
Phil
888-522-3472