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

Description:
We are getting "Unable to find global patron information" for a particular patron. The patron's name is not showing up on the patron list.

SQL shows:

select z303_REC_KEY, z304_REC_KEY from z303, Z304 where
2 substr(z303_REC_KEY,1,12)=substr(z304_REC_KEY,1,12) and
3 substr(z303_REC_KEY,1,12) LIKE '15653%';
**** Hit return to continue ****

Z303_REC_KEY Z304_REC_KEY
------------ --------------
15653 15653 01

So they are both in z303 and z304,

Also:
abc50@ALEPH18> select z303_REC_KEY, z304_REC_KEY, z305_REC_KEY from
2 z303, z304, z305 where
3 substr(z303_REC_KEY,1,12)=substr(z304_REC_KEY,1,12) and
4 substr(z305_REC_KEY,1,12)=substr(z304_REC_KEY,1,12) and
5 z305_REC_KEY like '15653%';
Z303_REC_KEY Z304_REC_KEY Z305_REC_KEY
------------ -------------- -----------------
15653 15653 01 15653 ABC50


It is the z308 - can this be fixed?

select z303_REC_KEY from z303
2 MINUS select z308_ID from z308;
**** Hit return to continue ****
Z303_REC_KEY
------------
15653

1 row selected.

Z303_REC_KEY
------------
15653

select z308_ID from z308
2 MINUS select z303_REC_KEY from z303;
**** Hit return to continue ****

Z308_ID
------------
16563


More:

select * from z308 where z308_ID IN
2 ( select z308_ID from z308 MINUS select z303_REC_KEY from z303);
**** Hit return to continue ****
Z308_REC_KEY Z308_VERIFICATION Z3
--------------------------- ---------------------------------------- --
Z308_ID Z3 Z
------------ -- -
0016563 ABC50 15653 00
16563 AC N

0115653 ABC50 15653 00
16563 AC N

Resolution:
If you are getting the "Unable to find global patron information" for multiple patrons, consult KB 3894.

This case was a defect in this one specific patron, so we corrected the z308 to match the z303, z304, and z305 as follows:

1. Back up the z308 with p_file_03.

2. SQL> update z308 set z308_rec_key = '0015653 ABC50' where z308_rec_key = '0016563 ABC50';

That should update one row.

3. Then:

SQL> update z308 set z308_id = '15653' where z308_id = '16563';

That should update two or three rows.

4. SQL> commit;

5. Then run p_cir_25 (to rebuild the z353 patron index).

• Article last edited: 10/8/2013