[
https://issues.apache.org/jira/browse/OFBIZ-10893?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16806486#comment-16806486
]
Wolfgang Rauchholz commented on OFBIZ-10893:
--------------------------------------------
Scenario: ecommerce order, drop-ship.
To answer your questions:
* Expected result: Sales order and a back-to-back purchase order created
through the eCommerce module.
* Same error with Derby and mysql setup
* Actual result: no order is created
* Working with standard OfBiz, no code change.
* Can reproduce the error when entering a sales order through ecommerce and
Order module.
Addtl information:
* Error produces when at the end hitting the buttom 'Submit Order'
* Same error occurs when order is entered through 'Order' module.
* Requirement Method Enum Id for product is set to 'Drop-ship' only. Inventory
for product is 0.
* Supplier for this part is setup and 'Contact Purpose' of 'Shipping Origin
Address' in part manager is set.
* URL is: https://www.wo-lar.com:8443/ecomseo/processorder?checkoutpage=quick
* Error message mentioned failure to create 'Order Item Ship Group'. There is
no seperate setup for 'Order Item Ship Group' required as I know.
Complete error message:
The Following Errors Occurred:
Problem accessing the Product entityERROR: Could not create order (problem
invoking the service:
org.apache.ofbiz.entity.transaction.GenericTransactionException: The current
transaction is marked for rollback, not beginning a new transaction and
aborting current operation; the rollbackOnly was caused by: Failure in create
operation for entity [OrderItemShipGroup]:
org.apache.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:OrderItemShipGroup][carrierPartyId,_NA_(java.lang.String)][carrierRoleTypeId,CARRIER(java.lang.String)][contactMechId,10005(java.lang.String)][createdStamp,2019-04-01
09:27:46.916(java.sql.Timestamp)][createdTxStamp,2019-04-01
09:27:46.811(java.sql.Timestamp)][facilityId,null()][giftMessage,(java.lang.String)][isGift,N(java.lang.String)][lastUpdatedStamp,2019-04-01
09:27:46.916(java.sql.Timestamp)][lastUpdatedTxStamp,2019-04-01
09:27:46.811(java.sql.Timestamp)][maySplit,Y(java.lang.String)][orderId,WS10013(java.lang.String)][shipAfterDate,null()][shipByDate,null()][shipGroupSeqId,00001(java.lang.String)][shipmentMethodTypeId,NO_SHIPPING(java.lang.String)][shippingInstructions,(java.lang.String)][supplierPartyId,null()][telecomContactMechId,null()][vendorPartyId,null()]
(SQL Exception while executing the following:INSERT INTO ORDER_ITEM_SHIP_GROUP
(ORDER_ID, SHIP_GROUP_SEQ_ID, SHIPMENT_METHOD_TYPE_ID, SUPPLIER_PARTY_ID,
VENDOR_PARTY_ID, CARRIER_PARTY_ID, CARRIER_ROLE_TYPE_ID, FACILITY_ID,
CONTACT_MECH_ID, TELECOM_CONTACT_MECH_ID, TRACKING_NUMBER,
SHIPPING_INSTRUCTIONS, MAY_SPLIT, GIFT_MESSAGE, IS_GIFT, SHIP_AFTER_DATE,
SHIP_BY_DATE, ESTIMATED_SHIP_DATE, ESTIMATED_DELIVERY_DATE, 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`.`ORDER_ITEM_SHIP_GROUP`,
CONSTRAINT `ORDER_ITSG_CSHM` FOREIGN KEY (`SHIPMENT_METHOD_TYPE_ID`,
`CARRIER_PARTY_ID`, `CARRIER_ROLE_TYPE_ID`) REFERENCES
`CARRIER_SHIPMENT_METHOD` (`SHIPMEN))). Rolling back
transaction.org.apache.ofbiz.entity.GenericEntityException: Error while
inserting:
[GenericEntity:OrderItemShipGroup][carrierPartyId,_NA_(java.lang.String)][carrierRoleTypeId,CARRIER(java.lang.String)][contactMechId,10005(java.lang.String)][createdStamp,2019-04-01
09:27:46.916(java.sql.Timestamp)][createdTxStamp,2019-04-01
09:27:46.811(java.sql.Timestamp)][facilityId,null()][giftMessage,(java.lang.String)][isGift,N(java.lang.String)][lastUpdatedStamp,2019-04-01
09:27:46.916(java.sql.Timestamp)][lastUpdatedTxStamp,2019-04-01
09:27:46.811(java.sql.Timestamp)][maySplit,Y(java.lang.String)][orderId,WS10013(java.lang.String)][shipAfterDate,null()][shipByDate,null()][shipGroupSeqId,00001(java.lang.String)][shipmentMethodTypeId,NO_SHIPPING(java.lang.String)][shippingInstructions,(java.lang.String)][supplierPartyId,null()][telecomContactMechId,null()][vendorPartyId,null()]
(SQL Exception while executing the following:INSERT INTO ORDER_ITEM_SHIP_GROUP
(ORDER_ID, SHIP_GROUP_SEQ_ID, SHIPMENT_METHOD_TYPE_ID, SUPPLIER_PARTY_ID,
VENDOR_PARTY_ID, CARRIER_PARTY_ID, CARRIER_ROLE_TYPE_ID, FACILITY_ID,
CONTACT_MECH_ID, TELECOM_CONTACT_MECH_ID, TRACKING_NUMBER,
SHIPPING_INSTRUCTIONS, MAY_SPLIT, GIFT_MESSAGE, IS_GIFT, SHIP_AFTER_DATE,
SHIP_BY_DATE, ESTIMATED_SHIP_DATE, ESTIMATED_DELIVERY_DATE, 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`.`ORDER_ITEM_SHIP_GROUP`,
CONSTRAINT `ORDER_ITSG_CSHM` FOREIGN KEY (`SHIPMENT_METHOD_TYPE_ID`,
`CARRIER_PARTY_ID`, `CARRIER_ROLE_TYPE_ID`) REFERENCES
`CARRIER_SHIPMENT_METHOD` (`SHIPMEN))) (Error while inserting:
[GenericEntity:OrderItemShipGroup][carrierPartyId,_NA_(java.lang.String)][carrierRoleTypeId,CARRIER(java.lang.String)][contactMechId,10005(java.lang.String)][createdStamp,2019-04-01
09:27:46.916(java.sql.Timestamp)][createdTxStamp,2019-04-01
09:27:46.811(java.sql.Timestamp)][facilityId,null()][giftMessage,(java.lang.String)][isGift,N(java.lang.String)][lastUpdatedStamp,2019-04-01
09:27:46.916(java.sql.Timestamp)][lastUpdatedTxStamp,2019-04-01
09:27:46.811(java.sql.Timestamp)][maySplit,Y(java.lang.String)][orderId,WS10013(java.lang.String)][shipAfterDate,null()][shipByDate,null()][shipGroupSeqId,00001(java.lang.String)][shipmentMethodTypeId,NO_SHIPPING(java.lang.String)][shippingInstructions,(java.lang.String)][supplierPartyId,null()][telecomContactMechId,null()][vendorPartyId,null()]
(SQL Exception while executing the following:INSERT INTO ORDER_ITEM_SHIP_GROUP
(ORDER_ID, SHIP_GROUP_SEQ_ID, SHIPMENT_METHOD_TYPE_ID, SUPPLIER_PARTY_ID,
VENDOR_PARTY_ID, CARRIER_PARTY_ID, CARRIER_ROLE_TYPE_ID, FACILITY_ID,
CONTACT_MECH_ID, TELECOM_CONTACT_MECH_ID, TRACKING_NUMBER,
SHIPPING_INSTRUCTIONS, MAY_SPLIT, GIFT_MESSAGE, IS_GIFT, SHIP_AFTER_DATE,
SHIP_BY_DATE, ESTIMATED_SHIP_DATE, ESTIMATED_DELIVERY_DATE, 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`.`ORDER_ITEM_SHIP_GROUP`,
CONSTRAINT `ORDER_ITSG_CSHM` FOREIGN KEY (`SHIPMENT_METHOD_TYPE_ID`,
`CARRIER_PARTY_ID`, `CARRIER_ROLE_TYPE_ID`) REFERENCES
`CARRIER_SHIPMENT_METHOD` (`SHIPMEN)))) (The current transaction is marked for
rollback, not beginning a new transaction and aborting current operation; the
rollbackOnly was caused by: Failure in create operation for entity
[OrderItemShipGroup]: org.apache.ofbiz.entity.GenericEntityException: Error
while inserting:
[GenericEntity:OrderItemShipGroup][carrierPartyId,_NA_(java.lang.String)][carrierRoleTypeId,CARRIER(java.lang.String)][contactMechId,10005(java.lang.String)][createdStamp,2019-04-01
09:27:46.916(java.sql.Timestamp)][createdTxStamp,2019-04-01
09:27:46.811(java.sql.Timestamp)][facilityId,null()][giftMessage,(java.lang.String)][isGift,N(java.lang.String)][lastUpdatedStamp,2019-04-01
09:27:46.916(java.sql.Timestamp)][lastUpdatedTxStamp,2019-04-01
09:27:46.811(java.sql.Timestamp)][maySplit,Y(java.lang.String)][orderId,WS10013(java.lang.String)][shipAfterDate,null()][shipByDate,null()][shipGroupSeqId,00001(java.lang.String)][shipmentMethodTypeId,NO_SHIPPING(java.lang.String)][shippingInstructions,(java.lang.String)][supplierPartyId,null()][telecomContactMechId,null()][vendorPartyId,null()]
(SQL Exception while executing the following:INSERT INTO ORDER_ITEM_SHIP_GROUP
(ORDER_ID, SHIP_GROUP_SEQ_ID, SHIPMENT_METHOD_TYPE_ID, SUPPLIER_PARTY_ID,
VENDOR_PARTY_ID, CARRIER_PARTY_ID, CARRIER_ROLE_TYPE_ID, FACILITY_ID,
CONTACT_MECH_ID, TELECOM_CONTACT_MECH_ID, TRACKING_NUMBER,
SHIPPING_INSTRUCTIONS, MAY_SPLIT, GIFT_MESSAGE, IS_GIFT, SHIP_AFTER_DATE,
SHIP_BY_DATE, ESTIMATED_SHIP_DATE, ESTIMATED_DELIVERY_DATE, 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`.`ORDER_ITEM_SHIP_GROUP`,
CONSTRAINT `ORDER_ITSG_CSHM` FOREIGN KEY (`SHIPMENT_METHOD_TYPE_ID`,
`CARRIER_PARTY_ID`, `CARRIER_ROLE_TYPE_ID`) REFERENCES
`CARRIER_SHIPMENT_METHOD` (`SHIPMEN))). Rolling back
transaction.org.apache.ofbiz.entity.GenericEntityException: Error while
inserting:
[GenericEntity:OrderItemShipGroup][carrierPartyId,_NA_(java.lang.String)][carrierRoleTypeId,CARRIER(java.lang.String)][contactMechId,10005(java.lang.String)][createdStamp,2019-04-01
09:27:46.916(java.sql.Timestamp)][createdTxStamp,2019-04-01
09:27:46.811(java.sql.Timestamp)][facilityId,null()][giftMessage,(java.lang.String)][isGift,N(java.lang.String)][lastUpdatedStamp,2019-04-01
09:27:46.916(java.sql.Timestamp)][lastUpdatedTxStamp,2019-04-01
09:27:46.811(java.sql.Timestamp)][maySplit,Y(java.lang.String)][orderId,WS10013(java.lang.String)][shipAfterDate,null()][shipByDate,null()][shipGroupSeqId,00001(java.lang.String)][shipmentMethodTypeId,NO_SHIPPING(java.lang.String)][shippingInstructions,(java.lang.String)][supplierPartyId,null()][telecomContactMechId,null()][vendorPartyId,null()]
(SQL Exception while executing the following:INSERT INTO ORDER_ITEM_SHIP_GROUP
(ORDER_ID, SHIP_GROUP_SEQ_ID, SHIPMENT_METHOD_TYPE_ID, SUPPLIER_PARTY_ID,
VENDOR_PARTY_ID, CARRIER_PARTY_ID, CARRIER_ROLE_TYPE_ID, FACILITY_ID,
CONTACT_MECH_ID, TELECOM_CONTACT_MECH_ID, TRACKING_NUMBER,
SHIPPING_INSTRUCTIONS, MAY_SPLIT, GIFT_MESSAGE, IS_GIFT, SHIP_AFTER_DATE,
SHIP_BY_DATE, ESTIMATED_SHIP_DATE, ESTIMATED_DELIVERY_DATE, 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`.`ORDER_ITEM_SHIP_GROUP`,
CONSTRAINT `ORDER_ITSG_CSHM` FOREIGN KEY (`SHIPMENT_METHOD_TYPE_ID`,
`CARRIER_PARTY_ID`, `CARRIER_ROLE_TYPE_ID`) REFERENCES
`CARRIER_SHIPMENT_METHOD` (`SHIPMEN))) (Error while inserting:
[GenericEntity:OrderItemShipGroup][carrierPartyId,_NA_(java.lang.String)][carrierRoleTypeId,CARRIER(java.lang.String)][contactMechId,10005(java.lang.String)][createdStamp,2019-04-01
09:27:46.916(java.sql.Timestamp)][createdTxStamp,2019-04-01
09:27:46.811(java.sql.Timestamp)][facilityId,null()][giftMessage,(java.lang.String)][isGift,N(java.lang.String)][lastUpdatedStamp,2019-04-01
09:27:46.916(java.sql.Timestamp)][lastUpdatedTxStamp,2019-04-01
09:27:46.811(java.sql.Timestamp)][maySplit,Y(java.lang.String)][orderId,WS10013(java.lang.String)][shipAfterDate,null()][shipByDate,null()][shipGroupSeqId,00001(java.lang.String)][shipmentMethodTypeId,NO_SHIPPING(java.lang.String)][shippingInstructions,(java.lang.String)][supplierPartyId,null()][telecomContactMechId,null()][vendorPartyId,null()]
(SQL Exception while executing the following:INSERT INTO ORDER_ITEM_SHIP_GROUP
(ORDER_ID, SHIP_GROUP_SEQ_ID, SHIPMENT_METHOD_TYPE_ID, SUPPLIER_PARTY_ID,
VENDOR_PARTY_ID, CARRIER_PARTY_ID, CARRIER_ROLE_TYPE_ID, FACILITY_ID,
CONTACT_MECH_ID, TELECOM_CONTACT_MECH_ID, TRACKING_NUMBER,
SHIPPING_INSTRUCTIONS, MAY_SPLIT, GIFT_MESSAGE, IS_GIFT, SHIP_AFTER_DATE,
SHIP_BY_DATE, ESTIMATED_SHIP_DATE, ESTIMATED_DELIVERY_DATE, 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`.`ORDER_ITEM_SHIP_GROUP`,
CONSTRAINT `ORDER_ITSG_CSHM` FOREIGN KEY (`SHIPMENT_METHOD_TYPE_ID`,
`CARRIER_PARTY_ID`, `CARRIER_ROLE_TYPE_ID`) REFERENCES
`CARRIER_SHIPMENT_METHOD` (`SHIPMEN))))))
Collapse
Valid CSS! Valid XHTML 1.0!
> Problems reading the database, please try again.ERROR: Could not create order
> -----------------------------------------------------------------------------
>
> Key: OFBIZ-10893
> URL: https://issues.apache.org/jira/browse/OFBIZ-10893
> Project: OFBiz
> Issue Type: Bug
> Components: ecommerce
> Affects Versions: 17.12.01
> Reporter: Wolfgang Rauchholz
> Priority: Major
>
> I get this error message after 'Final Checkout Review and hitting buttom
> 'Submit Order'
> Process stops there.
>
> The Following Errors Occurred:
> Problem accessing the Product entityERROR: No se pudo crear el pedido
> (problema invocando al servicio:
> org.apache.ofbiz.entity.transaction.GenericTransactionException: The current
> transaction is marked for rollback, not beginning a new transaction and
> aborting current operation; the rollbackOnly was caused by: Failure in create
> operation for entity [OrderItemShipGroup]:
> org.apache.ofbiz.entity.GenericEntityException: Error while inserting:
> [GenericEntity:OrderItemShipGroup][carrierPartyId,_NA_(java.lang.String)][carrierRoleTypeId,CARRIER(java.lang.String)][contactMechId,........
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
