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

    Why are BIBs rejected due to unique constraint during migration?

    1. Last updated
    2. Save as PDF
    • Article Type: Q&A
    • Product: Alma

    Question

    Why were a number of BIBs rejected due to a unique constraint reported in Migration Statistic report? (what was the unique constraint?)

    Answer

    The "unique constraint" error means there were more than one bib record with the same BIB system ID in 001 found in the MARC extracts file.
    The BIB system ID must be unique. So only first record will be migrated, others will be rejected during bib conversion.

    Additional Information

    This is an error/rejected message often reported in Alma Migration Statistic report that is sent to customer after the migration process has finished.
    In some non-ExLibris ILS systems, placeholder records were created by duplicating existing records in the catalog, thus duplicating the 001. Customers are not always aware of the duplicate BIBs.

    Category: Migration - Alma

    Subject: Bib-Inventory - Alma

    • Article last edited: 4/10/2014