Oracle error: io_z36_read; ORA-01007: variable not in select list

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

Description:
We see the following in our test upgrade v18 pc_server logs:

Oracle error: io_z36_read
ORA-01007: variable not in select list

What might be causing such an error? We do have z36 tables for all of our xxx50 libraries currently.

Resolution:
util f/4 for the abc50 z36 shows the same error:

enter file name (or q to exit) z36
new key = K, exit = Q, continue = RETURN
...
Oracle error: fetch z36
ORA-01007: variable not in select list

<end util f/4>

Comparing the SQL ABC50 "desc z36" to the /exlibris/aleph/a18_1/alephm/sql_tab/z36_create.sql, we see that these additional columns, which do not appear in the desc z36, are present in the v18 z36:

Z36_RETURN_LOCATION CHAR(5),
Z36_RETURN_SUB_LOCATION VARCHAR2(100),
Z36_SOURCE CHAR(1),
Z36_DELIVERY_TIME CHAR(4),
Z36_TAIL_TIME CHAR(4)

(One can also see these additional fields in the v18 ./alephm/source/copy/Z36 file.)

Since I find that the v17 Z36 also includes these columns, that means that the v16 -> v17 Upgrade Express step which converts the z36 did not occur properly. It is step 1017.

*******************************************************************
Step 1017 - Description:

This step updates the Z36 records based on the following changes performed
to the table:

1. Following new fields have been added to the Z36 record:

- Z36-EFFECTIVE-DUE-DATE: This field is for future use. The field is added
and set to 00000000.

- Z36-RETURN-LOCATION: This field contains the return location of the
booking request. The field is added and left empty.

- Z36-RETURN-SUB-LOCATION: This field contains the return sublocation of
the booking request. The field is added and left empty.

- Z36-SOURCE: This field specifies the origin of the loan. For regular loans
this field is left blank. The field is added and left empty.

- Z36-DELIVERY-TIME: This field is populated when the loan was created
following a booking request. The delivery time (the time that will be
added at the end of the booking request) is kept in this field. The field
is added and left empty.

- Z36-TAIL-TIME: This field is populated if the loan was created following
a booking request. The field contains the tail time, this is the time that
will be added at the end of the booking request. The field is added and left
empty.

2. The following fields are removed:

- Z36-LOAN-CATALOGER-NAME
- Z36-RETURN-CATALOGER-NAME
- Z36-RENEW-CATALOGER-NAME

They are replaced by the following fields:

- Z36-LOAN-CATALOGER-NAME
- Z36-LOAN-CATALOGER-IP
- Z36-RETURN-CATALOGER-NAME
- Z36-RETURN-CATALOGER-IP
- Z36-RENEW-CATALOGER-NAME
- Z36-RENEW-CATALOGER-IP
*******************************************************************