'A database error occurred. Unable to find patron name' error when searching for patron in Voyager Circulation

Symptoms

• 'A database error occurred. Unable to find patron name' error in Voyager Circulation when searching for patron
• Patron cannot log into WebVoyage

Defect Status

Issue VYG-7636 (Fines of >21474836.47 prevents viewing patron in Circulation, WebVoyage) is currently in Development

Replication Steps

1. Create a patron and give them a fine of $5 (or make sure that the Circulation policy governing this transaction is set to include a Lost Item Processing fee >0)
2. Create an item record and in the price field, enter any value greater than or equal to 21474836.47 (any value higher than this will change to 21474836.47 if you close the item and then re-open it)
3. Charge the item to a patron
4. Modify the due date to a date far enough in the past that this item will be flagged as Lost
5. Run Circjob 12 to flag the item as Lost and create the Lost Item Replacement Fee (which will be the item's price from step 2) on the patron's record 
6. Go back to Circulation and search for this patron; there will be an error stating 'A database error occurred. Unable to find patron name'; the patron will also be unable to log into WebVoyage

Workaround

Contact Voyager Support for assistance

• Article last edited: 04-Dec-2019