1 Reply by Ian M Spence

  • Ian M Spence
  • Veteran
  • Offline
  • From: North east Wales
  • Registered: 30-06-2006
  • Posts: 193

Re: Error on import

Hi

I was importing three files with very similar data, prepared in the same way for three different surveys. All went well until after the species had been indentified, then I had an error with the message, below. Can anyone give me a clue as to what went wrong? I have checked the file and cannot see anything that is obviously wrong and I am not sure what a 'domain error' actually means.

I hope someone can help and look forward to hearing from you.

All the best, Ian

date/time         : 2011-08-31, 14:20:54, 6ms
computer name     : IANDESKTOP-PC
user name         : Ian Desktop
operating system  : Windows NT New Service Pack 1 build 7601
system language   : English
system up time    : 5 hours 24 minutes
program up time   : 1 hour 14 minutes
processors        : 4x Intel(R) Core(TM) i5-2400 CPU @ 3.10GHz
physical memory   : 0/0 MB (free/total)
free disk space   : (C:) 1724.35 GB
display mode      : 1920x1080, 32 bit
process id        : $1b60
allocated memory  : 70.13 MB
command line      : RecorderApp.exe /1311840
executable        : RecorderApp.exe
exec. date/time   : 2010-07-22 16:40
version           : 6.15.4.238
madExcept version : 2.7h
exception class   : EOleException
exception message : Warning: A domain error occurred.

main thread ($1fac):
00565c26 RecorderApp.exe ADODB                           TADOCommand.Execute
00565b80 RecorderApp.exe ADODB                           TADOCommand.Execute
00565b60 RecorderApp.exe ADODB                           TADOCommand.Execute
005709d9 RecorderApp.exe BaseADODataModule       899  +9 TdmBaseADO.RunStoredProc
00957cf7 RecorderApp.exe IWColumnMappingClasses  618  +3 TMatchRule.MatchRecords
0098c8ac RecorderApp.exe BaseMatchPage           304  +9 TBaseMatch.btnSearchClick
004cce08 RecorderApp.exe Controls                        TControl.Click
004a9f5c RecorderApp.exe StdCtrls                        TButton.Click
00470c01 RecorderApp.exe Buttons                         TBitBtn.Click
0098e6cc RecorderApp.exe BaseMatchPage           870 +21 TBaseMatch.LoadContent
00984362 RecorderApp.exe MatchLocations          523  +5 TfraMatchLocations.LoadContent
00963213 RecorderApp.exe IWBasePage              117  +4 TBasePage.Create
00982a33 RecorderApp.exe MatchLocations          155  +1 TfraMatchLocations.Create
009905d0 RecorderApp.exe ImportWizard            305 +35 TfrmImportWizard.ChangePage
0099013e RecorderApp.exe ImportWizard            192 +22 TfrmImportWizard.btnNextClick
004cce08 RecorderApp.exe Controls                        TControl.Click
004a9f5c RecorderApp.exe StdCtrls                        TButton.Click
00470c01 RecorderApp.exe Buttons                         TBitBtn.Click
004aa050 RecorderApp.exe StdCtrls                        TButton.CNCommand
004ccc70 RecorderApp.exe Controls                        TControl.WndProc
004cfccf RecorderApp.exe Controls                        TWinControl.WndProc
004a9e20 RecorderApp.exe StdCtrls                        TButtonControl.WndProc
00721c39 RecorderApp.exe XPMenu                 2928 +10 TControlSubClass.ControlSubClass
76f0e72d ntdll.dll                                       RtlAnsiStringToUnicodeString
004cca40 RecorderApp.exe Controls                        TControl.Perform
004cfe07 RecorderApp.exe Controls                        DoControlMsg
004d045f RecorderApp.exe Controls                        TWinControl.WMCommand
004ccc70 RecorderApp.exe Controls                        TControl.WndProc
004cfccf RecorderApp.exe Controls                        TWinControl.WndProc
004a9e20 RecorderApp.exe StdCtrls                        TButtonControl.WndProc
004cf94c RecorderApp.exe Controls                        TWinControl.MainWndProc
00453460 RecorderApp.exe Classes                         StdWndProc
760d96c0 user32.dll                                      SendMessageW
760e7945 user32.dll                                      CallWindowProcA
004cfdb3 RecorderApp.exe Controls                        TWinControl.DefaultHandler
004cd210 RecorderApp.exe Controls                        TControl.WMLButtonUp
004ccc70 RecorderApp.exe Controls                        TControl.WndProc
004cfc01 RecorderApp.exe Controls                        TWinControl.WndProc
004ccc70 RecorderApp.exe Controls                        TControl.WndProc
004cfccf RecorderApp.exe Controls                        TWinControl.WndProc
004a9e20 RecorderApp.exe StdCtrls                        TButtonControl.WndProc
00721c39 RecorderApp.exe XPMenu                 2928 +10 TControlSubClass.ControlSubClass
004cca40 RecorderApp.exe Controls                        TControl.Perform
00453460 RecorderApp.exe Classes                         StdWndProc
004cf94c RecorderApp.exe Controls                        TWinControl.MainWndProc
00453460 RecorderApp.exe Classes                         StdWndProc
760d7bc5 user32.dll                                      DispatchMessageA
004bc12b RecorderApp.exe Forms                           TApplication.ProcessMessage
004bc162 RecorderApp.exe Forms                           TApplication.HandleMessage
004bc392 RecorderApp.exe Forms                           TApplication.Run
00a33a20 RecorderApp.exe RecorderApp             375 +83 initialization
74a93398 kernel32.dll                                    BaseThreadInitThunk

thread $1190:
76f0014d ntdll.dll                 
75f50bd7 KERNELBASE.dll            WaitForMultipleObjectsEx
74a91a27 kernel32.dll              WaitForMultipleObjectsEx
760e0864 user32.dll                MsgWaitForMultipleObjectsEx
760e0b64 user32.dll                MsgWaitForMultipleObjects
0042aba7 RecorderApp.exe madExcept ThreadExceptFrame
74a93398 kernel32.dll              BaseThreadInitThunk
>> created by main thread ($1fac) at:
6ef378a9 gdiplus.dll               

thread $b18:
76f0014d ntdll.dll     
74a93398 kernel32.dll  BaseThreadInitThunk

thread $1c50:
76f0014d ntdll.dll     
74a93398 kernel32.dll  BaseThreadInitThunk

thread $1cf4:
76eff8c1 ntdll.dll       
75f50a8b KERNELBASE.dll  WaitForSingleObjectEx
74a9118f kernel32.dll    WaitForSingleObjectEx
74a91143 kernel32.dll    WaitForSingleObject
74a93398 kernel32.dll    BaseThreadInitThunk

thread $1944:
76effd81 ntdll.dll                 
75f531b5 KERNELBASE.dll            SleepEx
75f53a86 KERNELBASE.dll            Sleep
0042aba7 RecorderApp.exe madExcept ThreadExceptFrame
74a93398 kernel32.dll              BaseThreadInitThunk
>> created by thread $1f54 at:
7465da8e ole32.dll                 

thread $c14:
76f01f36 ntdll.dll     
74a93398 kernel32.dll  BaseThreadInitThunk

thread $1a78:
76f01f36 ntdll.dll     
74a93398 kernel32.dll  BaseThreadInitThunk

thread $18e8:
76f01f36 ntdll.dll     
74a93398 kernel32.dll  BaseThreadInitThunk

thread $1a9c:
76f01f36 ntdll.dll     
74a93398 kernel32.dll  BaseThreadInitThunk

thread $1b14:
76f01f36 ntdll.dll     
74a93398 kernel32.dll  BaseThreadInitThunk

thread $1ff8:
76f01f36 ntdll.dll     
74a93398 kernel32.dll  BaseThreadInitThunk

