Oracle error in ARC ETL log on Aleph production: "Oracle error: io_z900_by_time"
- Article Type: General
- Product: Aleph
- Product Version: 21
Problem Symptoms:
Error messages in ARC ETL log file:
$alephe_scratch/arc_etl.log
<<
/SQL procedure successfully completed.
IN CREATE ARC DELETE TRIGGERS
1 START READING DELETED REC AT 04:48:18
Oracle error: io_z900_by_time
ORA-00942: table or view does not exist
Cause:
Configuration of ./alephe/tab/library_relation
Resolution:
Remove references to ABC30 library which is not fully defined in the system
Change relevant lines in ./alephe/tab/library_relation as follows
./alephe/tab/library_relation
ADM ABCL30 ABC50 <<<< remove this line
HOL ABC30 ABC60 <<<< remove this line
change
BIB ABC50 ABC01 ABC30 ABC40
to
BIB ABC50 ABC01 ABC40
change
BIB ABC60 ABC01 ABC30
to
BIB ABC60 ABC01
Additional Information
The ETL is looking for all bibliographic libraries related to the ADM library as defined in $alephe_tab/library_relation.
If this library is not fully set up, this definition causes the error message "Oracle error: io_z900_by_time
ORA-00942: table or view does not exist"
Category: ETL (ARC)/ARC
Subject: ARC
- Article last edited: 5/5/2014