Fatal Error Writing to SYSTEMP (AREV Specific) [Revelation On-Line Wiki]

Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community

At 12 FEB 1998 08:19:45AM Mike wrote:

AREV Specific

Everyone,
  We were running a select when the system froze. 
(After Seleting but while updating query tables).

The user chose to re-boot the machine, rather than

waiting for help. When AREV re-started we had an

error message on SYSTEMP. Using LHVERIFY shows GFE,

USING FIXLH shows Fatal Error Writing Table SYSTEMP.

My question is this - will restoring SYSTEMP from a backup

work, or do I need to re-load AREV. It is a stand-alone PC,

using NT 4.0, running on a PENTIUM 266. Thanks in Advance.
                        Mike

At 12 FEB 1998 08:37AM Aaron Kaplan wrote:

You can restore it, but if the system will let you clear the file, that would be faster.

[email protected]

Sprezzatura, Inc.

At 12 FEB 1998 08:42AM Mike wrote:

Aaron,
 Thanks for the speedy response. Clearing the table did
the trick. I just don't like to mess around with system

tables. Again, thank you very much.
                  Mike

At 12 FEB 1998 11:25AM Victor Engel wrote:

SYSTEMP is just a table for temporary storage of various items, such as work space for select lists. This file can get pretty big if you have enough aborts, so, especially on a stand-alone system, it's a good idea to periodically clear it when nobody but you is logged on.

View this thread on the forum...