Error 3022 - changes requested to the table were not successful

Modified on: 2017-09-22 13:52:11 -0400


Error 3022 The changes requested to the table were not successful because they would create duplicate values in the index, primary key or relationship.


This error means that data is trying to be inserted into the database but must overwrite data that cannot be overwritten.  Certain types of data corruptions can cause this problem especially if the software is run while using a corrupted or incorrectly formatted database. 

The first step to solving the problem would be run a repair and then a live update.  Make sure that the live update is a full update; the sync portion of the update is what is important (A REPAIR and then the FPASYNC.EXE can be run in lieu of the live update).   ** MAKE SURE THAT A BACKUP IS OBTAINED BEFORE RUNNING AND UTILITIES OR UPDATES!! **

During the FPASYNC or Sync portion of the live update, the utility should come up with at least one but possibly several 3022 messages.  In each case it has found bad records, click on IGNORE to skip and remove each bad record (may have to click ignore multiple times).  Do not click any other choice accept for ?ignore!?   For example, if ?abort? is chosen the database will be destroyed and you must restore from backup.

Should the FPASYNC or live update not fix the problem then a description of exactly where in the software the error occurs along with a copy of the database must be sent to Design Manager technical support for analysis.




Did you find this helpful? Yes No

Can you please tell us how we can improve this article?