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

    ILL: error message "Remote service error (c0862)" when displaying summary

     

    • Product: Aleph
    • Product Version: 20, 21, 22, 23
    • Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care

     

    Problem Symptoms:
    When selecting the summary for borrowing requests in GUI ILL:
    * There is an error message 
       "Remote service error (c0862)" Number of requests is zero
    * Sometimes the GUI crashes

     

    Cause:
    Missing Oracle indexes for the Z410 and Z416 tables.

     

    Resolution:
    Recreation of missing indexes using UTIL A 17 2.

     

    Additional Information:
    util a/17/14 can be used to check if all the Oracle indexes defined in file_list are present for a particular table.  

    The SQL in article " How to tell if Oracle indexes for a particular library are present & VALID " can be used to check all the Oracle indexes in a library at once.

     

     


    • Article last edited: 6-Jun-2016