When i delete it, it gives the following error.
NOTE: I have migrated the database to Oracle, and there is no data in any of the catalog tables.
Code: Select all
javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: ORA-02292: integrity constraint (MEDICODEAL_BL.FK5B95B7C96D386535) violated - child record found
org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1387)
org.hibernate.exception.ConstraintViolationException: ORA-02292: integrity constraint (MEDICODEAL_BL.FK5B95B7C96D386535) violated - child record found
org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:74)
java.sql.SQLIntegrityConstraintViolationException: ORA-02292: integrity constraint (MEDICODEAL_BL.FK5B95B7C96D386535) violated - child record found
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
TEMPORARY WORKAROUND
i have tried updating the BLC_PRODUCT table and setting the default_sku_id as null.
STEP#1: Set Default SKU as null
Code: Select all
update blc_product set DEFAULT_SKU_ID = null where PRODUCT_ID='12345';
STEP#2: Delete the product from admin panel. [works fine this time]
STEP#3: Delete the SKU manually from table.
Code: Select all
delete from blc_sku where sku_id='12345';