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

Description:
After refreshing the database on our Aleph 20 server (from Aleph18), I've tried to re-run the process for linking up the course reserve records (per KB 16384-25617). The indexing jobs (steps 1-4) are not working. Bibliographic information is indexing, but course related information is not. Also, viewing the records in the OPAC, I see bib data (e.g. author/title) but not course data (e.g., instructor, course number).

Resolution:
Dlib-ed to abc50, I get this when I do util f/4 for the z108:

Oracle error: fetch z108
ORA-01007: variable not in select list

The fetch error indicates that the z108 data is not in the format v20 is expecting.

> asm copy
> view Z108
01 Z108.
02 Z108-REC-KEY. K
03 Z108-COURSE-NUMBER PICTURE X(20).
03 Z108-COURSE-SEQUENCE PICTURE 9(4).

02 Z108-ALPHA PICTURE X(1).

02 Z108-COURSE-NAME PICTURE X(100).
02 Z108-COURSE-NAME-KEY PICTURE X(100). S

02 Z108-INSTRUCTOR-NAME PICTURE X(100).
02 Z108-INSTRUCTOR-NAME-KEY PICTURE X(100). S

02 Z108-DEPARTMENT PICTURE X(100).
02 Z108-DEPARTMENT-KEY PICTURE X(100). S

02 Z108-UNIT PICTURE X(20).
02 Z108-UNIT-KEY PICTURE X(20). S

02 Z108-DATE-FROM PICTURE 9(8).
02 Z108-DATE-TO PICTURE 9(8).

02 Z108-PERIOD PICTURE X(100).


>s+ abc50

SQL-abc50> desc z108
Name Null? Type
----------------------------------------- -------- ----------------------------
Z108_REC_KEY NOT NULL CHAR(20)
Z108_PROXY_COURSE_NUMBER CHAR(20)
Z108_ALPHA CHAR(1)
Z108_COURSE_NAME VARCHAR2(100)
Z108_COURSE_NAME_KEY CHAR(100)
Z108_INSTRUCTOR_NAME VARCHAR2(100)
Z108_INSTRUCTOR_NAME_KEY CHAR(100)
Z108_DEPARTMENT VARCHAR2(100)
Z108_DEPARTMENT_KEY CHAR(100)
Z108_DATE_FROM NUMBER(8)
Z108_DATE_TO NUMBER(8)
Z108_PERIOD VARCHAR2(100)
Z108_NO_STUDENTS NUMBER(5)
Z108_WEEKLY_HOURS CHAR(2)

You will note that the ./alephm/source/copy/Z108 file has a Z108-REC-KEY with the 4-byte Z108-COURSE-SEQUENCE at the end while the desc lacks that.

The 18-19 UE step which converts the z108 from v18 to v19/20 is 1013. It seems that this step was not executed against this z108,... or it failed.

Though there are no errors, the 1013 step was not executing properly ... we see this in the log:

Step begin 1013
___ drop table abc50.z108
___ create table abc50.z108 as (select * from abc30.z108)
___ drop table abc30.z108

Building data_scratch/file_list for adm libraries...
Modifying data_root/file_list: add z108 in adm libraries according to Z30
Updating data_scratch/file_list for adm libraries...


Whereas we *should* see this:

Step begin 1013
___ drop table abc50.z108
___ create table abc50.z108 as (select * from abc30.z108)
___ drop table abc30.z108

Building data_scratch/file_list for adm libraries...
Load: /exlibris/aleph/u20_2/alephe/tab/tab100
Load: /exlibris/aleph/u20_2/law50/tab/tab100
^[[2J^[[H^[[0m
ALEPH/SUN_OS_2, Copyright Ex Libris.
version 20 revision 01 copy 1, 12-Feb-2009
Modifying data_root/file_list: add z108 in adm libraries according to Z30
Updating data_scratch/file_list for adm libraries...
Load: /exlibris/aleph/u20_2/alephe/tab/tab100
Load: /exlibris/aleph/u20_2/law50/tab/tab100
^[[2J^[[H^[[0m
ALEPH/SUN_OS_2, Copyright Ex Libris.
version 20 revision 01 copy 1, 12-Feb-2009

The upgrade_util -> Upgrade parameters -> View Current Parameters has:

Libraries to be upgraded:
abc30

Even though you are running only the 1013 step, that step needs to have abc50 in the list in order to be able to operate on that library also.

Remember: the UE step 1013 requires that the input z108 be in the xxx30 library. Since the previous 1013 will have deleted it, you need to move the unconverted z108 back to the abc30 from the abc50 -- or get it from somewhere else -- prior to rerunning step 1013.

• Article last edited: 10/8/2013