[ https://issues.apache.org/jira/browse/OFBIZ-2947?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15338211#comment-15338211 ]
Jacques Le Roux commented on OFBIZ-2947: ---------------------------------------- Thanks Anurag! > 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)