Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. ABC50 item records not linked to HOL records after upgrade to v18

    ABC50 item records not linked to HOL records after upgrade to v18

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    • Article Type: General
    • Product: Aleph
    • Product Version: 18.01

    Description:
    ABC50 item records not linked to HOL records after upgrade to v18, that is, they do not appear under the HOL record in the Navigation tree on the lower left and the Linked column in the HOL links tab of the item record is not checked.

    I found KB entry 8192-2102 about how this can happen if the Z30_ID5 index is missing. However it wasn't. Just to be sure, I rebuilt the ABC50/Z30_ID5 index, but the problem persists.

    Resolution:
    When I do util f/4 for the abc50 z30, I get:

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

    The "variable not in select list" indicates that the fields in the record don't match what ALEPH's expecting.

    Comparing the ./alephm/sql_stat/z30_create.sql -- what the program's expecting -- to the "s+ abc50" "desc z30" -- what has been loaded --, I see that four fields are missing:

    < Z30_SHELF_REPORT_NUMBER CHAR(20),
    < Z30_ON_SHELF_DATE NUMBER(8),
    < Z30_ON_SHELF_SEQ NUMBER(6),
    ...
    < Z30_MAINTENANCE_COUNT NUMBER(3)

    The Z30_HOL_DOC_NUMBER_X -- and all the fields following the Z30_PRICE -- are read incorrectly.

    These four fields should have been added by the v16 - v17 Upgrade Express. It seems that that step was not executed or failed for some reason.


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • abc50 batch queue not working properly
      • ABC60 HOL record does not stay connected to ABC04 bib record
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 18.01
      2. contype:kba
      3. Prod:Aleph
      4. Type:General
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved