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

Description:
Why is there no entry for record 030160886 in the Z324?

Resolution:
As described in KB 8504 (v16 rep_change 703): the creation/update of the Z324 table is done by ue_11. Item changes trigger a creation of Z105 and the Z105 is handled by ue_11 type 8.

The following SQL shows that there are thousands of unprocessed type 8 z105's in the $z105_library (abc50):

abc50@ALEPH20> select substr(z105_text,1,5), count(*) from z105 where Z105_TYPE = '8' group by substr(z105_text,1,5);
**** Hit return to continue ****

SUBSTR(Z105_TEX COUNT(*)
--------------- ----------
ABC50 20742
<etc.>

(Note: there are also thousands of unprocessed z105's for z105_type 'e's. See KB 16384-35474.)

util a/17/14 showed that the z105_id Oracle index was missing for z105 in the $z105_library (abc50):

Enter Table Name : z105

Defined in file_list:
__________________________________________________________
IND z105_id 4M 0K TS2X
__________________________________________________________


Exist in the Database:
<blank>

I did util a/17/2 to generate the z105_id. I have stopped the abc00 ue_11 and did util a/17/2 to create the z105_id Oracle index.

I restarted ue_11 and, looking at the current run_e_11.22274, find that it is now processing the z105's without error.

• Article last edited: 10/8/2013