[jira] [Created] (OFBIZ-12608) No way to input shipment carrier information while creating purchase order
Xiguang Wang created OFBIZ-12608:
Summary: 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
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,1(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,1(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
[jira] [Updated] (OFBIZ-12607) MRP Fails to Run
[
https://issues.apache.org/jira/browse/OFBIZ-12607?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Steven Payne updated OFBIZ-12607:
-
Affects Version/s: 18.12.05
> MRP Fails to Run
>
>
> Key: OFBIZ-12607
> URL: https://issues.apache.org/jira/browse/OFBIZ-12607
> Project: OFBiz
> Issue Type: Bug
> Components: manufacturing
>Affects Versions: 18.12.03, 18.12.05
> Environment: Windows 10
> MySQL
>Reporter: Steven Payne
>Assignee: Nicolas Malin
>Priority: Major
> Labels: mrp
> Attachments: Facility.xml, ProductFacility.xml, WorkEffort2.txt,
> WorkEffortGoodStandard.xml, image-2022-04-27-08-01-32-251.png
>
>
> The MRP module fails to run.
>
> It seems to be related to loading the WEGS_CREATED status items in the
> WorkEffortGoodStandard table. When I load the database tables into the newest
> version of OFBiz (18.12.05) I need to exclude certain lines from the table in
> order to get the MRP to run.
>
> See below screen shot: (image-2022-04-27-08-01-32-251.png)
> !image-2022-04-27-08-01-32-251.png!
> The error from the log is below:
> 2022-04-27 07:59:53,600 |OFBiz-JobQueue-26 |ServiceDispatcher |E| Error in
> Service [createRequirementStatus]: Error doing entity-auto operation for
> entity RequirementStatus in service createRequirementStatus:
> org.apache.ofbiz.entity.GenericEntityException:
> org.apache.ofbiz.entity.GenericEntityException: Error while inserting:
> [GenericEntity:RequirementStatus][changeByUserLoginId,admin(java.lang.String)][createdStamp,2022-04-27
> 07:59:53.528(java.sql.Timestamp)][createdTxStamp,2022-04-27
> 07:59:53.527(java.sql.Timestamp)][lastUpdatedStamp,2022-04-27
> 07:59:53.528(java.sql.Timestamp)][lastUpdatedTxStamp,2022-04-27
> 07:59:53.527(java.sql.Timestamp)][requirementId,38541(java.lang.String)][statusDate,2022-04-27
> 07:59:53.528(java.sql.Timestamp)][statusId,REQ_PROPOSED(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO REQUIREMENT_STATUS
> (REQUIREMENT_ID, STATUS_ID, STATUS_DATE, CHANGE_BY_USER_LOGIN_ID,
> 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)) (Error while inserting:
> [GenericEntity:RequirementStatus][changeByUserLoginId,admin(java.lang.String)][createdStamp,2022-04-27
> 07:59:53.528(java.sql.Timestamp)][createdTxStamp,2022-04-27
> 07:59:53.527(java.sql.Timestamp)][lastUpdatedStamp,2022-04-27
> 07:59:53.528(java.sql.Timestamp)][lastUpdatedTxStamp,2022-04-27
> 07:59:53.527(java.sql.Timestamp)][requirementId,38541(java.lang.String)][statusDate,2022-04-27
> 07:59:53.528(java.sql.Timestamp)][statusId,REQ_PROPOSED(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO REQUIREMENT_STATUS
> (REQUIREMENT_ID, STATUS_ID, STATUS_DATE, CHANGE_BY_USER_LOGIN_ID,
> 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)))
> 2022-04-27 07:59:53,600 |OFBiz-JobQueue-26 |GenericServiceJob |E|
> Async-Service failed.
> java.lang.Exception: Error during creation or update MrpEvent, parameters:
> {reInitialize=true,
> userLogin=[GenericEntity:UserLogin][createdStamp,2019-07-17
> 12:31:03.524(java.sql.Timestamp)][createdTxStamp,2019-07-17
> 12:31:03.446(java.sql.Timestamp)][currentPassword,$SHA$ZOC.$A9uGqmZa8CQRqKoqEuVp1jT-Hbw(java.lang.String)][disabledDateTime,2022-04-18
>
> 10:54:33.972(java.sql.Timestamp)][enabled,Y(java.lang.String)][hasLoggedOut,N(java.lang.String)][lastLocale,en_CA(java.lang.String)][lastTimeZone,America/Vancouver(java.lang.String)][lastUpdatedStamp,2022-04-27
> 07:56:44.265(java.sql.Timestamp)][lastUpdatedTxStamp,2022-04-27
> 07:56:44.265(java.sql.Timestamp)][requirePasswordChange,N(java.lang.String)][successiveFailedLogins,0(java.lang.Long)][userLoginId,admin(java.lang.String)],
> manufacturingFacilityId=ACS_Kamloops, mrpId=10408, facilityId=ACS_Kamloops,
> defaultYearsOffset=1}
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
[jira] [Comment Edited] (OFBIZ-12607) MRP Fails to Run
[
https://issues.apache.org/jira/browse/OFBIZ-12607?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17529448#comment-17529448
]
Steven Payne edited comment on OFBIZ-12607 at 4/28/22 5:37 PM:
---
Thanks Nicolas.
Sorry Jacques, I figured since this stopped production here it was a blocker.
I'll keep that in mind for the future.
I have added the 4 tables that broke the MRP. I had to reduce the size of the
workEffort table in order to meet the 60MB max file size limitation.
was (Author: JIRAUSER288733):
Thanks Nicolas.
Sorry Jacques, I figured since this stopped production here it was a blocker.
I'll keep that in mind for the future.
I have added three of the 4 tables that broke the MRP. I can't add the
workEffort.xml file as it is over the 60MB limit.
> MRP Fails to Run
>
>
> Key: OFBIZ-12607
> URL: https://issues.apache.org/jira/browse/OFBIZ-12607
> Project: OFBiz
> Issue Type: Bug
> Components: manufacturing
>Affects Versions: 18.12.03
> Environment: Windows 10
> MySQL
>Reporter: Steven Payne
>Assignee: Nicolas Malin
>Priority: Major
> Labels: mrp
> Attachments: Facility.xml, ProductFacility.xml, WorkEffort2.txt,
> WorkEffortGoodStandard.xml, image-2022-04-27-08-01-32-251.png
>
>
> The MRP module fails to run.
>
> It seems to be related to loading the WEGS_CREATED status items in the
> WorkEffortGoodStandard table. When I load the database tables into the newest
> version of OFBiz (18.12.05) I need to exclude certain lines from the table in
> order to get the MRP to run.
>
> See below screen shot: (image-2022-04-27-08-01-32-251.png)
> !image-2022-04-27-08-01-32-251.png!
> The error from the log is below:
> 2022-04-27 07:59:53,600 |OFBiz-JobQueue-26 |ServiceDispatcher |E| Error in
> Service [createRequirementStatus]: Error doing entity-auto operation for
> entity RequirementStatus in service createRequirementStatus:
> org.apache.ofbiz.entity.GenericEntityException:
> org.apache.ofbiz.entity.GenericEntityException: Error while inserting:
> [GenericEntity:RequirementStatus][changeByUserLoginId,admin(java.lang.String)][createdStamp,2022-04-27
> 07:59:53.528(java.sql.Timestamp)][createdTxStamp,2022-04-27
> 07:59:53.527(java.sql.Timestamp)][lastUpdatedStamp,2022-04-27
> 07:59:53.528(java.sql.Timestamp)][lastUpdatedTxStamp,2022-04-27
> 07:59:53.527(java.sql.Timestamp)][requirementId,38541(java.lang.String)][statusDate,2022-04-27
> 07:59:53.528(java.sql.Timestamp)][statusId,REQ_PROPOSED(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO REQUIREMENT_STATUS
> (REQUIREMENT_ID, STATUS_ID, STATUS_DATE, CHANGE_BY_USER_LOGIN_ID,
> 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)) (Error while inserting:
> [GenericEntity:RequirementStatus][changeByUserLoginId,admin(java.lang.String)][createdStamp,2022-04-27
> 07:59:53.528(java.sql.Timestamp)][createdTxStamp,2022-04-27
> 07:59:53.527(java.sql.Timestamp)][lastUpdatedStamp,2022-04-27
> 07:59:53.528(java.sql.Timestamp)][lastUpdatedTxStamp,2022-04-27
> 07:59:53.527(java.sql.Timestamp)][requirementId,38541(java.lang.String)][statusDate,2022-04-27
> 07:59:53.528(java.sql.Timestamp)][statusId,REQ_PROPOSED(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO REQUIREMENT_STATUS
> (REQUIREMENT_ID, STATUS_ID, STATUS_DATE, CHANGE_BY_USER_LOGIN_ID,
> 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)))
> 2022-04-27 07:59:53,600 |OFBiz-JobQueue-26 |GenericServiceJob |E|
> Async-Service failed.
> java.lang.Exception: Error during creation or update MrpEvent, parameters:
> {reInitialize=true,
> userLogin=[GenericEntity:UserLogin][createdStamp,2019-07-17
> 12:31:03.524(java.sql.Timestamp)][createdTxStamp,2019-07-17
> 12:31:03.446(java.sql.Timestamp)][currentPassword,$SHA$ZOC.$A9uGqmZa8CQRqKoqEuVp1jT-Hbw(java.lang.String)][disabledDateTime,2022-04-18
>
> 10:54:33.972(java.sql.Timestamp)][enabled,Y(java.lang.String)][hasLoggedOut,N(java.lang.String)][lastLocale,en_CA(java.lang.String)][lastTimeZone,America/Vancouver(java.lang.String)][lastUpdatedStamp,2022-04-27
> 07:56:44.265(java.sql.Timestamp)][lastUpdatedTxStamp,2022-04-27
> 07:56:44.265(java.sql.Timestamp)][requirePasswordChange,N(java.lang.String)][successiveFailedLogins,0(java.lang.Long)][userLoginId,admin(java.lang.String)],
> manufacturingFacilityId=ACS_Kamloops, mrpId=10408, facilityId=ACS_Kamloops,
> defaultYearsOffset=1}
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
[jira] [Updated] (OFBIZ-12607) MRP Fails to Run
[
https://issues.apache.org/jira/browse/OFBIZ-12607?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Steven Payne updated OFBIZ-12607:
-
Attachment: WorkEffort2.txt
> MRP Fails to Run
>
>
> Key: OFBIZ-12607
> URL: https://issues.apache.org/jira/browse/OFBIZ-12607
> Project: OFBiz
> Issue Type: Bug
> Components: manufacturing
>Affects Versions: 18.12.03
> Environment: Windows 10
> MySQL
>Reporter: Steven Payne
>Assignee: Nicolas Malin
>Priority: Major
> Labels: mrp
> Attachments: Facility.xml, ProductFacility.xml, WorkEffort2.txt,
> WorkEffortGoodStandard.xml, image-2022-04-27-08-01-32-251.png
>
>
> The MRP module fails to run.
>
> It seems to be related to loading the WEGS_CREATED status items in the
> WorkEffortGoodStandard table. When I load the database tables into the newest
> version of OFBiz (18.12.05) I need to exclude certain lines from the table in
> order to get the MRP to run.
>
> See below screen shot: (image-2022-04-27-08-01-32-251.png)
> !image-2022-04-27-08-01-32-251.png!
> The error from the log is below:
> 2022-04-27 07:59:53,600 |OFBiz-JobQueue-26 |ServiceDispatcher |E| Error in
> Service [createRequirementStatus]: Error doing entity-auto operation for
> entity RequirementStatus in service createRequirementStatus:
> org.apache.ofbiz.entity.GenericEntityException:
> org.apache.ofbiz.entity.GenericEntityException: Error while inserting:
> [GenericEntity:RequirementStatus][changeByUserLoginId,admin(java.lang.String)][createdStamp,2022-04-27
> 07:59:53.528(java.sql.Timestamp)][createdTxStamp,2022-04-27
> 07:59:53.527(java.sql.Timestamp)][lastUpdatedStamp,2022-04-27
> 07:59:53.528(java.sql.Timestamp)][lastUpdatedTxStamp,2022-04-27
> 07:59:53.527(java.sql.Timestamp)][requirementId,38541(java.lang.String)][statusDate,2022-04-27
> 07:59:53.528(java.sql.Timestamp)][statusId,REQ_PROPOSED(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO REQUIREMENT_STATUS
> (REQUIREMENT_ID, STATUS_ID, STATUS_DATE, CHANGE_BY_USER_LOGIN_ID,
> 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)) (Error while inserting:
> [GenericEntity:RequirementStatus][changeByUserLoginId,admin(java.lang.String)][createdStamp,2022-04-27
> 07:59:53.528(java.sql.Timestamp)][createdTxStamp,2022-04-27
> 07:59:53.527(java.sql.Timestamp)][lastUpdatedStamp,2022-04-27
> 07:59:53.528(java.sql.Timestamp)][lastUpdatedTxStamp,2022-04-27
> 07:59:53.527(java.sql.Timestamp)][requirementId,38541(java.lang.String)][statusDate,2022-04-27
> 07:59:53.528(java.sql.Timestamp)][statusId,REQ_PROPOSED(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO REQUIREMENT_STATUS
> (REQUIREMENT_ID, STATUS_ID, STATUS_DATE, CHANGE_BY_USER_LOGIN_ID,
> 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)))
> 2022-04-27 07:59:53,600 |OFBiz-JobQueue-26 |GenericServiceJob |E|
> Async-Service failed.
> java.lang.Exception: Error during creation or update MrpEvent, parameters:
> {reInitialize=true,
> userLogin=[GenericEntity:UserLogin][createdStamp,2019-07-17
> 12:31:03.524(java.sql.Timestamp)][createdTxStamp,2019-07-17
> 12:31:03.446(java.sql.Timestamp)][currentPassword,$SHA$ZOC.$A9uGqmZa8CQRqKoqEuVp1jT-Hbw(java.lang.String)][disabledDateTime,2022-04-18
>
> 10:54:33.972(java.sql.Timestamp)][enabled,Y(java.lang.String)][hasLoggedOut,N(java.lang.String)][lastLocale,en_CA(java.lang.String)][lastTimeZone,America/Vancouver(java.lang.String)][lastUpdatedStamp,2022-04-27
> 07:56:44.265(java.sql.Timestamp)][lastUpdatedTxStamp,2022-04-27
> 07:56:44.265(java.sql.Timestamp)][requirePasswordChange,N(java.lang.String)][successiveFailedLogins,0(java.lang.Long)][userLoginId,admin(java.lang.String)],
> manufacturingFacilityId=ACS_Kamloops, mrpId=10408, facilityId=ACS_Kamloops,
> defaultYearsOffset=1}
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
[jira] [Comment Edited] (OFBIZ-12607) MRP Fails to Run
[
https://issues.apache.org/jira/browse/OFBIZ-12607?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17529448#comment-17529448
]
Steven Payne edited comment on OFBIZ-12607 at 4/28/22 4:17 PM:
---
Thanks Nicolas.
Sorry Jacques, I figured since this stopped production here it was a blocker.
I'll keep that in mind for the future.
I have added three of the 4 tables that broke the MRP. I can't add the
workEffort.xml file as it is over the 60MB limit.
was (Author: JIRAUSER288733):
Thanks Nicolas.
Sorry Jacques, I figured since this stopped production here it was a blocker.
I'll keep that in mind for the future.
I can also provide a copy of the database if you'd like.
> MRP Fails to Run
>
>
> Key: OFBIZ-12607
> URL: https://issues.apache.org/jira/browse/OFBIZ-12607
> Project: OFBiz
> Issue Type: Bug
> Components: manufacturing
>Affects Versions: 18.12.03
> Environment: Windows 10
> MySQL
>Reporter: Steven Payne
>Assignee: Nicolas Malin
>Priority: Major
> Labels: mrp
> Attachments: Facility.xml, ProductFacility.xml,
> WorkEffortGoodStandard.xml, image-2022-04-27-08-01-32-251.png
>
>
> The MRP module fails to run.
>
> It seems to be related to loading the WEGS_CREATED status items in the
> WorkEffortGoodStandard table. When I load the database tables into the newest
> version of OFBiz (18.12.05) I need to exclude certain lines from the table in
> order to get the MRP to run.
>
> See below screen shot: (image-2022-04-27-08-01-32-251.png)
> !image-2022-04-27-08-01-32-251.png!
> The error from the log is below:
> 2022-04-27 07:59:53,600 |OFBiz-JobQueue-26 |ServiceDispatcher |E| Error in
> Service [createRequirementStatus]: Error doing entity-auto operation for
> entity RequirementStatus in service createRequirementStatus:
> org.apache.ofbiz.entity.GenericEntityException:
> org.apache.ofbiz.entity.GenericEntityException: Error while inserting:
> [GenericEntity:RequirementStatus][changeByUserLoginId,admin(java.lang.String)][createdStamp,2022-04-27
> 07:59:53.528(java.sql.Timestamp)][createdTxStamp,2022-04-27
> 07:59:53.527(java.sql.Timestamp)][lastUpdatedStamp,2022-04-27
> 07:59:53.528(java.sql.Timestamp)][lastUpdatedTxStamp,2022-04-27
> 07:59:53.527(java.sql.Timestamp)][requirementId,38541(java.lang.String)][statusDate,2022-04-27
> 07:59:53.528(java.sql.Timestamp)][statusId,REQ_PROPOSED(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO REQUIREMENT_STATUS
> (REQUIREMENT_ID, STATUS_ID, STATUS_DATE, CHANGE_BY_USER_LOGIN_ID,
> 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)) (Error while inserting:
> [GenericEntity:RequirementStatus][changeByUserLoginId,admin(java.lang.String)][createdStamp,2022-04-27
> 07:59:53.528(java.sql.Timestamp)][createdTxStamp,2022-04-27
> 07:59:53.527(java.sql.Timestamp)][lastUpdatedStamp,2022-04-27
> 07:59:53.528(java.sql.Timestamp)][lastUpdatedTxStamp,2022-04-27
> 07:59:53.527(java.sql.Timestamp)][requirementId,38541(java.lang.String)][statusDate,2022-04-27
> 07:59:53.528(java.sql.Timestamp)][statusId,REQ_PROPOSED(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO REQUIREMENT_STATUS
> (REQUIREMENT_ID, STATUS_ID, STATUS_DATE, CHANGE_BY_USER_LOGIN_ID,
> 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)))
> 2022-04-27 07:59:53,600 |OFBiz-JobQueue-26 |GenericServiceJob |E|
> Async-Service failed.
> java.lang.Exception: Error during creation or update MrpEvent, parameters:
> {reInitialize=true,
> userLogin=[GenericEntity:UserLogin][createdStamp,2019-07-17
> 12:31:03.524(java.sql.Timestamp)][createdTxStamp,2019-07-17
> 12:31:03.446(java.sql.Timestamp)][currentPassword,$SHA$ZOC.$A9uGqmZa8CQRqKoqEuVp1jT-Hbw(java.lang.String)][disabledDateTime,2022-04-18
>
> 10:54:33.972(java.sql.Timestamp)][enabled,Y(java.lang.String)][hasLoggedOut,N(java.lang.String)][lastLocale,en_CA(java.lang.String)][lastTimeZone,America/Vancouver(java.lang.String)][lastUpdatedStamp,2022-04-27
> 07:56:44.265(java.sql.Timestamp)][lastUpdatedTxStamp,2022-04-27
> 07:56:44.265(java.sql.Timestamp)][requirePasswordChange,N(java.lang.String)][successiveFailedLogins,0(java.lang.Long)][userLoginId,admin(java.lang.String)],
> manufacturingFacilityId=ACS_Kamloops, mrpId=10408, facilityId=ACS_Kamloops,
> defaultYearsOffset=1}
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
[jira] [Updated] (OFBIZ-12607) MRP Fails to Run
[
https://issues.apache.org/jira/browse/OFBIZ-12607?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Steven Payne updated OFBIZ-12607:
-
Attachment: WorkEffortGoodStandard.xml
ProductFacility.xml
Facility.xml
> MRP Fails to Run
>
>
> Key: OFBIZ-12607
> URL: https://issues.apache.org/jira/browse/OFBIZ-12607
> Project: OFBiz
> Issue Type: Bug
> Components: manufacturing
>Affects Versions: 18.12.03
> Environment: Windows 10
> MySQL
>Reporter: Steven Payne
>Assignee: Nicolas Malin
>Priority: Major
> Labels: mrp
> Attachments: Facility.xml, ProductFacility.xml,
> WorkEffortGoodStandard.xml, image-2022-04-27-08-01-32-251.png
>
>
> The MRP module fails to run.
>
> It seems to be related to loading the WEGS_CREATED status items in the
> WorkEffortGoodStandard table. When I load the database tables into the newest
> version of OFBiz (18.12.05) I need to exclude certain lines from the table in
> order to get the MRP to run.
>
> See below screen shot: (image-2022-04-27-08-01-32-251.png)
> !image-2022-04-27-08-01-32-251.png!
> The error from the log is below:
> 2022-04-27 07:59:53,600 |OFBiz-JobQueue-26 |ServiceDispatcher |E| Error in
> Service [createRequirementStatus]: Error doing entity-auto operation for
> entity RequirementStatus in service createRequirementStatus:
> org.apache.ofbiz.entity.GenericEntityException:
> org.apache.ofbiz.entity.GenericEntityException: Error while inserting:
> [GenericEntity:RequirementStatus][changeByUserLoginId,admin(java.lang.String)][createdStamp,2022-04-27
> 07:59:53.528(java.sql.Timestamp)][createdTxStamp,2022-04-27
> 07:59:53.527(java.sql.Timestamp)][lastUpdatedStamp,2022-04-27
> 07:59:53.528(java.sql.Timestamp)][lastUpdatedTxStamp,2022-04-27
> 07:59:53.527(java.sql.Timestamp)][requirementId,38541(java.lang.String)][statusDate,2022-04-27
> 07:59:53.528(java.sql.Timestamp)][statusId,REQ_PROPOSED(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO REQUIREMENT_STATUS
> (REQUIREMENT_ID, STATUS_ID, STATUS_DATE, CHANGE_BY_USER_LOGIN_ID,
> 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)) (Error while inserting:
> [GenericEntity:RequirementStatus][changeByUserLoginId,admin(java.lang.String)][createdStamp,2022-04-27
> 07:59:53.528(java.sql.Timestamp)][createdTxStamp,2022-04-27
> 07:59:53.527(java.sql.Timestamp)][lastUpdatedStamp,2022-04-27
> 07:59:53.528(java.sql.Timestamp)][lastUpdatedTxStamp,2022-04-27
> 07:59:53.527(java.sql.Timestamp)][requirementId,38541(java.lang.String)][statusDate,2022-04-27
> 07:59:53.528(java.sql.Timestamp)][statusId,REQ_PROPOSED(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO REQUIREMENT_STATUS
> (REQUIREMENT_ID, STATUS_ID, STATUS_DATE, CHANGE_BY_USER_LOGIN_ID,
> 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)))
> 2022-04-27 07:59:53,600 |OFBiz-JobQueue-26 |GenericServiceJob |E|
> Async-Service failed.
> java.lang.Exception: Error during creation or update MrpEvent, parameters:
> {reInitialize=true,
> userLogin=[GenericEntity:UserLogin][createdStamp,2019-07-17
> 12:31:03.524(java.sql.Timestamp)][createdTxStamp,2019-07-17
> 12:31:03.446(java.sql.Timestamp)][currentPassword,$SHA$ZOC.$A9uGqmZa8CQRqKoqEuVp1jT-Hbw(java.lang.String)][disabledDateTime,2022-04-18
>
> 10:54:33.972(java.sql.Timestamp)][enabled,Y(java.lang.String)][hasLoggedOut,N(java.lang.String)][lastLocale,en_CA(java.lang.String)][lastTimeZone,America/Vancouver(java.lang.String)][lastUpdatedStamp,2022-04-27
> 07:56:44.265(java.sql.Timestamp)][lastUpdatedTxStamp,2022-04-27
> 07:56:44.265(java.sql.Timestamp)][requirePasswordChange,N(java.lang.String)][successiveFailedLogins,0(java.lang.Long)][userLoginId,admin(java.lang.String)],
> manufacturingFacilityId=ACS_Kamloops, mrpId=10408, facilityId=ACS_Kamloops,
> defaultYearsOffset=1}
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
[jira] [Comment Edited] (OFBIZ-12607) MRP Fails to Run
[
https://issues.apache.org/jira/browse/OFBIZ-12607?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17529448#comment-17529448
]
Steven Payne edited comment on OFBIZ-12607 at 4/28/22 1:55 PM:
---
Thanks Nicolas.
Sorry Jacques, I figured since this stopped production here it was a blocker.
I'll keep that in mind for the future.
I can also provide a copy of the database if you'd like.
was (Author: JIRAUSER288733):
Thanks Nicolas.
Sorry Jacques, I figured since this stopped production here it was a blocker.
I'll keep that in mind for the future.
> MRP Fails to Run
>
>
> Key: OFBIZ-12607
> URL: https://issues.apache.org/jira/browse/OFBIZ-12607
> Project: OFBiz
> Issue Type: Bug
> Components: manufacturing
>Affects Versions: 18.12.03
> Environment: Windows 10
> MySQL
>Reporter: Steven Payne
>Assignee: Nicolas Malin
>Priority: Major
> Labels: mrp
> Attachments: image-2022-04-27-08-01-32-251.png
>
>
> The MRP module fails to run.
>
> It seems to be related to loading the WEGS_CREATED status items in the
> WorkEffortGoodStandard table. When I load the database tables into the newest
> version of OFBiz (18.12.05) I need to exclude certain lines from the table in
> order to get the MRP to run.
>
> See below screen shot: (image-2022-04-27-08-01-32-251.png)
> !image-2022-04-27-08-01-32-251.png!
> The error from the log is below:
> 2022-04-27 07:59:53,600 |OFBiz-JobQueue-26 |ServiceDispatcher |E| Error in
> Service [createRequirementStatus]: Error doing entity-auto operation for
> entity RequirementStatus in service createRequirementStatus:
> org.apache.ofbiz.entity.GenericEntityException:
> org.apache.ofbiz.entity.GenericEntityException: Error while inserting:
> [GenericEntity:RequirementStatus][changeByUserLoginId,admin(java.lang.String)][createdStamp,2022-04-27
> 07:59:53.528(java.sql.Timestamp)][createdTxStamp,2022-04-27
> 07:59:53.527(java.sql.Timestamp)][lastUpdatedStamp,2022-04-27
> 07:59:53.528(java.sql.Timestamp)][lastUpdatedTxStamp,2022-04-27
> 07:59:53.527(java.sql.Timestamp)][requirementId,38541(java.lang.String)][statusDate,2022-04-27
> 07:59:53.528(java.sql.Timestamp)][statusId,REQ_PROPOSED(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO REQUIREMENT_STATUS
> (REQUIREMENT_ID, STATUS_ID, STATUS_DATE, CHANGE_BY_USER_LOGIN_ID,
> 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)) (Error while inserting:
> [GenericEntity:RequirementStatus][changeByUserLoginId,admin(java.lang.String)][createdStamp,2022-04-27
> 07:59:53.528(java.sql.Timestamp)][createdTxStamp,2022-04-27
> 07:59:53.527(java.sql.Timestamp)][lastUpdatedStamp,2022-04-27
> 07:59:53.528(java.sql.Timestamp)][lastUpdatedTxStamp,2022-04-27
> 07:59:53.527(java.sql.Timestamp)][requirementId,38541(java.lang.String)][statusDate,2022-04-27
> 07:59:53.528(java.sql.Timestamp)][statusId,REQ_PROPOSED(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO REQUIREMENT_STATUS
> (REQUIREMENT_ID, STATUS_ID, STATUS_DATE, CHANGE_BY_USER_LOGIN_ID,
> 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)))
> 2022-04-27 07:59:53,600 |OFBiz-JobQueue-26 |GenericServiceJob |E|
> Async-Service failed.
> java.lang.Exception: Error during creation or update MrpEvent, parameters:
> {reInitialize=true,
> userLogin=[GenericEntity:UserLogin][createdStamp,2019-07-17
> 12:31:03.524(java.sql.Timestamp)][createdTxStamp,2019-07-17
> 12:31:03.446(java.sql.Timestamp)][currentPassword,$SHA$ZOC.$A9uGqmZa8CQRqKoqEuVp1jT-Hbw(java.lang.String)][disabledDateTime,2022-04-18
>
> 10:54:33.972(java.sql.Timestamp)][enabled,Y(java.lang.String)][hasLoggedOut,N(java.lang.String)][lastLocale,en_CA(java.lang.String)][lastTimeZone,America/Vancouver(java.lang.String)][lastUpdatedStamp,2022-04-27
> 07:56:44.265(java.sql.Timestamp)][lastUpdatedTxStamp,2022-04-27
> 07:56:44.265(java.sql.Timestamp)][requirePasswordChange,N(java.lang.String)][successiveFailedLogins,0(java.lang.Long)][userLoginId,admin(java.lang.String)],
> manufacturingFacilityId=ACS_Kamloops, mrpId=10408, facilityId=ACS_Kamloops,
> defaultYearsOffset=1}
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
[jira] [Commented] (OFBIZ-12607) MRP Fails to Run
[
https://issues.apache.org/jira/browse/OFBIZ-12607?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17529448#comment-17529448
]
Steven Payne commented on OFBIZ-12607:
--
Thanks Nicolas.
Sorry Jacques, I figured since this stopped production here it was a blocker.
I'll keep that in mind for the future.
> MRP Fails to Run
>
>
> Key: OFBIZ-12607
> URL: https://issues.apache.org/jira/browse/OFBIZ-12607
> Project: OFBiz
> Issue Type: Bug
> Components: manufacturing
>Affects Versions: 18.12.03
> Environment: Windows 10
> MySQL
>Reporter: Steven Payne
>Assignee: Nicolas Malin
>Priority: Major
> Labels: mrp
> Attachments: image-2022-04-27-08-01-32-251.png
>
>
> The MRP module fails to run.
>
> It seems to be related to loading the WEGS_CREATED status items in the
> WorkEffortGoodStandard table. When I load the database tables into the newest
> version of OFBiz (18.12.05) I need to exclude certain lines from the table in
> order to get the MRP to run.
>
> See below screen shot: (image-2022-04-27-08-01-32-251.png)
> !image-2022-04-27-08-01-32-251.png!
> The error from the log is below:
> 2022-04-27 07:59:53,600 |OFBiz-JobQueue-26 |ServiceDispatcher |E| Error in
> Service [createRequirementStatus]: Error doing entity-auto operation for
> entity RequirementStatus in service createRequirementStatus:
> org.apache.ofbiz.entity.GenericEntityException:
> org.apache.ofbiz.entity.GenericEntityException: Error while inserting:
> [GenericEntity:RequirementStatus][changeByUserLoginId,admin(java.lang.String)][createdStamp,2022-04-27
> 07:59:53.528(java.sql.Timestamp)][createdTxStamp,2022-04-27
> 07:59:53.527(java.sql.Timestamp)][lastUpdatedStamp,2022-04-27
> 07:59:53.528(java.sql.Timestamp)][lastUpdatedTxStamp,2022-04-27
> 07:59:53.527(java.sql.Timestamp)][requirementId,38541(java.lang.String)][statusDate,2022-04-27
> 07:59:53.528(java.sql.Timestamp)][statusId,REQ_PROPOSED(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO REQUIREMENT_STATUS
> (REQUIREMENT_ID, STATUS_ID, STATUS_DATE, CHANGE_BY_USER_LOGIN_ID,
> 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)) (Error while inserting:
> [GenericEntity:RequirementStatus][changeByUserLoginId,admin(java.lang.String)][createdStamp,2022-04-27
> 07:59:53.528(java.sql.Timestamp)][createdTxStamp,2022-04-27
> 07:59:53.527(java.sql.Timestamp)][lastUpdatedStamp,2022-04-27
> 07:59:53.528(java.sql.Timestamp)][lastUpdatedTxStamp,2022-04-27
> 07:59:53.527(java.sql.Timestamp)][requirementId,38541(java.lang.String)][statusDate,2022-04-27
> 07:59:53.528(java.sql.Timestamp)][statusId,REQ_PROPOSED(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO REQUIREMENT_STATUS
> (REQUIREMENT_ID, STATUS_ID, STATUS_DATE, CHANGE_BY_USER_LOGIN_ID,
> 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)))
> 2022-04-27 07:59:53,600 |OFBiz-JobQueue-26 |GenericServiceJob |E|
> Async-Service failed.
> java.lang.Exception: Error during creation or update MrpEvent, parameters:
> {reInitialize=true,
> userLogin=[GenericEntity:UserLogin][createdStamp,2019-07-17
> 12:31:03.524(java.sql.Timestamp)][createdTxStamp,2019-07-17
> 12:31:03.446(java.sql.Timestamp)][currentPassword,$SHA$ZOC.$A9uGqmZa8CQRqKoqEuVp1jT-Hbw(java.lang.String)][disabledDateTime,2022-04-18
>
> 10:54:33.972(java.sql.Timestamp)][enabled,Y(java.lang.String)][hasLoggedOut,N(java.lang.String)][lastLocale,en_CA(java.lang.String)][lastTimeZone,America/Vancouver(java.lang.String)][lastUpdatedStamp,2022-04-27
> 07:56:44.265(java.sql.Timestamp)][lastUpdatedTxStamp,2022-04-27
> 07:56:44.265(java.sql.Timestamp)][requirePasswordChange,N(java.lang.String)][successiveFailedLogins,0(java.lang.Long)][userLoginId,admin(java.lang.String)],
> manufacturingFacilityId=ACS_Kamloops, mrpId=10408, facilityId=ACS_Kamloops,
> defaultYearsOffset=1}
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
[jira] [Updated] (OFBIZ-12607) MRP Fails to Run
[
https://issues.apache.org/jira/browse/OFBIZ-12607?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jacques Le Roux updated OFBIZ-12607:
Priority: Major (was: Blocker)
Changing Priority from Blocker to Major. We use Blocker to block releases, this
is not sufficient to block one
> MRP Fails to Run
>
>
> Key: OFBIZ-12607
> URL: https://issues.apache.org/jira/browse/OFBIZ-12607
> Project: OFBiz
> Issue Type: Bug
> Components: manufacturing
>Affects Versions: 18.12.03
> Environment: Windows 10
> MySQL
>Reporter: Steven Payne
>Assignee: Nicolas Malin
>Priority: Major
> Labels: mrp
> Attachments: image-2022-04-27-08-01-32-251.png
>
>
> The MRP module fails to run.
>
> It seems to be related to loading the WEGS_CREATED status items in the
> WorkEffortGoodStandard table. When I load the database tables into the newest
> version of OFBiz (18.12.05) I need to exclude certain lines from the table in
> order to get the MRP to run.
>
> See below screen shot: (image-2022-04-27-08-01-32-251.png)
> !image-2022-04-27-08-01-32-251.png!
> The error from the log is below:
> 2022-04-27 07:59:53,600 |OFBiz-JobQueue-26 |ServiceDispatcher |E| Error in
> Service [createRequirementStatus]: Error doing entity-auto operation for
> entity RequirementStatus in service createRequirementStatus:
> org.apache.ofbiz.entity.GenericEntityException:
> org.apache.ofbiz.entity.GenericEntityException: Error while inserting:
> [GenericEntity:RequirementStatus][changeByUserLoginId,admin(java.lang.String)][createdStamp,2022-04-27
> 07:59:53.528(java.sql.Timestamp)][createdTxStamp,2022-04-27
> 07:59:53.527(java.sql.Timestamp)][lastUpdatedStamp,2022-04-27
> 07:59:53.528(java.sql.Timestamp)][lastUpdatedTxStamp,2022-04-27
> 07:59:53.527(java.sql.Timestamp)][requirementId,38541(java.lang.String)][statusDate,2022-04-27
> 07:59:53.528(java.sql.Timestamp)][statusId,REQ_PROPOSED(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO REQUIREMENT_STATUS
> (REQUIREMENT_ID, STATUS_ID, STATUS_DATE, CHANGE_BY_USER_LOGIN_ID,
> 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)) (Error while inserting:
> [GenericEntity:RequirementStatus][changeByUserLoginId,admin(java.lang.String)][createdStamp,2022-04-27
> 07:59:53.528(java.sql.Timestamp)][createdTxStamp,2022-04-27
> 07:59:53.527(java.sql.Timestamp)][lastUpdatedStamp,2022-04-27
> 07:59:53.528(java.sql.Timestamp)][lastUpdatedTxStamp,2022-04-27
> 07:59:53.527(java.sql.Timestamp)][requirementId,38541(java.lang.String)][statusDate,2022-04-27
> 07:59:53.528(java.sql.Timestamp)][statusId,REQ_PROPOSED(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO REQUIREMENT_STATUS
> (REQUIREMENT_ID, STATUS_ID, STATUS_DATE, CHANGE_BY_USER_LOGIN_ID,
> 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)))
> 2022-04-27 07:59:53,600 |OFBiz-JobQueue-26 |GenericServiceJob |E|
> Async-Service failed.
> java.lang.Exception: Error during creation or update MrpEvent, parameters:
> {reInitialize=true,
> userLogin=[GenericEntity:UserLogin][createdStamp,2019-07-17
> 12:31:03.524(java.sql.Timestamp)][createdTxStamp,2019-07-17
> 12:31:03.446(java.sql.Timestamp)][currentPassword,$SHA$ZOC.$A9uGqmZa8CQRqKoqEuVp1jT-Hbw(java.lang.String)][disabledDateTime,2022-04-18
>
> 10:54:33.972(java.sql.Timestamp)][enabled,Y(java.lang.String)][hasLoggedOut,N(java.lang.String)][lastLocale,en_CA(java.lang.String)][lastTimeZone,America/Vancouver(java.lang.String)][lastUpdatedStamp,2022-04-27
> 07:56:44.265(java.sql.Timestamp)][lastUpdatedTxStamp,2022-04-27
> 07:56:44.265(java.sql.Timestamp)][requirePasswordChange,N(java.lang.String)][successiveFailedLogins,0(java.lang.Long)][userLoginId,admin(java.lang.String)],
> manufacturingFacilityId=ACS_Kamloops, mrpId=10408, facilityId=ACS_Kamloops,
> defaultYearsOffset=1}
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
[jira] [Commented] (OFBIZ-12606) Screen projectmgr main is taking long time to load when projects are more
[
https://issues.apache.org/jira/browse/OFBIZ-12606?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17529361#comment-17529361
]
Jacques Le Roux commented on OFBIZ-12606:
-
Hi Pierre,
You 1st comment makes totally sense, thanks
> Screen projectmgr main is taking long time to load when projects are more
> --
>
> Key: OFBIZ-12606
> URL: https://issues.apache.org/jira/browse/OFBIZ-12606
> Project: OFBiz
> Issue Type: Bug
> Components: projectmgr
>Affects Versions: 18.12.05
>Reporter: Balaji Yendamuri
>Priority: Minor
> Fix For: 18.12.06
>
>
> When projects are more than 1000 main screen of projectmgr component is
> taking very long time to load
> Currently it is loading all available projects in one shot and there is
> "{*}ProjectIsBillable{*}.{*}groovy{*}"
> which is calling in row-actions
> *Solution* : We can use performFind service to increase performance in this
> screen
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
[jira] [Commented] (OFBIZ-12606) Screen projectmgr main is taking long time to load when projects are more
[
https://issues.apache.org/jira/browse/OFBIZ-12606?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17529356#comment-17529356
]
Balaji Yendamuri commented on OFBIZ-12606:
--
yes , even i am seeing projectIsBillable.groovy is not much usefull here
I use performFind and fetch records with status "PRJ_ACTIVE"
> Screen projectmgr main is taking long time to load when projects are more
> --
>
> Key: OFBIZ-12606
> URL: https://issues.apache.org/jira/browse/OFBIZ-12606
> Project: OFBiz
> Issue Type: Bug
> Components: projectmgr
>Affects Versions: 18.12.05
>Reporter: Balaji Yendamuri
>Priority: Minor
> Fix For: 18.12.06
>
>
> When projects are more than 1000 main screen of projectmgr component is
> taking very long time to load
> Currently it is loading all available projects in one shot and there is
> "{*}ProjectIsBillable{*}.{*}groovy{*}"
> which is calling in row-actions
> *Solution* : We can use performFind service to increase performance in this
> screen
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
[jira] [Commented] (OFBIZ-12606) Screen projectmgr main is taking long time to load when projects are more
[
https://issues.apache.org/jira/browse/OFBIZ-12606?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17529331#comment-17529331
]
Pierre Smits commented on OFBIZ-12606:
--
Also, for the overview shown in the main screen I would say that calling the
{*}ProjectIsBillable{*}.{*}groovy{*} to generate that overview is irrelevant.
> Screen projectmgr main is taking long time to load when projects are more
> --
>
> Key: OFBIZ-12606
> URL: https://issues.apache.org/jira/browse/OFBIZ-12606
> Project: OFBiz
> Issue Type: Bug
> Components: projectmgr
>Affects Versions: 18.12.05
>Reporter: Balaji Yendamuri
>Priority: Minor
> Fix For: 18.12.06
>
>
> When projects are more than 1000 main screen of projectmgr component is
> taking very long time to load
> Currently it is loading all available projects in one shot and there is
> "{*}ProjectIsBillable{*}.{*}groovy{*}"
> which is calling in row-actions
> *Solution* : We can use performFind service to increase performance in this
> screen
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
[jira] [Commented] (OFBIZ-12606) Screen projectmgr main is taking long time to load when projects are more
[
https://issues.apache.org/jira/browse/OFBIZ-12606?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17529326#comment-17529326
]
Pierre Smits commented on OFBIZ-12606:
--
With a huge number of projects records in the WorkEffort table, I can imagine
that a lot of those records have the status PRJ_CANCELED or PRJ_CLOSED.
Therefore it seems a good thing to only show the projects with status
PRJ_ACTIVE in the main screen, as there is already a screen to search and find
projects.
> Screen projectmgr main is taking long time to load when projects are more
> --
>
> Key: OFBIZ-12606
> URL: https://issues.apache.org/jira/browse/OFBIZ-12606
> Project: OFBiz
> Issue Type: Bug
> Components: projectmgr
>Affects Versions: 18.12.05
>Reporter: Balaji Yendamuri
>Priority: Minor
> Fix For: 18.12.06
>
>
> When projects are more than 1000 main screen of projectmgr component is
> taking very long time to load
> Currently it is loading all available projects in one shot and there is
> "{*}ProjectIsBillable{*}.{*}groovy{*}"
> which is calling in row-actions
> *Solution* : We can use performFind service to increase performance in this
> screen
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
[jira] [Commented] (OFBIZ-12607) MRP Fails to Run
[
https://issues.apache.org/jira/browse/OFBIZ-12607?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17529249#comment-17529249
]
Nicolas Malin commented on OFBIZ-12607:
---
Hello [~Payne530]
I try to have a look on it
> MRP Fails to Run
>
>
> Key: OFBIZ-12607
> URL: https://issues.apache.org/jira/browse/OFBIZ-12607
> Project: OFBiz
> Issue Type: Bug
> Components: manufacturing
>Affects Versions: 18.12.03
> Environment: Windows 10
> MySQL
>Reporter: Steven Payne
>Assignee: Nicolas Malin
>Priority: Blocker
> Labels: mrp
> Attachments: image-2022-04-27-08-01-32-251.png
>
>
> The MRP module fails to run.
>
> It seems to be related to loading the WEGS_CREATED status items in the
> WorkEffortGoodStandard table. When I load the database tables into the newest
> version of OFBiz (18.12.05) I need to exclude certain lines from the table in
> order to get the MRP to run.
>
> See below screen shot: (image-2022-04-27-08-01-32-251.png)
> !image-2022-04-27-08-01-32-251.png!
> The error from the log is below:
> 2022-04-27 07:59:53,600 |OFBiz-JobQueue-26 |ServiceDispatcher |E| Error in
> Service [createRequirementStatus]: Error doing entity-auto operation for
> entity RequirementStatus in service createRequirementStatus:
> org.apache.ofbiz.entity.GenericEntityException:
> org.apache.ofbiz.entity.GenericEntityException: Error while inserting:
> [GenericEntity:RequirementStatus][changeByUserLoginId,admin(java.lang.String)][createdStamp,2022-04-27
> 07:59:53.528(java.sql.Timestamp)][createdTxStamp,2022-04-27
> 07:59:53.527(java.sql.Timestamp)][lastUpdatedStamp,2022-04-27
> 07:59:53.528(java.sql.Timestamp)][lastUpdatedTxStamp,2022-04-27
> 07:59:53.527(java.sql.Timestamp)][requirementId,38541(java.lang.String)][statusDate,2022-04-27
> 07:59:53.528(java.sql.Timestamp)][statusId,REQ_PROPOSED(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO REQUIREMENT_STATUS
> (REQUIREMENT_ID, STATUS_ID, STATUS_DATE, CHANGE_BY_USER_LOGIN_ID,
> 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)) (Error while inserting:
> [GenericEntity:RequirementStatus][changeByUserLoginId,admin(java.lang.String)][createdStamp,2022-04-27
> 07:59:53.528(java.sql.Timestamp)][createdTxStamp,2022-04-27
> 07:59:53.527(java.sql.Timestamp)][lastUpdatedStamp,2022-04-27
> 07:59:53.528(java.sql.Timestamp)][lastUpdatedTxStamp,2022-04-27
> 07:59:53.527(java.sql.Timestamp)][requirementId,38541(java.lang.String)][statusDate,2022-04-27
> 07:59:53.528(java.sql.Timestamp)][statusId,REQ_PROPOSED(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO REQUIREMENT_STATUS
> (REQUIREMENT_ID, STATUS_ID, STATUS_DATE, CHANGE_BY_USER_LOGIN_ID,
> 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)))
> 2022-04-27 07:59:53,600 |OFBiz-JobQueue-26 |GenericServiceJob |E|
> Async-Service failed.
> java.lang.Exception: Error during creation or update MrpEvent, parameters:
> {reInitialize=true,
> userLogin=[GenericEntity:UserLogin][createdStamp,2019-07-17
> 12:31:03.524(java.sql.Timestamp)][createdTxStamp,2019-07-17
> 12:31:03.446(java.sql.Timestamp)][currentPassword,$SHA$ZOC.$A9uGqmZa8CQRqKoqEuVp1jT-Hbw(java.lang.String)][disabledDateTime,2022-04-18
>
> 10:54:33.972(java.sql.Timestamp)][enabled,Y(java.lang.String)][hasLoggedOut,N(java.lang.String)][lastLocale,en_CA(java.lang.String)][lastTimeZone,America/Vancouver(java.lang.String)][lastUpdatedStamp,2022-04-27
> 07:56:44.265(java.sql.Timestamp)][lastUpdatedTxStamp,2022-04-27
> 07:56:44.265(java.sql.Timestamp)][requirePasswordChange,N(java.lang.String)][successiveFailedLogins,0(java.lang.Long)][userLoginId,admin(java.lang.String)],
> manufacturingFacilityId=ACS_Kamloops, mrpId=10408, facilityId=ACS_Kamloops,
> defaultYearsOffset=1}
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
[jira] [Assigned] (OFBIZ-12607) MRP Fails to Run
[
https://issues.apache.org/jira/browse/OFBIZ-12607?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Nicolas Malin reassigned OFBIZ-12607:
-
Assignee: Nicolas Malin
> MRP Fails to Run
>
>
> Key: OFBIZ-12607
> URL: https://issues.apache.org/jira/browse/OFBIZ-12607
> Project: OFBiz
> Issue Type: Bug
> Components: manufacturing
>Affects Versions: 18.12.03
> Environment: Windows 10
> MySQL
>Reporter: Steven Payne
>Assignee: Nicolas Malin
>Priority: Blocker
> Labels: mrp
> Attachments: image-2022-04-27-08-01-32-251.png
>
>
> The MRP module fails to run.
>
> It seems to be related to loading the WEGS_CREATED status items in the
> WorkEffortGoodStandard table. When I load the database tables into the newest
> version of OFBiz (18.12.05) I need to exclude certain lines from the table in
> order to get the MRP to run.
>
> See below screen shot: (image-2022-04-27-08-01-32-251.png)
> !image-2022-04-27-08-01-32-251.png!
> The error from the log is below:
> 2022-04-27 07:59:53,600 |OFBiz-JobQueue-26 |ServiceDispatcher |E| Error in
> Service [createRequirementStatus]: Error doing entity-auto operation for
> entity RequirementStatus in service createRequirementStatus:
> org.apache.ofbiz.entity.GenericEntityException:
> org.apache.ofbiz.entity.GenericEntityException: Error while inserting:
> [GenericEntity:RequirementStatus][changeByUserLoginId,admin(java.lang.String)][createdStamp,2022-04-27
> 07:59:53.528(java.sql.Timestamp)][createdTxStamp,2022-04-27
> 07:59:53.527(java.sql.Timestamp)][lastUpdatedStamp,2022-04-27
> 07:59:53.528(java.sql.Timestamp)][lastUpdatedTxStamp,2022-04-27
> 07:59:53.527(java.sql.Timestamp)][requirementId,38541(java.lang.String)][statusDate,2022-04-27
> 07:59:53.528(java.sql.Timestamp)][statusId,REQ_PROPOSED(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO REQUIREMENT_STATUS
> (REQUIREMENT_ID, STATUS_ID, STATUS_DATE, CHANGE_BY_USER_LOGIN_ID,
> 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)) (Error while inserting:
> [GenericEntity:RequirementStatus][changeByUserLoginId,admin(java.lang.String)][createdStamp,2022-04-27
> 07:59:53.528(java.sql.Timestamp)][createdTxStamp,2022-04-27
> 07:59:53.527(java.sql.Timestamp)][lastUpdatedStamp,2022-04-27
> 07:59:53.528(java.sql.Timestamp)][lastUpdatedTxStamp,2022-04-27
> 07:59:53.527(java.sql.Timestamp)][requirementId,38541(java.lang.String)][statusDate,2022-04-27
> 07:59:53.528(java.sql.Timestamp)][statusId,REQ_PROPOSED(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO REQUIREMENT_STATUS
> (REQUIREMENT_ID, STATUS_ID, STATUS_DATE, CHANGE_BY_USER_LOGIN_ID,
> 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)))
> 2022-04-27 07:59:53,600 |OFBiz-JobQueue-26 |GenericServiceJob |E|
> Async-Service failed.
> java.lang.Exception: Error during creation or update MrpEvent, parameters:
> {reInitialize=true,
> userLogin=[GenericEntity:UserLogin][createdStamp,2019-07-17
> 12:31:03.524(java.sql.Timestamp)][createdTxStamp,2019-07-17
> 12:31:03.446(java.sql.Timestamp)][currentPassword,$SHA$ZOC.$A9uGqmZa8CQRqKoqEuVp1jT-Hbw(java.lang.String)][disabledDateTime,2022-04-18
>
> 10:54:33.972(java.sql.Timestamp)][enabled,Y(java.lang.String)][hasLoggedOut,N(java.lang.String)][lastLocale,en_CA(java.lang.String)][lastTimeZone,America/Vancouver(java.lang.String)][lastUpdatedStamp,2022-04-27
> 07:56:44.265(java.sql.Timestamp)][lastUpdatedTxStamp,2022-04-27
> 07:56:44.265(java.sql.Timestamp)][requirePasswordChange,N(java.lang.String)][successiveFailedLogins,0(java.lang.Long)][userLoginId,admin(java.lang.String)],
> manufacturingFacilityId=ACS_Kamloops, mrpId=10408, facilityId=ACS_Kamloops,
> defaultYearsOffset=1}
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
[jira] [Commented] (OFBIZ-12606) Screen projectmgr main is taking long time to load when projects are more
[
https://issues.apache.org/jira/browse/OFBIZ-12606?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17529237#comment-17529237
]
Jacques Le Roux commented on OFBIZ-12606:
-
Hi Balaji,
Sounds good to me, looking forward.
> Screen projectmgr main is taking long time to load when projects are more
> --
>
> Key: OFBIZ-12606
> URL: https://issues.apache.org/jira/browse/OFBIZ-12606
> Project: OFBiz
> Issue Type: Bug
> Components: projectmgr
>Affects Versions: 18.12.05
>Reporter: Balaji Yendamuri
>Priority: Minor
> Fix For: 18.12.06
>
>
> When projects are more than 1000 main screen of projectmgr component is
> taking very long time to load
> Currently it is loading all available projects in one shot and there is
> "{*}ProjectIsBillable{*}.{*}groovy{*}"
> which is calling in row-actions
> *Solution* : We can use performFind service to increase performance in this
> screen
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
