1

Re: Importing Anything - Crash Report

Well as you may remember a couple of months back I was not having any luck in importing data. I reformatted all the data to the limits of R6 import wizard and at that point my server died.

New Server: now running
A little refresher on importing a small dataset and due to some uncertainty of how imported data will actually appear [confidence not what it was] I thought I would import 2 records.

Crash: After assigning locations I press next, at the same time as a warning that Adult might be related to more than one item I got this error report: Perhaps 2 records are too much to cope with :)

date/time         : 2010-11-04, 10:39:56, 147ms
computer name     : SERC-TONY
user name         : Tony.Price
operating system  : Windows XP Service Pack 3 build 2600
system language   : English
system up time    : 43 minutes 18 seconds
program up time   : 2 minutes 25 seconds
processors        : 2x AMD Athlon(tm) 7750 Dual-Core Processor
physical memory   : 1130/1919 MB (free/total)
free disk space   : (C:) 142.90 GB (U:) 305.77 GB
display mode      : 1280x1024, 32 bit
process id        : $b40
allocated memory  : 23.16 MB
command line      : RecorderApp.exe /918498
executable        : RecorderApp.exe
exec. date/time   : 2009-11-23 08:25
version           : 6.14.5.218
madExcept version : 2.7h
exception class   : EAccessViolation
exception message : Access violation at address 0097F588 in module 'RecorderApp.exe'. Read of address 00000038.

main thread ($b58):
0097f588 RecorderApp.exe 
7c90e470 ntdll.dll        KiUserCallbackDispatcher
7e4196c2 user32.dll       DispatchMessageA
7c90e485 ntdll.dll        KiUserExceptionDispatcher
7c90e470 ntdll.dll        KiUserCallbackDispatcher
7e4196c2 user32.dll       DispatchMessageA
7c90eb94 ntdll.dll        RtlAnsiStringToUnicodeString
7e4292de user32.dll       SendMessageW
7e42a993 user32.dll       CallWindowProcA
7e4196c2 user32.dll       DispatchMessageA

modules:
00350000 C4DLL.DLL             1.0.0.1          U:
003c0000 MS5User.Dll           5.0.0.4          U:
00400000 RecorderApp.exe       6.14.5.218       U:
013c0000 ms5cnv.dll            5.0.0.10         U:
01b50000 odbcint.dll           3.525.1132.0     C:\WINDOWS\system32
029a0000 xpsp2res.dll          5.1.2600.5512    C:\WINDOWS\system32
037e0000 SQLOLEDB.RLL          2000.85.1132.0   C:\Program Files\Common Files\System\Ole DB
037f0000 msadcer.dll           2.81.1132.0      C:\Program Files\Common Files\System\msadc
04770000 Normaliz.dll          6.0.5441.0       C:\WINDOWS\system32
07160000 Audiodev.dll          5.2.5721.5145    C:\WINDOWS\system32
10000000 MS5.Dll               5.0.0.12         U:
10930000 PortableDeviceApi.dll 5.2.5721.5145    C:\WINDOWS\system32
11c70000 WMASF.DLL             11.0.5721.5238   C:\WINDOWS\system32
15110000 WMVCore.DLL           11.0.5721.5275   C:\WINDOWS\system32
16080000 mdnsNSP.dll           1.0.3.1          C:\Program Files\Bonjour
16210000 wpdshext.dll          5.2.5721.5145    C:\WINDOWS\system32
20000000 xpsp3res.dll          5.1.2600.5512    C:\WINDOWS\system32
3d930000 WININET.dll           8.0.6001.18968   C:\WINDOWS\system32
3dfd0000 iertutil.dll          8.0.6001.18968   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
593f0000 wiashext.dll          5.1.2600.5512    C:\WINDOWS\system32
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
73ba0000 sti.dll               5.1.2600.5512    C:\WINDOWS\system32
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
74ae0000 CFGMGR32.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.18968   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.6018    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

Data Manger
Somerset Environmental Records Centre

2

Re: Importing Anything - Crash Report

Let me have the file and I will investigate.

Mike

Mike Weideli

3

Re: Importing Anything - Crash Report

Thanks for the file. Unfortunately it imports for me with no issues. This means the problem is not with the data. I wonder if perhaps something has got out to step with the import wizard tables which store the matches. It might be an idea if you have a look at the content of the IW_Matched  tables  and delete anything in there which you have any doubt about. 

Mike

Mike Weideli

4

Re: Importing Anything - Crash Report

Thanks Mike, you were correct. This could have been the reason for all the failures I've had up to this point.

I decided that going through all the entries in the dbo.IW_xxx files was too time consuming. There were no obvious incorrect entries on a skim through. Why there would be is a mystery as the wizard created them. I removed all entries, after all it was only a few weeks work down the drain.

The result is that after several months of trying I have actually apparently imported some data. I say apparently as just because it says so doesn't mean it has.

I have already found that the first record I look at is not imported as I expected. Still any progress is welcome at this time.

Thanks again Mike!

Data Manger
Somerset Environmental Records Centre