1 Topic by Darwyn Sumner (edited by Darwyn Sumner 01-03-2016 13:26:01)

  • Darwyn Sumner
  • Darwyn Sumner
  • Veteran
  • Offline
  • From: Dipterists Forum
  • Registered: 10-05-2006
  • Posts: 250

Topic: Import errors

Importing data from another Recorder user. (NBN zip file)
New data seems to have gone in smoothly but the option to show the records didn't do anything and I have the following error message.

Items rejected by Recorder 6 in data imported at 12-33-28 on 01/03/2016:
Created SQLSERVER_NAME
Created SQLSERVER_SURVEY_EVENT
Created SQLSERVER_SAMPLE
Created SQLSERVER_INDIVIDUAL
Created SQLSERVER_SURVEY_EVENT_RECORDER
Created SQLSERVER_LOCATION_FEATURE
Created SQLSERVER_TAXON_OCCURRENCE
Created SQLSERVER_TAXON_OCCURRENCE_SOURCES
Created SQLSERVER_TAXON_DETERMINATION
Created SQLSERVER_TAXON_OCCURRENCE_DATA
Created SQLSERVER_TENURE
Created SQLSERVER_GRID_SQUARE
Created SQLSERVER_NAME_SOURCES
Created SQLSERVER_NAME_RELATION
Created SQLSERVER_LOCATION_SOURCES
Created SQLSERVER_LOCATION_NAME
Created SQLSERVER_LOCATION_BOUNDARY
Exception on create for SQLSERVER_LOCATION_ADMIN_AREAS: ODBC--call failed

Failed to insert DSS00628000009Y1 into LOCATION_ADMIN_AREAS
Database Error Message:
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_LOCATION_ADMIN_AREAS_ADMIN_AREA". The conflict occurred in database "NBNData", table "dbo.ADMIN_AREA", column 'ADMIN_AREA_KEY'.(-2147217873) The statement has been terminated.(-2147217873)
--------------------
Created SQLSERVER_LOCATION_DATA
Created SQLSERVER_LOCATION_DESIGNATION

2 Reply by MikeWeideli

  • MikeWeideli
  • Administrator
  • Offline
  • From: Littlefield Consultancy
  • Registered: 05-07-2006
  • Posts: 2,645

Re: Import errors

Looks like an Admin Area in the import file  is not in your system. This could happen if the Dictionaries are out of step  or if the system providing the data has added some additional admin areas (which shouldn't be done).  Unless you are aware of something which may have caused this further investigation of the import file will be required.

Mike Weideli

MikeWeideli's Website