1 Reply by cpanter

  • cpanter
  • Member
  • Offline
  • Registered: 15-03-2011
  • Posts: 8

Re: Wizard Import failed

I have been importing records happily for the last few months gradually building up my database, however i have now become stuck and can no longer enter any data - receiving the eroor message at the bottom.

I have been furiously trying different things the last few days, based on other comments on the forum with no success, so any thoughts would be great.

I am currently using a standalone copy of recorder, and the database has just gone over 2gb c.825,000 records.

(Please bear in mind i am a relative novice - i have used recorder for just over a year, but am mostly self taught)
thanks,
Chris

date/time         : 2011-03-15, 15:32:30, 359ms
computer name     : envcp9
user name         : wsd06vpu
operating system  : Windows XP Service Pack 2 build 2600
system language   : English
system up time    : 1 hour
program up time   : 1 minute 54 seconds
processors        : 2x Intel(R) Core(TM)2 Duo CPU     E7500  @ 2.93GHz
physical memory   : 945/1980 MB (free/total)
free disk space   : (C:) 255.11 GB
display mode      : 1280x1024, 32 bit
process id        : $e0c
allocated memory  : 24.04 MB
command line      : RecorderApp.exe /721522
executable        : RecorderApp.exe
exec. date/time   : 2011-01-18 14:50
version           : 6.16.2.241
madExcept version : 2.7k
exception class   : EDBMergerError
exception message : Error occurred transferring records for SQLSERVER_SURVEY_EVENT into the main database.

main thread ($bec):
0073438e RecorderApp.exe DBMerger        340 +42 TDBMerger.CopyTableIntoMainDB
7c90e485 ntdll.dll                               KiUserExceptionDispatcher
00407760 RecorderApp.exe System                  @IntfClear
7c90e485 ntdll.dll                               KiUserExceptionDispatcher
00404973 RecorderApp.exe System                  @AfterConstruction
004fd4f3 RecorderApp.exe ComObj                  EOleException.Create
00407871 RecorderApp.exe System                  @CheckAutoResult
00573f81 RecorderApp.exe ADODB                   TADOCommand.Execute
0057c337 RecorderApp.exe ADODB                   TADOQuery.ExecSQL
00734f85 RecorderApp.exe DBMerger        514 +29 TDBMerger.DoSQLInsertRecords
007342dc RecorderApp.exe DBMerger        328 +30 TDBMerger.CopyTableIntoMainDB
00733f89 RecorderApp.exe DBMerger        277 +35 TDBMerger.DoMerge
0073e28b RecorderApp.exe TempData_ADO   1332  +8 TTempData.CopyRecordsIntoMainDB
009837bb RecorderApp.exe ImportAnalysis  769  +6 TfraImportAnalysis.SaveContent
0097fd77 RecorderApp.exe ImportWizard    178  +8 TfrmImportWizard.btnNextClick
004b43c4 RecorderApp.exe Controls                TControl.Click
004a94cc RecorderApp.exe StdCtrls                TButton.Click
00470171 RecorderApp.exe Buttons                 TBitBtn.Click
004a95c0 RecorderApp.exe StdCtrls                TButton.CNCommand
004b422c RecorderApp.exe Controls                TControl.WndProc
004b728b RecorderApp.exe Controls                TWinControl.WndProc
004a9390 RecorderApp.exe StdCtrls                TButtonControl.WndProc
00724609 RecorderApp.exe XPMenu         2928 +10 TControlSubClass.ControlSubClass
7c90eb94 ntdll.dll                               RtlAnsiStringToUnicodeString
004b3ffc RecorderApp.exe Controls                TControl.Perform
004b73c3 RecorderApp.exe Controls                DoControlMsg
004b7a1b RecorderApp.exe Controls                TWinControl.WMCommand
004b422c RecorderApp.exe Controls                TControl.WndProc
004b728b RecorderApp.exe Controls                TWinControl.WndProc
004a9390 RecorderApp.exe StdCtrls                TButtonControl.WndProc
004471a5 RecorderApp.exe Classes                 TList.Delete
004b6f08 RecorderApp.exe Controls                TWinControl.MainWndProc
004529d0 RecorderApp.exe Classes                 StdWndProc
7e41b8fe user32.dll                              SendMessageW
7e41f658 user32.dll                              CallWindowProcA
004b736f RecorderApp.exe Controls                TWinControl.DefaultHandler
004b47cc RecorderApp.exe Controls                TControl.WMLButtonUp
004b422c RecorderApp.exe Controls                TControl.WndProc
004b71bd RecorderApp.exe Controls                TWinControl.WndProc
004a9390 RecorderApp.exe StdCtrls                TButtonControl.WndProc
00724609 RecorderApp.exe XPMenu         2928 +10 TControlSubClass.ControlSubClass
004b3ffc RecorderApp.exe Controls                TControl.Perform
004529d0 RecorderApp.exe Classes                 StdWndProc
004b6f08 RecorderApp.exe Controls                TWinControl.MainWndProc
004529d0 RecorderApp.exe Classes                 StdWndProc
7e4196c2 user32.dll                              DispatchMessageA
004d527b RecorderApp.exe Forms                   TApplication.ProcessMessage
004d52b2 RecorderApp.exe Forms                   TApplication.HandleMessage
004d54e2 RecorderApp.exe Forms                   TApplication.Run
00a32904 RecorderApp.exe RecorderApp     422 +83 initialization

