Server Reboot - Have to manually restart application pool

[crazyjoe]

I am getting these more often now. I'm going to try sloDavid's fix. I'll let you know how I fare.

[crazyjoe]

The geniuses over at Applied Innovations figured out my problem. It was that I had a temp website running on my server that was created to install our SSL certificate. Removing the temp website has fixed me up nice (so far)

[crazyjoe]

Unfortunately my temp site removal did not fix my issue. I am continuing to be plagued by this. Twice last night and once this morning my site went down and we needed to manually reset my app pool. Does anyone have any more info I could give my hosts to try to fix me?

[mtrujillo86]

Not yet, I wish ablecommerce could identify this issue as a confirmed bug.

We have spent time and money trying to figure out the issue with no luck.

[crazyjoe]

I have been error free for a full week now (knock on wood). My hosts looked into my database to see if there was anything they could find that might be causing this. Here is what my hosts said they fixed in my database.

There were a couple tables that were owned to the schema of your user and not dbo. I reowned all objects to DBO and modified the SQL user to have use the DBO schema instead of the schema based on the username. I also increased the amount the database grows.

Hope this helps.

[jmestep]

We run across that issue occasionally when we get a site from another hoster and have to run a SQL script to update all to dbo.

[Logan Rhodehamel]

I am able to confirm a bug if the database is offline when AbleCommerce first starts up. Our HttpModule runs an initialization phase that will skip important parts if the connection cannot be opened. Even though the database comes back online later, initialization has already taken place and won't be run again unless the web application pool is bounced.

There is no quick workaround I can offer. We need to correct our HttpModule code and issue a patch.

[jmestep]

Good news- we'll keep watching for the patch

[crazyjoe]

I had gone almost 2 full weeks without this happening, but got it again last night. Twice last night and once this morning my site went down and needed to be have the Application Pool manually restarted to come back up. It's always this same error...

Server Error in '/' Application.

Object reference not set to an instance of an object.

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.NullReferenceException: Object reference not set to an instance of an object.

Source Error:

Line 30: {
Line 31:
Line 32: if (Token.Instance.User.IsInRole(Role.WebsiteAdminRoles))
Line 33: {
Line 34: //this.Page.InitComplete += new EventHandler(Page_InitComplete);

Source File: d:\Domains\MySite.com\wwwroot\Layouts\AdminPanel.ascx.cs Line: 32

Stack Trace:

[NullReferenceException: Object reference not set to an instance of an object.]
Layouts_AdminPanel.Page_Init(Object sender, EventArgs e) in d:\Domains\MySite.com\wwwroot\Layouts\AdminPanel.ascx.cs:32
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
System.Web.UI.Control.OnInit(EventArgs e) +99
System.Web.UI.UserControl.OnInit(EventArgs e) +77
System.Web.UI.Control.InitRecursive(Control namingContainer) +333
System.Web.UI.Control.InitRecursive(Control namingContainer) +210
System.Web.UI.Control.InitRecursive(Control namingContainer) +210
System.Web.UI.Control.InitRecursive(Control namingContainer) +210
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +378

Version Information: Microsoft .NET Framework Version:2.0.50727.3634; ASP.NET Version:2.0.50727.3634

I am desperate to get this fixed before the holidays.

Logan, can you give us any sort of time-frame for your patch? Is it this month, next month or is it a next year kind of thing? Also, is that the only thing I need to worry about, or is there a bigger issue that is causing the database to go offline that I need to correct? I can't imagine a reason why my DB would be offline at 10pm last night when this first happened. Any assistance is greatly appreciated. Thanks!

[Logan Rhodehamel]

Joe I think we are talking about this week sometime. The patched code is complete. My understanding is we are trying to sort out the pathway to publishing it.

[mtrujillo86]

Logan,

We have two in-house programmers as well as the open source code. If it's difficult to publish to your clients without open source code access, we are more than happy to receive the patch via email or some other way and implement it ourselves.

If not, i'll keep watching this thread for the patch link.

[Katie]

Good Morning,

A fix has been provided for this issue. Please go to this page in our help site for more information -

http://help.ablecommerce.com/index.htm# ... atches.htm

Thanks for everyone's efforts in troubleshooting this issue.

Katie

[kvij]

Can this patch be applied to version 7.0.5 too?

[kvij]

Can this patch CommerceBuilder.Sevices.dll from CommerceBuilder.Services.v7.6.14643 for Patch AC7-288 be applied to a 7.0.5 installation?

We do not wish to upgrade to 7.0.6 due to too much work involved.

[ForumsAdmin]

We haven't tried this but I think it may not work for 7.0.5.

[kvij]

Could you provide the source code for this patch, so we could compare and see if this could be applied to 7.0.5? Thanks

[ForumsAdmin]

The patch includes fixes in the licensing DLL for which the source is not made available.

[kvij]

The patch includes fixes in the licensing DLL for which the source is not made available.

So could you provide the code that we need to change in 7.0.5 to fix just this?

[kvij]

Or if you can please supply this patch for 7.0.5? Thanks

[kvij]

We'll have to spend weeks to upgrade to 7.0.6 just to apply this patch. Could you guys please spend 15 minutes and supply a patch for 7.0.5? It's only a single file. We don't have the source code for that file, or we could fix it on our end.

[dbreyley]

Is there a fix for this for Able Gold (build 5731)?

I had this issue affect our install last night. The SQL server restarted and the site was down until the App Pool was restarted.