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

    Upgrade Express: install_utree: "GRANT SELECT ...TO "CALLSLIP"; error 1917

    1. Last updated
    2. Save as PDF
    • Article Type: General
    • Product: Aleph
    • Product Version: 20

    Description:
    We see the following error in the install_utree.log (produced by the upgrade_util "Install customer data" step) for seven different tables:

    IMP-00017: following statement failed with ORACLE error 1917:
    "GRANT SELECT ON "Z103" TO "CALLSLIP""
    IMP-00003: ORACLE error 1917 encountered
    ORA-01917: user or role 'CALLSLIP' does not exist

    In an Aleph 22 instance the following messages were seen:

    ORA-39083: Object type OBJECT_GRANT failed to create with error:
    ORA-01917: user or role 'LIBRARIAN' does not exist

    Resolution:
    I find that, despite this error, the number of records in the v20 tables matches the number in your v18 tables.

    [From site:] "We've created a MSAccess database that pulls out only the callslips. I've created an oracle user specifically for this database.
    I can always create the user after the alephtest ver20 is up and running."

    • Article last edited: 10/8/2014