[OFBIZ-7262] Error on closing and re-opening of project

• Type: Bug
• Status: Closed
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: Release Branch 14.12, Release Branch 15.12, Trunk
• Fix Version/s: 14.12.01, 15.12.01, Trunk
• Component/s: scrum
• Assignee: Arun Patidar
• Reporter: Anurag Chandak
• Created: 09/Jun/16 06:47
• Updated: 29/Jun/16 17:01
• Resolved: 29/Jun/16 14:45

Description

Steps to regenerate:

• Go to the Scrum component and select a project (https://localhost:8443/scrum/control/viewScrumProject?projectId=DEMO-PROJECT-1)
• Close the project
• The following error is shown:

  The Following Errors Occurred:
  Exception thrown while creating the "goodStandardMap" GenericValue: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:WorkEffortGoodStandard][createdStamp,2016-06-09 12:16:46.65(java.sql.Timestamp)][createdTxStamp,2016-06-09 12:16:46.248(java.sql.Timestamp)][fromDate,2016-06-09 12:16:46.489(java.sql.Timestamp)][lastUpdatedStamp,2016-06-09 12:16:46.65(java.sql.Timestamp)][lastUpdatedTxStamp,2016-06-09 12:16:46.248(java.sql.Timestamp)][statusId,WEGS_CREATED(java.lang.String)][workEffortGoodStdTypeId,SCRUM_PRO_WORKEFF(java.lang.String)][workEffortId,DEMO-PROJECT-1(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.WORK_EFFORT_GOOD_STANDARD (WORK_EFFORT_ID, PRODUCT_ID, WORK_EFFORT_GOOD_STD_TYPE_ID, FROM_DATE, THRU_DATE, STATUS_ID, ESTIMATED_QUANTITY, ESTIMATED_COST, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Column 'PRODUCT_ID' cannot accept a NULL value.)) (Error while inserting: [GenericEntity:WorkEffortGoodStandard][createdStamp,2016-06-09 12:16:46.65(java.sql.Timestamp)][createdTxStamp,2016-06-09 12:16:46.248(java.sql.Timestamp)][fromDate,2016-06-09 12:16:46.489(java.sql.Timestamp)][lastUpdatedStamp,2016-06-09 12:16:46.65(java.sql.Timestamp)][lastUpdatedTxStamp,2016-06-09 12:16:46.248(java.sql.Timestamp)][statusId,WEGS_CREATED(java.lang.String)][workEffortGoodStdTypeId,SCRUM_PRO_WORKEFF(java.lang.String)][workEffortId,DEMO-PROJECT-1(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.WORK_EFFORT_GOOD_STANDARD (WORK_EFFORT_ID, PRODUCT_ID, WORK_EFFORT_GOOD_STD_TYPE_ID, FROM_DATE, THRU_DATE, STATUS_ID, ESTIMATED_QUANTITY, ESTIMATED_COST, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Column 'PRODUCT_ID' cannot accept a NULL value.)))
  

Issue Links

• is duplicated by: OFBIZ-7626 Getting error on closing or re-opening the project