Results 1 to 1 of 1
  1. #1
    Join Date
    Dec 2009
    Posts
    11

    Unanswered: DB Check Report Errors

    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):
    ===============================================
    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.
    Attached Files Attached Files
    Last edited by SilverJester; 01-08-10 at 13:47.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •