At 07:02 PM 7/30/2008, [EMAIL PROTECTED] wrote:
RScope sees this table and reports :
The width in two byte words of each row for table SYS_COMMENT_ID
is set to 1 in the structure file. It should be within the range
of 2 to 2100.
Is this a valid table?
Any thoughts?
Bob,
R:Scope 7.5 or R:Scope 7.6 can indeed fix this structural error.
Here's how:
With your reported error;
The width in two byte words of each row for table SYS_COMMENT_ID
is set to 1 in the structure file. It should be within the range
of 2 to 2100;
the problem is that the row size(s) for the SYS_COMMENTS table
is outside the valid range.
To repair the corruption,
01. First make a backup copy of the database.
02. Launch R:Scope 7.5/7.6, and connect to the corrupted database.
03. From the menus, select "Fix" > "Columns"
04. Select "SYS_COMMENTS" from the list.
05. The available columns, SYS_COMMENT_ID and SYS_COMMENT will be
displayed.
06. Here, starting with SYS_COMMENT_ID, verify the following:
Location in Row (2 Byte Words): 1
Data Type: 1
Length: 1
Scale: 0
07. If any values are different than what is listed above,
make the appropriate changes and save the changes.
08. Next, viewing SYS_COMMENT, verify the following:
Location in Row (2 Byte Words): 3
Data Type: 8
Length: 1
Scale: 0
09. If any values are different than what is listed above,
make the appropriate changes and save the changes.
10. Now, run the "Check Structure" options in R:Scope for
the SYS_COMMENTS table. Zero errors should be reported.
11. Lastly, to verify the entire database integrity, check
all the tables.
That's all there is to it!
Very Best R:egards,
Razzak.
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