modules:
00230000 C4DLL.DLL               1.0.0.1            C:\Recorder6
002a0000 MS5User.Dll             5.0.0.4            C:\Recorder6
002d0000 ms5cnv.dll              5.0.0.10           C:\Recorder6
00400000 RecorderApp.exe         6.15.4.238         C:\Recorder6
04e30000 GoToGridControl.ocx     2.0.0.16           C:\Recorder6\Addins
06390000 GoToKey.ocx             6.0.1.10           C:\Recorder6\Addins
06f60000 ShowUnchecked.ocx       6.0.0.13           C:\Recorder6\Addins
07170000 StdValLib.dll           6.14.3.208         C:\Recorder6\Addins
07650000 DropboxExt.14.dll       1.0.0.14           C:\Users\Ian Desktop\AppData\Roaming\Dropbox\bin
0f9a0000 VBAJET32.DLL            6.0.1.9431         C:\Windows\system32
0f9c0000 expsrv.dll              6.0.72.9589        C:\Windows\system32
10000000 MS5.Dll                 5.0.0.12           C:\Recorder6
50740000 docobj.dll              1.0.0.1822         C:\Windows\SysWow64
57c20000 msjtes40.dll            4.0.9756.0         C:\Windows\SysWOW64
57c70000 msjet40.dll             4.0.9756.0         C:\Windows\SysWOW64
57fb0000 mswstr10.dll            4.0.9756.0         C:\Windows\SysWOW64
58490000 odbccp32.dll            6.1.7601.17632     C:\Windows\system32
584d0000 msadrh15.dll            6.1.7600.16385     C:\Program Files (x86)\Common Files\System\ado
584f0000 msjetoledb40.dll        4.0.9756.0         C:\Windows\SysWOW64
58550000 WMVCore.DLL             12.0.7601.17514    C:\Windows\system32
587c0000 wpdshext.dll            6.1.7601.17514     C:\Windows\system32
58a10000 msjter40.dll            4.0.9756.0         C:\Windows\SysWOW64
58a30000 msadox.dll              6.1.7601.17514     C:\Program Files (x86)\Common Files\System\ado
58b90000 EhStorAPI.dll           6.1.7601.17514     C:\Windows\system32
58bc0000 audiodev.dll            6.1.7601.17514     C:\Windows\system32
58c00000 WMASF.DLL               12.0.7600.16385    C:\Windows\system32
58c40000 sqloledb.dll            6.1.7601.17514     C:\Program Files (x86)\Common Files\System\Ole DB
59cb0000 ieframe.DLL             9.0.8112.16434     C:\Windows\system32
5b350000 PortableDeviceApi.dll   6.1.7601.17514     C:\Windows\system32
5b620000 PortableDeviceTypes.dll 6.1.7600.16385     C:\Windows\system32
5b650000 comsvcs.dll             2001.12.8530.16385 C:\Windows\system32
5b790000 oledb32.dll             6.1.7601.17514     C:\Program Files (x86)\Common Files\System\Ole DB
5b9e0000 davclnt.dll             6.1.7601.17514     C:\Windows\System32
5ba00000 SearchFolder.dll        6.1.7601.17514     C:\Windows\system32
5bae0000 msader15.dll            6.1.7600.16385     C:\Program Files (x86)\Common Files\System\ado
5baf0000 StructuredQuery.dll     7.0.7601.17514     C:\Windows\System32
5bb50000 msadce.dll              6.1.7601.17514     C:\Program Files (x86)\Common Files\System\msadc
5bbf0000 RICHED20.dll            5.31.23.1230       C:\Windows\system32
5bd70000 MSJINT40.DLL            4.0.9756.0         C:\Windows\SysWOW64
5ff90000 tiptsf.dll              6.1.7600.16385     C:\Program Files (x86)\Common Files\microsoft shared\ink
63c10000 netbios.dll             6.1.7600.16385     C:\Windows\system32
643b0000 IconCodecService.dll    6.1.7600.16385     C:\Windows\system32
669d0000 SXS.DLL                 6.1.7601.17514     C:\Windows\system32
66bd0000 EhStorShell.dll         6.1.7600.16385     C:\Windows\system32
66c50000 WindowsCodecs.dll       6.1.7601.17514     C:\Windows\system32
69b10000 msxml4.dll              4.20.9876.0        c:\Windows\SysWOW64
69c70000 ntlanman.dll            6.1.7601.17514     C:\Windows\System32
69c90000 thumbcache.dll          6.1.7601.17514     C:\Windows\SysWOW64
69cb0000 DBNETLIB.DLL            6.1.7600.16385     C:\Windows\system32
69d50000 DAVHLPR.dll             6.1.7600.16385     C:\Windows\System32
69d60000 RICHED32.DLL            6.1.7601.17514     C:\Windows\system32
69d70000 MSDATL3.dll             6.1.7600.16385     C:\Program Files (x86)\Common Files\System\Ole DB
6ad60000 SHFolder.dll            6.1.7600.16385     C:\Windows\system32
6b000000 msadcer.dll             6.1.7600.16385     C:\Program Files (x86)\Common Files\System\msadc
6b010000 ATL.DLL                 3.5.2284.0         C:\Windows\system32
6b030000 OLEDB32R.DLL            6.1.7600.16385     C:\Program Files (x86)\Common Files\System\Ole DB
6b050000 msado15.dll             6.1.7601.17514     C:\Program Files (x86)\Common Files\System\ado
6b150000 HHCtrl.ocx              6.1.7600.16385     C:\Windows\system32
6b2d0000 odbc32.dll              6.1.7601.17514     C:\Windows\system32
6b420000 odbcint.dll             6.1.7600.16385     C:\Windows\system32
6dfb0000 comctl32.dll            5.82.7601.17514    C:\Windows\WinSxS\x86_microsoft.windows.common-controls_6595b64144ccf1df_5.82.7601.17514_none_ec83dffa859149af
6eef0000 gdiplus.dll             6.1.7601.17514     C:\Windows\WinSxS\x86_microsoft.windows.gdiplus_6595b64144ccf1df_1.1.7601.17514_none_72d18a4386696c80
6f7c0000 MSDART.DLL              6.1.7600.16385     C:\Windows\system32
6f920000 dwmapi.dll              6.1.7600.16385     C:\Windows\system32
6f950000 SAMLIB.dll              6.1.7600.16385     C:\Windows\system32
6fa80000 mpr.dll                 6.1.7600.16385     C:\Windows\system32
70290000 uxtheme.dll             6.1.7600.16385     C:\Windows\system32
703e0000 bcryptprimitives.dll    6.1.7600.16385     C:\Windows\SysWOW64
70c70000 SQLOLEDB.RLL            6.1.7600.16385     C:\Program Files (x86)\Common Files\System\Ole DB
70f40000 slc.dll                 6.1.7600.16385     C:\Windows\system32
70f50000 ntshrui.dll             6.1.7601.17514     C:\Windows\system32
71010000 apphelp.dll             6.1.7601.17514     C:\Windows\system32
710d0000 actxprxy.dll            6.1.7601.17514     C:\Windows\SysWOW64
711b0000 propsys.dll             7.0.7601.17514     C:\Windows\system32
712b0000 Comctl32.dll            6.10.7601.17514    C:\Windows\WinSxS\x86_microsoft.windows.common-controls_6595b64144ccf1df_6.0.7601.17514_none_41e6975e2bd6f2b2
717d0000 ntdsapi.dll             6.1.7600.16385     C:\Windows\system32
71910000 bcrypt.dll              6.1.7600.16385     C:\Windows\system32
71930000 ncrypt.dll              6.1.7600.16385     C:\Windows\system32
71b30000 WINSTA.dll              6.1.7601.17514     C:\Windows\System32
71ca0000 DBnmpNTw.dll            6.1.7600.16385     C:\Windows\system32
71cb0000 SHDOCVW.dll             6.1.7601.17514     C:\Windows\system32
71ce0000 drprov.dll              6.1.7600.16385     C:\Windows\System32
71cf0000 olepro32.dll            6.1.7601.17514     C:\Windows\system32
71e80000 security.dll            6.1.7600.16385     C:\Windows\system32
71ea0000 schannel.dll            6.1.7601.17514     C:\Windows\SysWOW64
72050000 cryptdll.dll            6.1.7600.16385     C:\Windows\system32
72070000 msv1_0.DLL              6.1.7601.17514     C:\Windows\SysWOW64
720c0000 credssp.dll             6.1.7601.17514     C:\Windows\system32
721b0000 samcli.dll              6.1.7601.17514     C:\Windows\system32
721d0000 rsaenh.dll              6.1.7600.16385     C:\Windows\system32
72210000 CRYPTSP.dll             6.1.7600.16385     C:\Windows\system32
72270000 RpcRtRemote.dll         6.1.7601.17514     C:\Windows\system32
722e0000 dbghelp.dll             6.1.7601.17514     C:\Windows\system32
72460000 cscapi.dll              6.1.7601.17514     C:\Windows\system32
724a0000 SECUR32.DLL             6.1.7601.17514     C:\Windows\system32
72850000 wkscli.dll              6.1.7601.17514     C:\Windows\system32
72860000 srvcli.dll              6.1.7601.17514     C:\Windows\system32
72880000 netutils.dll            6.1.7601.17514     C:\Windows\system32
72890000 NETAPI32.dll            6.1.7601.17514     C:\Windows\system32
72930000 ntmarta.dll             6.1.7600.16385     C:\Windows\system32
72bd0000 version.dll             6.1.7600.16385     C:\Windows\system32
72cf0000 profapi.dll             6.1.7600.16385     C:\Windows\system32
72d30000 wsock32.dll             6.1.7600.16385     C:\Windows\system32
742d0000 OLEACC.dll              7.0.0.0            C:\Windows\system32
74340000 winmm.dll               6.1.7601.17514     C:\Windows\system32
74400000 winspool.drv            6.1.7601.17514     C:\Windows\system32
745c0000 CRYPTBASE.dll           6.1.7600.16385     C:\Windows\syswow64
745d0000 SspiCli.dll             6.1.7601.17514     C:\Windows\syswow64
74630000 ole32.dll               6.1.7601.17514     C:\Windows\syswow64
74790000 Normaliz.dll            6.1.7600.16385     C:\Windows\syswow64
747a0000 NSI.dll                 6.1.7600.16385     C:\Windows\syswow64
747b0000 CRYPT32.dll             6.1.7601.17514     C:\Windows\syswow64
748d0000 urlmon.dll              9.0.8112.16434     C:\Windows\syswow64
749e0000 IMM32.DLL               6.1.7601.17514     C:\Windows\system32
74a40000 MSASN1.dll              6.1.7601.17514     C:\Windows\syswow64
74a80000 kernel32.dll            6.1.7601.17651     C:\Windows\syswow64
74b90000 SHLWAPI.dll             6.1.7601.17514     C:\Windows\syswow64
74bf0000 iertutil.dll            9.0.8112.16434     C:\Windows\syswow64
74db0000 DEVOBJ.dll              6.1.7601.17621     C:\Windows\syswow64
74dd0000 shell32.dll             6.1.7601.17514     C:\Windows\syswow64
75b10000 MSCTF.dll               6.1.7600.16385     C:\Windows\syswow64
75be0000 WININET.dll             9.0.8112.16434     C:\Windows\syswow64
75d00000 ADVAPI32.dll            6.1.7601.17514     C:\Windows\syswow64
75da0000 msvcrt.dll              7.0.7600.16385     C:\Windows\syswow64
75e50000 sechost.dll             6.1.7600.16385     C:\Windows\SysWOW64
75e70000 LPK.dll                 6.1.7600.16385     C:\Windows\syswow64
75e80000 CLBCatQ.DLL             2001.12.8530.16385 C:\Windows\syswow64
75f10000 WINTRUST.dll            6.1.7601.17514     C:\Windows\syswow64
75f40000 KERNELBASE.dll          6.1.7601.17651     C:\Windows\syswow64
75f90000 RPCRT4.dll              6.1.7601.17514     C:\Windows\syswow64
76080000 WS2_32.dll              6.1.7601.17514     C:\Windows\syswow64
760c0000 user32.dll              6.1.7601.17514     C:\Windows\syswow64
761c0000 CFGMGR32.dll            6.1.7601.17621     C:\Windows\syswow64
761f0000 SETUPAPI.dll            6.1.7601.17514     C:\Windows\syswow64
76390000 WLDAP32.dll             6.1.7601.17514     C:\Windows\syswow64
763e0000 comdlg32.dll            6.1.7601.17514     C:\Windows\syswow64
76460000 GDI32.dll               6.1.7601.17514     C:\Windows\syswow64
764f0000 oleaut32.dll            6.1.7601.17567     C:\Windows\syswow64
76580000 USP10.dll               1.626.7601.17561   C:\Windows\syswow64
76eb0000 PSAPI.DLL               6.1.7600.16385     C:\Windows\syswow64
76ee0000 ntdll.dll               6.1.7601.17514     C:\Windows\SysWOW64
7c340000 MSVCR71.dll             7.10.3052.4        C:\Users\Ian Desktop\AppData\Roaming\Dropbox\bin
7c3a0000 MSVCP71.dll             7.10.3077.0        C:\Users\Ian Desktop\AppData\Roaming\Dropbox\bin

2 Reply by johnvanbreda

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

Re: Error on import

Hi Ian
Are you able to reproduce this reliably? If so, would you be able to supply the import file for us to test?

Also, can you explain the exact sequence of steps leading to the error?

Kind Regards

John van Breda
Biodiverse IT

johnvanbreda's Website

3 Reply by MikeWeideli

  • MikeWeideli
  • Administrator
  • Offline
  • From: Littlefield Consultancy
  • Registered: 05-07-2006
  • Posts: 2,645

Re: Error on import

This has sometimes turned out to be a problem with the date format in Excel see post
http://forums.nbn.org.uk/viewtopic.php?id=2036, but not always. In the last case I looked at the (see http://forums.nbn.org.uk/viewtopic.php?id=2197 )  the file imported on my system without any problem. The data was finally imported by breaking down the file into smaller chunks and importing these.

Mike Weideli

MikeWeideli's Website

4 Reply by Ian M Spence

  • Ian M Spence
  • Veteran
  • Offline
  • From: North east Wales
  • Registered: 30-06-2006
  • Posts: 193

Re: Error on import

Hi John and Mike

I have been able to reproduce the problem as each time that I check the file to see if is 'clean' and save it I have been getting the same problem.

Mike's suggestion about breaking the file down reminds me of a problem I had a few years ago, when I had to keep halving the size of a file and never did fing out what caused the problem but with progressively smaller files they all imported eventually.

The file I have been working with has just 208 records. I have just reformatted the dates to Custom dd/mm/yyyy and tried again, but get the same error.

I go through the import wizard, choose the template, validate the columns, choose the survey to import to, select 'reported to recorder, see all the observers okay, get to the species page, search and all the species fields fill in. Click Next and the unhandled error occurs.

I have just tried the splitting the file trick and have now got the error in a file of just 27 records. Would you like to see the file to try to find out what is causing the problem? All the other records have now imported successfully from their reduced files. I think to send a file I need to send it to your email address and not via the Forum. Is that correct?

Many thanks for your suggestions.

All the best, Ian

5 Reply by johnvanbreda

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

Re: Error on import

Hi Ian
If you follow the link to my email on the left you should be able to send me the file to try. 27 records to import should be great.
Thanks

John van Breda
Biodiverse IT

johnvanbreda's Website

6 Reply by johnvanbreda

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

Re: Error on import

Hi Ian
I've worked out a fix - caused by a trigonometry function having an out of range value when Recorder checks that the locations it proposes to match to your data are actually near the data points. To fix the problem you will need to connect to your database using SQL Server Management Studio or Management Studio Express using a login with system admin privileges, then run the following script. Let me or your reseller know if you have not used these tools before.

ALTER PROCEDURE [dbo].[usp_IWMatch_Locations]
AS
    DECLARE @EarthRadiusKM float
    SET     @EarthRadiusKM = 6378
        
    -- Set Match_Count first.
    UPDATE    #Locations
    SET    Match_Count =  (SELECT    Count(DISTINCT L.Location_Key)
                FROM    #Master M
                JOIN    Location_Name LN ON LN.Item_Name = M.SYSTEM0100000000_Data
                JOIN    Location L ON L.Location_Key = LN.Location_Key
                JOIN    Location_Name LN2 ON LN2.Location_Key = L.Location_Key AND LN2.Preferred = 1
                WHERE    M.SYSTEM0100000000_Data = Import_Value
                -- next is a safety check to avoid domain errors on ACOS
                AND COS(RADIANS(M.SYSTEM0100000001_Lat)) * COS(RADIANS(L.Lat)) * 
                        COS(RADIANS(M.SYSTEM0100000001_Long) - RADIANS(L.Long)) + 
                        SIN(RADIANS(M.SYSTEM0100000001_Lat)) * SIN(RADIANS(L.Lat)) BETWEEN -1 AND 1
                AND    @EarthRadiusKM * ACOS(COS(RADIANS(M.SYSTEM0100000001_Lat)) * COS(RADIANS(L.Lat)) * 
                        COS(RADIANS(M.SYSTEM0100000001_Long) - RADIANS(L.Long)) + 
                        SIN(RADIANS(M.SYSTEM0100000001_Lat)) * SIN(RADIANS(L.Lat))) < 2
                )
    WHERE    Match_Key IS NULL
    
    -- Now get values and keys for unique matches only.
    UPDATE    #Locations
    SET    Match_Key = L.Location_Key,
        Match_Value = LN2.Item_Name,
        Spatial_Ref = L.Spatial_Ref,
        Spatial_Ref_System = L.Spatial_Ref_System,
        Lat = L.Lat,
        Long = L.Long
    FROM    #Master M
    JOIN    Location_Name LN ON LN.Item_Name = M.SYSTEM0100000000_Data
    JOIN    Location L ON L.Location_Key = LN.Location_Key
    JOIN    Location_Name LN2 ON LN2.Location_Key = L.Location_Key AND LN2.Preferred = 1
    WHERE    Match_Count = 1
    AND    Match_Key IS NULL
    AND    M.SYSTEM0100000000_Data = Import_Value
    -- next is a safety check to avoid domain errors on ACOS
    AND COS(RADIANS(M.SYSTEM0100000001_Lat)) * COS(RADIANS(L.Lat)) * 
            COS(RADIANS(M.SYSTEM0100000001_Long) - RADIANS(L.Long)) + 
            SIN(RADIANS(M.SYSTEM0100000001_Lat)) * SIN(RADIANS(L.Lat)) BETWEEN -1 AND 1
    AND    @EarthRadiusKM * ACOS(COS(RADIANS(M.SYSTEM0100000001_Lat)) * COS(RADIANS(L.Lat)) * 
            COS(RADIANS(M.SYSTEM0100000001_Long) - RADIANS(L.Long)) + 
            SIN(RADIANS(M.SYSTEM0100000001_Lat)) * SIN(RADIANS(L.Lat))) < 2