thread $558:
7c90e514 ntdll.dll                 KiFastSystemCallRet
7c90df48 ntdll.dll                 NtWaitForMultipleObjects
7c8094f8 kernel32.dll              WaitForMultipleObjectsEx
7e4195f3 user32.dll                MsgWaitForMultipleObjectsEx
7e4196a3 user32.dll                MsgWaitForMultipleObjects
0042b939 RecorderApp.exe madExcept CallThreadProc
0042b97b RecorderApp.exe madExcept ThreadExceptFrame
>> created by main thread ($bec) at:
4ec67b7f gdiplus.dll               

thread $c60:
7c90e514 ntdll.dll                 KiFastSystemCallRet
7c90daa8 ntdll.dll                 NtReplyWaitReceivePortEx
0042b939 RecorderApp.exe madExcept CallThreadProc
0042b97b RecorderApp.exe madExcept ThreadExceptFrame
>> created by main thread ($bec) at:
77e87695 RPCRT4.dll               

thread $dd4:
7c90e514 ntdll.dll     KiFastSystemCallRet
7c90df58 ntdll.dll     NtWaitForSingleObject
7c8025c5 kernel32.dll  WaitForSingleObjectEx
7c80252d kernel32.dll  WaitForSingleObject

thread $e68:
7c90e514 ntdll.dll                 KiFastSystemCallRet
7c90df48 ntdll.dll                 NtWaitForMultipleObjects
7c8094f8 kernel32.dll              WaitForMultipleObjectsEx
0042b939 RecorderApp.exe madExcept CallThreadProc
0042b97b RecorderApp.exe madExcept ThreadExceptFrame
>> created by main thread ($bec) at:
77de6414 advapi32.dll             

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

thread $fe0:
7c90e514 ntdll.dll                 KiFastSystemCallRet
7c90daa8 ntdll.dll                 NtReplyWaitReceivePortEx
0042b939 RecorderApp.exe madExcept CallThreadProc
0042b97b RecorderApp.exe madExcept ThreadExceptFrame
>> created by thread $c60 at:
77e87695 RPCRT4.dll               

thread $51c: <priority:1>
7c90e514 ntdll.dll     KiFastSystemCallRet
7c90df58 ntdll.dll     NtWaitForSingleObject
7c8025c5 kernel32.dll  WaitForSingleObjectEx
7c80252d kernel32.dll  WaitForSingleObject

thread $828: <priority:1>
7c90e514 ntdll.dll     KiFastSystemCallRet
7c90df58 ntdll.dll     NtWaitForSingleObject
7c8025c5 kernel32.dll  WaitForSingleObjectEx
7c80252d kernel32.dll  WaitForSingleObject

thread $8d8: <priority:1>
7c90e514 ntdll.dll     KiFastSystemCallRet
7c90df58 ntdll.dll     NtWaitForSingleObject
7c8025c5 kernel32.dll  WaitForSingleObjectEx
7c80252d kernel32.dll  WaitForSingleObject

