[ https://issues.apache.org/jira/browse/OFBIZ-753?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17357909#comment-17357909 ]
ASF subversion and git services commented on OFBIZ-753: ------------------------------------------------------- Commit 17aee6b9c28822fc0c7eea1444af024d5f020ca6 in ofbiz-framework's branch refs/heads/trunk from Jacques Le Roux [ https://gitbox.apache.org/repos/asf?p=ofbiz-framework.git;h=17aee6b ] Fixed: Failed to update work effort child (OFBIZ-12250) When trying to update child work effort, a SQL error is reported: Column 'WORK_EFFORT_ID' cannot accept a NULL value. Steps to reproduce: 1. Open : workeffort/control/ChildWorkEfforts?workEffortId=TASK01&trail=TASK01 2. Select a child work effort 3. Modify the name and click "Save" related to OFBIZ-753, workEffortId is also duplicated in edit form, If I comment out workEffortId field of EditWorkEffortAndAssoc, it works properly. Thanks: Xin Wang for report and Scott for initial workaround in OFBIZ-753 > Invalid WorkEffortId generated on creating WorkEffort child > ----------------------------------------------------------- > > Key: OFBIZ-753 > URL: https://issues.apache.org/jira/browse/OFBIZ-753 > Project: OFBiz > Issue Type: Bug > Components: workeffort > Reporter: Eriks Dobelis > Assignee: Scott Gray > Priority: Minor > Attachments: WorkEffortChild.diff > > > When I create a child work effort for an existing work effort from > WorkEffort/Work Effort/Children/Add New WorkEffort Child the created work > effort gets ID [,] instead of number. Another work effort child cannot be > generated as the same ID is used again. This is the error message that I get: > ERROR: Could not complete the Create Work Effort > [file:/var/www/home/ofbizdev/data/applications/workeffort/script/org/ofbiz/workeffort/workeffort/WorkEffortSimpleServices.xml#createWorkEffort] > process [problem creating the newEntity value: Exception while inserting the > following entity: > [GenericEntity:WorkEffort][actualCompletionDate,null()][actualMilliSeconds,null()][actualSetupMillis,null()][actualStartDate,null()][createdByUserLogin,admin(java.lang.String)][createdDate,2007-02-23 > 09:23:02.101(java.sql.Timestamp)][createdStamp,2007-02-23 > 09:23:02.101(java.sql.Timestamp)][createdTxStamp,2007-02-23 > 09:23:02.049(java.sql.Timestamp)][currentStatusId,CAL_CANCELLED(java.lang.String)][description,null()][estimateCalcMethod,null()][estimatedCompletionDate,null()][estimatedMilliSeconds,null()][estimatedSetupMillis,null()][estimatedStartDate,null()][facilityId,null()][fixedAssetId,null()][infoUrl,null()][lastModifiedByUserLogin,admin(java.lang.String)][lastModifiedDate,2007-02-23 > 09:23:02.101(java.sql.Timestamp)][lastStatusUpdate,2007-02-23 > 09:23:02.101(java.sql.Timestamp)][lastUpdatedStamp,2007-02-23 > 09:23:02.101(java.sql.Timestamp)][lastUpdatedTxStamp,2007-02-23 > 09:23:02.049(java.sql.Timestamp)][locationDesc,null()][moneyUomId,null()][percentComplete,null()][priority,null()][quantityProduced,null()][quantityRejected,null()][quantityToProduce,null()][reserv2ndPPPerc,null()][reservNthPPPerc,null()][reservPersons,null()][revisionNumber,1(java.lang.Long)][scopeEnumId,WES_PRIVATE(java.lang.String)][serviceLoaderName,null()][sourceReferenceId,null()][specialTerms,null()][timeTransparency,null()][totalMilliSecondsAllowed,null()][totalMoneyAllowed,null()][universalId,null()][workEffortId,[, > ](java.lang.String)][workEffortName,Test child > 2(java.lang.String)][workEffortParentId,null()][workEffortPurposeTypeId,null()][workEffortTypeId,AVAILABLE(java.lang.String)] > (while inserting: > [GenericEntity:WorkEffort][actualCompletionDate,null()][actualMilliSeconds,null()][actualSetupMillis,null()][actualStartDate,null()][createdByUserLogin,admin(java.lang.String)][createdDate,2007-02-23 > 09:23:02.101(java.sql.Timestamp)][createdStamp,2007-02-23 > 09:23:02.101(java.sql.Timestamp)][createdTxStamp,2007-02-23 > 09:23:02.049(java.sql.Timestamp)][currentStatusId,CAL_CANCELLED(java.lang.String)][description,null()][estimateCalcMethod,null()][estimatedCompletionDate,null()][estimatedMilliSeconds,null()][estimatedSetupMillis,null()][estimatedStartDate,null()][facilityId,null()][fixedAssetId,null()][infoUrl,null()][lastModifiedByUserLogin,admin(java.lang.String)][lastModifiedDate,2007-02-23 > 09:23:02.101(java.sql.Timestamp)][lastStatusUpdate,2007-02-23 > 09:23:02.101(java.sql.Timestamp)][lastUpdatedStamp,2007-02-23 > 09:23:02.101(java.sql.Timestamp)][lastUpdatedTxStamp,2007-02-23 > 09:23:02.049(java.sql.Timestamp)][locationDesc,null()][moneyUomId,null()][percentComplete,null()][priority,null()][quantityProduced,null()][quantityRejected,null()][quantityToProduce,null()][reserv2ndPPPerc,null()][reservNthPPPerc,null()][reservPersons,null()][revisionNumber,1(java.lang.Long)][scopeEnumId,WES_PRIVATE(java.lang.String)][serviceLoaderName,null()][sourceReferenceId,null()][specialTerms,null()][timeTransparency,null()][totalMilliSecondsAllowed,null()][totalMoneyAllowed,null()][universalId,null()][workEffortId,[, > ](java.lang.String)][workEffortName,Test child > 2(java.lang.String)][workEffortParentId,null()][workEffortPurposeTypeId,null()][workEffortTypeId,AVAILABLE(java.lang.String)] > (SQL Exception while executing the following:INSERT INTO db4.WORK_EFFORT > (WORK_EFFORT_ID, WORK_EFFORT_TYPE_ID, CURRENT_STATUS_ID, LAST_STATUS_UPDATE, > WORK_EFFORT_PURPOSE_TYPE_ID, WORK_EFFORT_PARENT_ID, WORKFLOW_PACKAGE_ID, > WORKFLOW_PACKAGE_VERSION, WORKFLOW_PROCESS_ID, WORKFLOW_PROCESS_VERSION, > WORKFLOW_ACTIVITY_ID, SCOPE_ENUM_ID, PRIORITY, PERCENT_COMPLETE, > WORK_EFFORT_NAME, DESCRIPTION, LOCATION_DESC, ESTIMATED_START_DATE, > ESTIMATED_COMPLETION_DATE, ACTUAL_START_DATE, ACTUAL_COMPLETION_DATE, > ESTIMATED_MILLI_SECONDS, ESTIMATED_SETUP_MILLIS, ESTIMATE_CALC_METHOD, > ACTUAL_MILLI_SECONDS, ACTUAL_SETUP_MILLIS, TOTAL_MILLI_SECONDS_ALLOWED, > TOTAL_MONEY_ALLOWED, MONEY_UOM_ID, SPECIAL_TERMS, TIME_TRANSPARENCY, > UNIVERSAL_ID, SOURCE_REFERENCE_ID, FIXED_ASSET_ID, FACILITY_ID, INFO_URL, > RECURRENCE_INFO_ID, RUNTIME_DATA_ID, NOTE_ID, SERVICE_LOADER_NAME, > QUANTITY_TO_PRODUCE, QUANTITY_PRODUCED, QUANTITY_REJECTED, RESERV_PERSONS, > RESERV2ND_P_P_PERC, RESERV_NTH_P_P_PERC, REVISION_NUMBER, CREATED_DATE, > CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE, LAST_MODIFIED_BY_USER_LOGIN, > LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) > VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, > ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, > ?, ?, ?, ?, ?, ?) (ERROR: duplicate key violates unique constraint > "pk_work_effort")))] calling service createWorkEffort in > createWorkEffortAndAssoc -- This message was sent by Atlassian Jira (v8.3.4#803005)