product store shipping method

[Siju.Ganapathy]

When i try to create a shipping method for a store it generating error like


The Following Errors Occurred:
ERROR: Could not complete the Creates a CarrierShipmentMethod [file:/C:/ofBiz/applications/product/script/org/ofbiz/shipment/shipment/ShipmentServices.xml#createCarrierShipmentMethod] process [problem creating the carrierShipmentMethod value: Error while inserting: [GenericEntity:CarrierShipmentMethod][carrierServiceCode,null()][createdStamp,2013-04-11 10:51:51.862(java.sql.Timestamp)][createdTxStamp,2013-04-11 10:51:51.862(java.sql.Timestamp)][lastUpdatedStamp,2013-04-11 10:51:51.862(java.sql.Timestamp)][lastUpdatedTxStamp,2013-04-11 10:51:51.862(java.sql.Timestamp)][partyId,10004(java.lang.String)][roleTypeId,PERSON_ROLE(java.lang.String)][sequenceNumber,null()][shipmentMethodTypeId,NormalShipping(java.lang.String)] (SQL Exception while executing the following:INSERT INTO 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 (?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot add or update a child row: a foreign key constraint fails (`ofbiz`.`carrier_shipment_method`, CONSTRAINT `CARR_SHMETH_PROLE` FOREIGN KEY (`PARTY_ID`, `ROLE_TYPE_ID`) REFERENCES `party_role` (`PARTY_ID`, `ROLE_TYPE_ID`))))]

[Malin Nicolas]

Hi Siju,

Add role PERSON_ROLE before to your party 10004
Nicolas

Le 11/04/2013 07:24, Siju.Ganapathy a écrit :

> When i try to create a shipping method for a store it generating error like
>
>
> The Following Errors Occurred:
> ERROR: Could not complete the Creates a CarrierShipmentMethod
> [file:/C:/ofBiz/applications/product/script/org/ofbiz/shipment/shipment/ShipmentServices.xml#createCarrierShipmentMethod]
> process [problem creating the carrierShipmentMethod value: Error while
> inserting:
> [GenericEntity:CarrierShipmentMethod][carrierServiceCode,null()][createdStamp,2013-04-11
> 10:51:51.862(java.sql.Timestamp)][createdTxStamp,2013-04-11
> 10:51:51.862(java.sql.Timestamp)][lastUpdatedStamp,2013-04-11
> 10:51:51.862(java.sql.Timestamp)][lastUpdatedTxStamp,2013-04-11
> 10:51:51.862(java.sql.Timestamp)][partyId,10004(java.lang.String)][roleTypeId,PERSON_ROLE(java.lang.String)][sequenceNumber,null()][shipmentMethodTypeId,NormalShipping(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO
> 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 (?, ?, ?, ?,
> ?, ?, ?, ?, ?) (Cannot add or update a child row: a foreign key constraint
> fails (`ofbiz`.`carrier_shipment_method`, CONSTRAINT `CARR_SHMETH_PROLE`
> FOREIGN KEY (`PARTY_ID`, `ROLE_TYPE_ID`) REFERENCES `party_role`
> (`PARTY_ID`, `ROLE_TYPE_ID`))))]
>
>
>
> --
> View this message in context: http://ofbiz.135035.n4.nabble.com/product-store-tp4640570.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.

--
Nicolas MALIN
Consultant
Tél : [phone]
Site projet : http://www.neogia.org/
-------
Société LibrenBerry
Tél : [phone]
Site : http://www.librenberry.net/