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

            discovered by

            Task - A task that needs to be done. KULRICE-13678 2.4.0 Coordinated Developer Testing (4/2/2014)

            • Major - Major loss of function.
            • Closed - The issue is considered finished, the resolution is correct. Issues which are not closed can be reopened.

              Activity

                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