[OFBIZ-12607] MRP Fails to Run

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Not A Problem
• Affects Version/s: 18.12.03, 18.12.05
• Component/s: manufacturing
• Labels: mrp

Environment

Windows 10

MySQL

Language

English

• Assignee: Nicolas Malin
• Reporter: Steven Payne
• Created: 27/Apr/22 15:08
• Updated: 24/May/22 16:19
• Resolved: 24/May/22 16:19

Description

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)

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}