Oracle error: update_cursor z103x

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

Problem Symptoms:
When running "Create Holdings and Item Records Using Bibliographic Data (manage-50)" in order to create items in a new ADM library several Oracle errors where reported in the log file:

Oracle error: update_cursor z103x
ORA-00942: table or view does not exist

Items and holding records where created correctly but for every one of the 16712 bib records processed the error appears.

These errors do not occur when running ""Create Holdings and Item Records Using Bibliographic Data (manage-50)" and create items in other ADMs.

Cause:
Configuration

Resolution:
Creating z103x must be in conjunction with update_z103_lkr_extended. This is from rep_ver #017012 in Aleph 21 were the new table was provided:

1) Create Z103X oracle table:
1.1) Add Z103X table to file_list in ALL libraries having Z103 table, For example xxx01/file_list:

!1 2 3 4 5 6
!!!-!!!!!!!!!!!!!!!!!-!!!!!!!!!!!!!!!-!!!!!!!!!!!!!!!-!!!!!!!!!!!!!!!-!!!!!!!!!!!!!!!!!!!!
TAB z103x 100K 0K TS1D
IND z103x_id 100K 0K TS1X

1.2) Create Z103X oracle table in all libraries having Z103 table using util/a/1/17.

2) Activate the extended linking routine:
2.1) In xxx01/tab/tab_z103 add the following line:
! 1 2
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!-!!!!!!!!!!!!!!!!!!!!->
update_z103_lkr_extended

2.2) In xxx50/tab/tab_z103 add the following line:
! 1 2
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!-!!!!!!!!!!!!!!!!!!!!->
update_z103_lkr_extended
 

3) Run manage-12 in order to create the links.

If you don't want to use z103x in xxx50 you should drop it and also delete it from the file list.

Category: Cataloging (500) - ALEPH

Subject: Services - ALEPH

• Article last edited: 2/27/2014