[jira] [Comment Edited] (OFBIZ-2947) The 1st time you close a project you get an error, it works the 2d time

[Nicolas Malin (Jira)]

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

Anurag Chandak edited comment on OFBIZ-2947 at 6/18/16 2:09 PM:
----------------------------------------------------------------

I am able to regenerate this issue on trunk, here are the steps:
- Go to Project --> Projects
- Click on New Project
- Only enter Project Name and click on save button
- Close the current project.
- The following error is thrown
{code}
Exception thrown while creating the "newWorkEffortStatus" GenericValue: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:WorkEffortStatus][createdStamp,2016-06-18 19:32:55.748(java.sql.Timestamp)][createdTxStamp,2016-06-18 19:32:55.702(java.sql.Timestamp)][lastUpdatedStamp,2016-06-18 19:32:55.748(java.sql.Timestamp)][lastUpdatedTxStamp,2016-06-18 19:32:55.702(java.sql.Timestamp)][setByUserLogin,admin(java.lang.String)][statusDatetime,2016-06-18 19:32:55.748(java.sql.Timestamp)][statusId,PRJ_CLOSED(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.WORK_EFFORT_STATUS (WORK_EFFORT_ID, STATUS_ID, STATUS_DATETIME, SET_BY_USER_LOGIN, REASON, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (Column 'WORK_EFFORT_ID' cannot accept a NULL value.)) (Error while inserting: [GenericEntity:WorkEffortStatus][createdStamp,2016-06-18 19:32:55.748(java.sql.Timestamp)][createdTxStamp,2016-06-18 19:32:55.702(java.sql.Timestamp)][lastUpdatedStamp,2016-06-18 19:32:55.748(java.sql.Timestamp)][lastUpdatedTxStamp,2016-06-18 19:32:55.702(java.sql.Timestamp)][setByUserLogin,admin(java.lang.String)][statusDatetime,2016-06-18 19:32:55.748(java.sql.Timestamp)][statusId,PRJ_CLOSED(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.WORK_EFFORT_STATUS (WORK_EFFORT_ID, STATUS_ID, STATUS_DATETIME, SET_BY_USER_LOGIN, REASON, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (Column 'WORK_EFFORT_ID' cannot accept a NULL value.)))
{code}

Dig around it and found that on closing the project, workEffortId is passed as NULL.

I am working on this and will add the patch with the proper fix.


was (Author: [hidden email]):
I am able to regenerate this issue, here are the steps:
- Go to Project --> Projects
- Click on New Project
- Only enter Project Name and click on save button
- Close the current project.
- The following error is thrown
{code}
Exception thrown while creating the "newWorkEffortStatus" GenericValue: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:WorkEffortStatus][createdStamp,2016-06-18 19:32:55.748(java.sql.Timestamp)][createdTxStamp,2016-06-18 19:32:55.702(java.sql.Timestamp)][lastUpdatedStamp,2016-06-18 19:32:55.748(java.sql.Timestamp)][lastUpdatedTxStamp,2016-06-18 19:32:55.702(java.sql.Timestamp)][setByUserLogin,admin(java.lang.String)][statusDatetime,2016-06-18 19:32:55.748(java.sql.Timestamp)][statusId,PRJ_CLOSED(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.WORK_EFFORT_STATUS (WORK_EFFORT_ID, STATUS_ID, STATUS_DATETIME, SET_BY_USER_LOGIN, REASON, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (Column 'WORK_EFFORT_ID' cannot accept a NULL value.)) (Error while inserting: [GenericEntity:WorkEffortStatus][createdStamp,2016-06-18 19:32:55.748(java.sql.Timestamp)][createdTxStamp,2016-06-18 19:32:55.702(java.sql.Timestamp)][lastUpdatedStamp,2016-06-18 19:32:55.748(java.sql.Timestamp)][lastUpdatedTxStamp,2016-06-18 19:32:55.702(java.sql.Timestamp)][setByUserLogin,admin(java.lang.String)][statusDatetime,2016-06-18 19:32:55.748(java.sql.Timestamp)][statusId,PRJ_CLOSED(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.WORK_EFFORT_STATUS (WORK_EFFORT_ID, STATUS_ID, STATUS_DATETIME, SET_BY_USER_LOGIN, REASON, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (Column 'WORK_EFFORT_ID' cannot accept a NULL value.)))
{code}

Dig around it and found that on closing the project, workEffortId is passed as NULL.

I am working on this and will add the patch with the proper fix.

> The 1st time you close a project you get an error, it works the 2d time
> -----------------------------------------------------------------------
>
>                 Key: OFBIZ-2947
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2947
>             Project: OFBiz
>          Issue Type: Bug
>          Components: specialpurpose/projectmgr
>    Affects Versions: Release Branch 09.04, Trunk
>            Reporter: Jacques Le Roux
>            Assignee: Anurag Chandak
>            Priority: Minor
>             Fix For: Trunk
>
>
> ERROR: Could not complete the Update Work Effort [file:/D:/workspace/ofbizRun/applications/workeffort/script/org/ofbiz/workeffort/workeffort/WorkEffortSimpleServices.xml#updateWorkEffort] process [problem creating the newWorkEffortStatus value: Error while inserting: [GenericEntity:WorkEffortStatus][createdStamp,2009-09-16 15:10:35.548(java.sql.Timestamp)][createdTxStamp,2009-09-16 15:10:35.501(java.sql.Timestamp)][lastUpdatedStamp,2009-09-16 15:10:35.548(java.sql.Timestamp)][lastUpdatedTxStamp,2009-09-16 15:10:35.501(java.sql.Timestamp)][setByUserLogin,admin(java.lang.String)][statusDatetime,2009-09-16 15:10:35.548(java.sql.Timestamp)][statusId,PRJ_CLOSED(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.WORK_EFFORT_STATUS (WORK_EFFORT_ID, STATUS_ID, STATUS_DATETIME, SET_BY_USER_LOGIN, REASON, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (ERREUR: une valeur NULL viole la contrainte NOT NULL de la colonne « work_effort_id »))]

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