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. p_manage_01: Load completed ... count 0; "set: syntax error"

    p_manage_01: Load completed ... count 0; "set: syntax error"

    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: 20

    Description:
    For certain cycles in the p_manage_01_d1 log (or the logs of other jobs which use cycles) you get the message "Load completed - logical record count 0."

    Followed in each case by a message: "set: syntax error".

    Resolution:
    Do this SQL to see if there are actually bib records in the cycle's range. For example, if the cycle is 200001-250000:
    SQL> select count (*) from z00 where z00_doc_number > '000200000' and z00_doc_number < '000250001';.

    If there are no doc records in this range, then p_manage_01 will not load any records..

    If there *are* doc records in this cycle's range, then check the preceding sections of the log carefully for any errors..

    Note: the first "Load completed" in the p_manage_01 (which is for Z970 records) will usually get 0 loaded and "set: syntax error" (since most sites don't have any Z970s).

    Additional Information

    faq


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • p_manage_01: "Write Error b_manage_01_c"
      • p_manage_01: ORA-1653: unable to extend table
    • Was this article helpful?

    Recommended articles

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