1 Reply by ser

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

Re: Problem imprting records

I am attempting to import a batch of 4,500 records exported from MapMate - I have done this loads of times previously with no problems. On the validation operation, it successfully validates the data reporting 0 error, then the "unhandled Error box" appears and the Next button is not activated, so I cannot proceed.

The error message is:

date/time         : 2010-07-22, 10:43:25, 62ms
computer name     : WS021
user name         : slawsoc
operating system  : Windows XP Service Pack 3 build 2600
system language   : English
system up time    : 2 hours 45 minutes
program up time   : 5 minutes 11 seconds
processors        : 4x Intel(R) Core(TM)2 Quad CPU    Q8300  @ 2.50GHz
physical memory   : 2048/2048 MB (free/total)
free disk space   : (C:) 89.58 GB (R:) 11.60 GB
display mode      : 1920x1080, 32 bit
process id        : $f8
allocated memory  : 28.44 MB
command line      : RecorderApp.exe /4391910
executable        : RecorderApp.exe
exec. date/time   : 2009-11-23 09:25
version           : 6.14.5.218
madExcept version : 2.7h
exception class   : ERangeError
exception message : Range check error.

main thread ($56c):
009395b3 RecorderApp.exe 
7e42a993 user32.dll       CallWindowProcA
7c90eb94 ntdll.dll        RtlAnsiStringToUnicodeString
7e4292de user32.dll       SendMessageW
7e42a993 user32.dll       CallWindowProcA
7e4196c2 user32.dll       DispatchMessageA

