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

Description:
After restarting ALEPH in our production region we are getting this error in the $data_scratch directory of nov01.

Util a/17/14 shows that z07a and its index are present. The other two processes of ue_01 seem to be processing records.

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

Resolution:
It seems that the z07a records were being processed successfully despite this message. Using the SQL select count(*) from z07a, I waited until the table was empty and then did util a/17/1 to drop/recreate it.

(I also stopped/restarted ue_01 -- this was not necessary for correcting this problem -- but I wanted to get a clean log.)

The errors are no longer appearing.