ORA-01007 (fetch z403)

• Article Type: General
• Product: Aleph
• Product Version: 22, 23

Problem Symptoms:
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.
 

Cause:
The xxx60 Z403 has the old Aleph 21 structure.
The structure of Z403 can be checked via SQL:
desc XXX60.z403;

In Aleph 22 the table should have field Z403_IP_ADDRESS_V6.
Z403 is not needed in HOL libraries and therefore obsolete in XXX60.

Resolution:
* 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;