Upgrade Express 20-22 error: "The old table z31 description does not match ..."

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

Problem Symptoms:
In upgrading from v20 - v22, upgrade_express_20_21 gives the error:

A_ERROR: The old table z31 description does not match the expected description.

for the Z31_DESCRIPTION and Z31_KEY columns.

Cause:
upgrade_express_20_21 expects the v20 input columns to look like this:

Z31_DESCRIPTION VARCHAR2(300)
Z31_KEY CHAR(100)

Instead, they looked like this:

Z31_DESCRIPTION VARCHAR2(100)
Z31_KEY VARCHAR2(100)

Apparently a 18->19 or 19->20 upgrade step to change these columns did not occur -- but seems to have not prevented successful use of the z31 table in v20.

Resolution:
1. Do the following (in v20) to put the columns in the form that upgrade_express_20_21 expects:

alter table z31 modify Z31_DESCRIPTION VARCHAR2(300);
alter table z31 modify Z31_KEY CHAR(100);

2. Re-run the upgrade_express_2101_2201 export and import steps.
3. Re-run the upgrade_express_2001_2101 upgrade steps ("3. Upgrade express")