Upgrade Express 18-19: step 1014: An error has occured while upgrading z107

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

Description:
We are getting an error message on step 1014 of the 18-19 Upgrade Express.

Step 1014 - Description:

Course-Reading library - moved Z107 table from the PW library to all ADM libraries.

*******************************************************************
Step begin 1014
...
...
The z107 table's old version is in z107_old

creating new table: abc50
...
...
Enter value for 2:
SP2-0546: User requested Interrupt or EOF detected.
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
...
...
abc50.Z107
*
ERROR at line 2:
ORA-00942: table or view does not exist
...
...
A_ERROR: An error has occured while upgrading z107 in abc50. Rolling back.
...
...
Rollback done.
Step end 1014

The v18 $pw_library has a z107 table, but it is empty (no records). We do not have Course Reading.

Resolution:
Since you are not using Course Reserves, this error can be ignored.

It should, however, have been able to define a z107 table in the abc50 ADM library. I *believe* that the failure to do so may have had to do with the fact that there is no entry for z107 in the v20 abc50 $data_root/file_list and the fact that the abc50 $data_root/prof_library has:

setenv file_list_type USR

This is incorrect. If a library is both an ADM library and the $usr_library, it needs to specify:

setenv file_list_type ADM

• Article last edited: 10/8/2013