modules:
00330000 HHCtrl.ocx                5.2.3790.2847    C:\WINDOWS\system32
003c0000 MS5User.Dll               5.0.0.4          C:\Program Files\Recorder 6
00400000 RecorderApp.exe           6.16.2.241       C:\Program Files\Recorder 6
00cf0000 C4DLL.DLL                 1.0.0.1          C:\Program Files\Recorder 6
018c0000 ms5cnv.dll                5.0.0.10         C:\Program Files\Recorder 6
02ed0000 xpsp2res.dll              5.1.2600.2180    C:\WINDOWS\system32
03b90000 SQLOLEDB.RLL              2000.85.1117.0   C:\Program Files\Common Files\System\Ole DB
03ba0000 msadcer.dll               2.81.1117.0      C:\Program Files\Common Files\System\msadc
03e40000 SHOWUN~1.OCX              6.0.0.13         C:\PROGRA~1\RECORD~1\Addins
04090000 STDVAL~1.DLL              6.15.1.230       C:\PROGRA~1\RECORD~1\Addins
044e0000 Normaliz.dll              6.0.5441.0       C:\WINDOWS\system32
04890000 msader15.dll              2.81.1117.0      C:\Program Files\Common Files\System\ado
04a40000 sqlsrv32.rll              2000.85.1117.0   C:\WINDOWS\system32
0f9a0000 VBAJET32.DLL              6.0.1.9431       C:\WINDOWS\system32
0f9c0000 expsrv.dll                6.0.72.9589      C:\WINDOWS\system32
0ffd0000 rsaenh.dll                5.1.2600.2161    C:\WINDOWS\system32
10000000 MS5.Dll                   5.0.0.12         C:\Program Files\Recorder 6
10930000 PortableDeviceApi.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 odbcint.dll               3.525.1117.0     C:\WINDOWS\system32
3d930000 WININET.dll               7.0.6000.17023   C:\WINDOWS\system32
3dfd0000 iertutil.dll              7.0.6000.17023   C:\WINDOWS\system32
4ca30000 msadrh15.dll              2.81.1117.0      C:\Program Files\Common Files\System\ado
4d650000 msadox.dll                2.81.1128.0      C:\Program Files\Common Files\System\ado
4dd00000 sqloledb.dll              2000.85.1117.0   C:\Program Files\Common Files\System\Ole DB
4de10000 msado15.dll               2.81.1128.0      C:\Program Files\Common Files\System\ado
4e530000 SQLSRV32.dll              2000.85.1117.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
5ad70000 uxtheme.dll               6.0.2900.2180    C:\WINDOWS\system32
5b860000 NETAPI32.dll              5.1.2600.3462    C:\WINDOWS\system32
5c1b0000 SQLUNIRL.dll              2000.80.728.0    C:\WINDOWS\system32
5d090000 comctl32.dll              5.82.2900.2982   C:\WINDOWS\system32
5edd0000 olepro32.dll              5.1.2600.2180    C:\WINDOWS\system32
5fe80000 odbccp32.dll              3.525.1117.0     C:\WINDOWS\system32
605d0000 mslbui.dll                5.1.2600.2180    C:\WINDOWS\system32
60e30000 MSDATL3.dll               2.81.1117.0      C:\Program Files\Common Files\System\Ole DB
629c0000 LPK.DLL                   5.1.2600.2180    C:\WINDOWS\system32
65e50000 GrooveSystemServices.dll  12.0.6421.1000   C:\Program Files\Microsoft Office\Office12
661d0000 GrooveShellExtensions.dll 12.0.6421.1000   C:\Program Files\Microsoft Office\Office12
68ef0000 GrooveUtil.DLL            12.0.6550.5004   C:\Program Files\Microsoft Office\Office12
68ff0000 GrooveNew.DLL             12.0.6413.1000   C:\Program Files\Microsoft Office\Office12
69b10000 msxml4.dll                4.20.9876.0      c:\WINDOWS\system32
6d4f0000 DBNETLIB.DLL              2000.85.1117.0   C:\WINDOWS\system32
71aa0000 WS2HELP.dll               5.1.2600.2180    C:\WINDOWS\system32
71ab0000 WS2_32.dll                5.1.2600.2180    C:\WINDOWS\system32
71ad0000 wsock32.dll               5.1.2600.2180    C:\WINDOWS\system32
71b20000 mpr.dll                   5.1.2600.2180    C:\WINDOWS\system32
71bf0000 SAMLIB.dll                5.1.2600.2180    C:\WINDOWS\System32
71c10000 ntlanman.dll              5.1.2600.2180    C:\WINDOWS\System32
71c80000 NETRAP.dll                5.1.2600.2180    C:\WINDOWS\System32
71c90000 NETUI1.dll                5.1.2600.2180    C:\WINDOWS\System32
71cd0000 NETUI0.dll                5.1.2600.2180    C:\WINDOWS\System32
71f80000 security.dll              5.1.2600.2180    C:\WINDOWS\system32
73000000 winspool.drv              5.1.2600.2180    C:\WINDOWS\system32
73160000 oledb32.dll               2.81.1117.0      C:\Program Files\Common Files\System\Ole DB
74060000 msadce.dll                2.81.1135.0      C:\Program Files\Common Files\System\msadc
74320000 odbc32.dll                3.525.1117.0     C:\WINDOWS\system32
74720000 MSCTF.dll                 5.1.2600.3319    C:\WINDOWS\system32
74980000 msxml3.dll                8.100.1050.0     C:\WINDOWS\system32
74cd0000 DBmsLPCn.dll              2000.80.760.0    C:\WINDOWS\system32
74d90000 USP10.dll                 1.420.2600.2180  C:\WINDOWS\system32
750b0000 RESUTILS.DLL              5.1.2600.2180    C:\WINDOWS\system32
750f0000 MTXCLU.DLL                2001.12.4414.320 C:\WINDOWS\system32
75130000 colbact.DLL               2001.12.4414.308 C:\WINDOWS\system32
75350000 OLEDB32R.DLL              2.81.1117.0      C:\Program Files\Common Files\System\Ole DB
754d0000 CRYPTUI.dll               5.131.2600.2180  C:\WINDOWS\system32
755c0000 msctfime.ime              5.1.2600.2180    C:\WINDOWS\system32
75940000 NDDEAPI.DLL               5.1.2600.2180    C:\WINDOWS\system32
75e90000 SXS.DLL                   5.1.2600.3019    C:\WINDOWS\system32
75f60000 drprov.dll                5.1.2600.2180    C:\WINDOWS\System32
75f70000 davclnt.dll               5.1.2600.2180    C:\WINDOWS\System32
75f80000 browseui.dll              6.0.2900.3395    C:\WINDOWS\system32
76380000 MSImg32.dll               5.1.2600.2180    C:\WINDOWS\system32
76390000 IMM32.DLL                 5.1.2600.2180    C:\WINDOWS\system32
763b0000 comdlg32.dll              6.0.2900.2180    C:\WINDOWS\system32
765b0000 MSDART.DLL                2.81.1117.0      C:\WINDOWS\system32
76600000 CSCDLL.dll                5.1.2600.2180    C:\WINDOWS\System32
76620000 comsvcs.dll               2001.12.4414.308 C:\WINDOWS\system32
76780000 SHFolder.dll              6.0.2900.2180    C:\WINDOWS\system32
76790000 cryptdll.dll              5.1.2600.2180    C:\WINDOWS\system32
767a0000 ntdsapi.dll               5.1.2600.2180    C:\WINDOWS\system32
76990000 ntshrui.dll               5.1.2600.2180    C:\WINDOWS\system32
769c0000 USERENV.dll               5.1.2600.2180    C:\WINDOWS\system32
76b20000 ATL.DLL                   3.5.2284.2       C:\WINDOWS\system32
76b40000 winmm.dll                 5.1.2600.2180    C:\WINDOWS\system32
76c30000 WINTRUST.dll              5.131.2600.3661  C:\WINDOWS\system32
76c90000 IMAGEHLP.dll              5.1.2600.2180    C:\WINDOWS\system32
76d10000 CLUSAPI.DLL               5.1.2600.2180    C:\WINDOWS\system32
76d60000 iphlpapi.dll              5.1.2600.2912    C:\WINDOWS\system32
76f20000 DNSAPI.dll                5.1.2600.3394    C:\WINDOWS\system32
76f60000 WLDAP32.dll               5.1.2600.2180    C:\WINDOWS\system32
76fd0000 CLBCATQ.DLL               2001.12.4414.308 C:\WINDOWS\system32
77050000 COMRes.dll                2001.12.4414.258 C:\WINDOWS\system32
77120000 oleaut32.dll              5.1.2600.3266    C:\WINDOWS\system32
773d0000 comctl32.dll              6.0.2900.2982    C:\WINDOWS\WinSxS\x86_Microsoft.Windows.Common-Controls_6595b64144ccf1df_6.0.2600.2982_x-ww_ac3f9c03
774e0000 ole32.dll                 5.1.2600.2726    C:\WINDOWS\system32
77920000 SETUPAPI.dll              5.1.2600.2180    C:\WINDOWS\system32
77a20000 cscui.dll                 5.1.2600.2180    C:\WINDOWS\System32
77a80000 crypt32.dll               5.131.2600.2180  C:\WINDOWS\system32
77b20000 MSASN1.dll                5.1.2600.3624    C:\WINDOWS\system32
77b40000 appHelp.dll               5.1.2600.2180    C:\WINDOWS\system32
77c00000 version.dll               5.1.2600.2180    C:\WINDOWS\system32
77c10000 msvcrt.dll                7.0.2600.2180    C:\WINDOWS\system32
77c70000 msv1_0.dll                5.1.2600.3625    C:\WINDOWS\system32
77dd0000 advapi32.dll              5.1.2600.3520    C:\WINDOWS\system32
77e70000 RPCRT4.dll                5.1.2600.3555    C:\WINDOWS\system32
77f10000 GDI32.dll                 5.1.2600.3466    C:\WINDOWS\system32
77f60000 SHLWAPI.dll               6.0.2900.3653    C:\WINDOWS\system32
77fe0000 Secur32.dll               5.1.2600.3592    C:\WINDOWS\system32
78130000 MSVCR80.dll               8.0.50727.4053   C:\WINDOWS\WinSxS\x86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.4053_x-ww_e6967989
7c630000 ATL80.DLL                 8.0.50727.762    C:\WINDOWS\WinSxS\x86_Microsoft.VC80.ATL_1fc8b3b9a1e18e3b_8.0.50727.762_x-ww_cbb27474
7c800000 kernel32.dll              5.1.2600.3541    C:\WINDOWS\system32
7c900000 ntdll.dll                 5.1.2600.3520    C:\WINDOWS\system32
7c9c0000 shell32.dll               6.0.2900.3402    C:\WINDOWS\system32
7e290000 shdocvw.dll               6.0.2900.3395    C:\WINDOWS\system32
7e410000 user32.dll                5.1.2600.3099    C:\WINDOWS\system32

