- Article Type: General
- Product: Aleph
- Product Version: 22, 23
After upgrade to Aleph 22 following messages occured in pc_server_nnnn.log:
Oracle error: fetch z403
ORA-01007: variable not in select list
Lines preceding these errors in the log (such as "Load: /aleph_tmp/utf_files/.../xxx60/tab/tab_buf_z403") indicate that the program is looking for the z403 in an xxx60 HOL library.
The xxx60 Z403 has the old Aleph 21 structure.
The structure of Z403 can be checked via SQL:
In Aleph 22 the table should have field Z403_IP_ADDRESS_V6.
Z403 is not needed in HOL libraries and therefore obsolete in XXX60.
* Make sure that Z403 in XXX60 is empty:
>select count(*) from xxx60.z403;
* If it has no data drop the table:
>drop table xxx60.z403;
Per system design Z403 should only exist in BIB and CRS libraries.
- Article last edited: 5/8/2014