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

Description:
The client hangs while trying to catalogue a new item. Below is the log.
I will begin my investigations, but thought I would report right away, in case you have a quick fix...

SERVICE : C0402
MODULE : Circulation Services
DESCRIPTION: Catalog a New Item - Minimal
ACTION : WRITE-CRS
PROGRAM : pc_cir_c0402

Load: /exlibris1/utf19/utf_files/exlibris/aleph/u19_2/mgu30/tab/tab_tag_text
Load: /exlibris1/utf19/utf_files/exlibris/aleph/u19_2/mgu30/tab/tab01.eng

expand_doc_bib_loc_1_c2 debug mode is off


expand_doc_sort_loc_a debug mode is off

Load: /exlibris1/utf19/utf_files/exlibris/aleph/u19_2/mgu30/tab/tab00.eng
Load: /exlibris/aleph/u19_2/alephe/unicode/unicode_to_filing_01
Load: /exlibris/aleph/u19_2/mgu30/tab/tab11_ind
Load: /exlibris/aleph/u19_2/mgu30/tab/tab_z103
Load: /exlibris/aleph/u19_2/mgu30/tab/tab_z105
Load: /exlibris1/utf19/utf_files/exlibris/aleph/u19_2/mgu30/tab/tab_publish
Load: /exlibris1/utf19/utf_files/exlibris/aleph/u19_2/alephe/tab/union_global_param
Load: /exlibris1/utf19/utf_files/exlibris/aleph/u19_2/mgu30/tab/tab_fix
Load: /exlibris1/utf19/utf_files/exlibris/aleph/u19_2/mgu50/tab/tab_tag_text
Load: /exlibris1/utf19/utf_files/exlibris/aleph/u19_2/mgu50/tab/tab_fix
Load: /exlibris1/utf19/utf_files/exlibris/aleph/u19_2/mgu50/tab/tab01.eng
Load: /exlibris1/utf19/utf_files/exlibris/aleph/u19_2/mgu50/tab/tab_expand
Load: /exlibris1/utf19/utf_files/exlibris/aleph/u19_2/mgu50/tab/tab00.eng
Load: /exlibris1/utf19/utf_files/exlibris/aleph/u19_2/mgu50/tab/tab_filing
Load: /exlibris/aleph/u19_2/mgu50/tab/tab11_ind
Load: /exlibris/aleph/u19_2/mgu50/tab/tab_z103
Load: /exlibris/aleph/u19_2/mgu50/tab/tab_z105
Load: /exlibris1/utf19/utf_files/exlibris/aleph/u19_2/mgu50/tab/tab_checksum
Load: /exlibris1/utf19/utf_files/exlibris/aleph/u19_2/mgu50/tab/tab_filing_call_no
Load: /exlibris1/utf19/utf_files/exlibris/aleph/u19_2/mgu50/tab/tab_z105_z30
Info: Empty table /exlibris1/utf19/utf_files/exlibris/aleph/u19_2/mgu50/tab/tab_z105_z30

Oracle error: io_z105_write
ORA-04098: trigger 'MGU50.Z105H_TRIGGER' is invalid and failed re-vali

Resolution:
As can be seen in the mgu50 $data_scratch/file_list, the z105h tab and trigger *are* being included (from the $aleph_root/tab/file_list.z105):

TAB z105h 100K 0K ts0
TRI z105h_trigger

There was a similar existing SI which I have made into a KB record (16384-16193).

We see that, though the z105h_trigger exists, the z105h table does not. There are two possible solutions:

1. Do util a/17/1 for the z105h in the $z105_library to define the z105h. Or

2. Drop the table and trigger:

SQL> drop table z105h;
SQL> drop trigger z105h_trigger;

and add these lines to the $z105_library $data_root/file_list:

NA z105h
NA z105h_trigger

• Article last edited: 10/8/2013