John van Breda
Biodiverse IT

johnvanbreda's Website

7 Reply by johnvanbreda

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

Re: Error on import

I forgot to mention, this script will of course be included in Recorder 6.17.

John van Breda
Biodiverse IT

johnvanbreda's Website

8 Reply by LBacon

  • LBacon
  • Veteran
  • Offline
  • Registered: 12-09-2006
  • Posts: 80

Re: Error on import

I have just tried to import an annual dataset update from one of our groups, a mere 20000 records.  All the species, name and location matching / adding goes OK (had to create a few new observers/locations but nothing unusual there).  Then, atthe first stage of the actual import, wheer data is being processed, the little "traffic light" box saying recorder has encountered an error, do you want to continue, restart or quit..... appears.  Alongside, the following error message is created.

I have tried thisimport three times, and three tiomes get to this problem.

Any advice in simple English much appreciated

Louise
CPERC

date/time         : 2011-09-13, 09:37:47, 476ms
computer name     : CPERC-03
user name         : Louise Bacon
operating system  : Windows XP Service Pack 3 build 2600
system language   : English
system up time    : 15 minutes 25 seconds
program up time   : 12 minutes 19 seconds
processors        : 2x Pentium(R) Dual-Core  CPU      E5700  @ 3.00GHz
physical memory   : 2048/2048 MB (free/total)
free disk space   : (C:) 193.16 GB
display mode      : 1440x900, 32 bit
process id        : $1dc
allocated memory  : 39.43 MB
command line      : RecorderApp.exe /66370
executable        : RecorderApp.exe
exec. date/time   : 2010-07-22 17:40
version           : 6.15.4.238
madExcept version : 2.7h
exception class   : EOleException
exception message : Error converting data type varchar to real.

main thread ($f7c):
00565c26 RecorderApp.exe ADODB                           TADOCommand.Execute
00565b80 RecorderApp.exe ADODB                           TADOCommand.Execute
00565b60 RecorderApp.exe ADODB                           TADOCommand.Execute
005709d9 RecorderApp.exe BaseADODataModule       899  +9 TdmBaseADO.RunStoredProc
0095cdeb RecorderApp.exe IWColumnMappingClasses 1736  +6 TImportFile.ApplyTableRulePostProcessing
0095d19b RecorderApp.exe IWColumnMappingClasses 1805 +54 TImportFile.ApplyTableRules
009808bc RecorderApp.exe Import                  189  +7 TfraImport.GenerateImportDatabase
0098073c RecorderApp.exe Import                  152 +14 TfraImport.Execute
00990758 RecorderApp.exe ImportWizard            339 +69 TfrmImportWizard.ChangePage
0099013e RecorderApp.exe ImportWizard            192 +22 TfrmImportWizard.btnNextClick
004cce08 RecorderApp.exe Controls                        TControl.Click
004a9f5c RecorderApp.exe StdCtrls                        TButton.Click
00470c01 RecorderApp.exe Buttons                         TBitBtn.Click
004aa050 RecorderApp.exe StdCtrls                        TButton.CNCommand
004ccc70 RecorderApp.exe Controls                        TControl.WndProc
004cfccf RecorderApp.exe Controls                        TWinControl.WndProc
004a9e20 RecorderApp.exe StdCtrls                        TButtonControl.WndProc
00721c39 RecorderApp.exe XPMenu                 2928 +10 TControlSubClass.ControlSubClass
7c90eb94 ntdll.dll                                       RtlAnsiStringToUnicodeString
004cca40 RecorderApp.exe Controls                        TControl.Perform
004cfe07 RecorderApp.exe Controls                        DoControlMsg
004d045f RecorderApp.exe Controls                        TWinControl.WMCommand
004ccc70 RecorderApp.exe Controls                        TControl.WndProc
004cfccf RecorderApp.exe Controls                        TWinControl.WndProc
004a9e20 RecorderApp.exe StdCtrls                        TButtonControl.WndProc
004464c9 RecorderApp.exe Classes                         TList.Delete
004cf94c RecorderApp.exe Controls                        TWinControl.MainWndProc
00453460 RecorderApp.exe Classes                         StdWndProc
7e4292de user32.dll                                      SendMessageW
7e42a993 user32.dll                                      CallWindowProcA
004cfdb3 RecorderApp.exe Controls                        TWinControl.DefaultHandler
004cd210 RecorderApp.exe Controls                        TControl.WMLButtonUp
004ccc70 RecorderApp.exe Controls                        TControl.WndProc
004cfc01 RecorderApp.exe Controls                        TWinControl.WndProc
004ccc70 RecorderApp.exe Controls                        TControl.WndProc
004cfccf RecorderApp.exe Controls                        TWinControl.WndProc
004a9e20 RecorderApp.exe StdCtrls                        TButtonControl.WndProc
00721c39 RecorderApp.exe XPMenu                 2928 +10 TControlSubClass.ControlSubClass
004cca40 RecorderApp.exe Controls                        TControl.Perform
004cf94c RecorderApp.exe Controls                        TWinControl.MainWndProc
00453460 RecorderApp.exe Classes                         StdWndProc
7e4196c2 user32.dll                                      DispatchMessageA
004bc12b RecorderApp.exe Forms                           TApplication.ProcessMessage
004bc162 RecorderApp.exe Forms                           TApplication.HandleMessage
004bc392 RecorderApp.exe Forms                           TApplication.Run
00a33a20 RecorderApp.exe RecorderApp             375 +83 initialization

