Order ID increased by 1000

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
7 years ago
Suddenly my Order ID increasing by one thousand each time.
I started in 1100 and go fine till 1532.

Then 1532 => 2533 => 3533 => 4534-4538 => 5538

What's going on?
7 years ago
read here:
https://www.nopcommerce.com/boards/t/39419/order-id-problems.aspx
7 years ago
This Error mostly occurs when SQL server 2012 loses its pre-allocated sequence numbers.

Thus, the option is to use a sequence (with no caching)
In SQL instead of identity:
CREATE SEQUENCE MySeq AS int
START WITH 1
INCREMENT BY 1
NO CACHE;


Thanks
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.