A_ERROR: The old table xxx.02.z69 description does not match the expected description

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

Problem Symptoms:
The v21 Upgrade Express log has the following error:

A_ERROR: The old table xxx.02.z69 description does not match the expected description.
4a5
> Z69_BOR_ID VARCHAR2(12)
6c7
< Z69_EVENT_TYPE VARCHAR2(2)
---
> Z69_EVENT_TYPE CHAR(2)
16a18,20
> Z69_SAVE_TO VARCHAR2(20)
> Z69_SAVE_FORMAT VARCHAR2(30)
> Z69_DOC_NUMBER NUMBER(9)

Cause:
The message is in regard to the xxx02 z69 (OPAC Events). The z69 is defined in v20 but the count(*) is 0.

The z69 which is actually being used is the xxx01.

Resolution:
Ignore the message in v21 and do the following to avoid future confusion:

(1)
?€¢ s+ duk02 ? make sure it?€™s duk02
?€¢ drop table z69;

(2) remove the following lines from the xxx02 file_list:
LS z69 XXX01
IND z69_id2 4M 0K TS1X

Category: Installation & Upgrades (500)

Subject: Upgrade Express (500)

• Article last edited: 12/10/2013