Exception Stack

----------------
EOleException : ODBC--insert on a linked table 'SQLSERVER_SURVEY_EVENT' failed
EDBMergerError : Error occurred transferring records for SQLSERVER_SURVEY_EVENT into the main database

2 Reply by johnvanbreda

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

Re: Wizard Import failed

Hi Chris,
What happens if you manually create a survey event? Does it work OK?
Also have you tried importing a file containing just a handful of records?
Best wishes

John van Breda
Biodiverse IT

johnvanbreda's Website

3 Reply by sallyrankin

  • sallyrankin
  • Administrator
  • Offline
  • Registered: 07-04-2006
  • Posts: 371

Re: Wizard Import failed

What version of SQL Server are you using? The maximum size of an MSDE database is 2 GB. MSDE, Microsoft SQL Server 2000 Desktop Engine, is the free run-time version of SQL Server 2000. The maximum size of a SQL Server 2005 Express database is 4 GB. Once you reach these limits you can no longer add data to the database. What version of the installation disk did you use to install Recorder 6? MSDE was on the installation disks up to and including v6.13. SQL Server 2005 Express is on the v6.14 and v6.15 installation disks. If you did your installation using a v6.13 disk and installed SQL Server from it you will be running MSDE. If this is the case you will need to convert to using SQL Server 2005 Express. There is some guidance on installing the latest version in http://forums.nbn.org.uk/viewtopic.php?pid=8317#p8317 but, from memory, I think you will need to uninstall MSDE before installing SQL Server 2005 Express – SP4.

Sally Rankin, JNCC Recorder Approved Expert
E-mail: s.rankin@btinternet.com
Telephone: 01491 578633
Mobile: 07941 207687

4 Reply by cpanter

  • cpanter
  • Member
  • Offline
  • Registered: 15-03-2011
  • Posts: 8

Re: Wizard Import failed

Thanks,
I did try a small batch (200 records) and had no luck and i cannot create a new survey event, receiving an error message:

Could not allocate space for object 'SURVEY_EVENT' in database 'NBNData' because the 'PRIMARY' filegroup is full.

