ABC50 item records not linked to HOL records after upgrade to v18

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

Description:
ABC50 item records not linked to HOL records after upgrade to v18, that is, they do not appear under the HOL record in the Navigation tree on the lower left and the Linked column in the HOL links tab of the item record is not checked.

I found KB entry 8192-2102 about how this can happen if the Z30_ID5 index is missing. However it wasn't. Just to be sure, I rebuilt the ABC50/Z30_ID5 index, but the problem persists.

Resolution:
When I do util f/4 for the abc50 z30, I get:

Oracle error: fetch z30
ORA-01007: variable not in select list

The "variable not in select list" indicates that the fields in the record don't match what ALEPH's expecting.

Comparing the ./alephm/sql_stat/z30_create.sql -- what the program's expecting -- to the "s+ abc50" "desc z30" -- what has been loaded --, I see that four fields are missing:

< Z30_SHELF_REPORT_NUMBER CHAR(20),
< Z30_ON_SHELF_DATE NUMBER(8),
< Z30_ON_SHELF_SEQ NUMBER(6),
...
< Z30_MAINTENANCE_COUNT NUMBER(3)

The Z30_HOL_DOC_NUMBER_X -- and all the fields following the Z30_PRICE -- are read incorrectly.

These four fields should have been added by the v16 - v17 Upgrade Express. It seems that that step was not executed or failed for some reason.

• Article last edited: 10/8/2013