Kuali Rice Development
  1. Kuali Rice Development
  2. KULRICE-12376

Travel Authorization Document with Daily Cost Estimate throws database exception

    Details

    • Type: Bug Fix Bug Fix
    • Status: Closed Closed
    • Priority: Major 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
    • Similar issues:
      KULRICE-11718Fill AFT Per-Screen Item Gap: KRAD Demo: Travel Authorization Request
      KULRICE-10045KRAD Sample App: Traveler Authorization Request Page. Lookups throw BadSqlGrammerException
      KULRICE-13449Fill AFT Per-Screen Item Gap: Lookups (various KRAD screens)
      KULRICE-12851Double quickfinder icons showing up in sample app
      KULRICE-10101KRAD Demo Travel Account Authorization Traveler Lookup Search throws SQL Exception
      KULRICE-11814Exception on travel account maintenance document
      KULRICE-13024Styling issues with travel authorization document
      KULRICE-11520Create Automated Functional (Smoke) Tests for KRAD Demo - Travel Application: Authorization Document
      KULRICE-13779Create Travel Authorization transactional document in KRAD
      KULRICE-9984Component Library: Travel Authorization Request missing expand/collapse
    • 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)
      

        Issue Links

          Activity

          Claus Niesen made changes -
          Field Original Value New Value
          Link This issue discovered by RICEQA-281 [ RICEQA-281 ]
          Peter Giles (Inactive) made changes -
          Fix Version/s 2.5 [ 17044 ]
          Kristina Taylor (Inactive) made changes -
          Rank Ranked higher
          Kristina Taylor (Inactive) made changes -
          Fix Version/s 2.5.1 [ 17833 ]
          Fix Version/s 2.5 [ 17044 ]
          Kristina Taylor (Inactive) made changes -
          Rank Ranked lower
          Kristina Taylor (Inactive) made changes -
          Rank Ranked higher
          Steve Edgar (Inactive) made changes -
          Assignee Steve Edgar [ sedgar ]
          Hide
          Steve Edgar (Inactive) added a comment -

          I am not able reproduce this. If I go to ...

          http://localhost:8080/krad-dev/kr-krad/approval?methodToCall=docHandler&command=initiate&docTypeName=TravelAuthorization

          .. and fill out the form with all the required fields, including adding values in the Daily Cost Estimate section, I am able to Save, Blanket Approve, or Submit the document for routing to another user, without any errors.

          I might be overlooking something. If more info is available to create the error, I can continue to investigate.

          Show
          Steve Edgar (Inactive) added a comment - I am not able reproduce this. If I go to ... http://localhost:8080/krad-dev/kr-krad/approval?methodToCall=docHandler&command=initiate&docTypeName=TravelAuthorization .. and fill out the form with all the required fields, including adding values in the Daily Cost Estimate section, I am able to Save, Blanket Approve, or Submit the document for routing to another user, without any errors. I might be overlooking something. If more info is available to create the error, I can continue to investigate.
          Steve Edgar (Inactive) made changes -
          Status Open [ 1 ] Resolved [ 5 ]
          Resolution Fixed [ 1 ]
          Hide
          Martin Taylor (Inactive) added a comment -

          Closing 2.5.1 Development

          Show
          Martin Taylor (Inactive) added a comment - Closing 2.5.1 Development
          Martin Taylor (Inactive) made changes -
          Status Resolved [ 5 ] Closed [ 6 ]

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Structure Helper Panel