Charles,

Thanks for reply. In this case the Taxon Occurrence parent sample key does exist. It is listed in the Taxon Occurrence table and also then in the Sample table.

Following these errors through in the same process, the failure then to insert into Taxon_Occurrence_Data table the TOD_Key exists in the T_O_D table with the T_O_Key next to it corresponding to the error one in the T_O table.

The same is true of the next ones of Taxon_Determination.

So far in these there were 7 errors in each section.

Next I get to the Name Relation insert failure, and I now start to remember a similar problem I had some time back... but continuing here:

There are 37 with the COLUMN FOREIGN KEY constraint of 'FK_NAME_RELATION_NAME1' and one of COLUMN FOREIGN KEY constraint of 'FK_NAME_RELATION_NAME2':

Failed to insert WA0000440000000C into NAME_RELATION
Database Error Message:
INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'FK_NAME_RELATION_NAME2'. The conflict occurred in database 'NBNData', table 'NAME', column 'NAME_KEY'.The statement has been terminated.

Looking this one up I discover that in the Name_Relation table there is a N_R_Key of WA0000440000000C, a Name_Key_1 of WA0000440000000L and a Name_Key_2 of WA0000440000000G. The N_K_1 is listed in the Name table and is marked as an organisation (-1). Is this possibly the route of all errors? However, sorting the Name_Relation table on Name_Key_1 I do discover the WA000044...L is there again, but clearly with no errors related to it, indicating the successful import of that... (can not check this now as do not have the other database here)...

Does this make any more sense to anyone please? I do remember some issue of organisations and Taxon Occurrences roled over from old Recorder 2000/2?

Thanks

Brian

Hi Sarah,

Thanks for getting back to me on this. I had a call from Sally about it and thought I understood, however, having gone through this checking process I do think there may still be an underlying problem going on.

Starting with the easy one:
The original database (where data exported from), all keys match between the N_R table N_K_1 and N_K_2 and the Individual, Organisation and Name table name keys.

When I do the same queries in the exported file (import file) I see the following results based on DISTINCT keys:

N_R table N_K_1 - only 2 match out of 53 (1 individual and 1 organisation)
N_R table N_K_2 - 98 match, but 2 do not (2 individuals not match)

Looking at the exported file and comparing the Name_Relation table - N_K_1 and 2 to the Name table I see consistent results to the above in that:

N_K_1 has 51 non-matches and N_K_2 has 2 non-matches.

The fact that all these name keys exist in the correct places in the main database indicates to me that the exporting is potentially missing off certain associations between records(?)

Not sure if any of this helps...?

Thanks

Brian