ue_08: ORA-00904: "Z01_CATEGORY": invalid identifier
- Product: Aleph
- Product Version: 20, 21, 22, 23
- Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care
Description:
UE_08 is very slow and the run_e_08 log has hundreds of the following error:
Oracle error: update_cursor4 z01
ORA-00904: "Z01_CATEGORY": invalid identifier
I'm wondering if there is a new index or alteration of an existing Z01 index that we did not acquire in our migration from 17 to 18.
The abc01 util a/17/14 shows that all of the Oracle indexes for the Z01 are present and valid.
Resolution:
ue_08 updates both the xxx01 Z01 *and* the xxx10 (authority library) Z01.
The SQL desc for the abc10 Z01 (see below) shows that the abc10 Z01 lacks the Z01_CATEGORY field, new with version 18. This should have been added by the upgrade, but it seems was not.
Also, util f/4 for the abc10 z01 gets this:
Oracle error: fetch z01
ORA-01007: variable not in select list
At this point, the p_manage_02 and p_manage_17 need to be run for abc10.
First, do util a/17/1 for the abc10 z01. Then, p_manage_02 with:
"Rebuild Entire" ("1") for Procedure to Run; and
"N" for both "Force Check" and "Run in Duplicate Mode"
p_manage_105 is optional but runs very quickly and is useful.
Then, in order to force ue_08 to reprocess the Z01's which it has been failing to process, you need to run the following SQL:
SQL> update z01 set z01_rec_key_4 = '-NEW-000000000' where z01_update_date > 'yyyymmdd';
<where "yyyymmdd" is the date that you went into production of version 18>
(Note: It's possible that this will be too many updates for your rollback segments. You may need to do the update in pieces, by different date ranges.)
SQL desc for abc10 Z01:
SQL> desc z01
Name Null? Type
----------------------------------------------------------------------- -------- ------------------------------------------------
Z01_REC_KEY NOT NULL CHAR(80)
Z01_ACC_SEQUENCE NOT NULL CHAR(9)
Z01_HASH NOT NULL CHAR(12)
Z01_AUT_TAG CHAR(5)
Z01_REC_KEY_4 CHAR(14)
Z01_ACC_SEQUENCE_SEE NUMBER(9)
Z01_NUMBER_OF_DOC NUMBER(5)
Z01_CATALOGER_NAME CHAR(10)
Z01_CATALOGER_LEVEL NUMBER(2)
Z01_OPEN_DATE NUMBER(8)
Z01_UPDATE_DATE NUMBER(8)
Z01_CATALOGER_LIBRARY CHAR(5)
Z01_NON_FILING_CHAR NUMBER(2)
Z01_UPDATE_DOC CHAR(1)
Z01_UPDATE_Z0102 CHAR(1)
Z01_REF_TYPE CHAR(1)
Z01_NORMALIZED_TEXT VARCHAR2(2000)
Z01_DISPLAY_TEXT VARCHAR2(2000)
- Article last edited: 12-Mar-2016