ue_08: ORA-00904: "Z01_CATEGORY": invalid identifier -- for USM01
- 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]
Additional Information
usm01, usm10, z01-category
- Article last edited: 10/8/2013