thread $8a4:
7c90e514 ntdll.dll                 KiFastSystemCallRet
7c90df48 ntdll.dll                 NtWaitForMultipleObjects
7c80958a kernel32.dll              WaitForMultipleObjectsEx
7e4195f3 user32.dll                MsgWaitForMultipleObjectsEx
7e4196a3 user32.dll                MsgWaitForMultipleObjects
0042aba7 RecorderApp.exe madExcept ThreadExceptFrame
>> created by main thread ($f7c) at:
4ec67f66 gdiplus.dll               

thread $924:
7c90e514 ntdll.dll  KiFastSystemCallRet
7c90df48 ntdll.dll  NtWaitForMultipleObjects

thread $928:
7c90e514 ntdll.dll     KiFastSystemCallRet
7c90df58 ntdll.dll     NtWaitForSingleObject
7c8025d5 kernel32.dll  WaitForSingleObjectEx
7c80253d kernel32.dll  WaitForSingleObject

thread $980:
7c90e514 ntdll.dll                 KiFastSystemCallRet
7c90daa8 ntdll.dll                 NtReplyWaitReceivePortEx
0042aba7 RecorderApp.exe madExcept ThreadExceptFrame
>> created by thread $904 at:
77e7d10d RPCRT4.dll               

thread $d14:
7c90e514 ntdll.dll  KiFastSystemCallRet
7c90d218 ntdll.dll  NtDelayExecution

modules:
00340000 C4DLL.DLL              1.0.0.1          \\rec-srv\Recorder 6 Server
003b0000 MS5User.Dll            5.0.0.4          \\rec-srv\Recorder 6 Server
00400000 RecorderApp.exe        6.15.4.238       \\rec-srv\Recorder 6 Server
01430000 ms5cnv.dll             5.0.0.10         \\rec-srv\Recorder 6 Server
01bc0000 odbcint.dll            3.525.1132.0     C:\WINDOWS\system32
02a60000 xpsp2res.dll           5.1.2600.5512    C:\WINDOWS\system32
03860000 SQLOLEDB.RLL           2000.85.1132.0   C:\Program Files\Common Files\System\Ole DB
03870000 msadcer.dll            2.81.1132.0      C:\Program Files\Common Files\System\msadc
03bb0000 GOTOGR~1.OCX           2.0.0.16         \\rec-srv\Recorder 6 Server\Addins
03d40000 GoToKey.ocx            6.0.1.10         \\rec-srv\Recorder 6 Server\Addins
03f80000 SHOWUN~1.OCX           6.0.0.13         \\rec-srv\Recorder 6 Server\Addins
041b0000 STDVAL~1.DLL           6.15.1.230       \\rec-srv\Recorder 6 Server\Addins
046f0000 LMIRfsClientNP.dll     2.1.3.0          C:\WINDOWS\system32
049c0000 Normaliz.dll           6.0.5441.0       C:\WINDOWS\system32
04ce0000 office.odf             14.0.6024.1000   C:\PROGRA~1\COMMON~1\MICROS~1\OFFICE14\Cultures
05100000 GrooveIntlResource.dll 14.0.6009.1000   C:\PROGRA~1\MICROS~3\Office14\1033
10000000 MS5.Dll                5.0.0.12         \\rec-srv\Recorder 6 Server
10930000 PortableDeviceApi.dll  5.2.5721.5145    C:\WINDOWS\system32
20000000 xpsp3res.dll           5.1.2600.5512    C:\WINDOWS\system32
3d930000 WININET.dll            8.0.6001.19098   C:\WINDOWS\system32
3dfd0000 iertutil.dll           8.0.6001.19098   C:\WINDOWS\system32
49460000 GROOVEEX.DLL           14.0.6019.1000   C:\PROGRA~1\MICROS~3\Office14
4dd00000 sqloledb.dll           2000.85.1132.0   C:\Program Files\Common Files\System\Ole DB
4de10000 msado15.dll            2.81.3012.0      C:\Program Files\Common Files\System\ado
4ec50000 gdiplus.dll            5.2.6002.22509   C:\WINDOWS\WinSxS\x86_Microsoft.Windows.GdiPlus_6595b64144ccf1df_1.0.6002.22509_x-ww_c7dad023
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.6028   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
732e0000 RICHED32.DLL           5.1.2600.0       C:\WINDOWS\system32
74060000 msadce.dll             2.81.3002.0      C:\Program Files\Common Files\System\msadc
74320000 odbc32.dll             3.525.3012.0     C:\WINDOWS\system32
74720000 MSCTF.dll              5.1.2600.5512    C:\WINDOWS\system32
74e30000 RICHED20.dll           5.30.23.1230     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.6003    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.6108    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.6089    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.6058    C:\WINDOWS\system32
773d0000 comctl32.dll           6.0.2900.6028    C:\WINDOWS\WinSxS\x86_Microsoft.Windows.Common-Controls_6595b64144ccf1df_6.0.2600.6028_x-ww_61e65202
774e0000 ole32.dll              5.1.2600.6010    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.6147  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.6022    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.19100   C:\WINDOWS\system32
78480000 MSVCP90.dll            9.0.30729.4148   C:\WINDOWS\WinSxS\x86_Microsoft.VC90.CRT_1fc8b3b9a1e18e3b_9.0.30729.4148_x-ww_d495ac4e
78520000 MSVCR90.dll            9.0.30729.4148   C:\WINDOWS\WinSxS\x86_Microsoft.VC90.CRT_1fc8b3b9a1e18e3b_9.0.30729.4148_x-ww_d495ac4e
78e20000 ATL90.DLL              9.0.30729.4148   C:\WINDOWS\WinSxS\x86_Microsoft.VC90.ATL_1fc8b3b9a1e18e3b_9.0.30729.4148_x-ww_353599c2
7c800000 kernel32.dll           5.1.2600.5781    C:\WINDOWS\system32
7c900000 ntdll.dll              5.1.2600.6055    C:\WINDOWS\system32
7c9c0000 shell32.dll            6.0.2900.6072    C:\WINDOWS\system32
7e290000 shdocvw.dll            6.0.2900.6003    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

9 Reply by LBacon

  • LBacon
  • Veteran
  • Offline
  • Registered: 12-09-2006
  • Posts: 80