Therefore it sounds like, as suggested, due to the maximum file size being reached. The version i used for installation was v6.13a. I will try and convert to the SQL Server 2005 Express and see how that goes.
Thanks again

5 Reply by cpanter

  • cpanter
  • Member
  • Offline
  • Registered: 15-03-2011
  • Posts: 8

Re: Wizard Import failed

I have installed SQL Server 2005 Express, however i cannot seem to be able to attach the database through this. Are there any guides to do this? I have tried to follow through the recorder Network Installation Guide, with no success and now seem unable to even connect to the server in the server management studio express.
Alternatively could i reinstall recorder and then would this automatically recognise the conversion?
I made a backup in recorder (when it was still working) and copied the database files (NBNData_Data.MDF and NBNData_Log.LDF), but have never restored my data from a backup and did not want to risk losing this.
Thanks!

6 Reply by cpanter

  • cpanter
  • Member
  • Offline
  • Registered: 15-03-2011
  • Posts: 8

Re: Wizard Import failed

I have eventually managed to work may way through linking up the database to recorder. And i can now open recorder again, however i cannot import any records.
I can manually data a single new event and species observation, so i assume the database is now going through the new SQL server 2005.
However when i try to import a relatively small batch of records (c.300 records) through the import wizard i have an error which i have never seen before at the stage of creating the temporary database. Error is as follows:

Failed to generate import table 'Sample'. The import job was aborted.
The error that occurred was:
data type mismatch in criteria expression
This is probably due to an error in the definition of the import process

I am then unable to continue and going back i get the recorder message:

exception class   : EOleException
exception message : Invalid object name '#Locations'.

Any thoughts on this would be great!

7 Reply by cpanter

  • cpanter
  • Member
  • Offline
  • Registered: 15-03-2011
  • Posts: 8

Re: Wizard Import failed

I am no longer having the problem as listed in the last post - i now have a new one. The last one seemed to resolve itself and i managed to import a couple of large databases (65,00 records each). However i then moved on to some other datasets, of just a few thousand and am unable to import these.

The error message listed at the bottom appears just after matching the species names in the import wizard.

Thanks to help from Mike we believe this must be a problem with the SQL server, after having checked the SQL Server Configuration Manager, Server Area Configuration and still no luck.

Also i still am unable to view any tables from ndndata in access.

The error message is as follows

date/time         : 2011-03-17, 14:56:27, 76ms
computer name     : envcp9
user name         : wsd06vpu
operating system  : Windows XP Service Pack 2 build 2600
system language   : English
system up time    : 1 hour 56 minutes
program up time   : 6 minutes 29 seconds
processors        : 2x Intel(R) Core(TM)2 Duo CPU     E7500  @ 2.93GHz
physical memory   : 222/1980 MB (free/total)
free disk space   : (C:) 249.32 GB
display mode      : 1280x1024, 32 bit
process id        : $108c
allocated memory  : 22.62 MB
command line      : RecorderApp.exe /19203054
executable        : RecorderApp.exe
exec. date/time   : 2011-01-18 14:50
version           : 6.16.2.241
madExcept version : 2.7k
exception class   : EOleException
exception message : A domain error occurred.

main thread ($125c):
00573f86 RecorderApp.exe ADODB                           TADOCommand.Execute
00573ee0 RecorderApp.exe ADODB                           TADOCommand.Execute
00573ec0 RecorderApp.exe ADODB                           TADOCommand.Execute
005c0581 RecorderApp.exe BaseADODataModule       899  +9 TdmBaseADO.RunStoredProc
0095da7f RecorderApp.exe IWColumnMappingClasses  618  +3 TMatchRule.MatchRecords
00991134 RecorderApp.exe BaseMatchPage           304  +9 TBaseMatch.btnSearchClick
004b43c4 RecorderApp.exe Controls                        TControl.Click
004a94cc RecorderApp.exe StdCtrls                        TButton.Click
00470171 RecorderApp.exe Buttons                         TBitBtn.Click
00992f54 RecorderApp.exe BaseMatchPage           870 +21 TBaseMatch.LoadContent
00988bea RecorderApp.exe MatchLocations          523  +5 TfraMatchLocations.LoadContent
00965f97 RecorderApp.exe IWBasePage              117  +4 TBasePage.Create
009872bb RecorderApp.exe MatchLocations          155  +1 TfraMatchLocations.Create
009802cc RecorderApp.exe ImportWizard            305 +35 TfrmImportWizard.ChangePage
0097fe3a RecorderApp.exe ImportWizard            192 +22 TfrmImportWizard.btnNextClick
004b43c4 RecorderApp.exe Controls                        TControl.Click
004a94cc RecorderApp.exe StdCtrls                        TButton.Click
00470171 RecorderApp.exe Buttons                         TBitBtn.Click
004a95c0 RecorderApp.exe StdCtrls                        TButton.CNCommand
004b422c RecorderApp.exe Controls                        TControl.WndProc
004b728b RecorderApp.exe Controls                        TWinControl.WndProc
004a9390 RecorderApp.exe StdCtrls                        TButtonControl.WndProc
00724609 RecorderApp.exe XPMenu                 2928 +10 TControlSubClass.ControlSubClass
7c90eb94 ntdll.dll                                       RtlAnsiStringToUnicodeString
004b3ffc RecorderApp.exe Controls                        TControl.Perform
004b73c3 RecorderApp.exe Controls                        DoControlMsg
004b7a1b RecorderApp.exe Controls                        TWinControl.WMCommand
004b422c RecorderApp.exe Controls                        TControl.WndProc
004b728b RecorderApp.exe Controls                        TWinControl.WndProc
004a9390 RecorderApp.exe StdCtrls                        TButtonControl.WndProc
004471a5 RecorderApp.exe Classes                         TList.Delete
004b6f08 RecorderApp.exe Controls                        TWinControl.MainWndProc
004529d0 RecorderApp.exe Classes                         StdWndProc
7e41b8fe user32.dll                                      SendMessageW
7e41f658 user32.dll                                      CallWindowProcA
004b736f RecorderApp.exe Controls                        TWinControl.DefaultHandler
004b47cc RecorderApp.exe Controls                        TControl.WMLButtonUp
004b422c RecorderApp.exe Controls                        TControl.WndProc
004b71bd RecorderApp.exe Controls                        TWinControl.WndProc
004b422c RecorderApp.exe Controls                        TControl.WndProc
004b728b RecorderApp.exe Controls                        TWinControl.WndProc
004a9390 RecorderApp.exe StdCtrls                        TButtonControl.WndProc
00724609 RecorderApp.exe XPMenu                 2928 +10 TControlSubClass.ControlSubClass
004b3ffc RecorderApp.exe Controls                        TControl.Perform
004529d0 RecorderApp.exe Classes                         StdWndProc
004b6f08 RecorderApp.exe Controls                        TWinControl.MainWndProc
004529d0 RecorderApp.exe Classes                         StdWndProc
7e4196c2 user32.dll                                      DispatchMessageA
004d527b RecorderApp.exe Forms                           TApplication.ProcessMessage
004d52b2 RecorderApp.exe Forms                           TApplication.HandleMessage
004d54e2 RecorderApp.exe Forms                           TApplication.Run
00a32904 RecorderApp.exe RecorderApp             422 +83 initialization

