[jira] [Commented] (OFBIZ-753) Invalid WorkEffortId generated on creating WorkEffort child

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-753?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17357906#comment-17357906 ]

ASF subversion and git services commented on OFBIZ-753:
-------------------------------------------------------

Commit 664fd8f39cec97601279d264cebb51587bf691aa in ofbiz-framework's branch refs/heads/release18.12 from Jacques Le Roux
[ https://gitbox.apache.org/repos/asf?p=ofbiz-framework.git;h=664fd8f ]

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)