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

    Object not available for your current profile"; two z61_rec_key's "ALEPH"

    • Article Type: General
    • Product: Aleph
    • Product Version: 20

    Problem Symptoms:
    * Unable to view recently-acquired ebooks in OPAC. Error message: "Object not available for your current profile."

    * Error attempting to modify ALEPH profile in GUI Circ --> Patrons --> Patron profiles. Error message: "Library for ALEPH profile cannot be changed".

    Cause:
    SQL showed two ALEPH rec-keys in XXX50 (where XXX50 is the $usr_library):

    xxx50@ALEPH20T> select z61_rec_key, z61_user_library from z61 where z61_rec_key = 'ALEPH';
    **** Hit return to continue ****

    Z61_REC_KEY Z61_U
    ------------ -----
    ALEPH USM50
    ALEPH XXX50

    util a/17/14 showed that the XXX50 z61_id Oracle index didn't exist:

    Enter Table Name : z61

    Defined in file_list:
    __________________________________________________________
    IND z61_id 128K 0K TS1X
    __________________________________________________________


    Exist in the Database:

    Enter CR to continue...

    Resolution:
    1. Delete the ALEPH / USM50 rec-key:

    xxx50@ALEPH20T> delete from z61 where z61_rec_key = 'ALEPH' and z61_user_library = 'USM50';

    1 row deleted.


    2. Do util a/17/2 to create the z61_id Oracle index

    3. Blank out the z61_user_library:

    xxx50@ALEPH20T> update z61 set z61_user_library = NULL where z61_rec_key = 'ALEPH';

    1 row updated.

    Additional Information

    Updating the ALEPH profile in the GUI was then OK.

    SQL information:
    This SQL (prior to the Delete) showed that ALEPH was the only duplicated z61_rec_key:

    abc50@ALEPH20T> select z61_rec_key, count(*) from z61 group by z61_rec_key having count(*) > 1;
    **** Hit return to continue ****

    Z61_REC_KEY COUNT(*)
    ------------ ----------
    ALEPH 2

    Category: Circulation (500)

    Subject: Profiles


    • Article last edited: 10/8/2013