At 07:11 PM 9/26/2005, Claudine Robbins wrote:

One of my databases has the syslayouts3 corrupted.  RScope 7.5 reports:

Syslayouts3 -- The LOB column value address (1156579328) is beyond the end
of LOB data file (file 4) at 4583424.

Any idea how I can attempt to manually fix this or should I just put a cross
on today's work and start over tomorrow with last week's backup?

I get a "Error - Internal error -- out of dynamic space" and "database files
are out of sync (2520)"

Claudine,

Without knowing all details, here's how to fix your specific situation:

Example:

01. Start RBG7 or RBG75

02. CONNECT dbname

03. At the R> Prompt:

    DELETE ROWS FROM SYS_LAYOUTS3

    RELOAD abcd

    DISCONNECT

    DELETE dbname.RB?

    RENAME abcd.rb? dbname.rb?

04. CONNECT dbname

Notes:

. Substitute dbname with the name of your actual database.
. With LAYOUT set to ON, you'll need to re-define data browser's layout
  settings, if you wish.

That's all there is to it!

Have fun!

Very Best R:egards,

Razzak.

Reply via email to