Topic: Import Rejected Items
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
Steve Hannah - GIS and Data Infrastructure Officer
The Wildlife Information Centre