Hi,
The delete option in broadleaf admin is not working with 3.1.2 GA version. I get the below exception every time I try to delete any product:
[ERROR] 14:09:11 SqlExceptionHelper - Cannot delete or update a parent row: a foreign key constraint fails (`stylemycase`.`BLC_PRODUCT`, CONSTRAINT `FK5B95B7C96D386535` FOREIGN KEY (`DEFAULT_SKU_ID`) REFERENCES `BLC_SKU` (`SKU_ID`))
[ERROR] 14:09:11 DynamicEntityRemoteService - Problem removing org.broadleafcommerce.core.catalog.domain.Product
org.broadleafcommerce.common.exception.ServiceException: Problem removing entity : org.hibernate.exception.ConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (`stylemycase`.`BLC_PRODUCT`, CONSTRAINT `FK5B95B7C96D386535` FOREIGN KEY (`DEFAULT_SKU_ID`) REFERENCES `BLC_SKU` (`SKU_ID`))
at org.broadleafcommerce.openadmin.server.service.persistence.module.BasicPersistenceModule.remove(BasicPersistenceModule.java:963)
at org.broadleafcommerce.openadmin.server.service.persistence.PersistenceManagerImpl.remove(PersistenceManagerImpl.java:644)
at org.broadleafcommerce.openadmin.server.service.DynamicEntityRemoteService$5.execute(DynamicEntityRemoteService.java:204)
at org.broadleafcommerce.openadmin.server.service.DynamicEntityRemoteService$5.execute(DynamicEntityRemoteService.java:199)
at org.broadleafcommerce.openadmin.server.service.persistence.PersistenceThreadManager.operation(PersistenceThreadManager.java:33)
at org.broadleafcommerce.openadmin.server.service.DynamicEntityRemoteService.remove(DynamicEntityRemoteService.java:199)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
Can some one please check?
Best Regards,
Ramesh
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.