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.
Cause:
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"
Resolution:
Change the start-doc parameter to 000000000 and the end-doc parameter to 999999999.
Additional Information
Diagnosis:
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 ****
COUNT(*)
----------
47280
(The z00p count is slightly lower because the z00p omits SUPPRESSED, DELETED, and CIRC-CREATED doc records.)
- Article last edited: 3/26/2014