Issue
The following message appears during a certain process or transaction in Sage Pro:
Error 5: Record is out of range
Solution or Workaround
Important
Create a full and verified backup before proceeding. This should first be attempted in a test installation and the results should be fully verified before implementing in a live system.
This message indicates one of the following:
Corrupted Table
The message generally indicates a corrupted table in Sage Pro. Use the check table integrity to identify and fix these corrupted tables, please refer to solution <rn:answer_xref title=”22706.html”>22706.html”>22706 for more information.
Important
Using the check table integrity to fix corrupted tables may resolve the error, but it may permanently remove and delete records from the table.
Damaged Index Files
Each .dbf file has a corresponding .cdx (index) file. The error will appear if there is a damaged .cdx file. There maybe cases where the check table integrity will not detect any errors or fix the damage index. In this situation delete all index files and then reindex the application and system files.
If running the check table integrity tool does not fix the error, validate and rebuild the database container. Please refer to solution<rn:answer_xref title=”21935.html”>21935.html”>21935.
In some cases either using check table integrity or rebuilding the database container may not resolve the error. In this circumstance, a third party data repair tool is required to fix the corrupted tables. Please contact your Sage Business Partner, Certified Consultant or Solution Provider to assist.
Table Exceeding Certain Record Count
This occurs under unique circumstances. To date there has been only a few reports of this scenario and in these reports the records that are causing the error have been found in the ICITEM tables exceeding 3845 records. Depending on which report is using the table and how it is sorting the records, the error appears. This is a issue with Microsoft FoxPro because the error can be replicated externally by performing the following query on an ICITEM table with more than 3845 records:
OPEN DATABASE PRODATA
USE ICITEM
SET ORDER TO ITEM
SKIP
© Copyright Sage Software
