ofbiz-notifications mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Michael Clifton (JIRA)" <j...@apache.org>
Subject [jira] [Created] (OFBIZ-9227) Violation of foreign key constraint
Date Tue, 21 Feb 2017 15:27:44 GMT
Michael Clifton created OFBIZ-9227:
--------------------------------------

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


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.)) (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.3.15#6346)

Mime
View raw message