Hi Jeff, This issue looks like it matches https://issues.apache.org/jira/browse/OFBIZ-12608 and is due to some missing seed data.
The missing data is included in the full demo dataset which is loaded into OFBiz during setup with the following command: ./gradlew loadAll This error is caused by a missing Shipment Method Type. In the demo instance, you can view Shipment Method Types here: OFBiz: Catalog Manager: List Shipment Method Types (apache.org) <https://demo-next.ofbiz.apache.org/catalog/control/ListShipmentMethodTypes> There also needs to be a Party configured with ID, '_NA_' and assigned the role, CARRIER. The missing entities were recently moved to seed data as part of fixing OFBIZ-12608. You can view the missing entities in this file: https://github.com/apache/ofbiz-framework/blob/trunk/applications/order/data/PurchaseOrderShippingSeedData.xml. You can use the WebTool to import that file as a fix for your environment. HTH Dan. On Wed, 14 Dec 2022 at 03:45, [email protected] <[email protected]> wrote: > Hello Community, > > I was creating a "Purchase Order". On the page 'Purchase Order : Order > Confirmation' and clicked on the button 'Create Order'. The following error > occurred. > I would like to know what I missed for the input. > Regards, > Jeff > > I got the following error: > > Did not complete the order, the following occurred:ERROR : Could not > create order > (write error :org.apache.ofbiz.entity.GenericEntityException: > org.apache.ofbiz.entity.GenericEntityException: Error while inserting: > [GenericEntity:OrderItemShipGroup][carrierPartyId,_NA_(java.lang.String)][carrierRoleTypeId,CARRIER(java.lang.String)][contactMechId,10060(java.lang.String)][createdStamp,2022-12-14 > 11:32:34.763(java.sql.Timestamp)][createdTxStamp,2022-12-14 > 11:32:34.667(java.sql.Timestamp)][estimatedDeliveryDate,2022-12-16 > 00:00:00.0(java.sql.Timestamp)][facilityId,10001(java.lang.String)][giftMessage,null()][isGift,N(java.lang.String)][lastUpdatedStamp,2022-12-14 > 11:32:34.763(java.sql.Timestamp)][lastUpdatedTxStamp,2022-12-14 > 11:32:34.667(java.sql.Timestamp)][maySplit,N(java.lang.String)][orderId,101(java.lang.String)][shipAfterDate,null()][shipByDate,null()][shipGroupSeqId,00001(java.lang.String)][shipmentMethodTypeId,STANDARD(java.lang.String)] > [shippingInstructions,null()][supplierAgreementId,null()][supplierPartyId,null()][telecomContactMechId,null()][vendorPartyId,null()] > (SQL Exception while executing the following:INSERT INTO > OFBIZ.ORDER_ITEM_SHIP_GROUP > (ORDER_ID, SHIP_GROUP_SEQ_ID, SHIPMENT_METHOD_TYPE_ID, SUPPLIER_PARTY_ID, > SUPPLIER_AGREEMENT_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 (?, ?, ?, ?, > ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on > table 'ORDER_ITEM_SHIP_GROUP' caused a violation of foreign key constraint > 'ORDER_ITSG_CSHM'for key (STANDARD,_NA_,CARRIER). The statement has been > rolled back.)) > -- Daniel Watford
