Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

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

    • Product: Voyager
    • Product Version: 8.2.0-10.1.0
    • Relevant for Installation Type: Multi-Tenant Direct, Dedicated-Direct, Local, TotalCare

    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