[
https://issues.apache.org/jira/browse/OFBIZ-753?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Scott Gray closed OFBIZ-753.
----------------------------
Resolution: Fixed
Hi Eriks
In rev. 524477 I've committed your patch and added some comments about the
problem. I'll create a new issue to address the problem with the form widget.
Thanks
> Invalid WorkEffortId generated on creating WorkEffort child
> -----------------------------------------------------------
>
> Key: OFBIZ-753
> URL: https://issues.apache.org/jira/browse/OFBIZ-753
> Project: OFBiz (The Open for Business Project)
> Issue Type: Bug
> Components: workeffort
> Reporter: Eriks Dobelis
> Assigned To: 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 is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
