It looks like you're trying to import a taxon occurrence that is missing its parent sample which is a scenario that shouldn't be possible with a standard Recorder 2002/6 export. Where has this export come from?

i'm getting the original copy and will try to see if there is problem when we exporting or the data itself at the back.

Taxon occurrence key is missing on determination table. Could this happen on the earlier version of Export on Recorder 2000?

taxon_occurrence_key data is key missing from taxon_determination table

cheers

Luck

There are 96 species in the Recorder 3 dictionary which are not in the Recorder 3 list in the Recorder 6/Recorder 2002 dictionary. If a Recorder 3 system contains records for any of these, then unless corrective action is taken, the records for them transfer without a Taxon_list_item_key (if I remember correctly). If a record doesn’t have a Taxon_list_item_key it cannot be displayed in the observation hierarchy because there is no species name to display.

In a R2002 to R6 data transfer I did recently nearly 200 taxon occurrences didn't transfer because they didn't have a sample in Recorder 2002; over 50,000 taxon determinations didn't transfer because they didn't have a taxon occurrence or because their taxon occurrence couldn't be transferred because it didn't have a sample in Recorder 2002. Nearly 200  taxon occurrence data entries didn't transfer because their taxon occurrences didn't transfer. These problems were all in Recorder 2002 so they were nothing to do with the R2002 to R6 data transfer. I don't know how this could have happened in Recorder 2002 but the customer said they thought it was due to problems with a very early version (2000-2001) of the import wizard.