• 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