z30h lacks Z30H_PROCESS_STATUS_DATE column; Z30H_OLD

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

Description:
Our cataloger noticed that no item history would display in the GUI (in our new version 20) even after updating an item. Looking at the database, I can see ABC50.Z30H and ABC50.Z30H_OLD tables. I haven't seen any documentation or reasons for why there would be an _OLD table.

It does appear that the current item histories are being captured in the Z30H table but are not displaying in the GUI.

It seems that this is due to the lack of the z30h_id Oracle index. I tried to do util a/17/2 to build it but got this error:

CREATE UNIQUE INDEX VCU50.Z30H_ID ON VCU50.Z30H (Z30H_REC_KEY ASC)
*
ERROR at line 1:
ORA-00955: name is already used by an existing object

I'm assuming this is because the index still exists in the z30h_old table?

Also - it looks like the z30h_old table was not updated in the 19-20 upgrade express as it is missing the Z30H_PROCESS_STATUS_DATE column.

Resolution:
DESC Z30H" for abc50 z30h_old shows that it lacks the Z30H_PROCESS_STATUS_DATE column.

The Z30H_PROCESS_STATUS_DATE column should have been added to the z30h by upgrade_express_1901_2001 step 1003.

Apparently in your v18 - 20 upgrade this step failed or was not run. (And then another staff member renamed the non-updated z30h to "z30h_old".)

You need to run this step (using the v18 z30h as input) to add the Z30H_PROCESS_STATUS_DATE.

If your only objective is to be able to test the item history display for an item after it has been updated in version 20, then, after doing the following, you should find that the item history displays:

s+ abc50
SQL> drop table z30h_old
util a/17/2 z30h <build the z30h_id Oracle index>

[This worked.]

When you next run the 19-20 Upgrade Express, you should make sure that the 1003 step is successful.

• Article last edited: 10/8/2013