• Product: Aleph
• Product Version: 20, 21, 22, 23
• Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care

Description:
After running the Upgrade Express 20-21, we find that when we do util f/4 for the z69 table in version 21 we get the error:

Oracle error: fetch z69
ORA-01007: variable not in select list 

Checking the ./upgrade_express_2001_2101 logs, I find that the 1020 step (which is supposed to add the 

z69_upd_time_stamp and 
z69_client_address_v6

columns to the z69 table) got the following error:

ERROR at line 1:
ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1'

Resolution:
This undo tablespace space problem is discussed in articles "unable to extend segment by 1024 in undo tablespace 'UNDOTS" and  "How big should UNDOTBS1 be?"  

util o/13/1 showed that UNDOTBS1 had one 6-gigabyte datafile. I used util o/13/3 to add second (4000 Meg / 4-gigabyte) datafile. After which, a re-run of Upgrade Express step 1020 was successful.

{In the longer-term, you should consider processing the older z69 records to produce OPAC statistics (with ARC or your own SQL), and then deleting them.}

• Article last edited: 12-Mar-2016