ofbiz-notifications mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Wolfgang Rauchholz (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (OFBIZ-10893) Problems reading the database, please try again.ERROR: Could not create order
Date Mon, 01 Apr 2019 07:43:00 GMT

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

Mime
View raw message