Enterprise - Unexpected Error in My Account

Enterprise - Unexpected Error in My Account

Database errors can occur in Enterprise when user barcodes are recycled. Upon attempting to login, the patron will encounter the following message:

Unexpected Error
The system encountered an error while processing the following request:
/client/en_US/LIBRARY/search/patronlogin.loginpageform/LIBRARY
Error Summary
could not execute statement; SQL [n/a]; constraint
[MTSCDSC.UQ_PATRON_USERNAME_AUTH_ID]; nested exception is
org.hibernate.exception.ConstraintViolationException: could not execute
statement

Thu Jun 13 17:31:13 CDT 2019

Because the user barcode was originally associated with a different user key, the patron encounters an Enterprise database error. This occurs most frequently when a patron's library card has been removed but is subsequently re-added.

For example, a patron's card is purged due to inactivity. If the patron visits the library with their old card in hand, the card cannot be found in the system. Library staff registers the patron using the old card number. Despite being the same person, the barcode is now attached to a different user key in the Symphony database. Enterprise still associates that barcode with the old user key. The patron will not be able to login to Enterprise until the old entry is resolved.

If you encounter the above error, please open a ticket with the patron's card number so that a database administrator can update the user key. 

    • Related Articles

    • Enterprise - Password/PIN Reset

      About This article covers how library cardholders can change or reset their password/PIN from Enterprise, the Montana Shared Catalog's current online public access catalog (OPAC). Forgot Password/PIN Reset If the user does not know their ...

    • Enterprise - Online Bill Payment

      Overview Enterprise now offers functionality that will allow for integration with PayPal so that patrons can pay their bills online using a credit card. Roles, responsibilities and configuration options are outlined below. Roles & Responsibilities ...

    • MobileStaff - Quota Error

      About Try the following troubleshooting tips to resolve a quota error in MobileStaff (formerly MobileCirc). Change Institution 1. From the Sign In page, access Setup. 2. From the Setup page, press Change Institution. Doing this should remove old ...

    • Enterprise - Online Bill Payment Patron Procedure

      Overview Libraries that have opted-in to online bill payment in Enterprise, can use the following instructions to assist their patrons. Patron Procedure 1. Navigate to your library's catalog, and click on My Account from the top menu. 2. Log in to ...

    • Enterprise - Profile Options

      About The following examples are provided to illustrate the available options in Enterprise, the current Montana Shared Catalog OPAC. As part of the library on-boarding process, please complete the attached Enterprise Profile Options Form and return ...