Broadleaf Commerce Discussion Forums

Hi,
I have build my own new catalog with 100+ categories and 2500+ products with many other options.

Now, when I am editing / adding a product from admin, I am getting the exception in sequence generator.
Do I need to change the values in sequence generator table in DB, if so then what value and for what option. I mean, do I need to change the value for all of the option in sequence generator table or do I need to change the code somewhere.

any help is highly appreciated.

- Sumit

Yes, you definitely must modify the entries in SEQUENCE_GENERATOR.

Broadleaf can also do this for you on startup if you put this in your environment properties:



In general, you want the entry in SEQUENCE_GENERATOR to be the maximum ID in the table + 100.

This should be set to "TRUE" or "FALSE"

auto.correct.sequence.generator.inconsistencies=false

Sorry, set that to true: