p_manage_02: z02_id fails; hundreds of duplicate z02's for same doc record

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

Description:
p_manage_02 fails with these messages:

Wed Oct 12 05:44:37 EDT 2005 Error : Only 1 indexes out of 2 for table z02 were created
Wed Oct 12 05:44:37 EDT 2005 Error : index list for index creation was 'z02_id', 'z02_id1'
Wed Oct 12 05:44:37 EDT 2005 Error : Please check logs /exlibris/aleph/u16_1/lva01/scratch/create_ora_tables_z02_id*.log

When we use util a/17/2 to build the z02_id, we get a "duplicates" error.

What should be we do?

Resolution:
This SQL showed that there were 270 duplicates:

SQL> select z02_rec_key from z02 group by z02_rec_key having count(*) > 1;

All the keys had "001503105" in bytes 10-19:

000609063001503105
000609064001503105
000609066001503105
<etc.>

Bytes 10-19 are the Z02-SEQUENCE-1 (which is the doc number).
Therefore, all of these Z02's were for the same doc number (The record has 100 650 fields, 90 651 fields -- all with "$$xHistory$$z1913-1921"--, and 20 other headings-eligible fields. We are uncertain if the problem was the number of headings of a particular type, the 90 headings with "$$xHistory$$z1913-1921", or something else....)

We did this to delete these duplicate Z02s:

SQL> delete from z02 where z02_doc_number = '001503105';

We were then able to build the z02_id with util a/17/2. (***ue_01 should not run!)

Then we sent doc record 001503105 to the server to be re-indexed.