1 Topic by ser

  • ser
  • ser
  • Administrator
  • Offline
  • From: Staffordshire Ecological Recor
  • Registered: 24-09-2008
  • Posts: 603

Topic: Problem with import

Just done an import from a text file and received the following error:

Items rejected by Recorder 6 in data imported at 12:21:07 on 20/02/2019:
Exception on create for SQLSERVER_SURVEY_EVENT: ODBC--call failed
Exception on create for SQLSERVER_SAMPLE: ODBC--call failed
Exception on create for SQLSERVER_SURVEY_EVENT_RECORDER: ODBC--call failed
Exception on create for SQLSERVER_TAXON_OCCURRENCE: ODBC--call failed
Exception on create for SQLSERVER_TAXON_OCCURRENCE_DATA: ODBC--call failed
Created SQLSERVER_TAXON_OCCURRENCE_SOURCES
Exception on create for SQLSERVER_TAXON_DETERMINATION: ODBC--call failed

it said it hadn't imported c 130 items out of 7,600, but I have no idea what didn't go in! I can't understand how the ODBC call can be selective!

Follow-up - I have just rerun the import and (because it was MapMate data using the MapMate key it doesn't create extra records) - all records were marked as being duplicates and this time all went in without error!

Craig

Craig Slawson
Staffordshire Ecological Record

ser's Website

2 Reply by DGERC (edited by DGERC 20-02-2019 13:13:35)

  • DGERC
  • DGERC
  • Veteran
  • Offline
  • From: SWSEIC
  • Registered: 31-05-2006
  • Posts: 232

Re: Problem with import

I think this looks like same errors as we've been reporting and Mike is looking at - thread here . Started off intermittent with us and now we can no longer import data. Hope we can get to the bottom of this soon.

Mike - anything we can do to help get to the bottom of this?

Mark Pollitt
SWSEIC (formerly DGERC)

DGERC's Website