modules:
00340000 C4DLL.DLL         1.0.0.1          R:
003b0000 MS5User.Dll       5.0.0.4          R:
00400000 RecorderApp.exe   6.14.5.218       R:
013c0000 ms5cnv.dll        5.0.0.10         R:
01bd0000 odbcint.dll       3.525.1132.0     C:\WINDOWS\system32
02a30000 xpsp2res.dll      5.1.2600.5512    C:\WINDOWS\system32
03a30000 SQLOLEDB.RLL      2000.85.1132.0   C:\Program Files\Common Files\System\Ole DB
03a40000 msadcer.dll       2.81.1132.0      C:\Program Files\Common Files\System\msadc
03e60000 GoToKey.ocx       6.0.1.10         R:\Addins
04080000 NBNExchange.ocx   6.13.2.24        R:\Addins
042b0000 Phenology.ocx     6.0.1.10         R:\Addins
045b0000 ShowUnchecked.ocx 6.0.0.13         R:\Addins
047e0000 StdValLib.dll     6.14.3.208       R:\Addins
049e0000 SurveyDelete.ocx  6.0.0.29         R:\Addins
05030000 Normaliz.dll      6.0.5441.0       C:\WINDOWS\system32
10000000 MS5.Dll           5.0.0.12         R:
20000000 xpsp3res.dll      5.1.2600.5512    C:\WINDOWS\system32
3d930000 WININET.dll       8.0.6001.18923   C:\WINDOWS\system32
3dfd0000 iertutil.dll      8.0.6001.18923   C:\WINDOWS\system32
4dd00000 sqloledb.dll      2000.85.1132.0   C:\Program Files\Common Files\System\Ole DB
4de10000 msado15.dll       2.81.1132.0      C:\Program Files\Common Files\System\ado
4ec50000 gdiplus.dll       5.2.6001.22319   C:\WINDOWS\WinSxS\x86_Microsoft.Windows.GdiPlus_6595b64144ccf1df_1.0.6001.22319_x-ww_f0b4c2df
5ad70000 uxtheme.dll       6.0.2900.5512    C:\WINDOWS\system32
5b860000 NETAPI32.dll      5.1.2600.5694    C:\WINDOWS\system32
5d090000 comctl32.dll      5.82.2900.5512   C:\WINDOWS\system32
5edd0000 olepro32.dll      5.1.2600.5512    C:\WINDOWS\system32
605d0000 mslbui.dll        5.1.2600.5512    C:\WINDOWS\system32
60e30000 MSDATL3.dll       2.81.1132.0      C:\Program Files\Common Files\System\Ole DB
662b0000 hnetcfg.dll       5.1.2600.5512    C:\WINDOWS\system32
68000000 rsaenh.dll        5.1.2600.5507    C:\WINDOWS\system32
68100000 dssenh.dll        5.1.2600.5507    C:\WINDOWS\system32
69b10000 msxml4.dll        4.20.9876.0      c:\WINDOWS\system32
6d4f0000 DBNETLIB.DLL      2000.85.1132.0   C:\WINDOWS\system32
71a50000 mswsock.dll       5.1.2600.5625    C:\WINDOWS\system32
71a90000 wshtcpip.dll      5.1.2600.5512    C:\WINDOWS\System32
71aa0000 WS2HELP.dll       5.1.2600.5512    C:\WINDOWS\system32
71ab0000 WS2_32.dll        5.1.2600.5512    C:\WINDOWS\system32
71ad0000 wsock32.dll       5.1.2600.5512    C:\WINDOWS\system32
71b20000 mpr.dll           5.1.2600.5512    C:\WINDOWS\system32
71bf0000 SAMLIB.dll        5.1.2600.5512    C:\WINDOWS\System32
71c10000 ntlanman.dll      5.1.2600.5512    C:\WINDOWS\System32
71c80000 NETRAP.dll        5.1.2600.5512    C:\WINDOWS\System32
71c90000 NETUI1.dll        5.1.2600.5512    C:\WINDOWS\System32
71cd0000 NETUI0.dll        5.1.2600.5512    C:\WINDOWS\System32
71f80000 security.dll      5.1.2600.5512    C:\WINDOWS\system32
73000000 winspool.drv      5.1.2600.5512    C:\WINDOWS\system32
73160000 OLEDB32.DLL       2.81.1132.0      C:\Program Files\Common Files\System\OLE DB
74060000 msadce.dll        2.81.3002.0      C:\Program Files\Common Files\System\msadc
74320000 odbc32.dll        3.525.1132.0     C:\WINDOWS\system32
74720000 MSCTF.dll         5.1.2600.5512    C:\WINDOWS\system32
750b0000 RESUTILS.DLL      5.1.2600.5512    C:\WINDOWS\system32
750f0000 MTXCLU.DLL        2001.12.4414.706 C:\WINDOWS\system32
75130000 colbact.DLL       2001.12.4414.700 C:\WINDOWS\system32
75350000 OLEDB32R.DLL      2.81.1132.0      C:\Program Files\Common Files\System\OLE DB
754d0000 CRYPTUI.dll       5.131.2600.5512  C:\WINDOWS\system32
755c0000 msctfime.ime      5.1.2600.5512    C:\WINDOWS\system32
75f60000 drprov.dll        5.1.2600.5512    C:\WINDOWS\System32
75f70000 davclnt.dll       5.1.2600.5512    C:\WINDOWS\System32
75f80000 browseui.dll      6.0.2900.5512    C:\WINDOWS\system32
76390000 IMM32.DLL         5.1.2600.5512    C:\WINDOWS\system32
763b0000 comdlg32.dll      6.0.2900.5512    C:\WINDOWS\system32
765b0000 MSDART.DLL        2.81.1132.0      C:\WINDOWS\system32
76600000 CSCDLL.dll        5.1.2600.5512    C:\WINDOWS\System32
76620000 comsvcs.dll       2001.12.4414.702 C:\WINDOWS\system32
76780000 SHFolder.dll      6.0.2900.5512    C:\WINDOWS\system32
76790000 cryptdll.dll      5.1.2600.5512    C:\WINDOWS\system32
767a0000 ntdsapi.dll       5.1.2600.5512    C:\WINDOWS\system32
767f0000 schannel.dll      5.1.2600.5834    C:\WINDOWS\system32
76990000 ntshrui.dll       5.1.2600.5512    C:\WINDOWS\system32
769c0000 USERENV.dll       5.1.2600.5512    C:\WINDOWS\system32
76b20000 ATL.DLL           3.5.2284.2       C:\WINDOWS\system32
76b40000 winmm.dll         5.1.2600.5512    C:\WINDOWS\system32
76c30000 WINTRUST.dll      5.131.2600.5922  C:\WINDOWS\system32
76c90000 IMAGEHLP.dll      5.1.2600.5512    C:\WINDOWS\system32
76d10000 CLUSAPI.DLL       5.1.2600.5512    C:\WINDOWS\system32
76d60000 iphlpapi.dll      5.1.2600.5512    C:\WINDOWS\system32
76f20000 DNSAPI.dll        5.1.2600.5625    C:\WINDOWS\system32
76f60000 WLDAP32.dll       5.1.2600.5512    C:\WINDOWS\system32
76fb0000 winrnr.dll        5.1.2600.5512    C:\WINDOWS\System32
76fc0000 rasadhlp.dll      5.1.2600.5512    C:\WINDOWS\system32
76fd0000 CLBCATQ.DLL       2001.12.4414.700 C:\WINDOWS\system32
77050000 COMRes.dll        2001.12.4414.700 C:\WINDOWS\system32
77120000 oleaut32.dll      5.1.2600.5512    C:\WINDOWS\system32
773d0000 comctl32.dll      6.0.2900.5512    C:\WINDOWS\WinSxS\x86_Microsoft.Windows.Common-Controls_6595b64144ccf1df_6.0.2600.5512_x-ww_35d4ce83
774e0000 ole32.dll         5.1.2600.5512    C:\WINDOWS\system32
77920000 SETUPAPI.dll      5.1.2600.5512    C:\WINDOWS\system32
77a20000 cscui.dll         5.1.2600.5512    C:\WINDOWS\System32
77a80000 crypt32.dll       5.131.2600.5512  C:\WINDOWS\system32
77b20000 MSASN1.dll        5.1.2600.5875    C:\WINDOWS\system32
77b40000 appHelp.dll       5.1.2600.5512    C:\WINDOWS\system32
77c00000 version.dll       5.1.2600.5512    C:\WINDOWS\system32
77c10000 msvcrt.dll        7.0.2600.5512    C:\WINDOWS\system32
77c70000 msv1_0.dll        5.1.2600.5876    C:\WINDOWS\system32
77dd0000 advapi32.dll      5.1.2600.5755    C:\WINDOWS\system32
77e70000 RPCRT4.dll        5.1.2600.5795    C:\WINDOWS\system32
77f10000 GDI32.dll         5.1.2600.5698    C:\WINDOWS\system32
77f60000 SHLWAPI.dll       6.0.2900.5912    C:\WINDOWS\system32
77fe0000 Secur32.dll       5.1.2600.5834    C:\WINDOWS\system32
78130000 urlmon.dll        8.0.6001.18923   C:\WINDOWS\system32
7c800000 kernel32.dll      5.1.2600.5781    C:\WINDOWS\system32
7c900000 ntdll.dll         5.1.2600.5755    C:\WINDOWS\system32
7c9c0000 shell32.dll       6.0.2900.5622    C:\WINDOWS\system32
7e290000 shdocvw.dll       6.0.2900.5897    C:\WINDOWS\system32
7e410000 user32.dll        5.1.2600.5512    C:\WINDOWS\system32
7e4b0000 HHCtrl.ocx        5.2.3790.4110    C:\WINDOWS\system32
7e720000 SXS.DLL           5.1.2600.5512    C:\WINDOWS\system32

