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