ue_01 not processing records like it should; z07_rec_key '000000000'
- Article Type: General
- Product: Aleph
- Product Version: 19.01
Description:
Despite the fact that there are 9,000 abc50 z07's waiting to be processed, the abc50 ue_01 processes only about 1 every 10 minutes, on average.
I see that the z07_sequences range from 20100903% to 20100928%.
Stopping and restarting the abc50 ue_01 has not helped.
Resolution:
This is similar to KB 16384-30721.... An analysis of ue_01_a.cbl shows that it does not expect any z07 record with z07_rec_key "000000000" (which is an illegal key). I found that there is an abc50 z00 with z00_doc_number 000000000, which was written on March 5, 2009:
abc50@ALEPH0> select * from z00 where z00_doc_number = '000000000';
**** Hit return to continue ****
Z00_DOC_N Z00_NO_LINES Z00_DATA_LEN
--------- ------------ ------------
Z00_DATA
--------------------------------------------------------------------------------
000000000 5 183
0008FMT LAD0030LDR L^^^^^^a^^^22^^^^^^^^45000046008 L090305^^^^^^^^^^^^^^^^^^
^^^^^^^^^^^eng^^0047CAT L$$aJONES$$b40$$c20090305$$lABC50$$h09280032LKR L$$a
ADM$$lABC01$$b000000000
and an abc50 z07 record which was written on Sept. 3, 2010:
abc50@ALEPH0> select * from z07 where z07_rec_key = '000000000';
**** Hit return to continue ****
Z07_REC_K Z07_SEQUENCE Z07_LEVEL Z07
--------- --------------- ---------- ---
Z07_HISTORY
--------------------------------------------------------------------------------
000000000 201009032201132 1
ABC50000000000
Both of these are illegal. You definitely need to delete the z07 record (in order to have ue_01 run properly):
> s+ abc50
SQL> delete from z07 where z07_rec_key = '000000000';
and I also suggest deleting the z00 record:
SQL> delete from z00 where z00_doc_number = '000000000';
After deleting these records, the abc50 ue_01 started processing normally.
- Article last edited: 10/8/2013