Craig Slawson
Staffordshire Ecological Record

ser's Website

2 Reply by ser

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

Re: Problem imprting records

On further investigation I think the error is being caused by the content of one of the records because I have tried importing the first 1,000 records and the error has not happened. If I find the offending record I'll post the problem here

Craig Slawson
Staffordshire Ecological Record

ser's Website

3 Reply by RobLarge

  • RobLarge
  • RobLarge
  • Veteran
  • Offline
  • From: Wiltshire
  • Registered: 15-07-2008
  • Posts: 812

Re: Problem imprting records

Looks like the sane problem we had in the past and Tony Price at SERC is having currently, it would certainly be useful to know what caused it in your case Craig.

Rob Large
Wildlife Sites Officer
Wiltshire & Swindon Biological Records Centre

RobLarge's Website

4 Reply by RobLarge

  • RobLarge
  • RobLarge
  • Veteran
  • Offline
  • From: Wiltshire
  • Registered: 15-07-2008
  • Posts: 812

Re: Problem imprting records

I've just checked and both Ellie and myself experienced this error in connection with the ongoing problem with adding determinations, see this thread and others http://forums.nbn.org.uk/viewtopic.php?pid=6778.

It may be the same problem...

Rob Large
Wildlife Sites Officer
Wiltshire & Swindon Biological Records Centre

RobLarge's Website

5 Reply by ser

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

Re: Problem imprting records

I've found the problem, it is a problem which need to be caught by Recorder.

There was a recorder of "J.Smith," - with the comma on the end - deleting the comma cured the problem!

Craig Slawson
Staffordshire Ecological Record

ser's Website

6 Reply by RobLarge

  • RobLarge
  • RobLarge
  • Veteran
  • Offline
  • From: Wiltshire
  • Registered: 15-07-2008
  • Posts: 812

Re: Problem imprting records

Was this recorder to be determiner as well? It seems likely that if this were the case, then Recorder is trying to add a second determiner where only one is allowed, which might somehow explain the Range Check Error.

Rob Large
Wildlife Sites Officer
Wiltshire & Swindon Biological Records Centre

RobLarge's Website

7 Reply by ser (edited by ser 27-07-2010 12:05:55)

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

Re: Problem imprting records

Rob,

Re the observer being the determiner, no it wasn't there was a separate Determiner field in the import, the problem was the trailing comma - this activated the parser to split a list of names into individual recorders, but there being nothing after the comma, the parser couldn't understand the lack of data and fell over!

The Range Check Error was I assume because the IW was trying to work on observer No.2, but it was a null entry, hence out of range

Craig Slawson
Staffordshire Ecological Record

ser's Website

8 Reply by RobLarge

  • RobLarge
  • RobLarge
  • Veteran
  • Offline
  • From: Wiltshire
  • Registered: 15-07-2008
  • Posts: 812

Re: Problem imprting records

Makes sense

Rob Large
Wildlife Sites Officer
Wiltshire & Swindon Biological Records Centre

RobLarge's Website