Re: Problem with an Import from Excel.
I've just imported 18,000 records from an Excel file and it appeared to work without any problems, but right at the end after everything was completed it rejected 6000 items.
The Import Rejects file contains a whole stack of entries like this:
--------------------
Failed to insert LC00021500002DJ4 into SURVEY_EVENT_RECORDER
Database Error Message:
Row cannot be located for updating. Some values may have been changed since it was last read.
--------------------
Failed to insert LC00021500009IHZ into TAXON_DETERMINATION
Database Error Message:
Row cannot be located for updating. Some values may have been changed since it was last read.
On looking at the data, it does look as though most of the records are there, but occasionally when trying to look at a Sample I get an unhandled error:
Exception occurred in application Recorder 6 at 16/10/2008 11:07:46.
Version : 6.10.4.120
Exception path:
EAccessViolation : Access violation at address 0073443B in module 'RecorderApp.exe'. Read of address 04E88000
Last event\actions:
TfrmTaxonOccurrences created
TfrmTaxonOccurrences destroyed
TfrmSampleDetails created
TfrmSampleDetails destroyed
TfrmTaxonOccurrences created
TfrmTaxonOccurrences destroyed
TfrmEventDetails created
TfrmEventDetails destroyed
TfrmSampleDetails created
Operating System : Windows XP 5.01.2600 Service Pack 3
Physical Memory available : 1,046,508 KB
DLLs loaded:
advapi32.dll (5.1.2600.5512)
comctl32.dll (5.82.2900.5512)
comdlg32.dll (6.0.2900.5512)
gdi32.dll (5.1.2600.5512)
HHCtrl.ocx (5.2.3790.4110)
kernel32.dll (5.1.2600.5512)
mpr.dll (5.1.2600.5512)
MS5.Dll (5.0.0.12)
MS5User.Dll (5.0.0.4)
odbc32.dll (3.525.1132.0)
ole32.dll (5.1.2600.5512)
oleaut32.dll (5.1.2600.5512)
shell32.dll (6.0.2900.5512)
user32.dll (5.1.2600.5512)
version.dll (5.1.2600.5512)
winmm.dll (5.1.2600.5512)
winspool.drv (5.1.2600.5512)
Is this as a result of the rejected items? If so should I delete the survey and re-import it from scratch? Any thought gratefully received.
Senior IT & Records Officer,
15 Talbot Road, Talbot Green, Pontyclun, CF72 8AD
www.sewbrec.org.uk, www.sewbrecord.org.uk