Topic: Recorder 6 Import crash

Hi,

I am trying to copy a number of locations (in excess of 1000) from our live version of Recorder v6.3 into a standalone test version (v6.9 Beta) using the export and import wizards in NBN .ZIP format.  The first 500 locations imported fine with the exception of a few determination dates that don't match their sample dates and a number of errors such as:

-----------------------------------------------------------------------------------------
Failed to insert LC0000130000008T into SQLSERVER_SURVEY_EVENT_OWNER
Database Error Message:
You tried to assign the Null value to a variable that is not a Variant data type.
-----------------------------------------------------------------------------------------

However, the real problem came when I tried to import the second 500 locations.  After importing almost everything (except the duplicate and invalid records identified during the initial analysis) it crashed with the following error:

-----------------------------------------------------------------------------------------
Exception occurred in application Recorder 6 at 26/09/2006 13-03-01.
Version : 6.9.2.92

Exception path:
EOleException : The INSERT INTO statement contains the following unknown field name: 'Bio_Key'.  Make sure you have typed the name correctly, and try the operation again
EDBMergerError : Error occurred transferring records for SQLSERVER_LOCATION_ADMIN_AREAS into the main database
EDBMergerError : Error occurred transferring records for SQLSERVER_LOCATION_ADMIN_AREAS into the main database

Last event\actions:
  TfrmLocationDetails destroyed
  TfrmLocations destroyed
  TfrmLocations deactivated
  TfrmObservations activated
  TfrmEventDetails destroyed
  TfrmObservations destroyed
  actImport invoked
  TfrmImportWizard created
  TfrmImportWizard activated

Operating System : Windows XP  5.01.2600  Service Pack 2
Physical Memory available : 2,086,980 KB

DLLs loaded:
  advapi32.dll (5.1.2600.2180)
  comctl32.dll (5.82.2900.2180)
  comdlg32.dll (6.0.2900.2180)
  gdi32.dll (5.1.2600.2180)
  HHCtrl.ocx (5.2.3790.2453)
  kernel32.dll (5.1.2600.2180)
  mpr.dll (5.1.2600.2180)
  MS5.Dll (5.0.0.12)
  MS5User.Dll (5.0.0.4)
  odbc32.dll (3.525.1117.0)
  ole32.dll (5.1.2600.2665)
  oleaut32.dll (5.1.2600.2180)
  shell32.dll (6.0.2900.2869)
  user32.dll (5.1.2600.2622)
  version.dll (5.1.2600.2180)
  winmm.dll (5.1.2600.2180)
  winspool.drv (5.1.2600.2180)

Information has been saved to the file C:\Program Files\Recorder 6\LastError.txt
-----------------------------------------------------------------------------------------

I don't know if this problem is specific to the new version6.9 or because I am using an old version 6.3 to export from (or something else entirely).  Does anyone have any ideas what the problem is or how I can get round the problem and copy our live data into a test database?

Many thanks,
Andy.

Andy Foy
Ecologist & IT consultant
Andy Foy Consulting (ex-HBIC)

Re: Recorder 6 Import crash

Andy, I'd post this over on the recorder forum if I were you. I never used version 6.3, so don't know how different it is and thus how compatible it is with 6.9.

Charles

Re: Recorder 6 Import crash

Thanks Charles,

I never do know which forum is best for what and try to avoid posting on both to avoid duplication.

In the meantime I think I have solved the problem.  It seems to be simply that the v6.3 SURVEY_EVENT_OWNER table contains a column 'Bio_Key' that is no longer in v6.9.  Hence the import fails because of the extra column.  I deleted this column from the NBN zipped export file and the import worked OK.

I wonder if there are any other compatibilities like this been Recorder versions?

Regards,
Andy.

Andy Foy
Ecologist & IT consultant
Andy Foy Consulting (ex-HBIC)