Sequence Generator

[kotnivineela]

Hi ,

I am migrating some data from the down stream system into broadleaf.
I am inserting data through sql queries.
I inserted a record by myself giving an id by adding 1 to the existing id in the table.Everything went fine and I can see it on the page.But when I try to add another through the broadleaf admin.I am getting a primary key error duplicate.Is there a way to increase the sequence manually for data inserted through queries.

Thanks,
Vineela

[phillipuniverse]

Yes, modify the SEQUENCE_GENERATOR table.

[bebloo]

Is there a blc processor to get subcategories ?
If so may I know what processor would it be ?