Missing Z324s; "io_z105 - table doesn't exist in database or tab_io_remote ... "
- 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