[jira] [Commented] (OFBIZ-7262) Error on closing and re-opening of project

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-7262?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15355312#comment-15355312 ]

Montalbano Florian commented on OFBIZ-7262:
-------------------------------------------

Hi [~[hidden email]],
I found just this problem on the trunk and I applied your patch.
Now closing and opening a Scrum Project works perfectly and there is no error in the console anymore.

Thank you !

> 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 13.07, Release Branch 14.12, Trunk, Release Branch 15.12
>            Reporter: Anurag Chandak
>            Assignee: Anurag Chandak
>            Priority: Blocker
>             Fix For: Upcoming Branch
>
>         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}

--
This message was sent by Atlassian JIRA
(v6.3.4#6332)