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.