Re: Import - Validate Colums
Another dataset this time 300,000 records. Had to leave it running late on Friday. 46 minutes later I have an exception, see below. It did find 380 errors.
date/time : 2010-07-16, 16:45:17, 981ms
computer name : SERC-TONY
user name : tony.price
operating system : Windows XP Service Pack 3 build 2600
system language : English
system up time : 3 hours 34 minutes
program up time : 46 minutes 58 seconds
processors : 2x AMD Athlon(tm) 7750 Dual-Core Processor
physical memory : 1299/1919 MB (free/total)
free disk space : (C:) 175.29 GB (U:) 35.40 GB
display mode : 1280x1024, 32 bit
process id : $718
allocated memory : 260.48 MB
command line : RecorderApp.exe /525826
executable : RecorderApp.exe
exec. date/time : 2009-11-23 09:25
version : 6.14.5.218
madExcept version : 2.7h
exception class : ERangeError
exception message : Range check error.
main thread ($d30):
009395b3 RecorderApp.exe
7e42a993 user32.dll CallWindowProcA
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
02d60000 SQLOLEDB.RLL 2000.85.1132.0 C:\Program Files\Common Files\System\Ole DB
036f0000 msadcer.dll 2.81.1132.0 C:\Program Files\Common Files\System\msadc
03970000 StdValLib.dll 6.14.3.208 U:\Addins
03f80000 Normaliz.dll 6.0.5441.0 C:\WINDOWS\system32
043d0000 msdasql.dll 2.81.1132.0 C:\Program Files\Common Files\System\Ole DB
04630000 MSDASQLR.DLL 2.81.1132.0 C:\Program Files\Common Files\System\Ole DB
07160000 Audiodev.dll 5.2.5721.5145 C:\WINDOWS\system32
0f9a0000 VBAJET32.DLL 6.0.1.9432 C:\WINDOWS\system32
0f9c0000 expsrv.dll 6.0.72.9590 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
1b000000 msjet40.dll 4.0.9511.0 C:\WINDOWS\system32
1b2c0000 msjter40.dll 4.0.9502.0 C:\WINDOWS\system32
1b2d0000 MSJINT40.DLL 4.0.9502.0 C:\WINDOWS\system32
1b570000 msjetoledb40.dll 4.0.9502.0 C:\WINDOWS\system32
1b5d0000 mswstr10.dll 4.0.9502.0 C:\WINDOWS\system32
1b800000 msjtes40.dll 4.0.9502.0 C:\WINDOWS\system32
20000000 xpsp3res.dll 5.1.2600.5512 C:\WINDOWS\system32
3d930000 WININET.dll 8.0.6001.18923 C:\WINDOWS\system32
3dfd0000 iertutil.dll 8.0.6001.18923 C:\WINDOWS\system32
4ca30000 msadrh15.dll 2.81.1132.0 C:\Program Files\Common Files\System\ado
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.5512 C:\WINDOWS\system32
5edd0000 olepro32.dll 5.1.2600.5512 C:\WINDOWS\system32
605d0000 mslbui.dll 5.1.2600.5512 C:\WINDOWS\system32
60e30000 MSDATL3.dll 2.81.1132.0 C:\Program Files\Common Files\System\Ole DB
662b0000 hnetcfg.dll 5.1.2600.5512 C:\WINDOWS\system32
68000000 rsaenh.dll 5.1.2600.5507 C:\WINDOWS\system32
68100000 dssenh.dll 5.1.2600.5507 C:\WINDOWS\system32
69b10000 msxml4.dll 4.20.9876.0 c:\WINDOWS\system32
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
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
750b0000 RESUTILS.DLL 5.1.2600.5512 C:\WINDOWS\system32
750f0000 MTXCLU.DLL 2001.12.4414.706 C:\WINDOWS\system32
75130000 colbact.DLL 2001.12.4414.700 C:\WINDOWS\system32
75350000 OLEDB32R.DLL 2.81.1132.0 C:\Program Files\Common Files\System\Ole DB
754d0000 CRYPTUI.dll 5.131.2600.5512 C:\WINDOWS\system32
755c0000 msctfime.ime 5.1.2600.5512 C:\WINDOWS\system32
75f60000 drprov.dll 5.1.2600.5512 C:\WINDOWS\System32
75f70000 davclnt.dll 5.1.2600.5512 C:\WINDOWS\System32
75f80000 browseui.dll 6.0.2900.5512 C:\WINDOWS\system32
76390000 IMM32.DLL 5.1.2600.5512 C:\WINDOWS\system32
763b0000 comdlg32.dll 6.0.2900.5512 C:\WINDOWS\system32
765b0000 MSDART.DLL 2.81.1132.0 C:\WINDOWS\system32
76600000 CSCDLL.dll 5.1.2600.5512 C:\WINDOWS\System32
76620000 comsvcs.dll 2001.12.4414.702 C:\WINDOWS\system32
76780000 SHFolder.dll 6.0.2900.5512 C:\WINDOWS\system32
76790000 cryptdll.dll 5.1.2600.5512 C:\WINDOWS\system32
767a0000 ntdsapi.dll 5.1.2600.5512 C:\WINDOWS\system32
767f0000 schannel.dll 5.1.2600.5834 C:\WINDOWS\system32
76990000 ntshrui.dll 5.1.2600.5512 C:\WINDOWS\system32
769c0000 USERENV.dll 5.1.2600.5512 C:\WINDOWS\system32
76b20000 ATL.DLL 3.5.2284.2 C:\WINDOWS\system32
76b40000 winmm.dll 5.1.2600.5512 C:\WINDOWS\system32
76c30000 WINTRUST.dll 5.131.2600.5922 C:\WINDOWS\system32
76c90000 IMAGEHLP.dll 5.1.2600.5512 C:\WINDOWS\system32
76d10000 CLUSAPI.DLL 5.1.2600.5512 C:\WINDOWS\system32
76d60000 iphlpapi.dll 5.1.2600.5512 C:\WINDOWS\system32
76f20000 DNSAPI.dll 5.1.2600.5625 C:\WINDOWS\system32
76f60000 WLDAP32.dll 5.1.2600.5512 C:\WINDOWS\system32
76fb0000 winrnr.dll 5.1.2600.5512 C:\WINDOWS\System32
76fc0000 rasadhlp.dll 5.1.2600.5512 C:\WINDOWS\system32
76fd0000 CLBCATQ.DLL 2001.12.4414.700 C:\WINDOWS\system32
77050000 COMRes.dll 2001.12.4414.700 C:\WINDOWS\system32
77120000 oleaut32.dll 5.1.2600.5512 C:\WINDOWS\system32
773d0000 comctl32.dll 6.0.2900.5512 C:\WINDOWS\WinSxS\x86_Microsoft.Windows.Common-Controls_6595b64144ccf1df_6.0.2600.5512_x-ww_35d4ce83
774e0000 ole32.dll 5.1.2600.5512 C:\WINDOWS\system32
77920000 SETUPAPI.dll 5.1.2600.5512 C:\WINDOWS\system32
77a20000 cscui.dll 5.1.2600.5512 C:\WINDOWS\System32
77a80000 crypt32.dll 5.131.2600.5512 C:\WINDOWS\system32
77b20000 MSASN1.dll 5.1.2600.5875 C:\WINDOWS\system32
77b40000 apphelp.dll 5.1.2600.5512 C:\WINDOWS\system32
77c00000 version.dll 5.1.2600.5512 C:\WINDOWS\system32
77c10000 msvcrt.dll 7.0.2600.5512 C:\WINDOWS\system32
77c70000 msv1_0.dll 5.1.2600.5876 C:\WINDOWS\system32
77dd0000 advapi32.dll 5.1.2600.5755 C:\WINDOWS\system32
77e70000 RPCRT4.dll 5.1.2600.5795 C:\WINDOWS\system32
77f10000 GDI32.dll 5.1.2600.5698 C:\WINDOWS\system32
77f60000 SHLWAPI.dll 6.0.2900.5912 C:\WINDOWS\system32
77fe0000 Secur32.dll 5.1.2600.5834 C:\WINDOWS\system32
78130000 urlmon.dll 8.0.6001.18923 C:\WINDOWS\system32
7c800000 kernel32.dll 5.1.2600.5781 C:\WINDOWS\system32
7c900000 ntdll.dll 5.1.2600.5755 C:\WINDOWS\system32
7c9c0000 shell32.dll 6.0.2900.5622 C:\WINDOWS\system32
7e290000 shdocvw.dll 6.0.2900.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
Somerset Environmental Records Centre