ERROR 10230 RECONSTRUCTING A FILE – DUPLICATE ITEMS IN INDEX

Error 10230 is listed in the B-Tree filer Error Codes as: ‘The key to add was declared as a primary key, but it already exists; or the key to add was declared as secondary key and exists with the same data reference.’ This error occurs while reconstructing a file. The program is attempting to write an entry to the index file, but an identical entry already exists. Currently, there is no alternative, but to locate the duplicates and delete or change one of the records. Locate the temporary file used during reconstruct, i.e. PO.$$$ when reconstructing the PO.DAT file. Divide the size of the PO.$$$ by the record size of PO’s then subtract one. This is the record number of the entry that is causing the error.