You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@ofbiz.apache.org by "Steven Payne (Jira)" <ji...@apache.org> on 2022/04/27 15:09:00 UTC
[jira] [Created] (OFBIZ-12607) MRP Fails to Run
Steven Payne created OFBIZ-12607:
------------------------------------
Summary: 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
Reporter: Steven Payne
Attachments: image-2022-04-27-08-01-32-251.png
The MRP module fails 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)