Product Store Setup Error with seed data in 14.12

[mandeepmavi]

Hi Friends,
I am unable to do initial set-up of product store in OfBIZ14.12 using seed data.

Getting some below shipment error.

Thanks

[mandeepmavi]

2015-05-12 22:21:45,277 |http-bio-8443-exec-3 |RequestHandler                |I| Ran Event [simple:component://commonext/script/org/ofbiz/setup/SetupEvents.xml#createProductStoreWithDefaultSetting] from [request], result is [error]
2015-05-12 22:21:45,277 |http-bio-8443-exec-3 |RequestHandler                |E| Request createProductStore caused an error with the following message: Error:ERROR parsing Entity Xml file: org.xml.sax.SAXException: A transaction error occurred reading data
org.ofbiz.entity.GenericEntityException: org.ofbiz.entity.GenericEntityException: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ShipmentCostEstimate][carrierPartyId,UPS(java.lang.String)][carrierRoleTypeId,CARRIER(java.lang.String)][createdStamp,2015-05-12 22:21:45.269(java.sql.Timestamp)][createdTxStamp,2015-05-12 22:21:44.021(java.sql.Timestamp)][lastUpdatedStamp,2015-05-12 22:21:45.269(java.sql.Timestamp)][lastUpdatedTxStamp,2015-05-12 22:21:44.021(java.sql.Timestamp)][orderFlatPrice,10.0(java.math.BigDecimal)][orderItemFlatPrice,0.0(java.math.BigDecimal)][orderPricePercent,0.0(java.math.BigDecimal)][productStoreId,9000(java.lang.String)][productStoreShipMethId,9003(java.lang.String)][shipmentCostEstimateId,10103(java.lang.String)][shipmentMethodTypeId,NEXT_DAY(java.lang.String)][weightBreakId,9002(java.lang.String)][weightUnitPrice,0.35(java.math.BigDecimal)] (SQL Exception while executing the following:INSERT INTO public.SHIPMENT_COST_ESTIMATE (SHIPMENT_COST_ESTIMATE_ID, SHIPMENT_METHOD_TYPE_ID, CARRIER_PARTY_ID, CARRIER_ROLE_TYPE_ID, PRODUCT_STORE_SHIP_METH_ID, PRODUCT_STORE_ID, PARTY_ID, ROLE_TYPE_ID, GEO_ID_TO, GEO_ID_FROM, WEIGHT_BREAK_ID, WEIGHT_UOM_ID, WEIGHT_UNIT_PRICE, QUANTITY_BREAK_ID, QUANTITY_UOM_ID, QUANTITY_UNIT_PRICE, PRICE_BREAK_ID, PRICE_UOM_ID, PRICE_UNIT_PRICE, ORDER_FLAT_PRICE, ORDER_PRICE_PERCENT, ORDER_ITEM_FLAT_PRICE, SHIPPING_PRICE_PERCENT, PRODUCT_FEATURE_GROUP_ID, OVERSIZE_UNIT, OVERSIZE_PRICE, FEATURE_PERCENT, FEATURE_PRICE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: insert or update on table "shipment_cost_estimate" violates foreign key constraint "shpmnt_ce_cshmth"
  Detail: Key (shipment_method_type_id, carrier_party_id, carrier_role_type_id)=(NEXT_DAY, UPS, CARRIER) is not present in table "carrier_shipment_method".)) (Error while inserting: [GenericEntity:ShipmentCostEstimate][carrierPartyId,UPS(java.lang.String)][carrierRoleTypeId,CARRIER(java.lang.String)][createdStamp,2015-05-12 22:21:45.269(java.sql.Timestamp)][createdTxStamp,2015-05-12 22:21:44.021(java.sql.Timestamp)][lastUpdatedStamp,2015-05-12 22:21:45.269(java.sql.Timestamp)][lastUpdatedTxStamp,2015-05-12 22:21:44.021(java.sql.Timestamp)][orderFlatPrice,10.0(java.math.BigDecimal)][orderItemFlatPrice,0.0(java.math.BigDecimal)][orderPricePercent,0.0(java.math.BigDecimal)][productStoreId,9000(java.lang.String)][productStoreShipMethId,9003(java.lang.String)][shipmentCostEstimateId,10103(java.lang.String)][shipmentMethodTypeId,NEXT_DAY(java.lang.String)][weightBreakId,9002(java.lang.String)][weightUnitPrice,0.35(java.math.BigDecimal)] (SQL Exception while executing the following:INSERT INTO public.SHIPMENT_COST_ESTIMATE (SHIPMENT_COST_ESTIMATE_ID, SHIPMENT_METHOD_TYPE_ID, CARRIER_PARTY_ID, CARRIER_ROLE_TYPE_ID, PRODUCT_STORE_SHIP_METH_ID, PRODUCT_STORE_ID, PARTY_ID, ROLE_TYPE_ID, GEO_ID_TO, GEO_ID_FROM, WEIGHT_BREAK_ID, WEIGHT_UOM_ID, WEIGHT_UNIT_PRICE, QUANTITY_BREAK_ID, QUANTITY_UOM_ID, QUANTITY_UNIT_PRICE, PRICE_BREAK_ID, PRICE_UOM_ID, PRICE_UNIT_PRICE, ORDER_FLAT_PRICE, ORDER_PRICE_PERCENT, ORDER_ITEM_FLAT_PRICE, SHIPPING_PRICE_PERCENT, PRODUCT_FEATURE_GROUP_ID, OVERSIZE_UNIT, OVERSIZE_PRICE, FEATURE_PERCENT, FEATURE_PRICE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: insert or update on table "shipment_cost_estimate" violates foreign key constraint "shpmnt_ce_cshmth"
  Detail: Key (shipment_method_type_id, carrier_party_id, carrier_role_type_id)=(NEXT_DAY, UPS, CARRIER) is not present in table "carrier_shipment_method".))) (org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ShipmentCostEstimate][carrierPartyId,UPS(java.lang.String)][carrierRoleTypeId,CARRIER(java.lang.String)][createdStamp,2015-05-12 22:21:45.269(java.sql.Timestamp)][createdTxStamp,2015-05-12 22:21:44.021(java.sql.Timestamp)][lastUpdatedStamp,2015-05-12 22:21:45.269(java.sql.Timestamp)][lastUpdatedTxStamp,2015-05-12 22:21:44.021(java.sql.Timestamp)][orderFlatPrice,10.0(java.math.BigDecimal)][orderItemFlatPrice,0.0(java.math.BigDecimal)][orderPricePercent,0.0(java.math.BigDecimal)][productStoreId,9000(java.lang.String)][productStoreShipMethId,9003(java.lang.String)][shipmentCostEstimateId,10103(java.lang.String)][shipmentMethodTypeId,NEXT_DAY(java.lang.String)][weightBreakId,9002(java.lang.String)][weightUnitPrice,0.35(java.math.BigDecimal)] (SQL Exception while executing the following:INSERT INTO public.SHIPMENT_COST_ESTIMATE (SHIPMENT_COST_ESTIMATE_ID, SHIPMENT_METHOD_TYPE_ID, CARRIER_PARTY_ID, CARRIER_ROLE_TYPE_ID, PRODUCT_STORE_SHIP_METH_ID, PRODUCT_STORE_ID, PARTY_ID, ROLE_TYPE_ID, GEO_ID_TO, GEO_ID_FROM, WEIGHT_BREAK_ID, WEIGHT_UOM_ID, WEIGHT_UNIT_PRICE, QUANTITY_BREAK_ID, QUANTITY_UOM_ID, QUANTITY_UNIT_PRICE, PRICE_BREAK_ID, PRICE_UOM_ID, PRICE_UNIT_PRICE, ORDER_FLAT_PRICE, ORDER_PRICE_PERCENT, ORDER_ITEM_FLAT_PRICE, SHIPPING_PRICE_PERCENT, PRODUCT_FEATURE_GROUP_ID, OVERSIZE_UNIT, OVERSIZE_PRICE, FEATURE_PERCENT, FEATURE_PRICE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: insert or update on table "shipment_cost_estimate" violates foreign key constraint "shpmnt_ce_cshmth"
  Detail: Key (shipment_method_type_id, carrier_party_id, carrier_role_type_id)=(NEXT_DAY, UPS, CARRIER) is not present in table "carrier_shipment_method".)) (Error while inserting: [GenericEntity:ShipmentCostEstimate][carrierPartyId,UPS(java.lang.String)][carrierRoleTypeId,CARRIER(java.lang.String)][createdStamp,2015-05-12 22:21:45.269(java.sql.Timestamp)][createdTxStamp,2015-05-12 22:21:44.021(java.sql.Timestamp)][lastUpdatedStamp,2015-05-12 22:21:45.269(java.sql.Timestamp)][lastUpdatedTxStamp,2015-05-12 22:21:44.021(java.sql.Timestamp)][orderFlatPrice,10.0(java.math.BigDecimal)][orderItemFlatPrice,0.0(java.math.BigDecimal)][orderPricePercent,0.0(java.math.BigDecimal)][productStoreId,9000(java.lang.String)][productStoreShipMethId,9003(java.lang.String)][shipmentCostEstimateId,10103(java.lang.String)][shipmentMethodTypeId,NEXT_DAY(java.lang.String)][weightBreakId,9002(java.lang.String)][weightUnitPrice,0.35(java.math.BigDecimal)] (SQL Exception while executing the following:INSERT INTO public.SHIPMENT_COST_ESTIMATE (SHIPMENT_COST_ESTIMATE_ID, SHIPMENT_METHOD_TYPE_ID, CARRIER_PARTY_ID, CARRIER_ROLE_TYPE_ID, PRODUCT_STORE_SHIP_METH_ID, PRODUCT_STORE_ID, PARTY_ID, ROLE_TYPE_ID, GEO_ID_TO, GEO_ID_FROM, WEIGHT_BREAK_ID, WEIGHT_UOM_ID, WEIGHT_UNIT_PRICE, QUANTITY_BREAK_ID, QUANTITY_UOM_ID, QUANTITY_UNIT_PRICE, PRICE_BREAK_ID, PRICE_UOM_ID, PRICE_UNIT_PRICE, ORDER_FLAT_PRICE, ORDER_PRICE_PERCENT, ORDER_ITEM_FLAT_PRICE, SHIPPING_PRICE_PERCENT, PRODUCT_FEATURE_GROUP_ID, OVERSIZE_UNIT, OVERSIZE_PRICE, FEATURE_PERCENT, FEATURE_PRICE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: insert or update on table "shipment_cost_estimate" violates foreign key constraint "shpmnt_ce_cshmth"
  Detail: Key (shipment_method_type_id, carrier_party_id, carrier_role_type_id)=(NEXT_DAY, UPS, CARRIER) is not present in table "carrier_shipment_method".))))

[mandeepmavi]

Hi friends, i am getting error while setting up Product store with seed data. Are my posts visible to all of you.

[mandeepmavi]

Is Patch OFBIZ-5949.patch for this error