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

    Too few records loaded from Aleph to Primo

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

    Problem Symptoms:
    A run of publish-06 (Create Tar File for ALEPH Published Records) (with "Range of documents" selected) was performed, but only 90,000 records were loaded into Primo. There should be more than 300,000 records.

    The $alephe_scratch/xxx01_p_publish_06.nnnnn log of the most recent run shows:

    setenv p_start_doc_number_x "000120001"
    setenv p_end_doc_number_x "000180000"

    Change the start-doc parameter to 000000000 and the end-doc parameter to 999999999.

    Additional Information


    Though there are 300,000+ z00p records total, the following SQL shows that there are 45,957 z00p records for each of the two publishing sets (MONOGRAPHS and SET1) in the specified key range:

    xxx50@ALEPH20> select z00p_set, count(*) from z00p where Z00P_DOC_NUMBER > '000120000' and Z00P_DOC_NUMBER < '000180000' group by z00p_set;
    **** Hit return to continue ****

    Z00P_SET COUNT(*)
    -------------------- ----------
    MONOGRAPHS 45957
    SET1 45957

    This corresponds to the number of xxx01 bib records which exist in this range:

    xxx01@ALEPH20> select count(*) from z00 where Z00_DOC_NUMBER > '000120000' and Z00_DOC_NUMBER < '000180000';
    **** Hit return to continue ****


    (The z00p count is slightly lower because the z00p omits SUPPRESSED, DELETED, and CIRC-CREATED doc records.)

    • Article last edited: 3/26/2014
    • Was this article helpful?