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