Problems w/ Dictionary record %Protect_Spec% (OpenInsight 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 24 MAR 1998 04:43:14PM Chris Blankenburg wrote:

OpenInsight Specific

While trying to save the dictionary, the system gave me a Unable to Save Temp_(table_name) error message. Now my dictionary is not accessible and LH2.LOG file is showing the following:

RO 26 DICT.HR_MASTER*HRIS OK

OP DATA\REV88951 69 OK

RC 69 OK

RD 69 %FIELDS% OK

RD 69 %PROTECT.SPEC% ERROR:107 FILE:1 GROUP:55

Running OI3.12, NT Service, NT Server 4.0, Win95, TCPIP, etc.

BTW..The LHService did not show any corresponding errors!

Any Ideas on whats going on and how to recover?

At 24 MAR 1998 05:29PM Aaron Kaplan wrote:

It seems like you have a GFE in the dictionary file.

Can you dump the file? If so, fix group 55.

apk@sprezzatura.com

Sprezzatura, Inc.

At 24 MAR 1998 07:01PM Chris Blankenburg wrote:

Aaron,

Thanks for the prompt reply. No, I can't do anything with the file at this point! No, read, open, etc etc. Any suggestions other than restore from backup??

cb

At 25 MAR 1998 09:36AM Aaron Kaplan wrote:

You could try attaching in the DICT file as a non-dict file and killing the %PROTECT_SPEC% record.

apk@sprezzatura.com

Sprezzatura, Inc.

At 30 MAR 1998 12:15PM Cameron Revelation wrote:

Chris,

RD 69 %PROTECT.SPEC% ERROR:107 FILE:1 GROUP:55

That is an unknown read error (see FSERRORS_100). Suggestion:

(Back up first!)

1) Create a blank table in the volume called NEWDICT.

2) Copy the REVMEDIA record for the existing dictionary from DICT.* to Q_DICT.*

3) Make sure that field 2 of the Q_DICT.* record is blank

4) Attach the Q_DICT. table

5) LH verify the Q_DICT.

6) Copy the dictionary fields (not % stuff) from Q_DICT. into NEWDICT

7) Look at the REVMEDIA record NEWDICT* … write down the number from field 1 (e.g. REV78047)

8) Delete the REVMEDIA records Q_DICT.* and NEWDICT*

9) Look at the REVMEDIA record DICT.* … write down the number from field 1 (e.g. REV78041) and make sure field 2 is blank.

10) Look at the REVMEDIA record * … writed down whatever is in field 2 and then blank it out.

11) Log out of OI (all users)

12) Delete the OS rev files (.lk/.ov) for the dictionary (e.g. REV78041.*)

13) Rename the OS rev files (.lk/.ov) for the NEWDICT to the dictionary (e.g. rename REV78047.* to REV78041.*)

Cameron Purdy

info@revelation.com

View this thread on the forum...