Hope somebody could help me with a small issue I have found with my nopCommerce v4.0 store, after migrating the site to a new windows server, i've noticed any new orders taken on the site the order sequence has changed see images below, instead of the next order ID being 20682 following after 20681 it is 21681 adding an extra 1 after the first digit, I noticed in the database the order number is taken from the table row, can this be changed so the sequence can go back to what it was before?
Many thanks Kava for the suggestion, the site is running on Windows Server 2012, followed the SQL Query against the afFected DB but get the following error, any ideas?
Thanks for your suggestions, so going back to my initial issue, it seems not to be IDENTITY_CACHE since this only applies to later release of Windows server, any ideas what the problem could be affecting the order numbering?
SQL Server 2017 introduced a new database scoped configuration option IDENTITY_CACHE. However, the problem of cached sequence I think goes back to SQL Server 2012.
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
Hai ancora qualche domanda o hai bisogno di aiuto?