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

Description:
The following error was found in the pc_server log. What is the z00t table that is trying to be updated here? According to the staff user below, at the time of the error she was searching for and deleting c-fly items in the system. She did not get any GUI errors during the process though.

SERVICE : C0227
MODULE : Catalog Services
DESCRIPTION: No Description Available
ACTION :
PROGRAM : pc_cat_c0227

Oracle error: update_cursor2 z00t
ORA-00942: table or view does not exist

Resolution:
If you want to use the Document Tracking function (new with v20), then you need to do util a/17/2 to build the Oracle indexes for the xxx01 z00t table.

If you don't want to use the Document Tracking function, then you should remove the "fix_doc_track" line from xxx01 tab_fix: the programs will then no longer be looking for the z00t.

The z00t functionality is described in KB 16384-42497.

• Article last edited: 10/8/2013