ofbiz-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Anahita Goljahani <anahita.goljah...@gmail.com>
Subject Re: delete product
Date Sun, 01 Feb 2015 05:47:16 GMT
Hi,

  just so you know, you may prevent the automatic creation of keywords by
setting "autoCreateKeywords" to "N" in Product entity.

Kind regards

Anahita

2015-01-30 9:16 GMT+01:00 info@agentur-m3.de <info@agentur-m3.de>:

> 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!
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message