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. Error Message: Item does not exist (Remote Service Error: c0174)

    Error Message: Item does not exist (Remote Service Error: c0174)

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Additional Information
    • Article Type: General
    • Product: Aleph
    • Product Version: 16.02

    Description:
    We have 6 items that will not allow an item record to be created. The cataloging assistant edits the BIB record, then normally selects the item button to create an item.
    However on these Bibliographic records we get this message:
    Item does not exist! (Remote Service Error: c0174 by docno21)

    It is only these records affected. He has entered items to other records with no problem.

    Resolution:
    This message is # 0021 in the $alephe_error_eng. It is issued by the pc_com_c0174 program when it looks an item up by barcode and doesn't find a match.

    I did this to diagnose..
    UTIL-F-3-12:.
    ENTER HOME LIBRARY : sys01.
    ENTER DOC-NUMBER : 401746.
    LPS50 000401746.
    SBS50 000401746.
    SYS60 000467548.

    and then:.
    ENTER HOME LIBRARY : lps50.
    ENTER DOC-NUMBER : 401746.
    SYS01 000401746.

    But when I do "dlib lps50" and UTIL-F-4 for 'doc', I find that there is no such doc number:.
    ENTER DOC NUMBER : 000401746.
    ....
    Error reading doc : 000401746.

    I did this SQL to find other such cases:.

    SQL-LPS50> select SUBSTR(Z103_REC_KEY,6,9) from z103 where Z103_REC_KEY like 'LPS50%' minus select z00_doc_number from lps50.z00;

    So it seems that somehow the z103 links, indicating the presence of an ADM record, were created, but the ADM record was not actually created.
    What we need to do is to remove these (bogus) z103 links, so that the system will know that there is no ADM and will create one.

    There are two ways we could do this:.
    (1) Run a sequence of 6 p_manage_12 jobs to rebuild the z103 for: sys01, lps30, sbt30, lps50, sbt50, and sys60; or.
    (2) Once you are satisfied that these are, in fact, cases of bad links, you can delete them like this:
    s+ sys01
    SQL-SYS01> delete from z103 where Z103_REC_KEY like 'LPC50%' and SUBSTR(Z103_REC_KEY,6,9) in ('000401746', '000676104', [etc.] );
    You should back up the z103 table, using p_file_03, before doing this.

    KEYWORDS: manage_12 p-manage-12 faq

    Additional Information

    faq


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Error message when trying to login to ARC: "The IBM Cognos gateway is unable to connect to the IBM Cognos BI server"
      • Error message: 'Home library is mandatory - TAB100-USER-ADDR-PERMISSION'
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 16.02
      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