logo
Welcome to our new AbleCommerce forums. As a guest, you may view the information here. To post to this forum, you must have a registered account with us, either as a new user evaluating AbleCommerce or an existing user of the application. For all questions related to the older version of Gold and earlier, please go to AbleCommerce Gold forum. Please use your AbleCommerce username and password to Login. New Registrations are disabled.

Notification

Icon
Error

Options
Go to last post Go to first unread
ray22901031  
#1 Posted : Monday, October 11, 2021 10:52:11 AM(UTC)
ray22901031

Rank: Advanced Member

Groups: Authorized User, Developers
Joined: 2/17/2019(UTC)
Posts: 826

Thanks: 3 times
Was thanked: 13 time(s) in 13 post(s)
We are trying to process some test orders before launching, now all of a sudden the system will not process test orders, the only thing that has been changed is that certain payment types were deleted.

Using version 9.0.4


Below is the error message I'm getting regardless if I defer payment, or pick a check. - Would appreciate any assistance.

An error has occured at https://mrm01/Admin/Orders/_MailPaymentForm View less
Exception: Transaction not connected, or was disconnected Stack Trace: at NHibernate.Transaction.AdoTransaction.CheckNotZombied() at NHibernate.Transaction.AdoTransaction.Rollback() at CommerceBuilder.Common.DatabaseSessionManager.RollbackTransaction() at CommerceBuilder.Services.Checkout.CheckoutService.ExecuteCheckout(CheckoutRequest checkoutRequest, Boolean validateBasket, Boolean triggerEvents) at CommerceBuilder.Services.Checkout.CheckoutScope.Checkout(Boolean validateBasket, Boolean triggerEvents) at AbleCommerce.Areas.Admin.Controllers.OrdersController._MailPaymentForm(MailPaymentFormModel model) in D:\Users\Ray\Documents\Visual Studio Projects\01-Projects\Able-RFL-9.0.4-b-101121\Website\Areas\Admin\Controllers\OrdersController.cs:line 3068 at lambda_method(Closure , ControllerBase , Object[] ) at System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters) at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters) at System.Web.Mvc.Async.AsyncControllerActionInvoker.b__39(IAsyncResult asyncResult, ActionInvocation innerInvokeState) at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult`2.CallEndDelegate(IAsyncResult asyncResult) at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethod(IAsyncResult asyncResult) at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.b__3d() at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass46.b__3f() at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethodWithFilters(IAsyncResult asyncResult) at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass21.<>c__DisplayClass2b.b__1c() at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass21.b__1e(IAsyncResult asyncResult) at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeAction(IAsyncResult asyncResult) at System.Web.Mvc.Controller.b__1d(IAsyncResult asyncResult, ExecuteCoreState innerState) at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult) at System.Web.Mvc.Controller.EndExecuteCore(IAsyncResult asyncResult) at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult) at System.Web.Mvc.Controller.EndExecute(IAsyncResult asyncResult) at System.Web.Mvc.MvcHandler.b__5(IAsyncResult asyncResult, ProcessRequestState innerState) at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult) at System.Web.Mvc.MvcHandler.EndProcessRequest(IAsyncResult asyncResult) at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

Many Thanks

Wanna join the discussion?! Login to your AbleCommerce Forums forum account. New Registrations are disabled.

ray22901031  
#2 Posted : Monday, October 11, 2021 10:57:51 AM(UTC)
ray22901031

Rank: Advanced Member

Groups: Authorized User, Developers
Joined: 2/17/2019(UTC)
Posts: 826

Thanks: 3 times
Was thanked: 13 time(s) in 13 post(s)
Yes, we did delete the mail payment type because it was asking for routing and checking information that customers will not fill in. We created a new pay by mail form based on phone.

Is this the same problem we had before, where you delete a specific payment type and the system explodes?
ray22901031  
#3 Posted : Monday, October 11, 2021 2:25:50 PM(UTC)
ray22901031

Rank: Advanced Member

Groups: Authorized User, Developers
Joined: 2/17/2019(UTC)
Posts: 826

Thanks: 3 times
Was thanked: 13 time(s) in 13 post(s)
Support,

Any help you can give us on this problem we would appreciate, we are still down and cannot process orders. We were able to restore the database from six days ago, before the payment method table was modified.

Unfortunately, that six days of work with categories and images that we will need to make up. Please any help you can give us trying to fix this we would appreciate.

Thank you
ray22901031  
#4 Posted : Wednesday, October 13, 2021 4:17:33 AM(UTC)
ray22901031

Rank: Advanced Member

Groups: Authorized User, Developers
Joined: 2/17/2019(UTC)
Posts: 826

Thanks: 3 times
Was thanked: 13 time(s) in 13 post(s)
THIS IS NOW FIXED!
Katie S  
#5 Posted : Wednesday, October 27, 2021 5:33:08 PM(UTC)
Katie S

Rank: Advanced Member

Groups: System, Administrators, Developers, Registered, HelpDesk
Joined: 10/29/2018(UTC)
Posts: 421

Thanks: 4 times
Was thanked: 34 time(s) in 33 post(s)
I'm so sorry this issue was answered. I know how frustrating that must have been for you.

I'm glad you were able to fix it, but I would like to figure out what could have happened so it doesn't happen to someone else.

There are 2 instrument types that might be causing some confusion. The "mail" type will notify the user that they can complete the order and mail in a check to the address on the invoice. The "check" type is for electronic checks and this must be used with a payment gateway that processes them at the time the order is placed.

Based on the error, it seems as if you might have been using electronic checks. But deleting payment methods should not cause problems like this, so it's a bit concerning.
Thanks for your support!

Katie
Secure eCommerce Software and Hosting
ray22901031  
#6 Posted : Wednesday, October 27, 2021 6:03:09 PM(UTC)
ray22901031

Rank: Advanced Member

Groups: Authorized User, Developers
Joined: 2/17/2019(UTC)
Posts: 826

Thanks: 3 times
Was thanked: 13 time(s) in 13 post(s)
First let me start by saying, we screwed up. It was 100% our fault, and we freaked out.

Occasionally, we need specific values in specific custom fields for reporting and our procedures. Most of the time these values need to be set using custom programming within Ablecommerce, but others do not, if you know how to use database triggers properly.

The problem was the trigger itself, we thought we took care of the trigger going into an endless loop, but obviously, we did not. So imagine this scenario, you are in Ablecommerce, and you're trying to change anything, adding a new item to an order, changing a quantity, anything that reflects a modification to the database.

- You try to COMMIT the changes to the database.
- The trigger executes
- Ablecommerce is still trying to COMMIT to the database
- The trigger executes again
- Ablecommerce tries again to POST and COMMIT to the database
- MS SQL Server now intervenes and issues a rollback.
- Nothing gets changed at all.

No error messages are being returned at all.

The only sensible clue is actually going into the window server log files and realizing that SQL Server instigated a Rollback.

We have taken steps to make sure that our triggers can no longer create looping situations.

I hope this helps someone else because it was pure hell for a couple of hours.

-Ray

Edited by user Wednesday, October 27, 2021 6:04:11 PM(UTC)  | Reason: Not specified

Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.