You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@ofbiz.apache.org by Justine Nowak <co...@gmail.com> on 2021/10/09 03:04:59 UTC

Product Key duplicate error

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.PRIMARY'))))

How do we get the system to automatically generate the Product Id based on
the next one in line.

Re: Product Key duplicate error

Posted by Gil Portenseigne <gi...@nereide.fr>.

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, 2021 at 10:04:59PM -0500, Justine Nowak wrote:
> 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.PRIMARY'))))
> 
> How do we get the system to automatically generate the Product Id based on
> the next one in line.