xxx30: "Error: library does not exist"; z103 "Invalid table name"

• Article Type: General
• Product: Aleph
• Product Version: 16.02

Description:
In running p_manage_07 for a Course Reserve library you get:
Error: library does not exist

And in running p_manage_12 you get:
Oracle error: update_cursor1 z103 ORA-00903: invalid table name

Resolution:
The p_manage_07 is reading the SID field in order to build the SID direct index. The p_manage_12 is reading the SID field in order to build the z103 ITM links.
These errors indicate that the programs have encountered a record which doesn't have the library in the expected position in the SID field. The SID should have a "dollar-dollar-a" (a-subfield code) and then the library. In this case the record's SID field lacked the a-subfield code.

KEYWORDS: manage_12 p-manage-12 p-manage-107 manage_107