v20 Order Log incorrect; Oracle error: fetch z71... variable not in select list
- Article Type: General
- Product: Aleph
- Product Version: 20
Description:
We just switched over to v20 today and noticed a big problem with our Order Log. Example is sys #3327862. The Date/Time is strange, there is a date under the User column etc.
--------------------------------------------------------------------------------
Also, when I do util-f-4 in the ABC50 for z71 I get the following:
Oracle error: fetch z71
ORA-01007: variable not in select list
Resolution:
The "Oracle error: fetch z71 ... variable not in select list" indicates that the z71 is in the z19 format rather than v20.
This is what I see in the /exlibris/aleph/upgrade_express_1901_2001/logs/log/1011.log:
Step begin 1011
Building data_scratch/file_list for adm libraries...
Modifying data_root/file_list: add z71_id3 in adm libraries according to Z71_ID2
Updating data_scratch/file_list for adm libraries...
Step end 1011
and this in the upgrade_util View/Update upgrade parameters:
Libraries to be upgraded:
No libraries are currently defined
This is like KB 16384-29745. Please refer to that KB for analysis/resolution.
- Article last edited: 10/8/2013