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

            cniesen Claus Niesen created issue -
            cniesen Claus Niesen made changes -
            Field Original Value New Value
            Link This issue discovered by RICEQA-281 [ RICEQA-281 ]
            gilesp Peter Giles (Inactive) made changes -
            Fix Version/s 2.5 [ 17044 ]
            kbtaylor Kristina Taylor (Inactive) made changes -
            Rank Ranked higher
            kbtaylor Kristina Taylor (Inactive) made changes -
            Fix Version/s 2.5.1 [ 17833 ]
            Fix Version/s 2.5 [ 17044 ]
            kbtaylor Kristina Taylor (Inactive) made changes -
            Rank Ranked lower
            kbtaylor Kristina Taylor (Inactive) made changes -
            Rank Ranked higher
            sedgar Steve Edgar (Inactive) made changes -
            Assignee Steve Edgar [ sedgar ]
            Hide
            sedgar 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
            sedgar 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.
            sedgar Steve Edgar (Inactive) made changes -
            Status Open [ 1 ] Resolved [ 5 ]
            Resolution Fixed [ 1 ]
            Hide
            mztaylor Martin Taylor (Inactive) added a comment -

            Closing 2.5.1 Development

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

              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: