1 (edited by TonyP 14-02-2011 14:06:36)

Re: Import Wizard - Location

I have a problem in the import location dialog. I have a location called "0" with three grid refs associated with it. These grids are up to 10km apart and the location name "0" does not exist in the dataset.

The only common factor I could see was that some of the data associated with each grid had a  location name which was a grid. As each of these starts with two letters [SS] I could not see why this might happen.

Anyone got any ideas?

I don't think it liked it, whatever the reason. On pressing next I got a warning about an unresolved 'nest' but before I could press anything there was an exception. The gist of which is;

date/time         : 2011-02-14, 13:52:37, 79ms
computer name     : SERC-TONY
user name         : Tony.Price
operating system  : Windows XP Service Pack 3 build 2600
system language   : English
system up time    : 4 days 4 hours
program up time   : 5 hours 5 minutes
processors        : 2x AMD Athlon(tm) 7750 Dual-Core Processor
physical memory   : 748/1919 MB (free/total)
free disk space   : (C:) 130.43 GB (U:) 122.48 GB
display mode      : 1280x1024, 32 bit
process id        : $b4c
allocated memory  : 251.62 MB
command line      : RecorderApp.exe /197486
executable        : RecorderApp.exe
exec. date/time   : 2010-07-22 16:40
version           : 6.15.4.238
madExcept version : 2.7h
exception class   : EListError
exception message : List index out of bounds (1).

main thread ($b10):
004465e9 RecorderApp.exe Classes                 TList.Get
00447d0b RecorderApp.exe Classes                 TCollection.GetItem
005d49f2 RecorderApp.exe DBGrids        1819  +1 TDBGridColumns.GetColumn
00985339 RecorderApp.exe MatchLocations  787  +5 TfraMatchLocations.sgSurrogateMatchDrawCell
005011f7 RecorderApp.exe Grids                   TCustomDrawGrid.DrawCell
005024c5 RecorderApp.exe Grids                   TStringGrid.DrawCell
004fc750 RecorderApp.exe Grids                   DrawCells
004fcc82 RecorderApp.exe Grids                   TCustomGrid.Paint

The error was not recoverable from. Another 5 hours lost.

Tony

Data Manger
Somerset Environmental Records Centre

2

Re: Import Wizard - Location

Well I went through the whole process again over the last day and got to the point of the '0' location. I created a bogus location to assign the information to and checked the assign remaining to locations [in this case that is all but the strange '0' location].

date/time         : 2011-02-15, 12:49:12, 472ms
computer name     : SERC-TONY
user name         : Tony.Price
operating system  : Windows XP Service Pack 3 build 2600
system language   : English
system up time    : 22 hours 4 minutes
program up time   : 21 hours 54 minutes
processors        : 2x AMD Athlon(tm) 7750 Dual-Core Processor
physical memory   : 582/1919 MB (free/total)
free disk space   : (C:) 129.06 GB (U:) 120.42 GB
display mode      : 1280x1024, 32 bit
process id        : $a4c
allocated memory  : 260.57 MB
command line      : RecorderApp.exe /66878
executable        : RecorderApp.exe
exec. date/time   : 2010-07-22 16:40
version           : 6.15.4.238
madExcept version : 2.7h
exception class   : EAccessViolation
exception message : Access violation at address 0098510C in module 'RecorderApp.exe'. Read of address 00000038.

main thread ($cc8):
0098510c RecorderApp.exe MatchLocations  767  +1 DrawSortDirection
009854fe RecorderApp.exe MatchLocations  816 +34 TfraMatchLocations.sgSurrogateMatchDrawCell
005011f7 RecorderApp.exe Grids                   TCustomDrawGrid.DrawCell
005024c5 RecorderApp.exe Grids                   TStringGrid.DrawCell
004fc750 RecorderApp.exe Grids                   DrawCells
004fcc1a RecorderApp.exe Grids                   TCustomGrid.Paint
004d4093 RecorderApp.exe Controls                TCustomControl.PaintWindow
004cfe66 RecorderApp.exe Controls                TWinControl.PaintHandler
004d0333 RecorderApp.exe Controls                TWinControl.WMPaint
004d402c RecorderApp.exe Controls                TCustomControl.WMPaint
004ccc70 RecorderApp.exe Controls                TControl.WndProc
004cfccf RecorderApp.exe Controls                TWinControl.WndProc
004cf94c RecorderApp.exe Controls                TWinControl.MainWndProc
00453460 RecorderApp.exe Classes                 StdWndProc
7c90e470 ntdll.dll                               KiUserCallbackDispatcher
7e4196c2 user32.dll                              DispatchMessageA
00425c36 RecorderApp.exe madExcept               HandleException
00429afc RecorderApp.exe madExcept               InterceptAHandleExcept
004cf987 RecorderApp.exe Controls                TWinControl.MainWndProc
7c90e485 ntdll.dll                               KiUserExceptionDispatcher
00404973 RecorderApp.exe System                  @AfterConstruction
00433fd3 RecorderApp.exe SysUtils                Exception.CreateFmt
005011f7 RecorderApp.exe Grids                   TCustomDrawGrid.DrawCell
005024c5 RecorderApp.exe Grids                   TStringGrid.DrawCell
004fc750 RecorderApp.exe Grids                   DrawCells
004fcc82 RecorderApp.exe Grids                   TCustomGrid.Paint
004d4093 RecorderApp.exe Controls                TCustomControl.PaintWindow
004cfe66 RecorderApp.exe Controls                TWinControl.PaintHandler
004d0333 RecorderApp.exe Controls                TWinControl.WMPaint
004b76f0 RecorderApp.exe Forms                   TCustomForm.WMPaint
004ccc70 RecorderApp.exe Controls                TControl.WndProc
004cfccf RecorderApp.exe Controls                TWinControl.WndProc
004b5a8d RecorderApp.exe Forms                   TCustomForm.WndProc
004cf94c RecorderApp.exe Controls                TWinControl.MainWndProc
00453460 RecorderApp.exe Classes                 StdWndProc
7c90e470 ntdll.dll                               KiUserCallbackDispatcher
7e4196c2 user32.dll                              DispatchMessageA
004bc12b RecorderApp.exe Forms                   TApplication.ProcessMessage
004bc162 RecorderApp.exe Forms                   TApplication.HandleMessage
004b8c71 RecorderApp.exe Forms                   TCustomForm.ShowModal
00466270 RecorderApp.exe Dialogs                 MessageDlgPosHelp
004661c2 RecorderApp.exe Dialogs                 MessageDlg
0098ca9c RecorderApp.exe BaseMatchPage   329 +34 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
00963213 RecorderApp.exe IWBasePage      117  +4 TBasePage.Create
0098636f RecorderApp.exe MatchGeneric     63  +1 TfraMatchGeneric.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
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
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
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 $7c:
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 ($cc8) at:
4ec67b7f gdiplus.dll               

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

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

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

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

modules:
00350000 C4DLL.DLL         1.0.0.1          U:
003c0000 MS5User.Dll       5.0.0.4          U:
00400000 RecorderApp.exe   6.15.4.238       U:
01430000 ms5cnv.dll        5.0.0.10         U:
01bc0000 odbcint.dll       3.525.1132.0     C:\WINDOWS\system32
02a10000 xpsp2res.dll      5.1.2600.5512    C:\WINDOWS\system32
03820000 SQLOLEDB.RLL      2000.85.1132.0   C:\Program Files\Common Files\System\Ole DB
03830000 msadcer.dll       2.81.1132.0      C:\Program Files\Common Files\System\msadc
03b60000 ShowUnchecked.ocx 6.0.0.13         U:\Addins
03dc0000 StdValLib.dll     6.15.1.230       U:\Addins
04430000 Normaliz.dll      6.0.5441.0       C:\WINDOWS\system32
10000000 MS5.Dll           5.0.0.12         U:
16080000 mdnsNSP.dll       1.0.3.1          C:\Program Files\Bonjour
20000000 xpsp3res.dll      5.1.2600.5512    C:\WINDOWS\system32
3d930000 WININET.dll       8.0.6001.19019   C:\WINDOWS\system32
3dfd0000 iertutil.dll      8.0.6001.19019   C:\WINDOWS\system32
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.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.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
6bd00000 SYNCOR11.DLL      0.1.2.3          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.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.6006    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.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.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.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.19019   C:\WINDOWS\system32
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.5512    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

The above is the result with the complaint about 'Nest' having more than one possible match. I must assume it is the next dialog that is the problem unless you know different.

Any help would be most welcome. This is the last major dataset I have to import and it would be a great relief to get it in.

Thanks

Data Manger
Somerset Environmental Records Centre

3

Re: Import Wizard - Location

Hi Tony
Would you be able to email me a sample import file that reproduces this problem? I suspect the fix will be easy but only if I can reproduce it.
Cheers

John van Breda
Biodiverse IT

4

Re: Import Wizard - Location

Sure, thanks John, is it the '0' location in the sample or to do with the next dialog? Just so I get the right type of sample to you.

Tony

Data Manger
Somerset Environmental Records Centre

5

Re: Import Wizard - Location

Hi Tony
Its hard to know which part of the data causes it - send me the part of the import referring to the 0 location and I can at least try it.
Best Wishes

John van Breda
Biodiverse IT

6

Re: Import Wizard - Location

I've tried it on a sub-set and not seen the same issue. I will proceed therefore until I find a sub-set that does have the problem or I finish the import.

Data Manger
Somerset Environmental Records Centre