thread $126c:
7c90e514 ntdll.dll                 KiFastSystemCallRet
7c90df48 ntdll.dll                 NtWaitForMultipleObjects
7c8094f8 kernel32.dll              WaitForMultipleObjectsEx
7e4195f3 user32.dll                MsgWaitForMultipleObjectsEx
7e4196a3 user32.dll                MsgWaitForMultipleObjects
0042b939 RecorderApp.exe madExcept CallThreadProc
0042b97b RecorderApp.exe madExcept ThreadExceptFrame
>> created by main thread ($125c) at:
4ec67b7f gdiplus.dll               

thread $1268:
7c90e514 ntdll.dll                 KiFastSystemCallRet
7c90daa8 ntdll.dll                 NtReplyWaitReceivePortEx
0042b939 RecorderApp.exe madExcept CallThreadProc
0042b97b RecorderApp.exe madExcept ThreadExceptFrame
>> created by main thread ($125c) at:
77e87695 RPCRT4.dll               

thread $1244:
7c90e514 ntdll.dll     KiFastSystemCallRet
7c90df58 ntdll.dll     NtWaitForSingleObject
7c8025c5 kernel32.dll  WaitForSingleObjectEx
7c80252d kernel32.dll  WaitForSingleObject

thread $12c4:
7c90e514 ntdll.dll                 KiFastSystemCallRet
7c90df48 ntdll.dll                 NtWaitForMultipleObjects
7c8094f8 kernel32.dll              WaitForMultipleObjectsEx
0042b939 RecorderApp.exe madExcept CallThreadProc
0042b97b RecorderApp.exe madExcept ThreadExceptFrame
>> created by main thread ($125c) at:
77de6414 advapi32.dll             

thread $12b8:
7c90e514 ntdll.dll  KiFastSystemCallRet
7c90d218 ntdll.dll  NtDelayExecution

thread $1394:
7c90e514 ntdll.dll                 KiFastSystemCallRet
7c90daa8 ntdll.dll                 NtReplyWaitReceivePortEx
0042b939 RecorderApp.exe madExcept CallThreadProc
0042b97b RecorderApp.exe madExcept ThreadExceptFrame
>> created by thread $1268 at:
77e87695 RPCRT4.dll               

