Anurag Chandak created OFBIZ-7262: ------------------------------------- Summary: Error on closing project Key: OFBIZ-7262 URL: https://issues.apache.org/jira/browse/OFBIZ-7262 Project: OFBiz Issue Type: Bug Components: specialpurpose/scrum Affects Versions: Release Branch 15.12, Trunk, Release Branch 14.12, Release Branch 13.07 Reporter: Anurag Chandak Assignee: Anurag Chandak Priority: Blocker Fix For: Upcoming Branch
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: {code} 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.))) {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)