[
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)
