[
https://issues.apache.org/jira/browse/OFBIZ-2947?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Anurag Chandak reopened OFBIZ-2947:
-----------------------------------
Assignee: Anurag Chandak
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)
Locked
