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

Description:
Step 1002 is to move the 5 user defined fields from the z13 to the z13u. It failed to do this. The 5 user-defined fields are no longer in the abc01.z13 -- nor in the abc01.z13u.

When I look at v18 using SQL, for the z13_user_defined_1 in ABC01, I get 1528355 rows returned with data. On v19, the rows are all empty.

This is with UE kit 1.07.

Resolution:
This is like KB 16384-8593, which was fixed locally (by Ex Libris).

As seen in util a/17/5/1, the abc01 z13 has a synonym pointing to abc21:

Z13 ABC21 Z13

The following lines in the log file (logs/log.20081026.104003/1002.log) refer to ABC21 (we admit it's hard to figure it out - we'll make it clearer in the new version of the UE):

A_ERROR: The old table z13 description does not match the expected description.
3c3
< Z13_REC_KEY CHAR(9)
---
> Z13_REC_KEY NOT NULL CHAR(9)

So... abc21.z13 was not upgraded since it was a little different than what it should have been (compared to the description in source/1002/z13_new_desc.dat) - the "NOT NULL" was missing.

abc21@ALEPH19> desc z13 shows this:

Z13_REC_KEY CHAR(9)


while the $alephm_root/sql_tab/z13_create.sql has this:

Z13_REC_KEY CHAR(9) NOT NULL,


and usm01@ALEPH19> desc z13 this:

usm01@ALEPH19> desc z13
Name Null? Type
----------------------------------------------------------------------- -------- -------------------------------------------------
Z13_REC_KEY NOT NULL CHAR(9)

Aside from the z13_rec_key NOT NULL, the v19 z13 should not have the Z13_USER_DEFINED fields (which have moved to the Z13U table). I see that the abc21 z13 *does* have these fields.

A comparison of the v18 to the v19, shows that the above differences are the only differences. It's possible that you could drop the USER-DEFINED fields from the z13 and then do this SQL:

SQL> ALTER TABLE Z13 MODIFY (Z13_REC_KEY NOT NULL);

The other approach would be to:

1. do util a/17/1 for the abc21 z13

2. confirm that the SQL "desc z13" shows the correct values

3. rerun the Upgrade Express step 1002 for abc21.

• Article last edited: 10/8/2013