UE 18->19, step 1002: ... error possibly near <*> indicator at char 1022

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

Description:
I've run into a problem with Upgrade Express from Aleph 18 to 19 on one of my Course Reading libraries.

The log file is attached, but the basic problem is that UE step 1002, which moves some fields from z13 to z13u is failing for a reason that I cannot understand.

The abc30 has this message which the other libraries do not:
A_WARNING: The table z13u in abc30 has already been upgraded.

The big problem is that, in failing, it is losing data. The UE step has problems with adding some data to the Z13U table, but instead of stopping, it goes ahead and truncates that data from the z13 table. The result is that there is no data in Z13u and the z13u columns in z13 are now gone.

Resolution:
The upgrade takes the ..._USER_DEFINED_1, _2, _3, _4, and _5 fields from the Z13 and moves them to the Z13U, so it is normal for these columns to be gone from the z13 in v20.

The following SQL shows that all the z13_USER_DEFINED_1 fields in abc30 in v18 are null:

abc30> select count(*) from z13 where z13_USER_DEFINED_1 is not null;
**** Hit return to continue ****

COUNT(*)
----------
0

Thus, no data has been lost. I agree that the UE 1002 should handle this better, but I believe there is no problem with the end result.

Also: the z13 and z13u can be rebuilt by p_manage_07. If there *is* a problem with the z13 or z13u, p_manage_07 can be used to correct it.

• Article last edited: 10/8/2013