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

Description:
I just ran the ALEPH 19.01 --> 20.01 Upgrade Express kit, and received a fatal error in step 1004. Here are the relevant sections from the 1004.log:

Populating the new field.
====Library: umn40====
Start processing ABC40.z410,ABC50.z700...
A_WARNING: Unable to prepare SQL. Error from Oracle:
DBD::Oracle::db prepare failed: ORA-00942: table or view does not exist (DBD ERROR: error possibly near <*> indicator at char 100 in 'select Z700_PROTOCOL_TYPE, Z410_ILL_UNIT, Z410_REC_KEY, Z700_REC_KEY_2 from ABC40.z410,ABC50.<*>z700 where Z410_ILL_UNIT IS NOT NULL and (Z700_PROTOCOL_TYPE = 'ISO' or Z700_PROTOCOL_TYPE = 'DANZG') and Z410_ILL_UNIT = trim(Z700_REC_KEY)') [for statement ``select Z700_PROTOCOL_TYPE, Z410_ILL_UNIT, Z410_REC_KEY, Z700_REC_KEY_2 from ABC40.z410,ABC50.z700 where Z410_ILL_UNIT IS NOT NULL and (Z700_PROTOCOL_TYPE = 'ISO' or Z700_PROTOCOL_TYPE = 'DANZG') and Z410_ILL_UNIT = trim(Z700_REC_KEY)'']) at /exlibris/aleph/upgrade_express_1901_
2001/source/1004/implement_a.pl line 31.

Building the index again, this time uniq.
UMN40 Z411_ID6 Z411
Creating index z411_id6 in umn40.

snip, snip

ERROR at line 1:
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found

-- end of log snippet --

The Z411-TRANSACTION NUMBER values are all zeros.

Resolution:
This has been corrected in the 19->20 UE package 1.08 and higher. The latest version of the package is available on the Ex Libris ftp server.

• Article last edited: 10/8/2013