Skip to main content
ExLibris

  • Subscribe by RSS
    • Aleph
    Ex Libris Knowledge Center

    v20 Order Log incorrect; Oracle error: fetch z71... variable not in select list

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

    Description:
    We just switched over to v20 today and noticed a big problem with our Order Log. Example is sys #3327862. The Date/Time is strange, there is a date under the User column etc.

    --------------------------------------------------------------------------------
    Also, when I do util-f-4 in the ABC50 for z71 I get the following:

    Oracle error: fetch z71
    ORA-01007: variable not in select list

    Resolution:
    The "Oracle error: fetch z71 ... variable not in select list" indicates that the z71 is in the z19 format rather than v20.

    This is what I see in the /exlibris/aleph/upgrade_express_1901_2001/logs/log/1011.log:

    Step begin 1011

    Building data_scratch/file_list for adm libraries...
    Modifying data_root/file_list: add z71_id3 in adm libraries according to Z71_ID2
    Updating data_scratch/file_list for adm libraries...

    Step end 1011


    and this in the upgrade_util View/Update upgrade parameters:

    Libraries to be upgraded:
    No libraries are currently defined

    This is like KB 16384-29745. Please refer to that KB for analysis/resolution.

    • Article last edited: 10/8/2013