1 Reply by TonyP (edited by TonyP 08-12-2010 14:34:30)

  • TonyP
  • TonyP
  • Veteran
  • Offline
  • From: Somerset
  • Registered: 15-05-2006
  • Posts: 306

Re: Wizard Failed ?

Well after 2 days of re-importing I pressed 'Do Import', it whirred for an hour or two got right to the end and Exception;


date/time         : 2010-12-08, 11:44:10, 906ms
user name         : Administrator
operating system  : Windows XP Service Pack 3 build 2600
system language   : English
system up time    : 2 days
program up time   : 1 day 23 hours
processor         : Intel(R) Celeron(R) CPU 2.66GHz
physical memory   : 1066/1983 MB (free/total)
free disk space   : (C:) 3.36 GB (U:) 137.31 GB
display mode      : 1280x1024, 32 bit
process id        : $2b0
allocated memory  : 482.93 MB
command line      : RecorderApp.exe /65898
executable        : RecorderApp.exe
exec. date/time   : 2009-11-23 08:25
version           : 6.14.5.218
madExcept version : 2.7h
exception class   : EDBMergerError
exception message : Error occurred transferring records for SQLSERVER_SAMPLE_RECORDER into the main database.

main thread ($98c):
0072d13f RecorderApp.exe 
7c90e485 ntdll.dll        KiUserExceptionDispatcher
771248b0 oleaut32.dll     SysFreeString
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:
012f0000 ms5cnv.dll        5.0.0.10         U:
01be0000 odbcint.dll       3.525.1132.0     C:\WINDOWS\system32
01c00000 LVPrcInj.dll      9.5.0.1098       C:\Program Files\Common Files\Logitech\LVMVFM
02310000 msjter40.dll      4.0.9502.0       C:\WINDOWS\system32
023c0000 MSJINT40.DLL      4.0.9502.0       C:\WINDOWS\system32
02950000 xpsp2res.dll      5.1.2600.5512    C:\WINDOWS\system32
031c0000 msader15.dll      2.81.1132.0      C:\Program Files\Common Files\System\ado
03600000 SQLOLEDB.RLL      2000.85.1132.0   C:\Program Files\Common Files\System\Ole DB
03610000 msadcer.dll       2.81.1132.0      C:\Program Files\Common Files\System\msadc
03940000 ShowUnchecked.ocx 6.0.0.13         U:\Addins
03ba0000 StdValLib.dll     6.14.3.208       U:\Addins
04310000 Normaliz.dll      6.0.5441.0       C:\WINDOWS\system32
04430000 msjetoledb40.dll  4.0.9502.0       C:\WINDOWS\system32
04490000 mswstr10.dll      4.0.9502.0       C:\WINDOWS\system32
04660000 msjtes40.dll      4.0.9502.0       C:\WINDOWS\system32
046c0000 sqlsrv32.rll      2000.85.1132.0   C:\WINDOWS\system32
054c0000 msjet40.dll       4.0.9511.0       C:\WINDOWS\system32
070d0000 WMASF.DLL         10.0.0.4060      C:\WINDOWS\system32
086c0000 WMVCore.DLL       10.0.0.3706      C:\WINDOWS\system32
092d0000 Audiodev.dll      5.2.3790.3646    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:
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
4ca30000 msadrh15.dll      2.81.1132.0      C:\Program Files\Common Files\System\ado
4d650000 msadox.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
4e530000 SQLSRV32.dll      2000.85.1132.0   C:\WINDOWS\system32
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
5c1b0000 SQLUNIRL.dll      2000.80.728.0    C:\WINDOWS\system32
5d090000 comctl32.dll      5.82.2900.6028   C:\WINDOWS\system32
5edd0000 olepro32.dll      5.1.2600.5512    C:\WINDOWS\system32
5f0e0000 nwprovau.dll      5.1.2600.5512    C:\WINDOWS\System32
5fe80000 odbccp32.dll      3.525.1132.0     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
751d0000 wshbth.dll        5.1.2600.5512    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
75940000 NDDEAPI.DLL       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

Exception Stack

----------------
EOleException : System resource exceeded

Does anyone know why this happened and why after it had apparently completed the import and lastly what didn't happen?

Thanks

Data Manger
Somerset Environmental Records Centre

TonyP's Website

2 Reply by TonyP

  • TonyP
  • TonyP
  • Veteran
  • Offline
  • From: Somerset
  • Registered: 15-05-2006
  • Posts: 306

Re: Wizard Failed ?

Well I have the same error again. I never got to the bottom of it before. This would appear to be a new dataset. The system crashed at the validation stage of the import.
A stage I still don't understand the meaning of as I thought that was the whole point of the 6 days of working with the wizard I had just put in.

I can't post the last error as it has been overwritten by another error from another R6 client failure, even less meaningfull.

madExcept version : 2.7h
exception class   : EAccessViolation
exception message : Access violation at address 00000014. Read of address 00000014.

main thread ($f04):
00000014 ???         
7e4196c2 user32.dll  DispatchMessageA

It was just sat waiting for some more location decisions to be made. I could believe that things such as backups may cause such errors but since it happens every night and I have been leaving my PC running for days at a time I don't think so.

So does anyone know why a string translation error from ansi to unicode in data that has been validated needs to cause such an error?

Please!

Data Manger
Somerset Environmental Records Centre

TonyP's Website

3 Reply by Luck

  • Luck
  • Veteran
  • Offline
  • From: Cheshire
  • Registered: 14-08-2007
  • Posts: 100

Re: Wizard Failed ?

Hello Tony,

Is it a spreadsheet that you tried to import? If so have you tried to split it into smaller chunk?

Luck

IT Officer
rECOrd (A Biodiversity Information System for Cheshire, Halton, Warrington and Wirral)
www.record-lrc.co.uk

Luck's Website

4 Reply by BDeed

  • BDeed
  • Veteran
  • Offline
  • From: Bolton
  • Registered: 01-03-2011
  • Posts: 451

Re: Wizard Failed ?

Sorry to revive an old thread but i have been having a similar problem to the "EAccessViolation" (second post) that seems to match this with the import wizard crashing while importing with the following Error:

operating system  : Windows XP Service Pack 3 build 2600
physical memory   : 1831/3319 MB (free/total)
process id        : $b40
allocated memory  : 32.42 MB
version           : 6.16.2.241
madExcept version : 2.7k
exception class   : EAccessViolation
exception message : Access violation at address D0CF0202. Read of address D0CF0202.

I have had a similar problem several times in the past, on checking the records this time they appear to have all gone through (even though the wizard crashed and was cancelled), and have exported in our standard format fine. However in the past records have only been partially imported, e.g. Taxon has been missing from the records.

Luckily so far this has only happened with small Surveys and imports.

Natural History & Biodiversity Data Enthusiast