If you are using DataCare to perform the Data Integrity Check, and you would like more information on this error than what is being provided, you can go into DC's Housekeeping | Company Profile and set the option for "Diagnostic level" to "Verbose". Then do a single entry check on Sales Analysis and print the DC Log again to see more.The short answer to DataCare and flat/keyed file checking is that it is looking for invalid characters in each of the fields. That would include both unrecognized ASCII characters and characters that don't belong in certain fields (such as Document Type that only have a few discrete possibilities).

Keyed file checking is for indexed/ISAM files. The flat (and keyed) file check is performed during the Phase 1 stage where DC will report on discrepancies found in the relationship between the data records and the key (ISAM) files. The layout for the files in a database is included in a resource data file. DC uses this information to check that each key points to the correct record and to check that there are no records without a corresponding key.

At this point, there are a couple of things you can do:

1. Try running Sales Analysis's "Update Item Description File". This will update the item descriptions in Sales Analysis to match current data from QIP or IC. Currency Code, Item number, Price list, Item source and Item description are all updated by this option. If changes have been made to those fields in either QIP or IC, the Update Item Description option should be run to ensure that the Sales Analysis database is current.

2. If you have made changes in your Sales Analysis database, (ie cleared or edited sales data), you may want to run the "Rebuild Sales Statistics" function to see if this sorts it out.

3. If you have a current backup of your Sales Analysis data, you could restore from this backup, then try the Data Integrity Check again to ensure all is ok. You may have to scan in any records that are missing from this backup to update Sales Analysis properly.

4. You could get a quote for a Database Repair from us. If you decide to do this, you can email: datarepair@softrak.com , or phone (604) 736-3741 and ask for that department.

Hope this helps,
Regards