Error on Checkout -- checkout fails, requires App pool reset

[sfeher]

Running GOLD 7.0.8

Seems like every 48 hours, our site fails to process payments correctly.
Using Authorize.net and everything on the gateway is working, functional, correct, etc.

AbleCommerce Error Log (in Dashboard) shows the following:
(emphasis below is mine -- where I suspect the problem is)
An error has occured at https://www.domain.com/Checkout/Payment.aspx

Exception: Exception of type 'System.Web.HttpUnhandledException' was thrown. Stack Trace: at System.Web.UI.Page.HandleError(Exception e) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequest(HttpContext context) at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) Inner Exception: Value cannot be null. Parameter name: key Inner Exception Stack Trace: at CommerceBuilder.DomainModel.EntityWithTypedId`1.Save() at CommerceBuilder.Stores.StoreRepository.GetNextOrderNumber(Boolean increment) at CommerceBuilder.Services.Checkout.CheckoutService.ExecuteCheckout(CheckoutRequest checkoutRequest, Boolean validateBasket) at AbleCommerce.ConLib.Checkout.PaymentForms.CreditCardPaymentForm.CreditCardButton_Click(Object sender, EventArgs e) at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

To solve this issue, we find that merely resetting the application pool fixes the problem immediately.
So -- question is:
1.) Is there a known issue whereby the Checkout.aspx page stalls out like this?
2.) Does anyone else suffer from this issue?

As a temporary(?) fix, I've just scheduled my app pool to recycle every 12 hours in hopes that is enough.....
I don't recall seeing anything in the installation/config settings of AC to recommend any specific recycle times for the app pool, but thought maybe others had some ideas.

Thanks!

[mazhar]

Not sure about the cause. You seems to be running quite old build of gold. We improved GetNextOrderNumber method in R8 to avoid a case of duplicate number generation and concurrent access but that doesn't seems to be the case with error description you gave.

[Katie]

What is the exact version of AbleCommerce Gold are you using? This should be shown on the bottom of any Admin page.

Also, from the Store settings page, there are some Checkout options. One of them will keep retrying the order if the customer is unable to make a valid payment. Do you have this option enabled?

Configure > Store > General
>> Do not create order unless it has a successful payment.

I also found a related post here: viewtopic.php?f=65&t=17490&start=25

But without knowing which version you are using, I don't know if this applies.

Thanks
Katie

[sfeher]

Good morning, Katie --

AbleCommerce for ASP.NET
VERSION: 7.0.8.5731

My settings for the "Ignore Failed Payments" is not checked.....

I've had success over the weekend. The store remained 'open' and processing orders. I did have the App Pool scheduled to recycle every 30 minutes and, while that works, I fear that's merely a recovery model for the code problem. I'd like to fix the problem if we can, of course!

Thanks!
Steve

[Katie]

Hi Steve,

Do you recall applying the Gold R5 Service Patch?

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

I know it's hard to upgrade if you have customizations, but the Gold R5 build is over 2 years old now. Something to think about...

Thanks
Katie