[jira] [Commented] (OFBIZ-10893) Problems reading the database, please try again.ERROR: Could not create order

["Wolfgang Rauchholz (JIRA)" <ji...@apache.org>]

    [ 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)