- Article Type: General
- Product: Aleph
- Product Version: 18.01
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.
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.
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',
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 ****
- Article last edited: 10/8/2013