At 03:04 PM 7/30/2015, Bill Niehaus wrote:
We are having trouble printing some reports and labels from our database.
I ran Autocheck and R:Scope and found no errors.
When I try to unload the database and reload it, I get some errors
during the reloading.
I am attaching the list of errors.
The errors appear to be of three types:
1 - Default value for changeDateShipping will be ignored
2 - Column SugarDev must be a valid REAL (We get lots of these
errors even though looking
at the values for those columns appears to be all numbers or missing data.)
3 - PestAppQuery is an undefined table (get several of these while
the "table" is really
a view).
Do you have any suggestions on where we start to fix this database?
Bill,
Please review the following suggestions.
01.
There is a definition for the changeDateShipping column where it is
set to "Computed"
and with a "Default Value". Only one can be set at a time. Edit the
table where the
column resides and remove the Default Value setting.
02.
The may be related to 01., or may be a separate issue. When you RUN
the unloaded
database structure and data, set the OUTPUT to a log file to capture
as much information
as possible.
OUTPUT DB_Rebuild.Log
RUN DBName.ALL
OUTPUT SCREEN
View the log output. The errors are likely originating from one
table. Review the
table structure and sequence of data output to verify the correct data is being
loaded into the intended column.
03.
The view PestAppQuery was either deleted and not recreated, and other
views depend
on it for definition, or the view structure is located further down in the view
creation list.
In recent R:BASE releases, the unloaded views are ordered in a
sequence where views
dependent other views are listed further down the list. So, perhaps
the PestAppQuery
view no longer exists.
You can UNLOAD the database structure and data separately to verify
the structure
will be rebuild correctly when both structure and data are used in the rebuild
process.
There are specific instructions within the the "Database Repair
Routine" section of
the DatabaseMaintenance.pdf document (default: C:\RBTI\RBG95_64).
Hope that helps!
Please feel free to reach out to me with any questions.
Good luck and ...
Very Best R:egards,
Razzak
www.rbase.com
www.rbaseX.com
www.facebook.com/rbase
--
32 years of continuous innovation!
17 Years of R:BASE Technologies, Inc. making R:BASE what it is today!
--
