Re: delete product

[Michael Brohl]

Hi,




Regards,

Michael

Am 30.01.15 um 09:16 schrieb i...@agentur-m3.de:

there are foreign key constraints from other tables (I guess product keywords). You first have to delete the product_keyword entities relating to your product before you can delete your product.

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!

smime.p7s
Description: S/MIME Cryptographic Signature