"Run time error -2147217887. The changes you requested to the table were not successful because they would create duplicate values in the index..." when performing various tasks

Entry Type: Informational

Product: FRx

Application: FRx Desktop   

Version Reported: 6.71

Subject:

The following error occurs when performing various tasks in FRx:

"Run time error -2147217887  The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again."

Possible Resolution:

FRx for Sage MAS 90 ERP and Sage MAS 200 ERP:

Duplicate records exist in the GL_AccountHistory file. To resolve this issue, perform the following:

Note: Use caution when working with this task. Always make a backup first. If necessary, seek the assistance of a qualified Sage Software support analyst.

1. Have all users exit Sage MAS 90 or 200 and FRx.
2. Reinitialize the GL_AccountHistory file. For more information, see How to reinitialize and manually reinitialize data files.
3. Rebuild sort files for General Ledger. For more information, see How to rebuild sort files.
4. Delete the .G32 file. For more information, see How to delete the .G32 file.