modules:
00330000 HHCtrl.ocx                5.2.3790.2847    C:\WINDOWS\system32
003c0000 MS5User.Dll               5.0.0.4          C:\Program Files\Recorder 6
00400000 RecorderApp.exe           6.16.2.241       C:\Program Files\Recorder 6
00cf0000 C4DLL.DLL                 1.0.0.1          C:\Program Files\Recorder 6
018c0000 ms5cnv.dll                5.0.0.10         C:\Program Files\Recorder 6
02ed0000 xpsp2res.dll              5.1.2600.2180    C:\WINDOWS\system32
03b70000 SQLOLEDB.RLL              2000.85.1117.0   C:\Program Files\Common Files\System\Ole DB
03b80000 msadcer.dll               2.81.1117.0      C:\Program Files\Common Files\System\msadc
03e20000 SHOWUN~1.OCX              6.0.0.13         C:\PROGRA~1\RECORD~1\Addins
04070000 STDVAL~1.DLL              6.15.1.230       C:\PROGRA~1\RECORD~1\Addins
046a0000 Normaliz.dll              6.0.5441.0       C:\WINDOWS\system32
0ffd0000 rsaenh.dll                5.1.2600.2161    C:\WINDOWS\system32
10000000 MS5.Dll                   5.0.0.12         C:\Program Files\Recorder 6
10930000 PortableDeviceApi.dll     5.2.5721.5145    C:\WINDOWS\system32
20000000 odbcint.dll               3.525.1117.0     C:\WINDOWS\system32
3d930000 WININET.dll               7.0.6000.17023   C:\WINDOWS\system32
3dfd0000 iertutil.dll              7.0.6000.17023   C:\WINDOWS\system32
4bd70000 DBnmpNTw.dll              2000.85.1117.0   C:\WINDOWS\system32
4dd00000 sqloledb.dll              2000.85.1117.0   C:\Program Files\Common Files\System\Ole DB
4de10000 msado15.dll               2.81.1128.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.2180    C:\WINDOWS\system32
5b860000 NETAPI32.dll              5.1.2600.3462    C:\WINDOWS\system32
5d090000 comctl32.dll              5.82.2900.2982   C:\WINDOWS\system32
5edd0000 olepro32.dll              5.1.2600.2180    C:\WINDOWS\system32
605d0000 mslbui.dll                5.1.2600.2180    C:\WINDOWS\system32
60e30000 MSDATL3.dll               2.81.1117.0      C:\Program Files\Common Files\System\Ole DB
629c0000 LPK.DLL                   5.1.2600.2180    C:\WINDOWS\system32
65e50000 GrooveSystemServices.dll  12.0.6421.1000   C:\Program Files\Microsoft Office\Office12
661d0000 GrooveShellExtensions.dll 12.0.6421.1000   C:\Program Files\Microsoft Office\Office12
68100000 dssenh.dll                5.1.2600.2133    C:\WINDOWS\system32
68ef0000 GrooveUtil.DLL            12.0.6550.5004   C:\Program Files\Microsoft Office\Office12
68ff0000 GrooveNew.DLL             12.0.6413.1000   C:\Program Files\Microsoft Office\Office12
69b10000 msxml4.dll                4.20.9876.0      c:\WINDOWS\system32
6d4f0000 DBNETLIB.DLL              2000.85.1117.0   C:\WINDOWS\system32
71aa0000 WS2HELP.dll               5.1.2600.2180    C:\WINDOWS\system32
71ab0000 WS2_32.dll                5.1.2600.2180    C:\WINDOWS\system32
71ad0000 wsock32.dll               5.1.2600.2180    C:\WINDOWS\system32
71b20000 mpr.dll                   5.1.2600.2180    C:\WINDOWS\system32
71bf0000 SAMLIB.dll                5.1.2600.2180    C:\WINDOWS\System32
71c10000 ntlanman.dll              5.1.2600.2180    C:\WINDOWS\System32
71c80000 NETRAP.dll                5.1.2600.2180    C:\WINDOWS\System32
71c90000 NETUI1.dll                5.1.2600.2180    C:\WINDOWS\System32
71cd0000 NETUI0.dll                5.1.2600.2180    C:\WINDOWS\System32
71f80000 security.dll              5.1.2600.2180    C:\WINDOWS\system32
73000000 winspool.drv              5.1.2600.2180    C:\WINDOWS\system32
73160000 oledb32.dll               2.81.1117.0      C:\Program Files\Common Files\System\Ole DB
732e0000 RICHED32.DLL              5.1.2600.0       C:\WINDOWS\system32
74060000 msadce.dll                2.81.1135.0      C:\Program Files\Common Files\System\msadc
74320000 odbc32.dll                3.525.1117.0     C:\WINDOWS\system32
74720000 MSCTF.dll                 5.1.2600.3319    C:\WINDOWS\system32
74980000 msxml3.dll                8.100.1050.0     C:\WINDOWS\system32
74cd0000 DBmsLPCn.dll              2000.80.760.0    C:\WINDOWS\system32
74d90000 USP10.dll                 1.420.2600.2180  C:\WINDOWS\system32
74e30000 RICHED20.dll              5.30.23.1228     C:\WINDOWS\system32
750b0000 RESUTILS.DLL              5.1.2600.2180    C:\WINDOWS\system32
750f0000 MTXCLU.DLL                2001.12.4414.320 C:\WINDOWS\system32
75130000 colbact.DLL               2001.12.4414.308 C:\WINDOWS\system32
75350000 OLEDB32R.DLL              2.81.1117.0      C:\Program Files\Common Files\System\Ole DB
754d0000 CRYPTUI.dll               5.131.2600.2180  C:\WINDOWS\system32
755c0000 msctfime.ime              5.1.2600.2180    C:\WINDOWS\system32
75e90000 SXS.DLL                   5.1.2600.3019    C:\WINDOWS\system32
75f60000 drprov.dll                5.1.2600.2180    C:\WINDOWS\System32
75f70000 davclnt.dll               5.1.2600.2180    C:\WINDOWS\System32
75f80000 browseui.dll              6.0.2900.3395    C:\WINDOWS\system32
76380000 MSImg32.dll               5.1.2600.2180    C:\WINDOWS\system32
76390000 IMM32.DLL                 5.1.2600.2180    C:\WINDOWS\system32
763b0000 comdlg32.dll              6.0.2900.2180    C:\WINDOWS\system32
765b0000 MSDART.DLL                2.81.1117.0      C:\WINDOWS\system32
76600000 CSCDLL.dll                5.1.2600.2180    C:\WINDOWS\System32
76620000 comsvcs.dll               2001.12.4414.308 C:\WINDOWS\system32
76780000 SHFolder.dll              6.0.2900.2180    C:\WINDOWS\system32
76790000 cryptdll.dll              5.1.2600.2180    C:\WINDOWS\system32
767a0000 ntdsapi.dll               5.1.2600.2180    C:\WINDOWS\system32
767f0000 schannel.dll              5.1.2600.3592    C:\WINDOWS\system32
76990000 ntshrui.dll               5.1.2600.2180    C:\WINDOWS\system32
769c0000 USERENV.dll               5.1.2600.2180    C:\WINDOWS\system32
76b20000 ATL.DLL                   3.5.2284.2       C:\WINDOWS\system32
76b40000 winmm.dll                 5.1.2600.2180    C:\WINDOWS\system32
76c30000 WINTRUST.dll              5.131.2600.3661  C:\WINDOWS\system32
76c90000 IMAGEHLP.dll              5.1.2600.2180    C:\WINDOWS\system32
76d10000 CLUSAPI.DLL               5.1.2600.2180    C:\WINDOWS\system32
76d60000 iphlpapi.dll              5.1.2600.2912    C:\WINDOWS\system32
76f20000 DNSAPI.dll                5.1.2600.3394    C:\WINDOWS\system32
76f60000 WLDAP32.dll               5.1.2600.2180    C:\WINDOWS\system32
76fd0000 CLBCATQ.DLL               2001.12.4414.308 C:\WINDOWS\system32
77050000 COMRes.dll                2001.12.4414.258 C:\WINDOWS\system32
77120000 oleaut32.dll              5.1.2600.3266    C:\WINDOWS\system32
773d0000 comctl32.dll              6.0.2900.2982    C:\WINDOWS\WinSxS\x86_Microsoft.Windows.Common-Controls_6595b64144ccf1df_6.0.2600.2982_x-ww_ac3f9c03
774e0000 ole32.dll                 5.1.2600.2726    C:\WINDOWS\system32
77920000 SETUPAPI.dll              5.1.2600.2180    C:\WINDOWS\system32
77a20000 cscui.dll                 5.1.2600.2180    C:\WINDOWS\System32
77a80000 crypt32.dll               5.131.2600.2180  C:\WINDOWS\system32
77b20000 MSASN1.dll                5.1.2600.3624    C:\WINDOWS\system32
77b40000 appHelp.dll               5.1.2600.2180    C:\WINDOWS\system32
77c00000 version.dll               5.1.2600.2180    C:\WINDOWS\system32
77c10000 msvcrt.dll                7.0.2600.2180    C:\WINDOWS\system32
77c70000 msv1_0.dll                5.1.2600.3625    C:\WINDOWS\system32
77dd0000 advapi32.dll              5.1.2600.3520    C:\WINDOWS\system32
77e70000 RPCRT4.dll                5.1.2600.3555    C:\WINDOWS\system32
77f10000 GDI32.dll                 5.1.2600.3466    C:\WINDOWS\system32
77f60000 SHLWAPI.dll               6.0.2900.3653    C:\WINDOWS\system32
77fe0000 Secur32.dll               5.1.2600.3592    C:\WINDOWS\system32
78130000 MSVCR80.dll               8.0.50727.4053   C:\WINDOWS\WinSxS\x86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.4053_x-ww_e6967989
7c630000 ATL80.DLL                 8.0.50727.762    C:\WINDOWS\WinSxS\x86_Microsoft.VC80.ATL_1fc8b3b9a1e18e3b_8.0.50727.762_x-ww_cbb27474
7c800000 kernel32.dll              5.1.2600.3541    C:\WINDOWS\system32
7c900000 ntdll.dll                 5.1.2600.3520    C:\WINDOWS\system32
7c9c0000 shell32.dll               6.0.2900.3402    C:\WINDOWS\system32
7e290000 shdocvw.dll               6.0.2900.3395    C:\WINDOWS\system32
7e410000 user32.dll                5.1.2600.3099    C:\WINDOWS\system32

