1 Reply by LBacon

  • LBacon
  • Veteran
  • Offline
  • Registered: 12-09-2006
  • Posts: 80

Re: Import failure

Having now restored my Recorder 6.14 database after a crash (see some earlier witterings in this forum), I have just tried to import some data from an excel spreadsheet.  At the do import stage, I get an error message, below, and what  I end up with is a set of events entered into the survey, with location & date but recorder blank, and with no samples attached.  Any ideas as to the problem?

Louise

Error report:

date/time         : 2009-10-05, 14:17:01, 187ms
computer name     : CPBRC-5
user name         : louiseb
operating system  : Windows XP Service Pack 3 build 2600
system language   : English
system up time    : 4 hours 53 minutes
program up time   : 16 minutes 50 seconds
processors        : 2x Intel(R) Core(TM)2 Duo CPU     E6850  @ 3.00GHz
physical memory   : 599/2021 MB (free/total)
free disk space   : (C:) 44.83 GB
display mode      : 1024x768, 32 bit
process id        : $4a4
allocated memory  : 31.40 MB
command line      : RecorderApp.exe /1573772
executable        : RecorderApp.exe
exec. date/time   : 2009-08-05 13:49
version           : 6.14.4.212
madExcept version : 2.7k
exception class   : EDBMergerError
exception message : Error occurred transferring records for SQLSERVER_TAXON_DETERMINATION into the main database.

main thread ($4dc):
00704d68 RecorderApp.exe 
7c90e485 ntdll.dll        KiUserExceptionDispatcher
7e42a993 user32.dll       CallWindowProcA
7c90eb94 ntdll.dll        RtlAnsiStringToUnicodeString
7e4292de user32.dll       SendMessageW
7e42a993 user32.dll       CallWindowProcA
7c90eb94 ntdll.dll        RtlAnsiStringToUnicodeString
7e4196c2 user32.dll       DispatchMessageA

thread $c68:
7c90e514 ntdll.dll     KiFastSystemCallRet
7c90df48 ntdll.dll     NtWaitForMultipleObjects
7c80958a kernel32.dll  WaitForMultipleObjectsEx
7e4195f3 user32.dll    MsgWaitForMultipleObjectsEx
7e4196a3 user32.dll    MsgWaitForMultipleObjects
>> created by main thread ($4dc) at:
4eca29b1 gdiplus.dll   

thread $a90:
7c90e514 ntdll.dll   KiFastSystemCallRet
7c90daa8 ntdll.dll   NtReplyWaitReceivePortEx
>> created by main thread ($4dc) at:
77e7df36 RPCRT4.dll 

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

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

thread $ec: <priority:1>
7c90e514 ntdll.dll     KiFastSystemCallRet
7c90df58 ntdll.dll     NtWaitForSingleObject
7c8025d5 kernel32.dll  WaitForSingleObjectEx
7c80253d kernel32.dll  WaitForSingleObject

thread $940: <priority:1>
7c90e514 ntdll.dll     KiFastSystemCallRet
7c90df58 ntdll.dll     NtWaitForSingleObject
7c8025d5 kernel32.dll  WaitForSingleObjectEx
7c80253d kernel32.dll  WaitForSingleObject

thread $a60: <priority:1>
7c90e514 ntdll.dll     KiFastSystemCallRet
7c90df58 ntdll.dll     NtWaitForSingleObject
7c8025d5 kernel32.dll  WaitForSingleObjectEx
7c80253d kernel32.dll  WaitForSingleObject

modules:
00340000 C4DLL.DLL             1.0.0.1          C:\Program Files\Recorder 6
003b0000 MS5User.Dll           5.0.0.4          C:\Program Files\Recorder 6
00400000 RecorderApp.exe       6.14.4.212       C:\Program Files\Recorder 6
01360000 ms5cnv.dll            5.0.0.10         C:\Program Files\Recorder 6
01b00000 odbcint.dll           3.525.1132.0     C:\WINDOWS\system32
02950000 xpsp2res.dll          5.1.2600.5512    C:\WINDOWS\system32
02c20000 msader15.dll          2.81.1132.0      C:\Program Files\Common Files\System\ado
03610000 SQLOLEDB.RLL          2000.85.1132.0   C:\Program Files\Common Files\System\Ole DB
03620000 msadcer.dll           2.81.1132.0      C:\Program Files\Common Files\System\msadc
03950000 GOTOGR~1.OCX          2.0.0.16         C:\PROGRA~1\RECORD~1\Addins
03b00000 GoToKey.ocx           6.0.1.8          C:\PROGRA~1\RECORD~1\Addins
03d30000 SHOWUN~1.OCX          6.0.0.11         C:\PROGRA~1\RECORD~1\Addins
03f60000 STDVAL~1.DLL          6.14.3.208       C:\PROGRA~1\RECORD~1\Addins
046f0000 sqlsrv32.rll          2000.85.1132.0   C:\WINDOWS\system32
04750000 Normaliz.dll          6.0.5441.0       C:\WINDOWS\system32
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         C:\Program Files\Recorder 6
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.5265   C:\WINDOWS\system32
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           7.0.6000.16876   C:\WINDOWS\system32
3dfd0000 iertutil.dll          7.0.6000.16876   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.1.3102.5581    C:\WINDOWS\WinSxS\x86_Microsoft.Windows.GdiPlus_6595b64144ccf1df_1.0.2600.5581_x-ww_dfbc4fc4
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.5512   C:\WINDOWS\system32
5edd0000 olepro32.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
69b10000 msxml4.dll            4.20.9870.0      c:\WINDOWS\system32
6d4f0000 DBNETLIB.DLL          2000.85.1132.0   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.1132.0     C:\WINDOWS\system32
74720000 MSCTF.dll             5.1.2600.5512    C:\WINDOWS\system32
74cd0000 DBmsLPCn.dll          2000.80.760.0    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
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
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.5512  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
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.5512    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.5834    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.5512    C:\WINDOWS\system32
77fe0000 Secur32.dll           5.1.2600.5834    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

Exception Stack

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

2 Reply by johnvanbreda

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

Re: Import failure

Hi Louise

It's not a very good solution I know, but have you tried going to the Options dialog on the Tools menu, and ticking "Use the v6.13 Import Wizard" on the first tab? It might at least let you import this data again.

If you want me to look at it a bit further perhaps you could email me the Excel file that caused the problem?

Thanks

John van Breda
Biodiverse IT

johnvanbreda's Website