Rank: Advanced Member
Groups: Authorized User, Developers
Joined: 2/17/2019(UTC)
Posts: 909
Thanks: 3 times
Was thanked: 15 time(s) in 15 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
|
|
|
|
|
|
Rank: Advanced Member
Groups: Authorized User, Developers
Joined: 2/17/2019(UTC)
Posts: 909
Thanks: 3 times
Was thanked: 15 time(s) in 15 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?
|
|
|
|
|
|
Rank: Advanced Member
Groups: Authorized User, Developers
Joined: 2/17/2019(UTC)
Posts: 909
Thanks: 3 times
Was thanked: 15 time(s) in 15 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
|
|
|
|
|
|
Rank: Advanced Member
Groups: Authorized User, Developers
Joined: 2/17/2019(UTC)
Posts: 909
Thanks: 3 times
Was thanked: 15 time(s) in 15 post(s)
|
|
|
|
|
|
|
Rank: Advanced Member
Groups: System, Administrators, Developers, Registered, HelpDesk
Joined: 10/29/2018(UTC)
Posts: 472
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 |
|
|
|
|
|
Rank: Advanced Member
Groups: Authorized User, Developers
Joined: 2/17/2019(UTC)
Posts: 909
Thanks: 3 times
Was thanked: 15 time(s) in 15 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
|
|
|
|
|
|
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.
Important Information:
The AbleCommerce Forums uses cookies. By continuing to browse this site, you are agreeing to our use of cookies.
More Details
Close
