I ran a check on my database and it came back with a lot of errors. Unfortunately I'm not entirely sure what they mean or how to go about fixing them. If someone could point me in the right direction I would appreciate it.
Here is part of the report (too long to post, the report in it's entirety is attached):
Quote:
===============================================
Database Check Statistics
===============================================
Pervasive.SQL Compatibility Mode = 7
Tables Checked = 80
Tables Passed = 3
Tables Failed = 77
Illegal Object Names = 3
Record Length Inconsistencies = 8
Variable Length Column Inconsistencies = 0
Data Type Inconsistencies = 0
Column Overlaps = 0
Full Path (instead of Relative) Table Locations = 0
Table Files Don't Exist = 0
Index Inconsistencies = 774
System Table Inconsistencies = 0
General Dictionary Inconsistencies = 2
===============================================
Tables That Passed Test
===============================================
X$Field
X$File
X$Index
===============================================
===============================================
Problems Detected with Database Definitions
===============================================
+++++++++++++++++++++++++++++++++++++++++++++++
Table Name = Accounts
Index Seg Flag Inconsistency.
The dictionary index 0 seg 0 indicates Yes
Data file index 0 seg 0 indicates No
Index Length Inconsistency.
The dictionary index 0 seg 0 indicates 8 (Column = 'MainAccount')
The data file index 0 seg 0 indicates 16
Dictionary Index Not Defined in Data File.
Dictionary defines index 0 seg 1
The data file does not.
Index Seg Flag Inconsistency.
The dictionary index 1 seg 1 indicates Yes
Data file index 1 seg 1 indicates No
Index Length Inconsistency.
The dictionary index 1 seg 1 indicates 8 (Column = 'MainAccount')
The data file index 1 seg 1 indicates 16
Dictionary Index Not Defined in Data File.
Dictionary defines index 1 seg 2
The data file does not.
Index Seg Flag Inconsistency.
The dictionary index 2 seg 1 indicates Yes
Data file index 2 seg 1 indicates No
Index Length Inconsistency.
The dictionary index 2 seg 1 indicates 8 (Column = 'MainAccount')
The data file index 2 seg 1 indicates 16
Dictionary Index Not Defined in Data File.
Dictionary defines index 2 seg 2
The data file does not.
Index Seg Flag Inconsistency.
The dictionary index 3 seg 1 indicates Yes
Data file index 3 seg 1 indicates No
Index Length Inconsistency.
The dictionary index 3 seg 1 indicates 8 (Column = 'MainAccount')
The data file index 3 seg 1 indicates 16
Dictionary Index Not Defined in Data File.
Dictionary defines index 3 seg 2
The data file does not.
+++++++++++++++++++++++++++++++++++++++++++++++
Table Name = APOpen
illegal column name '1099Amount'.
Index Seg Flag Inconsistency.
The dictionary index 0 seg 6 indicates Yes
Data file index 0 seg 6 indicates No
Index Seg Flag Inconsistency.
The dictionary index 1 seg 7 indicates Yes
Data file index 1 seg 7 indicates No
Index Seg Flag Inconsistency.
The dictionary index 2 seg 7 indicates Yes
Data file index 2 seg 7 indicates No
Index Seg Flag Inconsistency.
The dictionary index 3 seg 6 indicates Yes
Data file index 3 seg 6 indicates No
Index Seg Flag Inconsistency.
The dictionary index 4 seg 8 indicates Yes
Data file index 4 seg 8 indicates No
Index Seg Flag Inconsistency.
The dictionary index 5 seg 7 indicates Yes
Data file index 5 seg 7 indicates No
Index Data Type Inconsistency.
The dictionary index 6 seg 2 indicates 5 (Column = 'VoucherNumber')
The data file index 6 seg 2 indicates 0
Index Seg Flag Inconsistency.
The dictionary index 6 seg 8 indicates Yes
Data file index 6 seg 8 indicates No
Index Seg Flag Inconsistency.
The dictionary index 7 seg 7 indicates Yes
Data file index 7 seg 7 indicates No
Index Data Type Inconsistency.
The dictionary index 8 seg 2 indicates 5 (Column = 'LastActvityDate')
The data file index 8 seg 2 indicates 0
Index Seg Flag Inconsistency.
The dictionary index 8 seg 8 indicates Yes
Data file index 8 seg 8 indicates No
+++++++++++++++++++++++++++++++++++++++++++++++
Table Name = Attribute
Index Seg Flag Inconsistency.
The dictionary index 0 seg 1 indicates Yes
Data file index 0 seg 1 indicates No
Index Length Inconsistency.
The dictionary index 0 seg 1 indicates 1 (Column = 'AttributeNumber')
The data file index 0 seg 1 indicates 13
Dictionary Index Not Defined in Data File.
Dictionary defines index 0 seg 2
The data file does not.
Dictionary Index Not Defined in Data File.
Dictionary defines index 0 seg 3
The data file does not.
Index Seg Flag Inconsistency.
The dictionary index 1 seg 2 indicates Yes
Data file index 1 seg 2 indicates No
Index Length Inconsistency.
The dictionary index 1 seg 2 indicates 1 (Column = 'AttributeNumber')
The data file index 1 seg 2 indicates 13
Dictionary Index Not Defined in Data File.
Dictionary defines index 1 seg 3
The data file does not.
Dictionary Index Not Defined in Data File.
Dictionary defines index 1 seg 4
The data file does not.
+++++++++++++++++++++++++++++++++++++++++++++++
Table Name = Audit
Index Seg Flag Inconsistency.
The dictionary index 0 seg 6 indicates Yes
Data file index 0 seg 6 indicates No
Index Length Inconsistency.
The dictionary index 0 seg 6 indicates 2 (Column = 'ColorNumber')
The data file index 0 seg 6 indicates 4
Dictionary Index Not Defined in Data File.
Dictionary defines index 0 seg 7
The data file does not.
Index Seg Flag Inconsistency.
The dictionary index 1 seg 7 indicates Yes
Data file index 1 seg 7 indicates No
Index Length Inconsistency.
The dictionary index 1 seg 7 indicates 2 (Column = 'ColorNumber')
The data file index 1 seg 7 indicates 4
Dictionary Index Not Defined in Data File.
Dictionary defines index 1 seg 8
The data file does not.
+++++++++++++++++++++++++++++++++++++++++++++++
Table Name = BadCheck
illegal column name '1stLetterDate'.
illegal column name '2ndLetterDate'.
Index Seg Flag Inconsistency.
The dictionary index 0 seg 2 indicates Yes
Data file index 0 seg 2 indicates No
Index Seg Flag Inconsistency.
The dictionary index 1 seg 0 indicates No
Data file index 1 seg 0 indicates Yes
Index Length Inconsistency.
The dictionary index 1 seg 0 indicates 41 (Column = 'Zkey1')
The data file index 1 seg 0 indicates 1
The Data File Index is Not Defined in the Dictionary.
The data file defines index 1 seg 1
The dictionary does not.
The Data File Index is Not Defined in the Dictionary.
The data file defines index 1 seg 2
The dictionary does not.
The Data File Index is Not Defined in the Dictionary.
The data file defines index 1 seg 3
The dictionary does not.
Dictionary Index Not Defined in Data File.
Dictionary defines index 1 seg 0
The data file does not.
Index Seg Flag Inconsistency.
The dictionary index 2 seg 1 indicates Yes
Data file index 2 seg 1 indicates No
+++++++++++++++++++++++++++++++++++++++++++++++
Table Name = BankAccount
Index Seg Flag Inconsistency.
The dictionary index 1 seg 1 indicates Yes
Data file index 1 seg 1 indicates No
Index Seg Flag Inconsistency.
The dictionary index 2 seg 1 indicates Yes
Data file index 2 seg 1 indicates No
Index Seg Flag Inconsistency.
The dictionary index 3 seg 1 indicates Yes
Data file index 3 seg 1 indicates No
Index Length Inconsistency.
The dictionary index 4 seg 0 indicates 8 (Column = 'MainAccount')
The data file index 4 seg 0 indicates 16
Index Seg Flag Inconsistency.
The dictionary index 4 seg 1 indicates Yes
Data file index 4 seg 1 indicates No
Index Offset Inconsistency.
The dictionary index 4 seg 1 indicates 50 (Column = 'SubAccount')
The data file index 4 seg 1 indicates 58
Index Length Inconsistency.
The dictionary index 4 seg 1 indicates 8 (Column = 'SubAccount')
The data file index 4 seg 1 indicates 5
Dictionary Index Not Defined in Data File.
Dictionary defines index 4 seg 2
The data file does not.
+++++++++++++++++++++++++++++++++++++++++++++++
Table Name = Barcode
Index Length Inconsistency.
The dictionary index 1 seg 1 indicates 2 (Column = 'ColorNumber')
The data file index 1 seg 1 indicates 4
Index Offset Inconsistency.
The dictionary index 1 seg 2 indicates 17 (Column = 'SizeNumber')
The data file index 1 seg 2 indicates 19
Index Length Inconsistency.
The dictionary index 1 seg 2 indicates 2 (Column = 'SizeNumber')
The data file index 1 seg 2 indicates 1
Index Offset Inconsistency.
The dictionary index 1 seg 3 indicates 19 (Column = 'Type')
The data file index 1 seg 3 indicates 20
Index Seg Flag Inconsistency.
The dictionary index 1 seg 4 indicates Yes
Data file index 1 seg 4 indicates No
Index Offset Inconsistency.
The dictionary index 1 seg 4 indicates 20 (Column = 'BarcodeNumber')
The data file index 1 seg 4 indicates 21
Index Length Inconsistency.
The dictionary index 1 seg 4 indicates 1 (Column = 'BarcodeNumber')
The data file index 1 seg 4 indicates 20
Dictionary Index Not Defined in Data File.
Dictionary defines index 1 seg 5
The data file does not.
Index Seg Flag Inconsistency.
The dictionary index 2 seg 0 indicates No
Data file index 2 seg 0 indicates Yes
Index Length Inconsistency.
The dictionary index 2 seg 0 indicates 21 (Column = 'Zkey2')
The data file index 2 seg 0 indicates 1
The Data File Index is Not Defined in the Dictionary.
The data file defines index 2 seg 0
The dictionary does not.
The Data File Index is Not Defined in the Dictionary.
The data file defines index 2 seg 1
The dictionary does not.
+++++++++++++++++++++++++++++++++++++++++++++++
|
P.S.
The despite all these errors, the database (or at least the program that uses it), seems to work fine.
dBforums
>
DB Check Report Errors
01-08-10, 12:43
Linear Mode
