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

Description:
We have the problem described in KB 8192-938, but in the usm01/usm10 libraries:

ue_08: ORA-00904: "Z01_CATEGORY": invalid identifier -- for USM01

The Z01_CATEGORY was created fine in the production instances.

Resolution:
I find that, despite your having run p_manage_01 for usm10, the usm10 z01 is still incorrect: when I do util f/4 for the z01, I get:

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

Same for the usm01 z01.

But after doing util a/17/1 for the usm10 z01 and usm01 z01, and sending a record to the server (with util f/1/13) to populate the z01. Both of these z01's now display in util f/4 without error.

Now, p_manage_01 and p_manage_17 need to be run for usm10. And then p_manage_102, _02, _17, _32, and _35 need to be run for usm01.


[Jerry Specht]
[11/26/2006 4:53:22 AM Jerry Specht]