SYSTEMP FILE ERROR (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 16 JUL 1999 11:23:50AM ROSS COOPER wrote:

AREV Specific

Lately my system has been crashing on an error relating

to the SYSTEMP file. I think the error message is FRAME

FORMAT ERROR. (I have had this problem in the past.)

Should I delete the SYSTEMP file and RE-CREATE it? I

don't see the SYSTEMP file when I do a LISTTABLES. Is

there something I need to know to re-create this file?

Please let me know your thoughts.

Thank you,

Ross Cooper

Greystone Health Sciences

At 16 JUL 1999 02:06PM Don Miller - C3 Inc. wrote:

Try typing:
  CLEARTABLE SYSTEMP
from the TCL. That will clear out any data that may be there without reading the frames.

Don Miller

C3 Inc.

At 19 JUL 1999 04:18PM Victor Engel wrote:

Just in case you have not done this yet, I suggest doing the following first.

Make sure all users are logged off, or at the very least not doing any sort of query.

Dump the SYSTEMP file and make sure the sizelock is set to 0.

Then clear the file. The SYSTEMP file is used as temporary storage for queries, hence item number 1. Changing the sizelock to 0 if it is not 0 already will make the cleartable run much faster as well as free up more disk space.

View this thread on the forum...