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

    Unable to retrieve set of records" error when trying to display

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

    Description:
    When you click on "Show" to display the results of an OPAC search in the GUI, you get the message "Remote Service Error (c1005 11) Unable to retrieve set of records".

    Or, for a Browse, when you try to display the titles:

    Error 49 Not defined for service C1011 LOAD-SET in file pc_sear_c1011

    In the pc_server log you see messages such as these:
    PROGRAM: pc_sear_c1011

    Oracle error: io_z05_write
    ORA-00942: table or view does not exist

    io_z05_write: REATTEMPTING TO WRITE Z05...

    Oracle error: io_z05_update
    ORA-00942: table or view does not exist

    Oracle error: io_z05_update
    ORA-01003: no statement parsed

    Oracle error: io_sequence_next
    ORA-00936: missing expression

    Oracle error: io_z05_write
    ORA-00903: invalid table name

    Oracle error: io_z110_write
    ORA-00903: invalid table name

    Oracle error: io_z110_write
    ORA-00942: table or view does not exist

    io_z110_write: REATTEMPTING TO WRITE Z110...

    Oracle error: io_z110_start
    ORA-00942: table or view does not exist

    Oracle error: io_z05_update
    ORA-01003: no statement parsed

    [Note: since the z05 and z110 are also used by the Web OPAC, you would see similar errors there.]

    Resolution:
    The z05 and z110 result-set tables are re-initialized by clear_vir01.

    This problem occurs when the pc_server is running and a user tries to retrieve a result-set at the time clear_vir01 is re-initializing the z05 and z110.

    The clear_vir01 log may not show any error, but we find that the errors start occurring in the pc_server log *immediately* after clear_vir01 is run.

    The immediate solution is to restart the pc_server and the www_server. If the $alephe_scratch/clear_vir01 log shows z05 or z110 errors, then you will need to recreate those tables, using either util a/17/1 or clear_vir01 -- but we have found that usually there are no such errors and the util a/17/1 / clear_vir01 do *not* need to be run.

    It would seem that this might also be a problem if the p_sdi_01 job (which generates z05 and z110 records) were running at the same time as clear_vir01.

    The solution is to run clear_vir01 at a time when users are not likely to be doing searches and the print daemon is not running. Or to stop the pc_ and www_server, run clear_vir01, then restart the servers. (See KB 5297 about the method for doing this.)

    Additional Information

    Unable to retrieve set of records" Shaw search


    • Article last edited: 10/8/2013
    //Feedback