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

                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

                  Activity

                  Error rendering 'com.atlassian.jira.jira-view-issue-plugin:activitymodule'. Please contact your JIRA administrators.

                    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: