• 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