[OFBIZ-7683] Error occurred when making Shopping list public/private from Party Detail screen

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Release Branch 13.07, Release Branch 14.12, Release Branch 15.12, Trunk
• Fix Version/s: Release Branch 14.12, Release Branch 15.12, 17.12.01
• Component/s: party
• Sprint: 2016 - OFBiz Community Day 4
• Assignee: Michael Brohl
• Reporter: Ankit Joshi
• Created: 30/Jun/16 09:19
• Updated: 17/Dec/16 16:02
• Resolved: 17/Dec/16 16:02

Description

Steps to regenerate
1) Navigate to party component.
2) Search parties and move to the detail page.
3) Select Shopping List tab and create shopping list for the party.
4) Try to update shopping list with public / private.
Following error occurred -

Error while updating: [GenericEntity:ShoppingList][carrierPartyId,null()][carrierRoleTypeId,null()][contactMechId,null()][createdStamp,2016-06-30 13:57:21.0(java.sql.Timestamp)][createdTxStamp,2016-06-30 13:57:21.0(java.sql.Timestamp)][currencyUom,null()][description,null()][isActive,Y(java.lang.String)][isPublic,Yes(java.lang.String)][lastAdminModified,2016-06-30 14:03:25.0(java.sql.Timestamp)][lastOrderedDate,null()][lastUpdatedStamp,2016-06-30 14:15:21.079(java.sql.Timestamp)][lastUpdatedTxStamp,2016-06-30 14:15:21.008(java.sql.Timestamp)][listName,New Shopping List(java.lang.String)][parentShoppingListId,null()][partyId,10000(java.lang.String)][paymentMethodId,null()][productPromoCodeId,null()][productStoreId,null()][recurrenceInfoId,null()][shipmentMethodTypeId,null()][shoppingListId,10030(java.lang.String)][shoppingListTypeId,SLT_WISH_LIST(java.lang.String)][visitorId,null()] (SQL Exception while executing the following:UPDATE SHOPPING_LIST SET SHOPPING_LIST_TYPE_ID=?, PARENT_SHOPPING_LIST_ID=?, PRODUCT_STORE_ID=?, VISITOR_ID=?, PARTY_ID=?, LIST_NAME=?, DESCRIPTION=?, IS_PUBLIC=?, IS_ACTIVE=?, CURRENCY_UOM=?, SHIPMENT_METHOD_TYPE_ID=?, CARRIER_PARTY_ID=?, CARRIER_ROLE_TYPE_ID=?, CONTACT_MECH_ID=?, PAYMENT_METHOD_ID=?, RECURRENCE_INFO_ID=?, LAST_ORDERED_DATE=?, LAST_ADMIN_MODIFIED=?, PRODUCT_PROMO_CODE_ID=?, LAST_UPDATED_STAMP=?, LAST_UPDATED_TX_STAMP=?, CREATED_STAMP=?, CREATED_TX_STAMP=? WHERE SHOPPING_LIST_ID=? (Data truncation: Data too long for column 'IS_PUBLIC' at row 1))

Here is the reference link -
https://ofbiz-vm.apache.org:8443/partymgr/control/editShoppingList?partyId=Company