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

    p_publish_06 outputs only half of the z00p records; "b_publish_06_b: failure"

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

    Description:
    Only 213,432 xml files are being tarred out of the expected 548,897 in z00p when publish_04 is run.

    The service was run on the command line:
    csh -f p_publish_06 sys01,ALL,DOC,000000000,999999999,00000000,00000000,,/exlibris/aleph/u18_1/SYS01/primo_initial_publishing_20100611,N,6, > & $alephe_scratch/sys01_p_publish_06.log &

    The cycles file has all "+"s and the $alephe_scratch/p_publish_06 log doesn't show any error, but in one run there was a $data_scratch/p_publish_06_PRIMO-FULL.err file with the following:

    FAILURE Fri Jun 11 10:50:25 EDT 2010 ==================
    step 1
    Cycle: 8

    b_publish_06_b: failure

    Job Suspended !!!

    To identify this error in your log files use the command:
    grep "FAILURE Fri Jun 11 10:50:25 EDT 2010" $data_scratch/*.log

    but this grep does not find anything.

    Resolution:
    Util a 17 14 for z00p in the $usr_library returns the following:

    Enter Table Name : z00p
    make_library_file_list: env file_list_size does not exists. Using data_root/file_list as is

    Defined in file_list:
    _______________________________________________________
    IND z00p_id 100K 100K ts2x
    __________________________________________________________

    Exist in the Database:

    INDEX_NAME STATUS INDEX_TYPE UNIQUENESS COLUMN_NAME
    --------------- ------- ---------- ----------- --------------------
    Z00P_ID VALID NORMAL UNIQUE Z00P_REC_KEY


    Instead of:

    Enter Table Name : z00p

    Defined in file_list:
    ________________________________________________________
    IND z00p_id 100K 0K ts1
    IND z00p_id1 100K 0K ts1
    IND z00p_id2 100K 0K ts1
    IND z00p_id3 100K 0K ts1
    IND z00p_id4 100K 0K ts1
    IND z00p_id5 100K 0K ts1
    _________________________________________________________
    Exist in the Database:

    INDEX_NAME STATUS INDEX_TYPE UNIQUENESS COLUMN_NAME
    --------------- ------- ---------- ----------- --------------------
    Z00P_ID VALID NORMAL UNIQUE Z00P_REC_KEY
    Z00P_ID1 VALID NORMAL NONUNIQUE Z00P_SET
    Z00P_ID2 VALID NORMAL NONUNIQUE Z00P_DOC_NUMBER
    Z00P_ID3 VALID NORMAL NONUNIQUE Z00P_TIMESTAMP
    Z00P_ID4 VALID NORMAL NONUNIQUE Z00P_LIBRARY
    Z00P_ID5 VALID NORMAL NONUNIQUE Z00P_SET
    Z00P_ID5 VALID NORMAL NONUNIQUE Z00P_TIMESTAMP

    After the z00p Oracle indexes were defined (via util a/17/2), p_publish_06 produced the expected output.


    • Article last edited: 10/8/2013