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

Description:
The run_e_01_word process keeps failing with these errors:

HANDLING DOC NO. - ABC01.011326048 2012-04-17 17:44:42
Update z98 from z980 : 014000513496
PREMATURE END OF Z96 - 014000513496

Resolution:
This indicated a problem in the building of this z98 record by p_manage_01. It was corrected by a successful rerun of p_manage_01.


<Analysis:>

We tried deleting the problem z07a record:

SQL> delete from z07a where substr(z07a_rec_key,17,9)= '011326048';

<where '011326048' is the doc number in the ue_01_word log>.

But after 5 or 10 minutes ue_01_word hit a different problem record.

The z98/z980 014000513496 is the W-014 index (as seen in tab00.eng) and 000513496 is the z97_rec_number (searchable in util f/4 as "key 3"; "014000513496" is searchable in util f/4 word3).

As described above, this indicated a problem in the building of this z98 record by p_manage_01, which was corrected by a successful rerun of p_manage_01.

As a temporary measure (until p_manage_01 could be run) we deleted the z98/z980 records for this index/word combination.

We did:

>>delete from z980 where z980_rec_key like '014000513496%';
1 row deleted

>>delete from z98 where z98_rec_key like '014000513496%';
15 rows deleted

After which, ue_01_word ran successfully, but (of course) this word/index combination continued to not be searchable (until after the successful p_manage_01 run).

• Article last edited: 10/8/2013