How detect problem in our NopCommerce v3.3

Hello,

Some days ago our clients are unable to put orders in our store: http://tienda.frutafrescavirtual.com/
Finishing all the Checkout process in the final step our Nop gets a timeout error.
In the Nop Admin logs dont appears any error.

We did put our Nop in custom errors = off (via web config custom errors) and this is the error we are getting:
   http://tienda.frutafrescavirtual.com/Error01.jpg
But we dont understand what happen.

Also today we have used Exceptionless.com app to get more info about the error.
The timeout error is receiving a "System.Data.Entity.Infrastructure.DbUpdateException" as you can verify here:
   http://tienda.frutafrescavirtual.com/Error02.jpg
All the strack trace of the error is: http://tienda.frutafrescavirtual.com/Error02.txt

And now another error appears: Now we can't see our orders in the administration. And Exceptionless is showing this exceptios: NullReferenceException in <OrderList>b__1d: Object reference not set to an instance of an object.
      http://tienda.frutafrescavirtual.com/Error03.jpg
All the strack trace of the error is: http://tienda.frutafrescavirtual.com/Error03.txt

We have no idea what to do here!!!
Can you help us?

Thanks,

Have you checked if there is any connection issue with the database?

Did it happen only when placing orders?

The problem is only placing orders. The store actually is working all right: http://tienda.frutafrescavirtual.com/

:(

The 1st and 2nd error msg suggested that something was wrong in Nop.Web.Controllers.CheckoutController.ConfirmOrder().

The 3rd error msg suggested something is null when a value is expected in Nop.Admin.Controllers.OrderController.

Did something get changed recently?

It's best to run the solution in debugger mode, reproduce the error and trace the bug. Focus on the checkout controller in Nop.Web and the order controller in Nop.Admin.

AxiomaX wrote:

Was any change made anywhere recently? Like DB changed or made and changes related to the Orders?

We are not sure if we did a change in orders but we think dont.
We are final users so we dont touch code or databases.

How is run the solution in debugger mode? Download code of Nop and run it locally? If we run locally it wont have the theme and plugins we have in production!

If you don't have access to the source code nor the database, then it will be a lot more difficult to find out what's causing the problem. You should contact your tech support or whoever is supporting your website technically to examine the issue.

As previously mentioned, something is wrong with the checkout controller and the order controller, that should help with narrowing down. The errors suggested something was off with the database, particularly with the Order table.

Ultimately it came down to -- what was changed recently? Sites don't just break without a cause. If you were unaware of any changes made, you might want to check with others who have access to the site.

You can help further narrow down the issue by trying the followings:

1. Create an impersonated order in admin -- does it go through?

2. Go to manage orders in admin, click around until it breaks -- where does it break?

3. Check all order-related settings are in place to support the ordering process, ie. payment methods, shipping methods, discounts, etc. If something breaks along the way, make a note of it because it might be relevant to the issue.

4. Check all current shopping carts and see if there is a pattern in product selection that leads to the issue

5. Ask your database admin to check if the Order table is still in the database

These are just some ideas of where I would check if I were in your shoe.

Sorry there's nothing more I can offer at this point. Good luck!

Thanks karenian,

We downloaded the source code of Nop v3.3 and use the settings.txt from production server.
As you recommended us, we did a debug of checkout process.

We found the error just when trying to insert the order in the server.
The inner exceptio is:
"Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding."

We are testing insertin orders manually (in SQL vis INSERT INTO Orders table) and it takes a lot of time.
Just a simple insert in this table.

We think there are problems with this table or our sql, but how we fix it or what to do if this tables ans others answer to other queries fast?

Any ideas?

Thanks

I am not a db expert, so I don't have much insight on why that particular table is not performing. But it is good that you were able to pinpoint where the core of the issue is. You should check with your db admin and get support.

One thing I would check, is the Order table being locked down by another process?

Thanks karenian
How we can verify it?
Thanks