Uploaded image for project: 'Kuali Rice Development'
  1. Kuali Rice Development
  2. KULRICE-12376

Travel Authorization Document with Daily Cost Estimate throws database exception

    Details

    • Type: Bug Fix
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.4
    • Fix Version/s: 2.5.1
    • Component/s: Development
    • Security Level: Public (Public: Anyone can view)
    • Labels:
      None
    • KAI Review Status:
      Not Required
    • KTI Review Status:
      Not Required
    • Code Review Status:
      Not Required
    • Include in Release Notes?:
      Yes

      Description

      Create a Travel Authorization with a Daily Cost Estimate entry.

      Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'TRVL_AUTH_DOC_ID' cannot be null
      Error Code: 1048
      Call: INSERT INTO TRVL_PD_EXP_T (PD_EXP_ID, BKFST_VAL, DNNR_VAL, MLG_EST, INCD_VAL, LNCH_VAL, MLG_RT_ID, OBJ_ID, PD_DT, TRVL_AUTH_DOC_ID, TRVL_DEST_ID, VER_NBR) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
      	bind => [12 parameters bound]
      Query: InsertObjectQuery(edu.sampleu.travel.dataobject.TravelPerDiemExpense@6383de62[travelPerDiemExpenseId=10002,travelAuthorizationDocumentId=<null>,travelDestinationId=10000,breakfastValue=0,lunchValue=0,dinnerValue=0,incidentalsValue=0,mileageRateId=10000,estimatedMileage=0,versionNumber=1,objectId=c23cc106-b89f-491d-8fb9-f98bb72a8827]); nested exception is javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.1.v20130918-f2b9fc5): org.eclipse.persistence.exceptions.DatabaseException
      Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'TRVL_AUTH_DOC_ID' cannot be null
      Error Code: 1048
      Call: INSERT INTO TRVL_PD_EXP_T (PD_EXP_ID, BKFST_VAL, DNNR_VAL, MLG_EST, INCD_VAL, LNCH_VAL, MLG_RT_ID, OBJ_ID, PD_DT, TRVL_AUTH_DOC_ID, TRVL_DEST_ID, VER_NBR) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
      	bind => [12 parameters bound]
      Query: InsertObjectQuery(edu.sampleu.travel.dataobject.TravelPerDiemExpense@6383de62[travelPerDiemExpenseId=10002,travelAuthorizationDocumentId=<null>,travelDestinationId=10000,breakfastValue=0,lunchValue=0,dinnerValue=0,incidentalsValue=0,mileageRateId=10000,estimatedMileage=0,versionNumber=1,objectId=c23cc106-b89f-491d-8fb9-f98bb72a8827])
      	at org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils.java:321)
      

        Attachments

          Issue Links

            Activity

            No work has yet been logged on this issue.

              People

              • Assignee:
                sedgar Steve Edgar (Inactive)
                Reporter:
                cniesen Claus Niesen
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: