Login Problems/Loop

• Article Type: General
• Product: MetaLib
• Product Version: 3

Description:
Users cannot login to MetaLib. I checked the logs and found a loop repeating pds_handle-GUEST as follows:
http://metalib.jmu.ac.uk:8331/V/I1AVKAJ85XRC9IFM9INP9MRATLBUY18BPLR5FB87RYN9V56FN8-01795?&pds_handle=GUEST&pds_handle=GUEST
&pds_handle=GUEST&pds_handle=GUEST&pds_handle=GUEST&pds_handle=GUEST&pds_handle=GUEST&pds_handle=

Resolution:
Most likely this happened because the MetaLib user session index has been corrupted. This could happen when the temporary library vir01 is cleared during work and indexes are not created correctly.
To check this give the following commands on the server :

>> dlib vir01
UTIL-A-17-14
Enter Table Name : z54

This is done to detect if there is a problem with the Z54 session indexes

The output will give you the number of indexes which should be created and the actual number of indexes:
Defined in file_list:
__________________________________________________________
IND z54_id 1M 1M ts1
IND z54_id1 1M 1M ts1
IND z54_id2 1M 1M ts1
__________________________________________________________
Exist in the Database:
INDEX_NAME STATUS UNIQUENES COLUMN_NAME
--------------- -------- --------- -------------------------
Z54_ID1 VALID NONUNIQUE Z54_TIME
Z54_ID2 VALID NONUNIQUE Z54_BOR_ID

From the above, one can see that there is a problem with z54_id
It does NOT exist in the Database

Actions
=======
1. Shutdown MetaLib
2. Perform clear vir01
3. Start MetaLib

This procedure should rebuild the required indexes. Check the indexes to confirm that indexes created correctly.