> Error on closing and re-opening of 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 14.12, Trunk, Release Branch 15.12
> Reporter: Anurag Chandak
> Assignee: Arun Patidar
> Priority: Blocker
> Fix For: Trunk, 14.12.01, 15.12.01
>
> Attachments: OFBIZ-7262.patch
>
>
> 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}
Locked
