1 Reply by Matt_tullie (edited by Matt_tullie 26-03-2009 16:37:16)

  • Matt_tullie
  • Veteran
  • Offline
  • From: Carlisle, Cumbria
  • Registered: 18-05-2007
  • Posts: 166

Re: Corruption fear... how to proceed?

Given my previous corruption problems!

I was happily importing records, when one set gave me:

exception class   : EDBMergerError
exception message : Error occurred transferring records for SQLSERVER_TAXON_OCCURRENCE into the main database.

I then tested the export to see if there wa a problem and got:

exception class   : EOleException
exception message : Cannot alter table '#TAXON_OCCURRENCE' because this table does not exist in database 'NBNData'.

Subsequent testing gave me varied results with some exports crashing with:

exception class   : EOleException
exception message : List index out of bounds (0).

Granted this error is on the larger surveys. Smaller exports seem to work.


I have a back up from 6 days ago and can try and rescue the records entered between then and now and then do a restore.

But Id like to hear whether the above errors sound menacing or a 'not too worry - plod on'.

Any thoughts?

Full errors in doc:

http://forums.nbn.org.uk/uploaded/TH_ER … H26_09.doc

Thanks.

MAtt

Cumbria Biodiversity Data Centre
Tullie House Museum

Matt_tullie's Website

2 Reply by johnvanbreda

  • johnvanbreda
  • Administrator
  • Offline
  • From: UK
  • Registered: 27-04-2006
  • Posts: 1,237

Re: Corruption fear... how to proceed?

A quick question Matt, before testing the exports, had you restarted Recorder? The cannot alter table message might be a throwback to the previous error on import. It would be interesting to know if the export errors are still happening today.

John van Breda
Biodiverse IT

johnvanbreda's Website

3 Reply by Matt_tullie

  • Matt_tullie
  • Veteran
  • Offline
  • From: Carlisle, Cumbria
  • Registered: 18-05-2007
  • Posts: 166

Re: Corruption fear... how to proceed?

Ive been doing some exports this morning which seem to be working fine - up to 20000 records so far.
Surveys with 48000 and above would seem to be crashing with the error -  'List index out of bounds'.

I removed the validation addin and was able to export a 62000 survey.

So this is the known problem of the validation addin.

From which I  surmise that yesterdays hiatus hasn't done anything severe as feared.

We shall, therefore, press on.

The oddity from yesterday is the crash mid import... We shall try again and see what happens.

And just to answer the first point - I hadnt restarted recorder at the time of the 'lost table' error.
Thanks for listening.

M

Cumbria Biodiversity Data Centre
Tullie House Museum

Matt_tullie's Website

4 Reply by sallyrankin

  • sallyrankin
  • Administrator
  • Offline
  • Registered: 07-04-2006
  • Posts: 371

Re: Corruption fear... how to proceed?

Have you checked out the links in http://forums.nbn.org.uk/viewtopic.php?pid=4164#p4164

Sally Rankin, JNCC Recorder Approved Expert
E-mail: s.rankin@btinternet.com
Telephone: 01491 578633
Mobile: 07941 207687

5 Reply by Matt_tullie

  • Matt_tullie
  • Veteran
  • Offline
  • From: Carlisle, Cumbria
  • Registered: 18-05-2007
  • Posts: 166

Re: Corruption fear... how to proceed?

Sally

Noted, thank you.

I have corrected some biotope errors - yet to test the export again!

M

Cumbria Biodiversity Data Centre
Tullie House Museum

Matt_tullie's Website