[jira] [Updated] (OFBIZ-7402) Catalog : Showing error when duplicating product

[Nicolas Malin (Jira)]

     [ https://issues.apache.org/jira/browse/OFBIZ-7402?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jacques Le Roux updated OFBIZ-7402:
-----------------------------------
    Description:
Steps:
1. Navigate on Catalog, and Create New Product.
2. Fill all required details and click on update product.
3. Duplicate Product section will open with updated product.
4. Click on Duplicate button.

Actual : Not able to duplicate product in Catalog. It generates a non user friendly error message.

Expected : Error message should be user friendly, and should be fixed if there is any issue.
{code}
Error message :
The Following Errors Occurred:
Exception thrown while creating the "newProduct" GenericValue: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:Product][amountUomTypeId,null()][autoCreateKeywords,null()][billOfMaterialLevel,0(java.lang.Long)][brandName,null()][chargeShipping,null()][comments,null()][configId,null()][createdByUserLogin,admin(java.lang.String)][createdDate,2016-06-18 16:44:17.857(java.sql.Timestamp)][createdStamp,2016-06-18 16:48:03.861(java.sql.Timestamp)][createdTxStamp,2016-06-18 16:48:03.718(java.sql.Timestamp)][defaultShipmentBoxTypeId,null()][depthUomId,null()][description,null()][detailImageUrl,null()][detailScreen,null()][diameterUomId,null()][facilityId,null()][fixedAmount,null()][heightUomId,null()][inShippingBox,N(java.lang.String)][includeInPromotions,null()][internalName,New Product(java.lang.String)][introductionDate,null()][inventoryItemTypeId,NON_SERIAL_INV_ITEM(java.lang.String)][inventoryMessage,null()][isVariant,N(java.lang.String)][isVirtual,N(java.lang.String)][largeImageUrl,null()][lastModifiedByUserLogin,admin(java.lang.String)][lastModifiedDate,2016-06-18 16:44:17.857(java.sql.Timestamp)][lastUpdatedStamp,2016-06-18 16:48:03.861(java.sql.Timestamp)][lastUpdatedTxStamp,2016-06-18 16:48:03.718(java.sql.Timestamp)][longDescription,null()][lotIdFilledIn,Allowed(java.lang.String)][manufacturerPartyId,null()][mediumImageUrl,null()][orderDecimalQuantity,null()][originGeoId,null()][originalImageUrl,null()][piecesIncluded,null()][priceDetailText,null()][primaryProductCategoryId,null()][productDepth,null()][productDiameter,null()][productHeight,null()][productId,10005(java.lang.String)][productName,null()][productRating,null()][productTypeId,FINISHED_GOOD(java.lang.String)][productWeight,null()][productWidth,null()][quantityIncluded,null()][quantityUomId,null()][ratingTypeEnum,null()][releaseDate,null()][requireAmount,null()][requireInventory,null()][requirementMethodEnumId,null()][reserv2ndPPPerc,null()][reservMaxPersons,null()][reservNthPPPerc,null()][returnable,null()][salesDiscWhenNotAvail,null()][salesDiscontinuationDate,null()][shippingDepth,null()][shippingHeight,null()][shippingWeight,null()][shippingWidth,null()][smallImageUrl,null()][supportDiscontinuationDate,null()][taxable,null()][virtualVariantMethodEnum,null()][weightUomId,null()][widthUomId,null()] (SQL Exception while executing the following:INSERT INTO OFBIZ.PRODUCT (PRODUCT_ID, PRODUCT_TYPE_ID, PRIMARY_PRODUCT_CATEGORY_ID, MANUFACTURER_PARTY_ID, FACILITY_ID, INTRODUCTION_DATE, RELEASE_DATE, SUPPORT_DISCONTINUATION_DATE, SALES_DISCONTINUATION_DATE, SALES_DISC_WHEN_NOT_AVAIL, INTERNAL_NAME, BRAND_NAME, COMMENTS, PRODUCT_NAME, DESCRIPTION, LONG_DESCRIPTION, PRICE_DETAIL_TEXT,
{code}

  was:
Steps:
1. Navigate on Catalog, and Create New Product.
2. Fill all required details and click on update product.
3. Duplicate Product section will open with updated product.
4. Click on Duplicate button.

Actual : Not able to duplicate product in Catalog. It generates a non user friendly error message.

Expected : Error message should be user friendly, and should be fixed if there is any issue.

Error message :
The Following Errors Occurred:
Exception thrown while creating the "newProduct" GenericValue: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:Product][amountUomTypeId,null()][autoCreateKeywords,null()][billOfMaterialLevel,0(java.lang.Long)][brandName,null()][chargeShipping,null()][comments,null()][configId,null()][createdByUserLogin,admin(java.lang.String)][createdDate,2016-06-18 16:44:17.857(java.sql.Timestamp)][createdStamp,2016-06-18 16:48:03.861(java.sql.Timestamp)][createdTxStamp,2016-06-18 16:48:03.718(java.sql.Timestamp)][defaultShipmentBoxTypeId,null()][depthUomId,null()][description,null()][detailImageUrl,null()][detailScreen,null()][diameterUomId,null()][facilityId,null()][fixedAmount,null()][heightUomId,null()][inShippingBox,N(java.lang.String)][includeInPromotions,null()][internalName,New Product(java.lang.String)][introductionDate,null()][inventoryItemTypeId,NON_SERIAL_INV_ITEM(java.lang.String)][inventoryMessage,null()][isVariant,N(java.lang.String)][isVirtual,N(java.lang.String)][largeImageUrl,null()][lastModifiedByUserLogin,admin(java.lang.String)][lastModifiedDate,2016-06-18 16:44:17.857(java.sql.Timestamp)][lastUpdatedStamp,2016-06-18 16:48:03.861(java.sql.Timestamp)][lastUpdatedTxStamp,2016-06-18 16:48:03.718(java.sql.Timestamp)][longDescription,null()][lotIdFilledIn,Allowed(java.lang.String)][manufacturerPartyId,null()][mediumImageUrl,null()][orderDecimalQuantity,null()][originGeoId,null()][originalImageUrl,null()][piecesIncluded,null()][priceDetailText,null()][primaryProductCategoryId,null()][productDepth,null()][productDiameter,null()][productHeight,null()][productId,10005(java.lang.String)][productName,null()][productRating,null()][productTypeId,FINISHED_GOOD(java.lang.String)][productWeight,null()][productWidth,null()][quantityIncluded,null()][quantityUomId,null()][ratingTypeEnum,null()][releaseDate,null()][requireAmount,null()][requireInventory,null()][requirementMethodEnumId,null()][reserv2ndPPPerc,null()][reservMaxPersons,null()][reservNthPPPerc,null()][returnable,null()][salesDiscWhenNotAvail,null()][salesDiscontinuationDate,null()][shippingDepth,null()][shippingHeight,null()][shippingWeight,null()][shippingWidth,null()][smallImageUrl,null()][supportDiscontinuationDate,null()][taxable,null()][virtualVariantMethodEnum,null()][weightUomId,null()][widthUomId,null()] (SQL Exception while executing the following:INSERT INTO OFBIZ.PRODUCT (PRODUCT_ID, PRODUCT_TYPE_ID, PRIMARY_PRODUCT_CATEGORY_ID, MANUFACTURER_PARTY_ID, FACILITY_ID, INTRODUCTION_DATE, RELEASE_DATE, SUPPORT_DISCONTINUATION_DATE, SALES_DISCONTINUATION_DATE, SALES_DISC_WHEN_NOT_AVAIL, INTERNAL_NAME, BRAND_NAME, COMMENTS, PRODUCT_NAME, DESCRIPTION, LONG_DESCRIPTION, PRICE_DETAIL_TEXT,

> Catalog : Showing error when duplicating product
> ------------------------------------------------
>
>                 Key: OFBIZ-7402
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-7402
>             Project: OFBiz
>          Issue Type: Bug
>          Components: product
>    Affects Versions: Trunk
>            Reporter: Padmavati Rawat
>             Fix For: Trunk
>
>         Attachments: Error in Duplicate Product.png
>
>
> Steps:
> 1. Navigate on Catalog, and Create New Product.
> 2. Fill all required details and click on update product.
> 3. Duplicate Product section will open with updated product.
> 4. Click on Duplicate button.
> Actual : Not able to duplicate product in Catalog. It generates a non user friendly error message.
> Expected : Error message should be user friendly, and should be fixed if there is any issue.
> {code}
> Error message :
> The Following Errors Occurred:
> Exception thrown while creating the "newProduct" GenericValue: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:Product][amountUomTypeId,null()][autoCreateKeywords,null()][billOfMaterialLevel,0(java.lang.Long)][brandName,null()][chargeShipping,null()][comments,null()][configId,null()][createdByUserLogin,admin(java.lang.String)][createdDate,2016-06-18 16:44:17.857(java.sql.Timestamp)][createdStamp,2016-06-18 16:48:03.861(java.sql.Timestamp)][createdTxStamp,2016-06-18 16:48:03.718(java.sql.Timestamp)][defaultShipmentBoxTypeId,null()][depthUomId,null()][description,null()][detailImageUrl,null()][detailScreen,null()][diameterUomId,null()][facilityId,null()][fixedAmount,null()][heightUomId,null()][inShippingBox,N(java.lang.String)][includeInPromotions,null()][internalName,New Product(java.lang.String)][introductionDate,null()][inventoryItemTypeId,NON_SERIAL_INV_ITEM(java.lang.String)][inventoryMessage,null()][isVariant,N(java.lang.String)][isVirtual,N(java.lang.String)][largeImageUrl,null()][lastModifiedByUserLogin,admin(java.lang.String)][lastModifiedDate,2016-06-18 16:44:17.857(java.sql.Timestamp)][lastUpdatedStamp,2016-06-18 16:48:03.861(java.sql.Timestamp)][lastUpdatedTxStamp,2016-06-18 16:48:03.718(java.sql.Timestamp)][longDescription,null()][lotIdFilledIn,Allowed(java.lang.String)][manufacturerPartyId,null()][mediumImageUrl,null()][orderDecimalQuantity,null()][originGeoId,null()][originalImageUrl,null()][piecesIncluded,null()][priceDetailText,null()][primaryProductCategoryId,null()][productDepth,null()][productDiameter,null()][productHeight,null()][productId,10005(java.lang.String)][productName,null()][productRating,null()][productTypeId,FINISHED_GOOD(java.lang.String)][productWeight,null()][productWidth,null()][quantityIncluded,null()][quantityUomId,null()][ratingTypeEnum,null()][releaseDate,null()][requireAmount,null()][requireInventory,null()][requirementMethodEnumId,null()][reserv2ndPPPerc,null()][reservMaxPersons,null()][reservNthPPPerc,null()][returnable,null()][salesDiscWhenNotAvail,null()][salesDiscontinuationDate,null()][shippingDepth,null()][shippingHeight,null()][shippingWeight,null()][shippingWidth,null()][smallImageUrl,null()][supportDiscontinuationDate,null()][taxable,null()][virtualVariantMethodEnum,null()][weightUomId,null()][widthUomId,null()] (SQL Exception while executing the following:INSERT INTO OFBIZ.PRODUCT (PRODUCT_ID, PRODUCT_TYPE_ID, PRIMARY_PRODUCT_CATEGORY_ID, MANUFACTURER_PARTY_ID, FACILITY_ID, INTRODUCTION_DATE, RELEASE_DATE, SUPPORT_DISCONTINUATION_DATE, SALES_DISCONTINUATION_DATE, SALES_DISC_WHEN_NOT_AVAIL, INTERNAL_NAME, BRAND_NAME, COMMENTS, PRODUCT_NAME, DESCRIPTION, LONG_DESCRIPTION, PRICE_DETAIL_TEXT,
> {code}

--
This message was sent by Atlassian JIRA
(v6.3.4#6332)