• Article Type: General
• Product: Aleph
• Product Version: 20

Description:
We're getting errors in several of the Oracle steps where it is trying to create a new index. The error is:

/exlibris/aleph/upgrade_express_1801_1901/logs/log/1002.log:ORA-00959: tablespace 'TS2X' does not exist

The thing is, our tablespace is TS2XA, not TS2X. It appears that somewhere a variable is being set incorrectly to only have the first 4 characters of the tablespace name. Is that possible?

Can we simply modify the file_list's in ./u20_1/abcnn/scratch directory by changing TS2X references to TS2XA, then re-run the Oracle steps > 999?

Resolution:
This message is occurring because the program is reading the $aleph_root file_list.XXX templates to supplement your ABCnn file_list's. This is described in KB 16384-24994.

The abcnn/scratch/file_list is a *by-product* of the process. The program

1. reads your ./abcnn/file_list
2. adds entries from the relevant $aleph_root/tab/file_list.XXXX (which are not included in #1)
3. writes the merged table out to $alephe_scratch

It re-does this *each* time. The simplest thing is to add the new indexes, etc., to each of your ./abcnn/file_list's.

• Article last edited: 10/8/2013