[OFBIZ-4381] ofbizsetup "INSERT CARRIER_SHIPMENT_METHOD" ERROR when new store is created

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: Release 10.04
• Component/s: commonext
• Assignee: Jacques Le Roux
• Reporter: Marcelo Giubergia
• Created: 29/Aug/11 21:04
• Updated: 05/Feb/12 22:00
• Resolved: 10/Sep/11 13:37

Description

I installed ofbiz from scratch according with recommended method

>ant clean-all
>ant run-install-extseed
>ant create-admin-setup
>./startofbiz.sh

Then, when I create an store by https://localhost:8443/ofbizsetup/control/createProductStore

Error: Error parsing entity xml file: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:CarrierShipmentMethod][createdStamp,2011-08-29 11:16:33.247(java.sql.Timestamp)][createdTxStamp,2011-08-29 11:16:32.951(java.sql.Timestamp)][lastUpdatedStamp,2011-08-29 11:16:33.247(java.sql.Timestamp)][lastUpdatedTxStamp,2011-08-29 11:16:32.951(java.sql.Timestamp)][partyId,sds(java.lang.String)][roleTypeId,CARRIER(java.lang.String)][sequenceNumber,4(java.lang.Long)][shipmentMethodTypeId,LOCAL_DELIVERY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.CARRIER_SHIPMENT_METHOD (SHIPMENT_METHOD_TYPE_ID, PARTY_ID, ROLE_TYPE_ID, SEQUENCE_NUMBER, CARRIER_SERVICE_CODE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: inserción o actualización en la tabla «carrier_shipment_method» viola la llave foránea «carr_shmeth_type»<br/> Detail: La llave (shipment_method_type_id)=(LOCAL_DELIVERY) no está presente en la tabla «shipment_method_type».)) calling service parseEntityXmlFile in importTempDataFile

Issue Links

• is related to: OFBIZ-4675 Incorrect fix applied in OFBIZ-4381