ofbiz-notifications mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Aman Agrawal (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (OFBIZ-9227) Violation of foreign key constraint
Date Sat, 25 Nov 2017 05:57:00 GMT

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

Aman Agrawal commented on OFBIZ-9227:
-------------------------------------

Hi Michael,

I think this issue is fixed on svn revision no: r1772880.

I think we can close this ticket.

> Violation of foreign key constraint
> -----------------------------------
>
>                 Key: OFBIZ-9227
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-9227
>             Project: OFBiz
>          Issue Type: Bug
>          Components: workeffort
>    Affects Versions: Release Branch 16.11
>         Environment: Win 7
>            Reporter: Michael Clifton
>            Assignee: Aman Agrawal
>            Priority: Minor
>              Labels: database, tasks, workeffort
>
> Trying to add a task to a project phase, I receive the below error.
> 2017-02-21 09:23:54,189 |http-nio-8443-exec-1 |ServiceDispatcher |E| Error in Service
[createProjectTask]: Exception thrown while creating the "newEntity" GenericValue: org.apache.ofbiz.entity.GenericEntityException:
Error while inserting: [GenericEntity:WorkEffort][createdByUserLogin,admin(java.lang.String)][createdDate,2017-02-21
09:23:52.876(java.sql.Timestamp)][createdStamp,2017-02-21 09:23:52.876(java.sql.Timestamp)][createdTxStamp,2017-02-21
09:23:51.627(java.sql.Timestamp)][currentStatusId,PTS_CREATED(java.lang.String)][description,Test(java.lang.String)][estimatedCompletionDate,2017-02-24
00:00:00.0(java.sql.Timestamp)][estimatedStartDate,2017-02-21 00:00:00.0(java.sql.Timestamp)][lastModifiedByUserLogin,admin(java.lang.String)][lastModifiedDate,2017-02-21
09:23:52.876(java.sql.Timestamp)][lastStatusUpdate,2017-02-21 09:23:52.876(java.sql.Timestamp)][lastUpdatedStamp,2017-02-21
09:23:52.876(java.sql.Timestamp)][lastUpdatedTxStamp,2017-02-21 09:23:51.627(java.sql.Timestamp)][priority,1(java.lang.Long)][revisionNumber,1(java.lang.Long)][scopeEnumId,WES_PRIVATE(java.lang.String)][sequenceNum,1(java.lang.Long)][workEffortId,10090(java.lang.String)][workEffortName,Test(java.lang.String)][workEffortParentId,10048(java.lang.String)][workEffortTypeId,Task(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO OFBIZ.WORK_EFFORT (WORK_EFFORT_ID,
WORK_EFFORT_TYPE_ID, CURRENT_STATUS_ID, LAST_STATUS_UPDATE, WORK_EFFORT_PURPOSE_TYPE_ID, WORK_EFFORT_PARENT_ID,
SCOPE_ENUM_ID, PRIORITY, PERCENT_COMPLETE, WORK_EFFORT_NAME, SHOW_AS_ENUM_ID, SEND_NOTIFICATION_EMAIL,
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, TEMP_EXPR_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, ACCOMMODATION_MAP_ID, ACCOMMODATION_SPOT_ID, 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, SEQUENCE_NUM) VALUES (?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'WORK_EFFORT'
caused a violation of foreign key constraint 'WK_EFFRT_TYPE' for key (Task). The statement
has been rolled back.)) 



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message