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

[Nicolas Malin (Jira)]

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 9.04, SVN trunk
            Reporter: Jacques Le Roux
            Priority: Minor
             Fix For: Release Branch 9.04, SVN 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 is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

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

Jacques Le Roux closed OFBIZ-2947.
----------------------------------

       Resolution: Fixed
    Fix Version/s:     (was: Release Branch 9.04)

I can't reproduce this error in trunk and it's not possible in R9.04 because you get another error message (not a bug) before, I gave up on R9.04

> 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 9.04, SVN trunk
>            Reporter: Jacques Le Roux
>            Priority: Minor
>             Fix For: SVN 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 is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.