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

Description:
We currently have the union view set up in the OPAC for course reserves. Our course reserves coordinator noticed that when he searchs in the OPAC for new courses he just added it's displaying the wrong records for the courses.

This seems to just be a problem for new courses he is adding in v19. All other courses are displaying fine.

Resolution:
I found that, though these new ABC30 records have z120 records, they have no z127 records.

The update of the z127 is supposed to occur via a trigger on the z120. (When the z120 is updated, the trigger causes the z127 to be updated.)

The $aleph_root/tab/file_list.COURSE has entries for the z127 triggers and the ABC30 $data_scratch/file_list (the merged file_list) contains the entries shown below. (For information on managing the file_list, see KB 8192-3719.)

TRI z127_trigger
TRI z127_trigger_1
TRI z127_trigger_2

But util a/17/6/4 for abc30 shows no z127 triggers.


You need to do:

1. util a/17/6/1 ("Create/Recreate Library Triggers")

2. util a/17/6/4 to confirm that the z127 triggers exist

The preceding steps will assure that the updates to the z120 by ue_01 (or p_union_14) will result in z127 updates as well.

3. run create_127 and load_z127_to_mem to create z127's for the doc records which have been created since the initial run. (Note: The load_z127_to_mem is not strictly necessary for a very small database, such as the Course Reserve database.)

• Article last edited: 10/8/2013