Fivecolleges has been reported that they are getting 500 errors being generated when financial transaction report is run for Amherst College. They tried to do Amherst and I got a 500 error. Based on the circulation log, there should be many more financial transactions than appear in the report.
 
Steps to reproduce:

1. Login to Folio.

2. Go to User app.

3. Click actions in user search results, click on financial transactions detail report

4. use start date 7/1; end date is 7/26

5. fee fine owner is either Amherst college library or Hampshire College Library

6. associated service point is AC Frost Library for Amherst; and HC Herald Johnson, for Hampshire

Request URL: https://okapi-fivecolleges.folio.ebsco.com/feefine-reports/financial-transactions-detail
Request Method: POST
Status Code: 500
Date: Wed, 27 Jul 2022 15:50:35 GMT
 
Payload:

{"createdAt":["1b36ecc6-0dd9-496a-bc49-15f0a35ce4ec"],"feeFineOwner":"a59aa418-117f-4382-ad05-afc85ff640e2","startDate":"2022-07-01","endDate":"2022-07-07"}

 
Response:
HTTP 500 Internal Server Error.
If the issue persists, please report it to EBSCO Connect.
 
See attached screenshot and logs for details
 

Hint for dev:

19:57:46 [] [] [] [] ERROR FeeFineReportsAPI    Failed to build report: Invalid format: "2019-05-29T04:00:00+00:00" is malformed at "+00:00"

See org.folio.rest.service.report.DateBasedReportService#reformatLoanDate.

loanDateTimeFormatter expects loanDate in format "yyyy-MM-dd'T'HH:mm:ss.SSS'Z'"