[
https://issues.apache.org/jira/browse/OFBIZ-12608?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17928019#comment-17928019
]
ASF subversion and git services commented on OFBIZ-12608:
---------------------------------------------------------
Commit 37fe4cc5d5ccb151805af87a966c47aac93c7586 in ofbiz-framework's branch
refs/heads/release24.09 from Jacques Le Roux
[ https://gitbox.apache.org/repos/asf?p=ofbiz-framework.git;h=37fe4cc5d5 ]
Fixed: OFBiz Setup failing to setup the product store (OFBIZ-13211)
In a clan installation, the Product Store screen in OFBiz Setup fails to update.
The method createProductStoreWithDefaultSetting is expecting the table
ShipmentMethodType to be empty to insert the seed data from
OfbizSetupShippingData.xml.
But because OFBIZ-12608 introduced new seed data that inserts one record in
ShipmentMethodType, the condition expecting the table to be empty is not met
anymore and then the shipping data is not initialized.
Thanks: Carlos Guzman
jleroux: while at it update ofbiz-setup.adoc. We no longer use Ant.
> No way to input shipment carrier information while creating purchase order
> --------------------------------------------------------------------------
>
> Key: OFBIZ-12608
> URL: https://issues.apache.org/jira/browse/OFBIZ-12608
> Project: OFBiz
> Issue Type: Bug
> Components: order
> Affects Versions: 18.12.05
> Environment: Ubuntu 20.04 LTS
> PostgreSQL 12
> Reporter: Xiguang Wang
> Assignee: Daniel Watford
> Priority: Major
> Fix For: 22.01.01
>
>
> Hi Community,
>
> We've deployed ofbiz 18.12.05 on our own server and are trying to use it
> without much development.
>
> Today I tested the "New Purchase Order" function. The first steps are fine.
> But with the final step "Create Order", the system threw an exception saying
> shipment/carrier information was missing. I looked through the UI and didn't
> find any place to input shipment/carrier information. I think it should be a
> bug with the default UI.
>
> I modified OrderServices.java and added these code as a workaround:
> {code:java}
> if (valueObj.get("carrierRoleTypeId") == null) {
> valueObj.set("carrierRoleTypeId", "CARRIER");
> + valueObj.set("carrierPartyId", "SFEXPRESS");
> + valueObj.set("shipmentMethodTypeId", "SFEXPRESS_STD");
> }{code}
>
> SFEXPRESS is an existing carrier I added to the system earlier. This code
> works fine.
>
> The debug information is attached as below.
> {code:java}
> 20:57:17.387 [QUIET] [system.out] Detail: Key (shipment_method_type_id,
> carrier_party_id, carrier_role_type_id)=(STANDARD, _NA_, CARRIER) is not
> present in table "carrier_shipment_method".)) (Error while inserting:
> [GenericEntity:OrderItemShipGroup][carrierPartyId,_NA_(java.lang.String)][carrierRoleTypeId,CARRIER(java.lang.String)][contactMechId,10010(java.lang.String)][createdStamp,2022-04-28
> 20:57:17.357(java.sql.Timestamp)][createdTxStamp,2022-04-28
> 20:57:17.311(java.sql.Timestamp)][estimatedDeliveryDate,2022-04-28
> 00:00:00.0(java.sql.Timestamp)][facilityId,10000(java.lang.String)][giftMessage,null()][isGift,N(java.lang.String)][lastUpdatedStamp,2022-04-28
> 20:57:17.357(java.sql.Timestamp)][lastUpdatedTxStamp,2022-04-28
> 20:57:17.311(java.sql.Timestamp)][maySplit,N(java.lang.String)][orderId,SO2204170486(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
> public.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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
> ?) (ERROR: insert or update on table "order_item_ship_group" violates foreign
> key constraint "order_itsg_cshm"
> 20:57:17.413 [QUIET] [system.out] Caused by: java.lang.Exception: Current
> Location Stack
> 20:57:17.413 [QUIET] [system.out] at
> org.apache.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:185)
> ~[ofbiz.jar:?]
> 20:57:17.413 [QUIET] [system.out] at
> org.apache.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:112)
> ~[ofbiz.jar:?]
> 20:57:17.413 [QUIET] [system.out] at
> org.apache.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:66)
> ~[ofbiz.jar:?]
> 20:57:17.413 [QUIET] [system.out] at
> org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:874)
> ~[ofbiz.jar:?]
> 20:57:17.413 [QUIET] [system.out] at
> org.apache.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1323)
> ~[ofbiz.jar:?]
> 20:57:17.413 [QUIET] [system.out] at
> org.apache.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1279)
> ~[ofbiz.jar:?]
> 20:57:17.413 [QUIET] [system.out] at
> org.apache.ofbiz.order.order.OrderServices.createOrder(OrderServices.java:1035)
> ~[ofbiz.jar:?]
> 20:57:17.413 [QUIET] [system.out] at
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_292]
> 20:57:17.413 [QUIET] [system.out] at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> ~[?:1.8.0_292]
> 20:57:17.413 [QUIET] [system.out] at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> ~[?:1.8.0_292]
> 20:57:17.413 [QUIET] [system.out] at
> java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_292]
> 20:57:17.413 [QUIET] [system.out] at
> org.apache.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100)
> ~[ofbiz.jar:?]
> 20:57:17.413 [QUIET] [system.out] at
> org.apache.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57)
> ~[ofbiz.jar:?]
> 20:57:17.413 [QUIET] [system.out] at
> org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:415)
> ~[ofbiz.jar:?]
> 20:57:17.414 [QUIET] [system.out] at
> org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:240)
> ~[ofbiz.jar:?]
> 20:57:17.414 [QUIET] [system.out] at
> org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:88)
> ~[ofbiz.jar:?]
> 20:57:17.414 [QUIET] [system.out] at
> org.apache.ofbiz.order.shoppingcart.CheckOutHelper.createOrder(CheckOutHelper.java:613)
> ~[ofbiz.jar:?]
> 20:57:17.414 [QUIET] [system.out] at
> org.apache.ofbiz.order.shoppingcart.CheckOutEvents.createOrder(CheckOutEvents.java:488)
> ~[ofbiz.jar:?]
> 20:57:17.414 [QUIET] [system.out] at
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_292]
> 20:57:17.414 [QUIET] [system.out] at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> ~[?:1.8.0_292]
> 20:57:17.414 [QUIET] [system.out] at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> ~[?:1.8.0_292]
> 20:57:17.414 [QUIET] [system.out] at
> java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_292]
> 20:57:17.414 [QUIET] [system.out] at
> org.apache.ofbiz.webapp.event.JavaEventHandler.invoke(JavaEventHandler.java:86)
> ~[ofbiz.jar:?]
> 20:57:17.414 [QUIET] [system.out] ... 39 more{code}
>
> I hope it is enough for devs to locate the bug. Thanks for your patience and
> looking forward to any comments.
>
> James.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
