Product Key duplicate error

2021-10-08 Thread Justine Nowak
Hello, We did an XML upload of a lot of SKUs into Ofbiz, but today when I go to manually add a new product without a Product Id letting the system automatically decide that. I get the following error. (SQL Exception while executing the following:null (Duplicate entry '10044' for key 'PRODUCT.PRIM

Re: Product Key duplicate error

2021-10-09 Thread Gil Portenseigne
Hello Justine, There is a table `SequenceValueItem` that manage those kind of sequences, you just need to set a value above you max product Id into the tuple with SeqName = "Product". Then reboot your OFBiz instance to empty the current sequence bank in memory. Regards, Gil On Fri, Oct 08, 20