This is intended behaviour. Functionality to delete products is not available in the applications as a result of the productId being a fk in many dependencies.
Products can be set to be expired, in order to hide visibility. Best regards, Pierre Smits *ORRTIZ.COM <http://www.orrtiz.com>* Services & Solutions for Cloud- Based Manufacturing, Professional Services and Retail & Trade http://www.orrtiz.com On Fri, Jan 30, 2015 at 9:16 AM, i...@agentur-m3.de <i...@agentur-m3.de> wrote: > Hi All, > > I tried to create some test products (just product_id > and description and a user defined PRODUCT_TYPE_ID > "FLEAMARKETITEM") using a simple method. > > ofbiz now gives me an error when deleting them. > > Pressing delete-button the data engine says: > > Delete failed (write error): org.ofbiz.entity.GenericEntityException: > org.ofbiz.entity.GenericDataSourceException: Exception while deleting > the following entity: > [GenericEntity:Product][productId,fleamarket(java.lang.String)] (SQL > Exception while executing the following:DELETE FROM OFBIZ.PRODUCT WHERE > PRODUCT_ID=? (DELETE on table 'PRODUCT' caused a violation of foreign > key constraint 'PROD_KWD_PROD_NEW' for key (fleamarket). The statement > has been rolled back.)) (Exception while deleting the following entity: > [GenericEntity:Product][productId,fleamarket(java.lang.String)] (SQL > Exception while executing the following:DELETE FROM OFBIZ.PRODUCT WHERE > PRODUCT_ID=? (DELETE on table 'PRODUCT' caused a violation of foreign > key constraint 'PROD_KWD_PROD_NEW' for key (fleamarket). The statement > has been rolled back.))) > > Also I tried with SQL: > > SQL Exception while executing the following:DELETE FROM PRODUCT WHERE > PRODUCT_TYPE_ID = 'FLEAMARKETITEM' (DELETE on table 'PRODUCT' caused a > violation of foreign key constraint 'PROD_KWD_PROD_NEW' for key > (fleamarket). The statement has been rolled back.) > > > So it seems I can't delete these items. What is going wrong? > How can I reset the entity state to correct relations? > > > Thank you! >