You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "Eriks Dobelis (JIRA)" <ji...@apache.org> on 2007/02/23 08:41:05 UTC
[jira] Updated: (OFBIZ-753) Invalid WorkEffortId generated on
creating WorkEffort child
[ https://issues.apache.org/jira/browse/OFBIZ-753?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Eriks Dobelis updated OFBIZ-753:
--------------------------------
Attachment: WorkEffortChild.diff
This patch solves the issue (at least for me). This line was returned twice:
<input type="hidden" name="workEffortId"/>
I removed one from AddWorkEffortAndAssoc form.
> 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
> 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.