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.
Additional Information
SQL, p_manage_02, z02, util a
- Article last edited: 10/8/2013