Object not available for your current profile"; two z61_rec_key's "ALEPH"
- Article Type: General
- Product: Aleph
- Product Version: 20
Problem Symptoms:
* Unable to view recently-acquired ebooks in OPAC. Error message: "Object not available for your current profile."
* Error attempting to modify ALEPH profile in GUI Circ --> Patrons --> Patron profiles. Error message: "Library for ALEPH profile cannot be changed".
Cause:
SQL showed two ALEPH rec-keys in XXX50 (where XXX50 is the $usr_library):
xxx50@ALEPH20T> select z61_rec_key, z61_user_library from z61 where z61_rec_key = 'ALEPH';
**** Hit return to continue ****
Z61_REC_KEY Z61_U
------------ -----
ALEPH USM50
ALEPH XXX50
util a/17/14 showed that the XXX50 z61_id Oracle index didn't exist:
Enter Table Name : z61
Defined in file_list:
__________________________________________________________
IND z61_id 128K 0K TS1X
__________________________________________________________
Exist in the Database:
Enter CR to continue...
Resolution:
1. Delete the ALEPH / USM50 rec-key:
xxx50@ALEPH20T> delete from z61 where z61_rec_key = 'ALEPH' and z61_user_library = 'USM50';
1 row deleted.
2. Do util a/17/2 to create the z61_id Oracle index
3. Blank out the z61_user_library:
xxx50@ALEPH20T> update z61 set z61_user_library = NULL where z61_rec_key = 'ALEPH';
1 row updated.
Additional Information
Updating the ALEPH profile in the GUI was then OK.
SQL information:
This SQL (prior to the Delete) showed that ALEPH was the only duplicated z61_rec_key:
abc50@ALEPH20T> select z61_rec_key, count(*) from z61 group by z61_rec_key having count(*) > 1;
**** Hit return to continue ****
Z61_REC_KEY COUNT(*)
------------ ----------
ALEPH 2
Category: Circulation (500)
Subject: Profiles
- Article last edited: 10/8/2013