Unable to find global patron information" for one patron; z308 incorrect
- 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