[OFBIZ-7402] Catalog : Showing error when duplicating product

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: Trunk
• Fix Version/s: 17.12.01
• Component/s: product
• Assignee: Deepak Dixit
• Reporter: Padmavati Rawat
• Created: 18/Jun/16 06:50
• Updated: 08/Aug/17 12:46
• Resolved: 08/Dec/16 11:05

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.

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,