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

["Anurag Chandak (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/OFBIZ-2947?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Anurag Chandak updated OFBIZ-2947:
----------------------------------
    Attachment: OFBIZ-2947.patch

Provided the patch with proper fix, issue occurred due to use of inappropriate map. Instead of fetching the value of projectId from parameters, its better to get it from context map as its already set at screen.

> 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
>
>         Attachments: OFBIZ-2947.patch
>
>
> 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)