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.