Oracle errors after Upgrade Express 20-21, but no indication of problems in logs
- Article Type: General
- Product: Aleph
- Product Version: 21
Problem Symptoms:
After running Upgrade Express 20 --> 21, there are fetch znnn / "variable not in select list" errors and Oracle indexes which were supposed to have been added are not present, but no errors are seen (about these tables) in the Upgrade Express log files. See Additional Information below.
Cause:
Uncertain. It may be that the Upgrade libraries were not properly specified (-- but there is no indication of this in the logs).
Resolution:
Perform complete re-run of upgrade_util "3. Upgrade Express" step (for both Aleph files and Oracle tables) corrected the problem.
Additional Information
After running Upgrade Express 20 --> 21,
1. the v21 p_file_20 fails with:
Oracle error: fetch z304
ORA-01007: variable not in select list
Oracle error: fetch z305
ORA-01007: variable not in select list
and the same error is seen in the $usr_library util f/4 for z304 and z305....
The end of the ./alephm/source/copy "vi Z305" shows:
02 Z305-BOOKING-IGNORE-HOURS PICTURE X(1).
02 Z305-RUSH-CAT-REQUEST PICTURE X(1).
02 Z305-UPD-TIME-STAMP PICTURE 9(15).
while the end of SQL "desc z305" for the xxx50 shows only:
Z305_BOOKING_IGNORE_HOURS CHAR(1)
Z305_RUSH_CAT_REQUEST CHAR(1)
That is, the Z305-UPD-TIME-STAMP has not been added. (Same for the z304 and the Z304-UPD-TIME-STAMP.)
and util a/17/14 for z305 shows:
Enter Table Name : z305
Defined in file_list:
__________________________________________________________
IND z305_id 5M 100K TS2X
IND z305_id1 128K 0K TS1X
__________________________________________________________
Exist in the Database:
INDEX_NAME STATUS INDEX_TYPE UNIQUENESS COLUMN_NAME
That is, the z305_id1 is missing.
2. util a/17/14 for the z308 shows that the z308_id3 (new in v21) is missing.
3. SQL shows that the following xxx01 Oracle indexes are missing:
xxx01@ALEPH21> select index_name from all_indexes where owner = 'USM01' and index_name like 'Z%' minus select index_name from all_indexes where owner = 'LAW01' and index_name like 'Z%' and status = 'VALID';
**** Hit return to continue ****
INDEX_NAME
------------------------------
Z07P_ID1
Z35_ID4
But no errors are seen
1. in the .../1007.log for the Z304-UPD-TIME-STAMP / z304_id1,
in the .../1008.log for the Z305-UPD-TIME-STAMP / z305_id1;
2. in the .../1009.log for the z308_id3;d or
3. in the .../1000.log for the z07p_id1 or the .../1010.log for Z35_ID4.
Category: Installation & Upgrades (500)
Subject: Upgrade Express (500)
- Article last edited: 10/8/2013