About 10 records are missing from an excel import and I'm not entirely sure why. Here is the rejection report, can anyone advise on this?
Items rejected by Recorder 6 in data imported at 13-23-39 on 10/09/2015:
Failed to insert LC0004260000G00D into TAXON_OCCURRENCE
Database Error Message:
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_TAXON_OCCURRENCE_SAMPLE". The conflict occurred in database "NBNData", table "dbo.SAMPLE", column 'SAMPLE_KEY'.(-2147217873) The statement has been terminated.(-2147217873)
Note: This record may have been rejected because of a parent record that was also rejected.
--------------------
Failed to insert LC0004260000G00E into TAXON_OCCURRENCE
Database Error Message:
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_TAXON_OCCURRENCE_SAMPLE". The conflict occurred in database "NBNData", table "dbo.SAMPLE", column 'SAMPLE_KEY'.(-2147217873) The statement has been terminated.(-2147217873)
Note: This record may have been rejected because of a parent record that was also rejected.
--------------------
Failed to insert LC0004260000G00I into TAXON_OCCURRENCE
Database Error Message:
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_TAXON_OCCURRENCE_SAMPLE". The conflict occurred in database "NBNData", table "dbo.SAMPLE", column 'SAMPLE_KEY'.(-2147217873) The statement has been terminated.(-2147217873)
Note: This record may have been rejected because of a parent record that was also rejected.
--------------------
Failed to insert LC0004260000FZTJ into TAXON_OCCURRENCE
Database Error Message:
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_TAXON_OCCURRENCE_SAMPLE". The conflict occurred in database "NBNData", table "dbo.SAMPLE", column 'SAMPLE_KEY'.(-2147217873) The statement has been terminated.(-2147217873)
Note: This record may have been rejected because of a parent record that was also rejected.
--------------------
Failed to insert LC0004260000FZTK into TAXON_OCCURRENCE
Database Error Message:
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_TAXON_OCCURRENCE_SAMPLE". The conflict occurred in database "NBNData", table "dbo.SAMPLE", column 'SAMPLE_KEY'.(-2147217873) The statement has been terminated.(-2147217873)
Note: This record may have been rejected because of a parent record that was also rejected.
--------------------
Failed to insert LC0004260000FZTL into TAXON_OCCURRENCE
Database Error Message:
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_TAXON_OCCURRENCE_SAMPLE". The conflict occurred in database "NBNData", table "dbo.SAMPLE", column 'SAMPLE_KEY'.(-2147217873) The statement has been terminated.(-2147217873)
Note: This record may have been rejected because of a parent record that was also rejected.
--------------------
Failed to insert LC0004260000G0SM into TAXON_OCCURRENCE
Database Error Message:
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_TAXON_OCCURRENCE_SAMPLE". The conflict occurred in database "NBNData", table "dbo.SAMPLE", column 'SAMPLE_KEY'.(-2147217873) The statement has been terminated.(-2147217873)
Note: This record may have been rejected because of a parent record that was also rejected.
--------------------
Failed to insert LC0004260000G1JL into TAXON_OCCURRENCE
Database Error Message:
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_TAXON_OCCURRENCE_SAMPLE". The conflict occurred in database "NBNData", table "dbo.SAMPLE", column 'SAMPLE_KEY'.(-2147217873) The statement has been terminated.(-2147217873)
Note: This record may have been rejected because of a parent record that was also rejected.
--------------------
Failed to insert LC0004260000G1QJ into TAXON_OCCURRENCE
Database Error Message:
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_TAXON_OCCURRENCE_SAMPLE". The conflict occurred in database "NBNData", table "dbo.SAMPLE", column 'SAMPLE_KEY'.(-2147217873) The statement has been terminated.(-2147217873)
Note: This record may have been rejected because of a parent record that was also rejected.
--------------------
Failed to insert LC00042600003KAD into SURVEY_EVENT_RECORDER
Database Error Message:
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_SURVEY_EVENT_RECORDER_SURVEY_EVENT". The conflict occurred in database "NBNData", table "dbo.SURVEY_EVENT", column 'SURVEY_EVENT_KEY'.(-2147217873) The statement has been terminated.(-2147217873)
Note: This record may have been rejected because of a parent record that was also rejected.
--------------------
Failed to insert LC00042600003KCE into SURVEY_EVENT_RECORDER
Database Error Message:
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_SURVEY_EVENT_RECORDER_SURVEY_EVENT". The conflict occurred in database "NBNData", table "dbo.SURVEY_EVENT", column 'SURVEY_EVENT_KEY'.(-2147217873) The statement has been terminated.(-2147217873)
Note: This record may have been rejected because of a parent record that was also rejected.
--------------------
Failed to insert LC00042600003KCF into SURVEY_EVENT_RECORDER
Database Error Message:
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_SURVEY_EVENT_RECORDER_SURVEY_EVENT". The conflict occurred in database "NBNData", table "dbo.SURVEY_EVENT", column 'SURVEY_EVENT_KEY'.(-2147217873) The statement has been terminated.(-2147217873)
Note: This record may have been rejected because of a parent record that was also rejected.
--------------------
Failed to insert LC00042600003KCJ into SURVEY_EVENT_RECORDER
Database Error Message:
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_SURVEY_EVENT_RECORDER_SURVEY_EVENT". The conflict occurred in database "NBNData", table "dbo.SURVEY_EVENT", column 'SURVEY_EVENT_KEY'.(-2147217873) The statement has been terminated.(-2147217873)
Note: This record may have been rejected because of a parent record that was also rejected.
--------------------
Failed to insert LC00042600003KMR into SURVEY_EVENT_RECORDER
Database Error Message:
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_SURVEY_EVENT_RECORDER_SURVEY_EVENT". The conflict occurred in database "NBNData", table "dbo.SURVEY_EVENT", column 'SURVEY_EVENT_KEY'.(-2147217873) The statement has been terminated.(-2147217873)
Note: This record may have been rejected because of a parent record that was also rejected.
--------------------
Failed to insert LC00042600003KYQ into SURVEY_EVENT_RECORDER
Database Error Message:
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_SURVEY_EVENT_RECORDER_SURVEY_EVENT". The conflict occurred in database "NBNData", table "dbo.SURVEY_EVENT", column 'SURVEY_EVENT_KEY'.(-2147217873) The statement has been terminated.(-2147217873)
Note: This record may have been rejected because of a parent record that was also rejected.
--------------------
Failed to insert LC00042600003KX4 into SURVEY_EVENT_RECORDER
Database Error Message:
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_SURVEY_EVENT_RECORDER_SURVEY_EVENT". The conflict occurred in database "NBNData", table "dbo.SURVEY_EVENT", column 'SURVEY_EVENT_KEY'.(-2147217873) The statement has been terminated.(-2147217873)
Note: This record may have been rejected because of a parent record that was also rejected.
--------------------
Failed to insert LC00042600008150 into TAXON_OCCURRENCE_DATA
Database Error Message:
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_TAXON_OCCURRENCE_DATA_TAXON_OCCURRENCE". The conflict occurred in database "NBNData", table "dbo.TAXON_OCCURRENCE", column 'TAXON_OCCURRENCE_KEY'.(-2147217873) The statement has been terminated.(-2147217873)
Note: This record may have been rejected because of a parent record that was also rejected.
--------------------
Failed to insert LC00042600008181 into TAXON_OCCURRENCE_DATA
Database Error Message:
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_TAXON_OCCURRENCE_DATA_TAXON_OCCURRENCE". The conflict occurred in database "NBNData", table "dbo.TAXON_OCCURRENCE", column 'TAXON_OCCURRENCE_KEY'.(-2147217873) The statement has been terminated.(-2147217873)
Note: This record may have been rejected because of a parent record that was also rejected.
--------------------
Failed to insert LC000426000081X4 into TAXON_OCCURRENCE_DATA
Database Error Message:
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_TAXON_OCCURRENCE_DATA_TAXON_OCCURRENCE". The conflict occurred in database "NBNData", table "dbo.TAXON_OCCURRENCE", column 'TAXON_OCCURRENCE_KEY'.(-2147217873) The statement has been terminated.(-2147217873)
Note: This record may have been rejected because of a parent record that was also rejected.
--------------------
Failed to insert LC000426000081ZY into TAXON_OCCURRENCE_DATA
Database Error Message:
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_TAXON_OCCURRENCE_DATA_TAXON_OCCURRENCE". The conflict occurred in database "NBNData", table "dbo.TAXON_OCCURRENCE", column 'TAXON_OCCURRENCE_KEY'.(-2147217873) The statement has been terminated.(-2147217873)
Note: This record may have been rejected because of a parent record that was also rejected.
--------------------
Failed to insert LC000426000082LJ into TAXON_OCCURRENCE_DATA
Database Error Message:
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_TAXON_OCCURRENCE_DATA_TAXON_OCCURRENCE". The conflict occurred in database "NBNData", table "dbo.TAXON_OCCURRENCE", column 'TAXON_OCCURRENCE_KEY'.(-2147217873) The statement has been terminated.(-2147217873)
Note: This record may have been rejected because of a parent record that was also rejected.
--------------------
Failed to insert LC000426000082LK into TAXON_OCCURRENCE_DATA
Database Error Message:
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_TAXON_OCCURRENCE_DATA_TAXON_OCCURRENCE". The conflict occurred in database "NBNData", table "dbo.TAXON_OCCURRENCE", column 'TAXON_OCCURRENCE_KEY'.(-2147217873) The statement has been terminated.(-2147217873)
Note: This record may have been rejected because of a parent record that was also rejected.
--------------------
Failed to insert LC000426000082RL into TAXON_OCCURRENCE_DATA
Database Error Message:
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_TAXON_OCCURRENCE_DATA_TAXON_OCCURRENCE". The conflict occurred in database "NBNData", table "dbo.TAXON_OCCURRENCE", column 'TAXON_OCCURRENCE_KEY'.(-2147217873) The statement has been terminated.(-2147217873)
Note: This record may have been rejected because of a parent record that was also rejected.
--------------------
Failed to insert LC000426000082U1 into TAXON_OCCURRENCE_DATA
Database Error Message:
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_TAXON_OCCURRENCE_DATA_TAXON_OCCURRENCE". The conflict occurred in database "NBNData", table "dbo.TAXON_OCCURRENCE", column 'TAXON_OCCURRENCE_KEY'.(-2147217873) The statement has been terminated.(-2147217873)
Note: This record may have been rejected because of a parent record that was also rejected.
--------------------
Failed to insert LC0004260000834G into TAXON_OCCURRENCE_DATA
Database Error Message:
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_TAXON_OCCURRENCE_DATA_TAXON_OCCURRENCE". The conflict occurred in database "NBNData", table "dbo.TAXON_OCCURRENCE", column 'TAXON_OCCURRENCE_KEY'.(-2147217873) The statement has been terminated.(-2147217873)
Note: This record may have been rejected because of a parent record that was also rejected.
--------------------
Failed to insert LC0004260000G0GD into TAXON_DETERMINATION
Database Error Message:
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_TAXON_DETERMINATION_TAXON_OCCURRENCE". The conflict occurred in database "NBNData", table "dbo.TAXON_OCCURRENCE", column 'TAXON_OCCURRENCE_KEY'.(-2147217873) The statement has been terminated.(-2147217873)
Note: This record may have been rejected because of a parent record that was also rejected.
--------------------
Failed to insert LC0004260000G0N2 into TAXON_DETERMINATION
Database Error Message:
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_TAXON_DETERMINATION_TAXON_OCCURRENCE". The conflict occurred in database "NBNData", table "dbo.TAXON_OCCURRENCE", column 'TAXON_OCCURRENCE_KEY'.(-2147217873) The statement has been terminated.(-2147217873)
Note: This record may have been rejected because of a parent record that was also rejected.
--------------------
Failed to insert LC0004260000G0N6 into TAXON_DETERMINATION
Database Error Message:
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_TAXON_DETERMINATION_TAXON_OCCURRENCE". The conflict occurred in database "NBNData", table "dbo.TAXON_OCCURRENCE", column 'TAXON_OCCURRENCE_KEY'.(-2147217873) The statement has been terminated.(-2147217873)
Note: This record may have been rejected because of a parent record that was also rejected.
--------------------
Failed to insert LC0004260000G0NK into TAXON_DETERMINATION
Database Error Message:
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_TAXON_DETERMINATION_TAXON_OCCURRENCE". The conflict occurred in database "NBNData", table "dbo.TAXON_OCCURRENCE", column 'TAXON_OCCURRENCE_KEY'.(-2147217873) The statement has been terminated.(-2147217873)
Note: This record may have been rejected because of a parent record that was also rejected.
--------------------
Failed to insert LC0004260000G2HG into TAXON_DETERMINATION
Database Error Message:
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_TAXON_DETERMINATION_TAXON_OCCURRENCE". The conflict occurred in database "NBNData", table "dbo.TAXON_OCCURRENCE", column 'TAXON_OCCURRENCE_KEY'.(-2147217873) The statement has been terminated.(-2147217873)
Note: This record may have been rejected because of a parent record that was also rejected.
--------------------
Failed to insert LC0004260000G2HI into TAXON_DETERMINATION
Database Error Message:
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_TAXON_DETERMINATION_TAXON_OCCURRENCE". The conflict occurred in database "NBNData", table "dbo.TAXON_OCCURRENCE", column 'TAXON_OCCURRENCE_KEY'.(-2147217873) The statement has been terminated.(-2147217873)
Note: This record may have been rejected because of a parent record that was also rejected.
--------------------
Failed to insert LC0004260000G2I0 into TAXON_DETERMINATION
Database Error Message:
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_TAXON_DETERMINATION_TAXON_OCCURRENCE". The conflict occurred in database "NBNData", table "dbo.TAXON_OCCURRENCE", column 'TAXON_OCCURRENCE_KEY'.(-2147217873) The statement has been terminated.(-2147217873)
Note: This record may have been rejected because of a parent record that was also rejected.
--------------------
Failed to insert LC0004260000G0VI into TAXON_DETERMINATION
Database Error Message:
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_TAXON_DETERMINATION_TAXON_OCCURRENCE". The conflict occurred in database "NBNData", table "dbo.TAXON_OCCURRENCE", column 'TAXON_OCCURRENCE_KEY'.(-2147217873) The statement has been terminated.(-2147217873)
Note: This record may have been rejected because of a parent record that was also rejected.
--------------------
Failed to insert LC0004260000G274 into TAXON_DETERMINATION
Database Error Message:
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_TAXON_DETERMINATION_TAXON_OCCURRENCE". The conflict occurred in database "NBNData", table "dbo.TAXON_OCCURRENCE", column 'TAXON_OCCURRENCE_KEY'.(-2147217873) The statement has been terminated.(-2147217873)
Note: This record may have been rejected because of a parent record that was also rejected.
--------------------
Failed to insert LC00042600003G1J into SAMPLE_RECORDER
Database Error Message:
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_SAMPLE_RECORDER_SAMPLE". The conflict occurred in database "NBNData", table "dbo.SAMPLE", column 'SAMPLE_KEY'.(-2147217873) The statement has been terminated.(-2147217873)
Note: This record may have been rejected because of a parent record that was also rejected.
--------------------
Failed to insert LC00042600003G3M into SAMPLE_RECORDER
Database Error Message:
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_SAMPLE_RECORDER_SAMPLE". The conflict occurred in database "NBNData", table "dbo.SAMPLE", column 'SAMPLE_KEY'.(-2147217873) The statement has been terminated.(-2147217873)
Note: This record may have been rejected because of a parent record that was also rejected.
--------------------
Failed to insert LC00042600003G3N into SAMPLE_RECORDER
Database Error Message:
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_SAMPLE_RECORDER_SAMPLE". The conflict occurred in database "NBNData", table "dbo.SAMPLE", column 'SAMPLE_KEY'.(-2147217873) The statement has been terminated.(-2147217873)
Note: This record may have been rejected because of a parent record that was also rejected.
--------------------
Failed to insert LC00042600003G3R into SAMPLE_RECORDER
Database Error Message:
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_SAMPLE_RECORDER_SAMPLE". The conflict occurred in database "NBNData", table "dbo.SAMPLE", column 'SAMPLE_KEY'.(-2147217873) The statement has been terminated.(-2147217873)
Note: This record may have been rejected because of a parent record that was also rejected.
--------------------
Failed to insert LC00042600003GFI into SAMPLE_RECORDER
Database Error Message:
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_SAMPLE_RECORDER_SAMPLE". The conflict occurred in database "NBNData", table "dbo.SAMPLE", column 'SAMPLE_KEY'.(-2147217873) The statement has been terminated.(-2147217873)
Note: This record may have been rejected because of a parent record that was also rejected.
--------------------
Failed to insert LC00042600003GQU into SAMPLE_RECORDER
Database Error Message:
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_SAMPLE_RECORDER_SAMPLE". The conflict occurred in database "NBNData", table "dbo.SAMPLE", column 'SAMPLE_KEY'.(-2147217873) The statement has been terminated.(-2147217873)
Note: This record may have been rejected because of a parent record that was also rejected.
--------------------
Failed to insert LC00042600003GSO into SAMPLE_RECORDER
Database Error Message:
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_SAMPLE_RECORDER_SAMPLE". The conflict occurred in database "NBNData", table "dbo.SAMPLE", column 'SAMPLE_KEY'.(-2147217873) The statement has been terminated.(-2147217873)
Note: This record may have been rejected because of a parent record that was also rejected.
--------------------
Steve