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
Tullie House Museum