At 01:27 PM 7/20/2013, Alastair Burr wrote:
... what is causing me the real problem is that RELOAD exits with these
errors and sets the ErrVar to the error number.
R>reload xxx
-ERROR- Table SYS_COMMENTS has an incorrect number of rows. ( 450)
-ERROR- Table SYS_DEFAULTS has an incorrect number of rows. ( 450)
-ERROR- Table SYS_COMPUTED has an incorrect number of rows. ( 450)
-ERROR- Table SYS_CONSTRAINTS has an incorrect number of rows. ( 450)
Finished reloading with 4 error(s).
RELOAD operation is complete
Any thoughts?
Alastair,
Got R:Scope 9.5 (32/64)?
If not, UNLOAD and then Re-Build the database and see what you observe.
Here's a very simple exercise to check the health/integrity of the database.
Note: Make a backup copy of your database before following the steps below.
-- At the R> Prompt
SET MESSAGES ON
SET ERROR MESSAGES ON
DISCONNECT
CONNECT dbname IDENTIFIED BY owner password
OUTPUT ABC.ALL
UNLOAD ALL
OUTPUT SCREEN
DISCONNECT
RENAME dbname.rb? dbbackup.rb? -- 9.5 (32)
RENAME dbname.rx? dbbackup.rx? -- 9.5 (64)
SET FEEDBACK ON
RUN ABC.ALL
SET FEEDBACK OFF
Watch the database being re-build right in front of your eyes.
Notice any -ERROR-s, if any, and handle those specific items accordingly.
With a corrupted database schema or data, you may check the health/integrity
of your database using the two-step process as follows:
-- Step 01 (Unload Database Schema)
DISCONNECT
CONNECT dbname IDENTIFIED BY owner password
OUTPUT ABC_STRUCTURE.ALL
UNLOAD STRUCTURE
OUTPUT SCREEN
-- Step 02 (Unload Actual Data)
OUTPUT ABC_DATA.ALL
UNLOAD DATA
OUTPUT SCREEN
DISCONNECT
RENAME dbname.rb? dbbackup.rb? -- 9.5 (32)
RENAME dbname.rx? dbbackup.rx? -- 9.5 (64)
-- First Re-Build the Database Schema
CLS
RUN ABC_STRUCTURE.ALL
Watch the database schema being re-build right in front of your eyes.
Notice any -ERROR-s, if any, and handle those specific items
accordingly by manually editing the ABC_STRUCTURE.ALL file.
Make sure to delete the dbname.rb? or dbname.rx? prior to running
the ABC_STRUCTURE.ALL again.
Repeat this step until you have a perfect database database schema
with no -ERROR-s using the TRACE option as follows:
CLS
DISCONNECT
DELETE dbname.rb? -- 9.5 (32)
DELETE dbname.rx? -- 9.5 (64)
TRACE ABC_STRUCTURE.ALL
Make sure to delete the dbname.rb? or dbname.rx? prior to TRACing
the ABC_STRUCTURE.ALL again.
-- Once the database schema is built with no errors, then load the data
CLS
SET FEEDBACK ON
RUN ABC_DATA.ALL
SET FEEDBACK OFF
Hope this simple exercise/steps provides you with some blue's clues!
Very Best R:egards,
Razzak.
www.rbase.com
www.facebook.com/rbase
--
30+ years of continuous innovation!
15 Years of R:BASE Technologies, Inc. making R:BASE what it is today!
--
