1 Reply by Ian M Spence

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

Re: Error with locations on import

Hi

I have upgraded to Win 7 - the process went well but took 3hrs 20 min on this laptop. I have been using R6.14.4.212 and imports have generally worked well. However, I have now had four instances of files failing at the part of the import wizard where the locations and grid references are checked. There is an unhandled error and the following message is created:

date/time         : 2009-12-21, 19:18:57, 414ms
computer name     : CBRG-ATLAS
user name         : Ian
operating system  : Windows NT New build 7600
system language   : English
system up time    : 4 hours 4 minutes
program up time   : 29 minutes 47 seconds
processors        : 2x Intel(R) Core(TM)2 Duo CPU     T5800  @ 2.00GHz
physical memory   : 613/2043 MB (free/total)
free disk space   : (C:) 99.97 GB
display mode      : 1280x800, 32 bit
process id        : $f04
allocated memory  : 59.33 MB
command line      : RecorderApp.exe /1835716
executable        : RecorderApp.exe
exec. date/time   : 2009-08-05 12:49
version           : 6.14.4.212
madExcept version : 2.7k
exception class   : EOleException
exception message : Warning: A domain error occurred.

main thread ($f90):
00562202 RecorderApp.exe 
776328c3 ntdll.dll        RtlAnsiStringToUnicodeString
76e07690 user32.dll       SendMessageW
76e241f4 user32.dll       CallWindowProcA
76e03573 user32.dll       DispatchMessageA
771d1172 kernel32.dll     BaseThreadInitThunk

thread $49c:
776264f4 ntdll.dll       KiFastSystemCallRet
77625e4a ntdll.dll       NtWaitForMultipleObjects
759b686c KERNELBASE.dll  WaitForMultipleObjectsEx
771cf125 kernel32.dll    WaitForMultipleObjectsEx
76e090b8 user32.dll      MsgWaitForMultipleObjectsEx
76e059f9 user32.dll      MsgWaitForMultipleObjects
771d1172 kernel32.dll    BaseThreadInitThunk
>> created by main thread ($f90) at:
743b78b3 gdiplus.dll     

thread $e24:
776264f4 ntdll.dll     KiFastSystemCallRet
77625e4a ntdll.dll     NtWaitForMultipleObjects
771d1172 kernel32.dll  BaseThreadInitThunk

thread $888:
776264f4 ntdll.dll     KiFastSystemCallRet
77625e4a ntdll.dll     NtWaitForMultipleObjects
771d1172 kernel32.dll  BaseThreadInitThunk

thread $760:
776264f4 ntdll.dll       KiFastSystemCallRet
77625e6a ntdll.dll       NtWaitForSingleObject
759b1796 KERNELBASE.dll  WaitForSingleObjectEx
771ceffe kernel32.dll    WaitForSingleObjectEx
771cefad kernel32.dll    WaitForSingleObject
771d1172 kernel32.dll    BaseThreadInitThunk

thread $9d4:
776264f4 ntdll.dll       KiFastSystemCallRet
77624c1a ntdll.dll       NtDelayExecution
759b1870 KERNELBASE.dll  SleepEx
759b1813 KERNELBASE.dll  Sleep
771d1172 kernel32.dll    BaseThreadInitThunk
>> created by thread $b00 at:
774b642e ole32.dll       

thread $de0:
776264f4 ntdll.dll     KiFastSystemCallRet
77625e7a ntdll.dll     NtWaitForWorkViaWorkerFactory
771d1172 kernel32.dll  BaseThreadInitThunk

thread $dd8:
776264f4 ntdll.dll     KiFastSystemCallRet
77625e7a ntdll.dll     NtWaitForWorkViaWorkerFactory
771d1172 kernel32.dll  BaseThreadInitThunk

thread $dd0:
776264f4 ntdll.dll     KiFastSystemCallRet
77625e7a ntdll.dll     NtWaitForWorkViaWorkerFactory
771d1172 kernel32.dll  BaseThreadInitThunk

thread $d14:
776264f4 ntdll.dll     KiFastSystemCallRet
77625e7a ntdll.dll     NtWaitForWorkViaWorkerFactory
771d1172 kernel32.dll  BaseThreadInitThunk

thread $dc4:
776264f4 ntdll.dll     KiFastSystemCallRet
77625e7a ntdll.dll     NtWaitForWorkViaWorkerFactory
771d1172 kernel32.dll  BaseThreadInitThunk

thread $9bc:
776264f4 ntdll.dll     KiFastSystemCallRet
77625e7a ntdll.dll     NtWaitForWorkViaWorkerFactory
771d1172 kernel32.dll  BaseThreadInitThunk

thread $630:
776264f4 ntdll.dll     KiFastSystemCallRet
77625e7a ntdll.dll     NtWaitForWorkViaWorkerFactory
771d1172 kernel32.dll  BaseThreadInitThunk

thread $a70:
776264f4 ntdll.dll     KiFastSystemCallRet
77625e7a ntdll.dll     NtWaitForWorkViaWorkerFactory
771d1172 kernel32.dll  BaseThreadInitThunk

modules:
001d0000 C4DLL.DLL            1.0.0.1            C:\Recorder 6
00240000 MS5User.Dll          5.0.0.4            C:\Recorder 6
00390000 ms5cnv.dll           5.0.0.10           C:\Recorder 6
00400000 RecorderApp.exe      6.14.4.212         C:\Recorder 6
01ff0000 dadkeyb.dll          9.2.6.0            C:\Program Files\Dell\QuickSet
039b0000 DropboxExt.3.dll     1.0.0.3            C:\Users\Ian\AppData\Roaming\Dropbox\bin
05f90000 SHOWUN~1.OCX         6.0.0.13           C:\RECORD~1\Addins
06240000 STDVAL~1.DLL         6.14.3.208         C:\RECORD~1\Addins
06420000 SURVEY~1.OCX         6.0.0.29           C:\RECORD~1\Addins
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:\Recorder 6
66ac0000 msjet40.dll          4.0.9756.0         C:\Windows\system32
66ff0000 SearchFolder.dll     6.1.7600.16385     C:\Windows\system32
67090000 ieproxy.dll          8.0.7600.16385     C:\Program Files\Internet Explorer
67680000 sqloledb.dll         6.1.7600.16385     C:\Program Files\Common Files\System\Ole DB
67770000 comsvcs.dll          2001.12.8530.16385 C:\Windows\system32
679c0000 oledb32.dll          6.1.7600.16385     C:\Program Files\Common Files\System\Ole DB
67dd0000 msjtes40.dll         4.0.9756.0         C:\Windows\system32
67e20000 mswstr10.dll         4.0.9756.0         C:\Windows\system32
67ec0000 msjetoledb40.dll     4.0.9756.0         C:\Windows\system32
67f20000 msadox.dll           6.1.7600.16385     C:\Program Files\Common Files\System\ado
67fa0000 msadce.dll           6.1.7600.16385     C:\Program Files\Common Files\System\msadc
682c0000 msado15.dll          6.1.7600.16385     C:\Program Files\Common Files\System\ado
683c0000 HHCtrl.ocx           6.1.7600.16385     C:\Windows\system32
684d0000 StructuredQuery.dll  7.0.7600.16385     C:\Windows\System32
68700000 odbccp32.dll         6.1.7600.16385     C:\Windows\system32
6b600000 msxml3.dll           8.110.7600.16385   C:\Windows\System32
6bc50000 DBNETLIB.DLL         6.1.7600.16385     C:\Windows\system32
6bf50000 odbcint.dll          6.1.7600.16385     C:\Windows\system32
6c010000 odbc32.dll           6.1.7600.16385     C:\Windows\system32
6c420000 tiptsf.dll           6.1.7600.16385     C:\Program Files\Common Files\microsoft shared\ink
6c550000 shdocvw.dll          6.1.7600.16385     C:\Windows\System32
6c750000 actxprxy.dll         6.1.7600.16385     C:\Windows\system32
6c900000 ntshrui.dll          6.1.7600.16385     C:\Windows\system32
6c9b0000 EhStorShell.dll      6.1.7600.16385     C:\Windows\system32
6d050000 winspool.drv         6.1.7600.16385     C:\Windows\system32
6d910000 mpr.dll              6.1.7600.16385     C:\Windows\system32
6de00000 security.dll         6.1.7600.16385     C:\Windows\system32
6e0f0000 msader15.dll         6.1.7600.16385     C:\Program Files\Common Files\System\ado
6e1f0000 msadrh15.dll         6.1.7600.16385     C:\Program Files\Common Files\System\ado
6e210000 msjter40.dll         4.0.9756.0         C:\Windows\system32
70430000 wsock32.dll          6.1.7600.16385     C:\Windows\system32
706a0000 ntdsapi.dll          6.1.7600.16385     C:\Windows\system32
70f00000 cscapi.dll           6.1.7600.16385     C:\Windows\system32
71ff0000 SQLOLEDB.RLL         6.1.7600.16385     C:\Program Files\Common Files\System\Ole DB
72000000 msadcer.dll          6.1.7600.16385     C:\Program Files\Common Files\System\msadc
721c0000 ieframe.DLL          8.0.7600.16385     C:\Windows\system32
73460000 OLEDB32R.DLL         6.1.7600.16385     C:\Program Files\Common Files\System\Ole DB
73480000 MSDATL3.dll          6.1.7600.16385     C:\Program Files\Common Files\System\Ole DB
736a0000 MSDART.DLL           6.1.7600.16385     C:\Windows\system32
736c0000 thumbcache.dll       6.1.7600.16385     C:\Windows\system32
73730000 netbios.dll          6.1.7600.16385     C:\Windows\system32
73830000 MSJINT40.DLL         4.0.9756.0         C:\Windows\system32
738a0000 olepro32.dll         6.1.7600.16385     C:\Windows\system32
73980000 slc.dll              6.1.7600.16385     C:\Windows\system32
739a0000 ATL.DLL              3.5.2284.0         C:\Windows\system32
73a40000 SHFolder.dll         6.1.7600.16385     C:\Windows\system32
73af0000 ntmarta.dll          6.1.7600.16385     C:\Windows\system32
73bd0000 winmm.dll            6.1.7600.16385     C:\Windows\system32
73d30000 OLEACC.dll           7.0.0.0            C:\Windows\system32
73ea0000 samcli.dll           6.1.7600.16385     C:\Windows\system32
73eb0000 wkscli.dll           6.1.7600.16385     C:\Windows\system32
73ee0000 netutils.dll         6.1.7600.16385     C:\Windows\system32
73ef0000 NETAPI32.dll         6.1.7600.16385     C:\Windows\system32
74000000 DBnmpNTw.dll         6.1.7600.16385     C:\Windows\system32
740a0000 WindowsCodecs.dll    6.1.7600.16385     C:\Windows\system32
741d0000 dwmapi.dll           6.1.7600.16385     C:\Windows\system32
74370000 gdiplus.dll          6.1.7600.16385     C:\Windows\WinSxS\x86_microsoft.windows.gdiplus_6595b64144ccf1df_1.1.7600.16385_none_72fc7cbf861225ca
74500000 uxtheme.dll          6.1.7600.16385     C:\Windows\system32
74540000 propsys.dll          7.0.7600.16385     C:\Windows\system32
74640000 SAMLIB.dll           6.1.7600.16385     C:\Windows\system32
74680000 Comctl32.dll         6.10.7600.16385    C:\Windows\WinSxS\x86_microsoft.windows.common-controls_6595b64144ccf1df_6.0.7600.16385_none_421189da2b7fabfc
74bf0000 version.dll          6.1.7600.16385     C:\Windows\system32
74e80000 credssp.dll          6.1.7600.16385     C:\Windows\system32
74ec0000 bcryptprimitives.dll 6.1.7600.16385     C:\Windows\system32
74f80000 rsaenh.dll           6.1.7600.16385     C:\Windows\system32
74ff0000 schannel.DLL         6.1.7600.16385     C:\Windows\system32
75140000 msv1_0.DLL           6.1.7600.16420     C:\Windows\system32
751e0000 CRYPTSP.dll          6.1.7600.16385     C:\Windows\system32
752f0000 bcrypt.dll           6.1.7600.16385     C:\Windows\system32
75310000 ncrypt.dll           6.1.7600.16385     C:\Windows\system32
753d0000 cryptdll.dll         6.1.7600.16385     C:\Windows\system32
755b0000 srvcli.dll           6.1.7600.16385     C:\Windows\system32
75620000 SECUR32.DLL          6.1.7600.16385     C:\Windows\system32
75640000 SSPICLI.DLL          6.1.7600.16385     C:\Windows\system32
75660000 apphelp.dll          6.1.7600.16385     C:\Windows\system32
756b0000 CRYPTBASE.dll        6.1.7600.16385     C:\Windows\system32
756c0000 SXS.DLL              6.1.7600.16385     C:\Windows\system32
75720000 RpcRtRemote.dll      6.1.7600.16385     C:\Windows\system32
75730000 profapi.dll          6.1.7600.16385     C:\Windows\system32
757a0000 MSASN1.dll           6.1.7600.16415     C:\Windows\system32
757b0000 DEVOBJ.dll           6.1.7600.16385     C:\Windows\system32
757d0000 CFGMGR32.dll         6.1.7600.16385     C:\Windows\system32
75800000 CRYPT32.dll          6.1.7600.16385     C:\Windows\system32
75920000 comctl32.dll         5.82.7600.16385    C:\Windows\WinSxS\x86_microsoft.windows.common-controls_6595b64144ccf1df_5.82.7600.16385_none_ebf82fc36c758ad5
759b0000 KERNELBASE.dll       6.1.7600.16385     C:\Windows\system32
75a30000 advapi32.dll         6.1.7600.16385     C:\Windows\system32
75ad0000 LPK.dll              6.1.7600.16385     C:\Windows\system32
75ae0000 iertutil.dll         8.0.7600.16385     C:\Windows\system32
75e20000 shell32.dll          6.1.7600.16385     C:\Windows\system32
76a70000 WS2_32.dll           6.1.7600.16385     C:\Windows\system32
76ab0000 PSAPI.DLL            6.1.7600.16385     C:\Windows\system32
76ac0000 sechost.dll          6.1.7600.16385     C:\Windows\SYSTEM32
76ae0000 WLDAP32.dll          6.1.7600.16385     C:\Windows\system32
76b30000 SHLWAPI.dll          6.1.7600.16385     C:\Windows\system32
76b90000 USP10.dll            1.626.7600.16385   C:\Windows\system32
76c30000 RPCRT4.dll           6.1.7600.16385     C:\Windows\system32
76ce0000 GDI32.dll            6.1.7600.16385     C:\Windows\system32
76d60000 CLBCatQ.DLL          2001.12.8530.16385 C:\Windows\system32
76df0000 user32.dll           6.1.7600.16385     C:\Windows\system32
76f20000 oleaut32.dll         6.1.7600.16385     C:\Windows\system32
76fb0000 MSCTF.dll            6.1.7600.16385     C:\Windows\system32
77180000 kernel32.dll         6.1.7600.16385     C:\Windows\system32
77260000 comdlg32.dll         6.1.7600.16385     C:\Windows\system32
772e0000 SETUPAPI.dll         6.1.7600.16385     C:\Windows\system32
77480000 ole32.dll            6.1.7600.16385     C:\Windows\system32
775e0000 ntdll.dll            6.1.7600.16385     C:\Windows\SYSTEM32
77720000 IMM32.DLL            6.1.7600.16385     C:\Windows\system32
77740000 NSI.dll              6.1.7600.16385     C:\Windows\system32
77760000 msvcrt.dll           7.0.7600.16385     C:\Windows\system32
7c340000 MSVCR71.dll          7.10.3052.4        C:\Users\Ian\AppData\Roaming\Dropbox\bin
7c3a0000 MSVCP71.dll          7.10.3077.0        C:\Users\Ian\AppData\Roaming\Dropbox\bin

When the error first happened, I could not understand it as the file with the error had been created in Excel in exactly the same way as many other files that were imported successfully. I split the file in half, and imported one half without a problem and the other wouldn't import - same error. I repeated this until each half file was about 20 records and then both files imported correctly, so there appeared to be no error at all. This process of halving files is not very helpful as it takes ages. I don't understand the message, above, but are there any clues therein?

I look forward to hearing a helpful message and wish all users a Merry Christmas.

Cheers, Ian

2 Reply by johnvanbreda

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

Re: Error with locations on import

Hi Ian,
I think this error occurs when you get some sort of mathematical processing error in SQL Server. Is it possible to supply the smallest example file which reproduces the error for us to try importing? If it is a reproducable error then it will be much easier to find the fix.

Best wishes

John van Breda
Biodiverse IT

johnvanbreda's Website

3 Reply by Ian M Spence

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

Re: Error with locations on import

Hi John

The difficulty is not ever finding an error. I have just been doing some importing and had to whittle down to files of just 22 records (ie a file with c 44 records produced the error). I have some more to tackle so will send you a file when it gets to about 100 records.

Cheers, Ian