Run-Time Error '3022': The Changes you Requested to the Table were not Successful


Symptoms


"Run-time error '3022': 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."This error occurs when saving changes to a report or generating a report.

Cause


There is corruption in the specification set.

Resolution


Compact the Current Spec Set. See Compacting an FRx Database. If the compacting fails, please contact FRx Support to repair the file. If the compacting succeeds, but the report component still gives the error message, you should either try to export the component into a new specification set or recreate the component. See How to Import and Export a Specification Set

References