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

    publish-04 Hangs

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

    Description:
    publish-04 has been running for hours and appears to be hung.
    Why won't publish_04 complete?

    Resolution:
    The p_publish_04 could not extend the table size due to of lack of space in the tablespace:
    $data_scratch/p_publish_04_b_4.log
    Error: write_xml_to_clob: ORA-01691: unable to extend lob segment
    ABC50.Z00P_SEGNAME by 8192 in

    Although the process does not indicate the table space in subject, I found that the TS3D tablespace, on which the Z00P table resides, is full:
    Tablespace Total Used Free % Free
    --------------- --------- --------- --------- ---------
    TS3D 12288 12121 164 1.33%

    ****************************************************
    Tablespace Name : TS3D
    Owner Name : ABC50
    Table Name : Z00P
    table size : 596639744 bytes
    record count : 531896 Number
    bytes per record : 1122 bytes
    Free space : 167936 bytes
    load size : 11217226 bytes
    ****************************************************

    I added 2G to the TS3D tablespace and reran the process:
    csh -f $aleph_proc/p_publish_04 NPL01,ALL,000000000,999999999,04, > & $alephe_scratch/p_publish_04_20100825.log &

    The process finished without an error:
    [1] 13259
    [2] 13443
    [3] 13562
    [4] 13719
    [4] - Done csh -f /exlibris/aleph/a20_1/aleph/proc/p_publish_04_b ...
    [2] - Done csh -f /exlibris/aleph/a20_1/aleph/proc/p_publish_04_b ...
    [1] - Done csh -f /exlibris/aleph/a20_1/aleph/proc/p_publish_04_b ...
    Wrote Z100 record with rec-key: 000001433
    Load: /exlibris/aleph/u20_1/alephe/tab/tab100
    Load: /exlibris/aleph/u20_1/abc01/tab/tab100
    Load: /tmp/utf_files/exlibris/aleph/u20_1/abc01/tab/pc_tab_exp_field.eng
    Load: /tmp/utf_files/exlibris/aleph/u20_1/abc01/tab/pc_tab_exp_field_extended.eng
    Load: /tmp/utf_files/exlibris/aleph/u20_1/abc01/tab/tab_alert
    end

    Now there are 8% free bytes in the tablespace:
    Tablespace Total Used Free % Free
    --------------- --------- --------- --------- ---------
    TS3D 12288 12121 164 1.33%
    TS3D 14192 12918 1271 8.96%

    The minimum size of a tablespace to be enough for the publish_04 process is ~700M.


    • Article last edited: 10/8/2013