Uploaded image for project: 'OFBiz'
  1. OFBiz
  2. OFBIZ-7402

Catalog : Showing error when duplicating product

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: Trunk
    • Fix Version/s: Upcoming Release
    • Component/s: product
    • Labels:
      None

      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, 
      

        Activity

        Hide
        jacques.le.roux Jacques Le Roux added a comment -

        Please give the complete error message for us to better understand before having to run the application, ie click on Show All before creating the snapshoot, thanks

        Show
        jacques.le.roux Jacques Le Roux added a comment - Please give the complete error message for us to better understand before having to run the application, ie click on Show All before creating the snapshoot, thanks
        Hide
        padma.rawat Padmavati Rawat added a comment - - edited

        Hi Jacques Le Roux]

        I have added steps to regenerate the issue in the description section along with error message.

        Show
        padma.rawat Padmavati Rawat added a comment - - edited Hi Jacques Le Roux ] I have added steps to regenerate the issue in the description section along with error message.
        Hide
        jacques.le.roux Jacques Le Roux added a comment -

        Ah the old infamous Jira error . I'm not Jan le Roux as ASF Jira sometimes thinks, I'm Jacques Le Roux. OK, thanks!

        Show
        jacques.le.roux Jacques Le Roux added a comment - Ah the old infamous Jira error . I'm not Jan le Roux as ASF Jira sometimes thinks, I'm Jacques Le Roux . OK, thanks!
        Hide
        deepak.dixit Deepak Dixit added a comment -

        Converted ticket type from bug to improvement as its an improvement.

        This has been committed at trunk at r#1773213

        Thanks Arvind and Padma for your contribution

        Show
        deepak.dixit Deepak Dixit added a comment - Converted ticket type from bug to improvement as its an improvement. This has been committed at trunk at r#1773213 Thanks Arvind and Padma for your contribution

          People

          • Assignee:
            deepak.dixit Deepak Dixit
            Reporter:
            padma.rawat Padmavati Rawat
          • Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development