manage-01: Oracle errors "io_z30_sub_library_list_n" and "update_cursor13 z30"
- Article Type: General
- Product: Aleph
- Product Version: 21
Problem Symptoms:
manage-01: the following errors appear in the xxx01 $data_scratch p_manage_01_a_*log's:
Oracle error: io_z30_sub_library_list_n
ORA-00942: table or view does not exist
Oracle error: update_cursor13 z30
ORA-00942: table or view does not exist
There are 8 occurrences of the former and 11 of the latter.
Note: this is a multi-ADM site.
Cause:
Uncertain
Resolution:
Given the fact that there are just 18 occurances (each representing one link/record), the best option is to just ignore them. If there's a real problem, someone will report it.
Though Article 000014285 ("Oracle error: update_cursor1 z30; ... table or view does not exist") is for "Oracle error: update_cursor1 z30", I believe it's the same principle as this cursor13 (z30_id13 Oracle index) error.
The SQL shown in that Article on xxx50 gives the results shown in Additional Information below. There are no blank or incorrect z103_lkr_library values. The same should be done for the other ADM's.
Article 12400 ("Oracle error: io_z30_sub_library_list_n") is relevant to the other error, but, likewise, with just the 8 occurrences, it is not a cause for real concern.
Additional Information
xxx50@ALEPH21> select z103_lkr_library, z103_lkr_type, count(*) from z103 group by z103_lkr_library, z103_lkr_type order by z103_lkr_library, z103_lkr_type;
**** Hit return to continue ****
Z103_ Z10 COUNT(*)
----- --- ----------
XXX30 ADM 3327
XXX30 ITM 9806
XXX50 ADM 1352296
YYY01 ADM 1348969
YYY01 ITM 8674
ZZZ30 ITM 11
Category: Batch (500)
- Article last edited: 9/3/2014