Re: Error on import

Well,

I decided to start halving my data and import what I could - I know have a batch of about 1000 records which still give the same error but have lost the inclination to compete the task this week of reducing the dataset down and repeating the import until I was left with only one or two records.  That can wait for another day....but if anyone has any idea if I am looking for a piece of text in one of the records or something like that which is causing this problem then I would be most grateful........

LBacon wrote:

I have just tried to import an annual dataset update from one of our groups, a mere 20000 records.  All the species, name and location matching / adding goes OK (had to create a few new observers/locations but nothing unusual there).  Then, atthe first stage of the actual import, wheer data is being processed, the little "traffic light" box saying recorder has encountered an error, do you want to continue, restart or quit..... appears.  Alongside, the following error message is created.

I have tried thisimport three times, and three tiomes get to this problem.

Any advice in simple English much appreciated

Louise
CPERC

date/time         : 2011-09-13, 09:37:47, 476ms
computer name     : CPERC-03
user name         : Louise Bacon
operating system  : Windows XP Service Pack 3 build 2600
system language   : English
system up time    : 15 minutes 25 seconds
program up time   : 12 minutes 19 seconds
processors        : 2x Pentium(R) Dual-Core  CPU      E5700  @ 3.00GHz
physical memory   : 2048/2048 MB (free/total)
free disk space   : (C:) 193.16 GB
display mode      : 1440x900, 32 bit
process id        : $1dc
allocated memory  : 39.43 MB
command line      : RecorderApp.exe /66370
executable        : RecorderApp.exe
exec. date/time   : 2010-07-22 17:40
version           : 6.15.4.238
madExcept version : 2.7h
exception class   : EOleException
exception message : Error converting data type varchar to real.

main thread ($f7c):
00565c26 RecorderApp.exe ADODB                           TADOCommand.Execute
00565b80 RecorderApp.exe ADODB                           TADOCommand.Execute
00565b60 RecorderApp.exe ADODB                           TADOCommand.Execute
005709d9 RecorderApp.exe BaseADODataModule       899  +9 TdmBaseADO.RunStoredProc
0095cdeb RecorderApp.exe IWColumnMappingClasses 1736  +6 TImportFile.ApplyTableRulePostProcessing
0095d19b RecorderApp.exe IWColumnMappingClasses 1805 +54 TImportFile.ApplyTableRules
009808bc RecorderApp.exe Import                  189  +7 TfraImport.GenerateImportDatabase
0098073c RecorderApp.exe Import                  152 +14 TfraImport.Execute
00990758 RecorderApp.exe ImportWizard            339 +69 TfrmImportWizard.ChangePage
0099013e RecorderApp.exe ImportWizard            192 +22 TfrmImportWizard.btnNextClick
004cce08 RecorderApp.exe Controls                        TControl.Click
004a9f5c RecorderApp.exe StdCtrls                        TButton.Click
00470c01 RecorderApp.exe Buttons                         TBitBtn.Click
004aa050 RecorderApp.exe StdCtrls                        TButton.CNCommand
004ccc70 RecorderApp.exe Controls                        TControl.WndProc
004cfccf RecorderApp.exe Controls                        TWinControl.WndProc
004a9e20 RecorderApp.exe StdCtrls                        TButtonControl.WndProc
00721c39 RecorderApp.exe XPMenu                 2928 +10 TControlSubClass.ControlSubClass
7c90eb94 ntdll.dll                                       RtlAnsiStringToUnicodeString
004cca40 RecorderApp.exe Controls                        TControl.Perform
004cfe07 RecorderApp.exe Controls                        DoControlMsg
004d045f RecorderApp.exe Controls                        TWinControl.WMCommand
004ccc70 RecorderApp.exe Controls                        TControl.WndProc
004cfccf RecorderApp.exe Controls                        TWinControl.WndProc
004a9e20 RecorderApp.exe StdCtrls                        TButtonControl.WndProc
004464c9 RecorderApp.exe Classes                         TList.Delete
004cf94c RecorderApp.exe Controls                        TWinControl.MainWndProc
00453460 RecorderApp.exe Classes                         StdWndProc
7e4292de user32.dll                                      SendMessageW
7e42a993 user32.dll                                      CallWindowProcA
004cfdb3 RecorderApp.exe Controls                        TWinControl.DefaultHandler
004cd210 RecorderApp.exe Controls                        TControl.WMLButtonUp
004ccc70 RecorderApp.exe Controls                        TControl.WndProc
004cfc01 RecorderApp.exe Controls                        TWinControl.WndProc
004ccc70 RecorderApp.exe Controls                        TControl.WndProc
004cfccf RecorderApp.exe Controls                        TWinControl.WndProc
004a9e20 RecorderApp.exe StdCtrls                        TButtonControl.WndProc
00721c39 RecorderApp.exe XPMenu                 2928 +10 TControlSubClass.ControlSubClass
004cca40 RecorderApp.exe Controls                        TControl.Perform
004cf94c RecorderApp.exe Controls                        TWinControl.MainWndProc
00453460 RecorderApp.exe Classes                         StdWndProc
7e4196c2 user32.dll                                      DispatchMessageA
004bc12b RecorderApp.exe Forms                           TApplication.ProcessMessage
004bc162 RecorderApp.exe Forms                           TApplication.HandleMessage
004bc392 RecorderApp.exe Forms                           TApplication.Run
00a33a20 RecorderApp.exe RecorderApp             375 +83 initialization

thread $8a4:
7c90e514 ntdll.dll                 KiFastSystemCallRet
7c90df48 ntdll.dll                 NtWaitForMultipleObjects
7c80958a kernel32.dll              WaitForMultipleObjectsEx
7e4195f3 user32.dll                MsgWaitForMultipleObjectsEx
7e4196a3 user32.dll                MsgWaitForMultipleObjects
0042aba7 RecorderApp.exe madExcept ThreadExceptFrame
>> created by main thread ($f7c) at:
4ec67f66 gdiplus.dll               

thread $924:
7c90e514 ntdll.dll  KiFastSystemCallRet
7c90df48 ntdll.dll  NtWaitForMultipleObjects

thread $928:
7c90e514 ntdll.dll     KiFastSystemCallRet
7c90df58 ntdll.dll     NtWaitForSingleObject
7c8025d5 kernel32.dll  WaitForSingleObjectEx
7c80253d kernel32.dll  WaitForSingleObject

