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