Hi philip,
Sequence Generator is getting reset or the update is not happening so once after restart after setting the
blPU.hibernate.hbm2ddl.auto=validate or None it is throwing duplicate entry issue.
We tried by setting in the development.properties but that did't work..
detect.sequence.generator.inconsistencies=true
auto.correct.sequence.generator.inconsistencies=true
We have 3.1.8 code base and we tried to add product, image after doing create drop it works and then later after killing the tomcat we set it to None then once after restart later if we add a product or an SKU it is not adding rather it is throwing the below and see in the DB that the sequences are not getting updated.
Caused by: org.broadleafcommerce.openadmin.server.service.persistence.PersistenceException: javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: Duplicate entry '99952' for key 'PRIMARY'
at org.broadleafcommerce.openadmin.server.service.persistence.module.provider.MediaFieldPersistenceProvider.populateValue(MediaFieldPersistenceProvider.java:145)
at org.broadleafcommerce.openadmin.server.service.persistence.module.BasicPersistenceModule.createPopulatedInstance(BasicPersistenceModule.java:300)
at org.broadleafcommerce.openadmin.server.service.persistence.module.BasicPersistenceModule.createPopulatedInstance(BasicPersistenceModule.java:227)
at com.broadleafcommerce.enterprise.workflow.admin.service.handler.ProductCustomPersistenceHandler.add(ProductCustomPersistenceHandler.java:82)
Can you please help me..thanks.
I verified BLC forum
viewtopic.php?f=14&t=3051
viewtopic.php?f=11&t=3180
This forum is in readonly mode and serves as an archive of old information. All posting, registration and commenting abilities have been turned off. To get help, the Broadleaf team reguarly monitors the broadleaf-commerce tag on Stack Overflow so please ask your questions there.