thread $980:
7c90e514 ntdll.dll                 KiFastSystemCallRet
7c90daa8 ntdll.dll                 NtReplyWaitReceivePortEx
0042aba7 RecorderApp.exe madExcept ThreadExceptFrame
>> created by thread $904 at:
77e7d10d RPCRT4.dll               

thread $d14:
7c90e514 ntdll.dll  KiFastSystemCallRet
7c90d218 ntdll.dll  NtDelayExecution

modules:
00340000 C4DLL.DLL              1.0.0.1          \\rec-srv\Recorder 6 Server
003b0000 MS5User.Dll            5.0.0.4          \\rec-srv\Recorder 6 Server
00400000 RecorderApp.exe        6.15.4.238       \\rec-srv\Recorder 6 Server
01430000 ms5cnv.dll             5.0.0.10         \\rec-srv\Recorder 6 Server
01bc0000 odbcint.dll            3.525.1132.0     C:\WINDOWS\system32
02a60000 xpsp2res.dll           5.1.2600.5512    C:\WINDOWS\system32
03860000 SQLOLEDB.RLL           2000.85.1132.0   C:\Program Files\Common Files\System\Ole DB
03870000 msadcer.dll            2.81.1132.0      C:\Program Files\Common Files\System\msadc
03bb0000 GOTOGR~1.OCX           2.0.0.16         \\rec-srv\Recorder 6 Server\Addins
03d40000 GoToKey.ocx            6.0.1.10         \\rec-srv\Recorder 6 Server\Addins
03f80000 SHOWUN~1.OCX           6.0.0.13         \\rec-srv\Recorder 6 Server\Addins
041b0000 STDVAL~1.DLL           6.15.1.230       \\rec-srv\Recorder 6 Server\Addins
046f0000 LMIRfsClientNP.dll     2.1.3.0          C:\WINDOWS\system32
049c0000 Normaliz.dll           6.0.5441.0       C:\WINDOWS\system32
04ce0000 office.odf             14.0.6024.1000   C:\PROGRA~1\COMMON~1\MICROS~1\OFFICE14\Cultures
05100000 GrooveIntlResource.dll 14.0.6009.1000   C:\PROGRA~1\MICROS~3\Office14\1033
10000000 MS5.Dll                5.0.0.12         \\rec-srv\Recorder 6 Server
10930000 PortableDeviceApi.dll  5.2.5721.5145    C:\WINDOWS\system32
20000000 xpsp3res.dll           5.1.2600.5512    C:\WINDOWS\system32
3d930000 WININET.dll            8.0.6001.19098   C:\WINDOWS\system32
3dfd0000 iertutil.dll           8.0.6001.19098   C:\WINDOWS\system32
49460000 GROOVEEX.DLL           14.0.6019.1000   C:\PROGRA~1\MICROS~3\Office14
4dd00000 sqloledb.dll           2000.85.1132.0   C:\Program Files\Common Files\System\Ole DB
4de10000 msado15.dll            2.81.3012.0      C:\Program Files\Common Files\System\ado
4ec50000 gdiplus.dll            5.2.6002.22509   C:\WINDOWS\WinSxS\x86_Microsoft.Windows.GdiPlus_6595b64144ccf1df_1.0.6002.22509_x-ww_c7dad023
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.6028   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
732e0000 RICHED32.DLL           5.1.2600.0       C:\WINDOWS\system32
74060000 msadce.dll             2.81.3002.0      C:\Program Files\Common Files\System\msadc
74320000 odbc32.dll             3.525.3012.0     C:\WINDOWS\system32
74720000 MSCTF.dll              5.1.2600.5512    C:\WINDOWS\system32
74e30000 RICHED20.dll           5.30.23.1230     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.6003    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.6108    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.6089    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.6058    C:\WINDOWS\system32
773d0000 comctl32.dll           6.0.2900.6028    C:\WINDOWS\WinSxS\x86_Microsoft.Windows.Common-Controls_6595b64144ccf1df_6.0.2600.6028_x-ww_61e65202
774e0000 ole32.dll              5.1.2600.6010    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.6147  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.6022    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.19100   C:\WINDOWS\system32
78480000 MSVCP90.dll            9.0.30729.4148   C:\WINDOWS\WinSxS\x86_Microsoft.VC90.CRT_1fc8b3b9a1e18e3b_9.0.30729.4148_x-ww_d495ac4e
78520000 MSVCR90.dll            9.0.30729.4148   C:\WINDOWS\WinSxS\x86_Microsoft.VC90.CRT_1fc8b3b9a1e18e3b_9.0.30729.4148_x-ww_d495ac4e
78e20000 ATL90.DLL              9.0.30729.4148   C:\WINDOWS\WinSxS\x86_Microsoft.VC90.ATL_1fc8b3b9a1e18e3b_9.0.30729.4148_x-ww_353599c2
7c800000 kernel32.dll           5.1.2600.5781    C:\WINDOWS\system32
7c900000 ntdll.dll              5.1.2600.6055    C:\WINDOWS\system32
7c9c0000 shell32.dll            6.0.2900.6072    C:\WINDOWS\system32
7e290000 shdocvw.dll            6.0.2900.6003    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

10 Reply by johnvanbreda

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

Re: Error on import

Hi Louise
As noted in the email I just sent you, please send me a copy of the import file to test.
Thanks

John van Breda
Biodiverse IT

johnvanbreda's Website

11 Reply by johnvanbreda

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

Re: Error on import

Hi Louise,
Not sure if my email reached you - it bounced back. Can you use the link on the left to email me so I can let you know where to send the file to please.

John van Breda
Biodiverse IT

johnvanbreda's Website

12 Reply by johnvanbreda

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

Re: Error on import

Hi Louise,
Thanks for sending me the file to try. I can confirm that this file imports OK in my latest code, and that I have recently fixed an import problem relating to non-numeric columns in the import of abundance data. In your case I think the presence of * in abundance is causing the problem.

The issue will be fixed in the next release of Recorder.

Best wishes

John van Breda
Biodiverse IT

johnvanbreda's Website

13 Reply by Ian M Spence

  • Ian M Spence
  • Veteran
  • Offline
  • From: North east Wales
  • Registered: 30-06-2006
  • Posts: 193

Re: Error on import

Hi

Apologies for John for me not writing this much sooner after the help he gave to install the code in a message, above, that seems to have overcome my problem with importing data. The New Year is a key time for importing records from observers and I hope the new code will pass that test with flying colours! Many thanks for your help, John.

All the best, Ian