Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    GUI search: "Unable to retreive set of records"; can't log-in to OPAC

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

    Description:
    When a search is done in the GUI it finds results but when you attempt to display the results it gives an error message that says Remote service error (c1005 set11) Unable to retreive set of records. Also, when you try accessing the OPAC, you cannot even login as guest.

    [Later:]
    It appears that clear VIR01 didn't run correctly this morning resulting in a lot of tables not being recreated. The SYSTEM tablespace was out of space so I just added more space to it. The system is still not useable but I'm unsure what tables need to be recreated or how to recreate them.

    Resolution:
    The SQL below (from KB 8192-6423) showed that almost all the vir01 tables lacked Oracle indexes -- and may not have been present at all. Here's what I did to run clear_vir01:

    > cd alephe_scratch
    > csh -f $aleph_proc/clear_vir01 VIR01 > & clear_vir01.1008.js &

    Adding tablespace and runing clear_vir01 corrected the problem.

    SQL (from KB 8192-6423):

    vir01@ALEPH1> select index_name from all_indexes where index_name in
    ('Z00_ID', 'Z01_ID', 'Z01_ID2', 'Z01_ID3', 'Z01_ID4', 'Z02_ID', 'Z02_ID1', 'Z05_ID', 'Z05_ID1', 'Z05_ID2',
    2 3 'Z05_ID3', 'Z05_ID4', 'Z101_ID', 'Z103_ID', 'Z103_ID1', 'Z110_ID', 'Z11_ID', 'Z11_ID1', 'Z130_ID', 'Z131_ID',
    4 'Z13_ID','Z140_ID',
    5 'Z51_ID', 'Z52_ID', 'Z60_ID', 'Z63_ID', 'Z63_ID1', 'Z64_ID', 'Z65_ID')
    6 minus select index_name from all_indexes where owner = 'VIR01';
    **** Hit return to continue ****

    INDEX_NAME
    ------------------------------
    Z02_ID
    Z02_ID1
    Z05_ID
    Z05_ID1
    Z05_ID2
    Z05_ID3
    Z05_ID4
    Z101_ID
    Z103_ID
    Z103_ID1
    Z110_ID
    Z11_ID
    Z11_ID1
    Z130_ID
    Z131_ID
    Z13_ID
    Z51_ID
    Z52_ID
    Z60_ID
    Z63_ID
    Z63_ID1
    Z64_ID
    Z65_ID


    • Article last edited: 10/8/2013