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
Priority: Minor
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.
