manage-01: "name is already used ...; such column list already indexed"
- Article Type: General
- Product: Aleph
- Product Version: 20
Problem Symptoms:
Running manage-01 ("Rebuild Words Index"): the following messages appear in the $alephe_scratch manage-01 ) log:
1. Z9n "table or view does not exist"
2. Z9n "name is already used by an existing object:"
3. Z9n_ID "such column list already indexed"
where Z9n is the:
Z95 (List of words in document),
Z97 (Word dictionary), or
Z98 (Word/record)
Z980 (Temporary word/record)
See sample log in "Additional information" below.
Cause:
Library in which manage-01 is being run in has Synonyms pointing z95, z97, z98, and z980 to another (parallel) library.
Resolution:
1. Do util a/17/5/1 ("List Library Synonyms") in the library in which the job is being run.
1a. Confirm that there are Synonyms for the z95, z97, z98, and z980.
2.. vi $data_root/file_list
2a. Delete LS Z9n lines from file_list.
3. Copy TAB Z9n and IND Z9n_ID lines from other library file_list to this library file_list.
4. Do util a/17/5/2 ("Drop/recreate Library Synonyms") in the library in which the job is being run.
5. Resubmit manage-01 exactly as submitted previously.
Additional Information
Messages in the $alephe_scratch manage-01 ("Rebuild Words Index") log:
aleph_admin@ALEPH0> 12:26:38 aleph_admin@ALEPH0> DROP TABLE XXX01.Z95
*
ERROR at line 1:
ORA-00942: table or view does not exist
...
...
CREATE TABLE XXX01.Z95 (Z95_DOC_NUMBER CHAR(9) NOT NULL,
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
...
...
aleph_admin@ALEPH0> 12:26:40 aleph_admin@ALEPH0> CREATE UNIQUE INDEX XXX01.Z95_ID ON XXX01.Z95 (Z95_DOC_NUMBER ASC)
*
ERROR at line 1:
ORA-01408: such column list already indexed
And similar messages for the z97, Z98, and z980.
Category: Background processing (500)
Subject: Indexing (500)
- Article last edited: 10/8/2013