Developer forum

Forum » Dynamicweb 9.0 Upgrade issues » Orders and Order Details Hit Timeout Error

Orders and Order Details Hit Timeout Error

E-mail notifications
Shiwanka Chathuranga Dynamicweb Employee
Shiwanka Chathuranga
Reply
Posted on 28/05/2019 12:35:24

After updating 8.9 to 9.5.3 in backend order details hit sqltimeout error

we have changed index based on latest db structure but still getting the error and order list also very slow.

any clue to resolve it?


Replies

 
Morten Snedker Dynamicweb Employee
Morten Snedker
Posted on 06/06/2019 14:37:09
Reply

Hi Shiwanka,

I take it that with your latest contact with helpdesk that this issue is now resolved.

Best regards
Morten Snedker | Helpdesk

 
Shiwanka Chathuranga Dynamicweb Employee
Shiwanka Chathuranga
Posted on 06/06/2019 15:29:12
Reply
This post has been marked as an answer

Yes Morten

 

i will give the clues here that if any other faced how to fix quickly

* Refer the latest DB indexes and correct on the OLD DB specially in table AccessUser, EcomProducts, EcomOrders, EcomOrderLines, EcomOrderDubuggingInfo

* Purge the stats table records based on requirement 

Votes for this answer: 1

 

You must be logged in to post in the forum