[KULRICE-12376] Travel Authorization Document with Daily Cost Estimate throws database exception Created: 02/Apr/14  Updated: 11/Nov/14  Resolved: 19/Sep/14

Status: Closed
Project: Kuali Rice Development
Component/s: Development
Affects Version/s: 2.4
Fix Version/s: 2.5.1
Security Level: Public (Public: Anyone can view)

Type: Bug Fix Priority: Major
Reporter: Claus Niesen Assignee: Steve Edgar (Inactive)
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Discovered
discovered by KULRICE-13678 2.4.0 Coordinated Developer Testing (... Closed
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)


 Comments   
Comment by Steve Edgar (Inactive) [ 17/Sep/14 ]

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.

Comment by Martin Taylor (Inactive) [ 11/Nov/14 ]

Closing 2.5.1 Development

Generated at Wed Feb 26 23:06:13 CST 2020 using JIRA 6.1.5#6160-sha1:a61a0fc278117a0da0ec9b89167b8f29b6afdab2.