8 Reply by sallyrankin

  • sallyrankin
  • Administrator
  • Offline
  • Registered: 07-04-2006
  • Posts: 371

Re: Wizard Import failed

This error has occurred before – see http://forums.nbn.org.uk/viewtopic.php?pid=5605#p5605 . Unfortunately there isn’t much information on how/whether it was resolved but can you try to isolate which records being imported are causing it.

Sally Rankin, JNCC Recorder Approved Expert
E-mail: s.rankin@btinternet.com
Telephone: 01491 578633
Mobile: 07941 207687

9 Reply by johnvanbreda

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

Re: Wizard Import failed

I'm not convinced this is caused by the SQL Server. As Sally suggests can you try to split your data into smaller chunks to identify a small subset of records which exhibits the error, then email them to me to try importing?

John van Breda
Biodiverse IT

johnvanbreda's Website

10 Reply by cpanter

  • cpanter
  • Member
  • Offline
  • Registered: 15-03-2011
  • Posts: 8

Re: Wizard Import failed

Thanks, based on the suggestion, i have been interrogating my data files, the files were saved as excel files and is suspected the format of the dates in excel was a problem as they were a mix of normal dates (01/01/2000) ranges (2000-2010), and pre dates (-2000). All i have done is to change the cells to the correct format (e.g. a date for normal dates or number for the pre dates and ranges), as this was all i could see that i thought could be a problem.
These previously were not a problem using the old server, i am not sure if this makes sense as a the root of the problem or the solution - but it is now importing again with out any problems!!
Thanks to everyones help with these problems, as hopefully these appear to be resolved!