Topic: Redundant sample keys in SAMPLE_GEOM table

Hello, I've recently hit on an issue that has been preventing our reimporting data. We'd used the import wizard to import originally, but due to errors in the data, we had to delete them and reimport. The records were deleted via the delete button in the Survey window.

Upon reimporting I have been getting most items rejected because the unique key is already in the SAMPLE_GEOM table. However it doesn't appear in the Sample table and neither is it in the Tocc table. We import using Mapmate keys.

Has anyone experienced this before and does anyone have a fix?

I've removed the few keys that were causing the issue, but I am concerned that we will hit this lingering keys issue again.

Many thanks,


Eric Fletcher
RECORD Manager