You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by "Siju.Ganapathy" <sh...@gmail.com> on 2013/04/11 07:24:29 UTC
product store
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.
Re: product store
Posted by Nicolas Malin <ma...@librenberry.net>.
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 : 06.17.66.40.06
Site projet : http://www.neogia.org/
-------
Société LibrenBerry
Tél : 02.48.02.56.12
Site : http://www.librenberry.net/