Uploaded image for project: 'OFBiz'
  1. OFBiz
  2. OFBIZ-9227

Violation of foreign key constraint

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Not A Problem
    • Release Branch 16.11
    • None
    • workeffort
    • Win 7

    Description

      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.))

      Attachments

        Issue Links

          Activity

            People

              aman.agrawal Aman Agrawal
              Gryphoenix Michael Clifton
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: