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