1 Reply by mhorlock (edited by mhorlock 06-07-2010 16:17:53)

  • mhorlock
  • Member
  • Offline
  • From: Norwich
  • Registered: 07-01-2009
  • Posts: 17

Re: Export to NBN Zipped Access problem

Hi

I am trying to export a large dataset (300000 occurences) based on a polygon. I had a problem with invalid records which I have sorted, however I still get the error message below telling me that "Cannot drop the table '#TAXON_OCCURRENCE', because it does not exist or you do not have permission." I have previously only had this message after invalid items have been detected and I have then continued with the export regardless. Does anyone have any idea why I am still getting this message despite having sorted the invalid items?

Thanks for any advice
Martin



date/time         : 2010-07-06, 17:16:51, 671ms
computer name     : PT68942
user name         : dvamh
operating system  : Windows XP Service Pack 2 build 2600
system language   : English
system up time    : 8 hours 31 minutes
program up time   : 54 minutes 3 seconds
processors        : 2x Intel(R) Core(TM)2 Duo CPU     E6550  @ 2.33GHz
physical memory   : 898/2046 MB (free/total)
free disk space   : (C:) 76.34 GB (F:) 20.13 GB
display mode      : 1440x900, 32 bit
process id        : $b0c
allocated memory  : 524.63 MB
command line      : RecorderApp.exe /2097342
executable        : RecorderApp.exe
exec. date/time   : 2009-08-05 13:49
version           : 6.14.4.212
madExcept version : 2.7k
exception class   : EOleException
exception message : Cannot drop the table '#TAXON_OCCURRENCE', because it does not exist or you do not have permission.

main thread ($fa8):
00000000 ???         
77d4bcc7 user32.dll  DispatchMessageA

thread $ab4:
7c90eb94 ntdll.dll     KiFastSystemCallRet
7c90e9a9 ntdll.dll     NtWaitForMultipleObjects
7c8094ec kernel32.dll  WaitForMultipleObjectsEx
77d4bbf8 user32.dll    MsgWaitForMultipleObjectsEx
77d4bca8 user32.dll    MsgWaitForMultipleObjects
>> created by main thread ($fa8) at:
4ec958ef gdiplus.dll   

thread $e04:
7c90eb94 ntdll.dll  KiFastSystemCallRet
7c90e9a9 ntdll.dll  NtWaitForMultipleObjects

thread $eb4:
7c90eb94 ntdll.dll     KiFastSystemCallRet
7c90e9be ntdll.dll     NtWaitForSingleObject
7c8025d5 kernel32.dll  WaitForSingleObjectEx
7c80253d kernel32.dll  WaitForSingleObject

thread $a20:
7c90eb94 ntdll.dll  KiFastSystemCallRet
7c90d85a ntdll.dll  NtDelayExecution

thread $7a4:
7c90eb94 ntdll.dll   KiFastSystemCallRet
7c90e397 ntdll.dll   NtReplyWaitReceivePortEx
>> created by thread $970 at:
77e8760d RPCRT4.dll 

DatabaseOutput ($100):
7c90eb94 ntdll.dll        KiFastSystemCallRet
7c90e9be ntdll.dll        NtWaitForSingleObject
7c8025d5 kernel32.dll     WaitForSingleObjectEx
7c80253d kernel32.dll     WaitForSingleObject
7c90eaf5 ntdll.dll        KiUserExceptionDispatcher
7c937b43 ntdll.dll        RtlUnwind
771266ef oleaut32.dll     VariantChangeType
7c90eaf5 ntdll.dll        KiUserExceptionDispatcher
7c937b43 ntdll.dll        RtlUnwind
771266ef oleaut32.dll     VariantChangeType
7c90eaf5 ntdll.dll        KiUserExceptionDispatcher
>> created by main thread ($fa8) at:
008aa37b RecorderApp.exe 

thread $f34:
7c90eb94 ntdll.dll   KiFastSystemCallRet
7c90e397 ntdll.dll   NtReplyWaitReceivePortEx
>> created by thread $7a4 at:
77e8760d RPCRT4.dll 

modules:
00330000 C4DLL.DLL       1.0.0.1          F:\Recorder\Recorder 6 Server
003a0000 MS5User.Dll     5.0.0.4          F:\Recorder\Recorder 6 Server
00400000 RecorderApp.exe 6.14.4.212       F:\Recorder\Recorder 6 Server
01340000 ms5cnv.dll      5.0.0.10         F:\Recorder\Recorder 6 Server
02920000 xpsp2res.dll    5.1.2600.2180    C:\WINDOWS\system32
02c70000 MFC90ENU.DLL    9.0.30729.1      C:\WINDOWS\WinSxS\x86_Microsoft.VC90.MFCLOC_1fc8b3b9a1e18e3b_9.0.30729.1_x-ww_b0db7d03
03740000 SQLOLEDB.RLL    2000.85.1117.0   C:\Program Files\Common Files\System\Ole DB
03750000 msadcer.dll     2.81.1117.0      C:\Program Files\Common Files\System\msadc
03a90000 GOTOGR~1.OCX    2.0.0.16         F:\Recorder\RECORD~2\Addins
03c50000 GoToKey.ocx     6.0.1.8          F:\Recorder\RECORD~2\Addins
03e70000 NBNEXC~1.OCX    6.13.2.24        F:\Recorder\RECORD~1\Addins
040b0000 SHOWUN~1.OCX    6.0.0.11         F:\Recorder\RECORD~2\Addins
042e0000 STDVAL~1.DLL    6.13.2.175       F:\Recorder\RECORD~2\Addins
044e0000 SURVEY~1.OCX    6.0.0.25         F:\Recorder\RECORD~1\Addins
0ffd0000 rsaenh.dll      5.1.2600.2161    C:\WINDOWS\system32
10000000 MS5.Dll         5.0.0.12         F:\Recorder\Recorder 6 Server
20000000 odbcint.dll     3.525.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.1117.0      C:\Program Files\Common Files\System\ado
4ec50000 gdiplus.dll     5.1.3102.2180    C:\WINDOWS\WinSxS\x86_Microsoft.Windows.GdiPlus_6595b64144ccf1df_1.0.2600.2180_x-ww_522f9f82
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.2180   C:\WINDOWS\system32
5d300000 HHCtrl.ocx      5.2.3790.1194    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
62ef0000 AcSignIcon.dll  18.0.55.0        C:\WINDOWS\system32
662b0000 hnetcfg.dll     5.1.2600.2180    C:\WINDOWS\system32
68100000 dssenh.dll      5.1.2600.2133    C:\WINDOWS\system32
69b10000 msxml4.dll      4.20.9818.0      C:\WINDOWS\system32
6d4f0000 DBNETLIB.DLL    2000.85.1117.0   C:\WINDOWS\system32
6fa00000 SOPHOS~1.DLL    1.0.0.4030       C:\PROGRA~1\Sophos\SOPHOS~1
71a50000 mswsock.dll     5.1.2600.2180    C:\WINDOWS\system32
71a90000 wshtcpip.dll    5.1.2600.2180    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.1117.0      C:\Program Files\Common Files\System\msadc
74320000 odbc32.dll      3.525.1117.0     C:\WINDOWS\system32
74720000 MSCTF.dll       5.1.2600.2180    C:\WINDOWS\system32
74e30000 RICHED20.dll    5.30.23.1221     C:\WINDOWS\system32
750b0000 RESUTILS.DLL    5.1.2600.2180    C:\WINDOWS\system32
750f0000 MTXCLU.DLL      2001.12.4414.258 C:\WINDOWS\system32
75130000 colbact.DLL     2001.12.4414.258 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
75e90000 SXS.DLL         5.1.2600.2180    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.3660    C:\WINDOWS\system32
76380000 MSIMG32.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.258 C:\WINDOWS\system32
76780000 SHFolder.dll    6.0.2900.2180    C:\WINDOWS\system32
767a0000 ntdsapi.dll     5.1.2600.2180    C:\WINDOWS\system32
767f0000 schannel.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.0       C:\WINDOWS\system32
76b40000 winmm.dll       5.1.2600.2180    C:\WINDOWS\system32
76bf0000 PSAPI.DLL       5.1.2600.2180    C:\WINDOWS\system32
76c30000 WINTRUST.dll    5.131.2600.2180  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.2180    C:\WINDOWS\system32
76f20000 DNSAPI.dll      5.1.2600.2180    C:\WINDOWS\system32
76f60000 WLDAP32.dll     5.1.2600.2180    C:\WINDOWS\system32
76fb0000 winrnr.dll      5.1.2600.2180    C:\WINDOWS\System32
76fc0000 rasadhlp.dll    5.1.2600.2180    C:\WINDOWS\system32
76fd0000 CLBCATQ.DLL     2001.12.4414.258 C:\WINDOWS\system32
77050000 COMRes.dll      2001.12.4414.258 C:\WINDOWS\system32
77120000 oleaut32.dll    5.1.2600.2180    C:\WINDOWS\system32
771b0000 WININET.dll     6.0.2900.3660    C:\WINDOWS\system32
773d0000 comctl32.dll    6.0.2900.2180    C:\WINDOWS\WinSxS\x86_Microsoft.Windows.Common-Controls_6595b64144ccf1df_6.0.2600.2180_x-ww_a84f1ff9
774e0000 ole32.dll       5.1.2600.2180    C:\WINDOWS\system32
77920000 SETUPAPI.dll    5.1.2600.2938    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.2180    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.2180    C:\WINDOWS\system32
77d40000 user32.dll      5.1.2600.2180    C:\WINDOWS\system32
77dd0000 advapi32.dll    5.1.2600.2180    C:\WINDOWS\system32
77e70000 RPCRT4.dll      5.1.2600.2180    C:\WINDOWS\system32
77f10000 GDI32.dll       5.1.2600.2180    C:\WINDOWS\system32
77f60000 SHLWAPI.dll     6.0.2900.3653    C:\WINDOWS\system32
77fe0000 Secur32.dll     5.1.2600.2180    C:\WINDOWS\system32
78520000 MSVCR90.dll     9.0.30729.1      C:\WINDOWS\WinSxS\x86_Microsoft.VC90.CRT_1fc8b3b9a1e18e3b_9.0.30729.1_x-ww_6f74963e
789e0000 mfc90u.dll      9.0.30729.1      C:\WINDOWS\WinSxS\x86_Microsoft.VC90.MFC_1fc8b3b9a1e18e3b_9.0.30729.1_x-ww_405b0943
7c800000 kernel32.dll    5.1.2600.2180    C:\WINDOWS\system32
7c900000 ntdll.dll       5.1.2600.2180    C:\WINDOWS\system32
7c9c0000 shell32.dll     6.0.2900.2180    C:\WINDOWS\system32
7e1e0000 urlmon.dll      6.0.2900.3660    C:\WINDOWS\system32
7e290000 shdocvw.dll     6.0.2900.3660    C:\WINDOWS\system32

Martin Horlock
Norfolk Biodiversity information Service

mhorlock's Website

2 Reply by johnvanbreda

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

Re: Export to NBN Zipped Access problem

Hi Martin,
Not sure why this would happen at all, but I'm just wondering if the problem is still there today? It might be that having restarted Recorder, the stuff that was breaking things got cleaned up.

John van Breda
Biodiverse IT

johnvanbreda's Website

3 Reply by mhorlock

  • mhorlock
  • Member
  • Offline
  • From: Norwich
  • Registered: 07-01-2009
  • Posts: 17

Re: Export to NBN Zipped Access problem

Hi John

The problem is still there this morning. It isn't warning me about invalid records so that must be sorted. It just comes up with the same error when I try to export.

Martin

Martin Horlock
Norfolk Biodiversity information Service

mhorlock's Website

4 Reply by johnvanbreda

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

Re: Export to NBN Zipped Access problem

Hi Martin,
Is there any chance you could get your copy of Recorder updated to the latest version 6.15? This gives much better information for diagnosing problems in the error messages.
Also, do you get this error if you export, say, just 1 record?
Regards

John van Breda
Biodiverse IT

johnvanbreda's Website

5 Reply by mhorlock

  • mhorlock
  • Member
  • Offline
  • From: Norwich
  • Registered: 07-01-2009
  • Posts: 17

Re: Export to NBN Zipped Access problem

John

I am able to export small amounts of data. I have exported this dataset previously with no problems. That time I even got away with dropping the invalid records. However even splitting the dataset into much smaller chunks is not working. It seems to get hung up in the process when it gets to the point "gathering data for export - substrate". I have also been having problems in that our county council IT people keep having to close the process down as Recorder is taking up 100% of the memory on the sequel server.

I have a couple of questions.

Is it possible that there is data that is not being cleared from these failed exports which is causing problems? If so how can I deal with this?

Will upgrading to 6.15 make ant difference other than a more detailed error meassge.

Thanks
Martin

Martin Horlock
Norfolk Biodiversity information Service

mhorlock's Website

6 Reply by Mary Campling

  • Mary Campling
  • Administrator
  • Offline
  • Registered: 16-04-2010
  • Posts: 101

Re: Export to NBN Zipped Access problem

Dear Martin,

You may need to restrict Recorders memory allowance on the SQL server to prevent the server grinding to a halt. We recommend allowing it to use 2/3rds of the memory, or 1/2 if there are a number of other processes using it. You might also consider a RAM upgrade for the server. John van Breda recommends at least 2Gb, ideally 3Gb for 32 bit Windows, or 4Gb upwards for 64 bit Windows

The forced closure of Recorder when this happens may be leaving some of the Import temporary tables in the database, causing Recorder to fail on future imports. The upgrade to 6.15 may help us diagnose any issues and recreate your environment for reproducing errors.

I will certainly add the issues you have experienced to the investigations/bugs list, namely any inefficiencies in the export process and reasons for export failings after ending Recorder mid-export.

Hope this helps, Mary

7 Reply by charlesroper

  • charlesroper
  • charlesroper
  • Digital Development Manager
  • Offline
  • From: Field Studies Council
  • Registered: 26-03-2006
  • Posts: 906

Re: Export to NBN Zipped Access problem

I am getting this error when trying to do an export of 43,649 occurrences and it is also based on a fairly large polygon (5MB PDF of the area here). Recorder is at version 6.16.2.241. I also tried exporting as an XML file and got a different error (the exception was "List index out of bounds" or similar - I'll try again and post more info if needed). Here's the error when exporting to NBN Access Database (zipped).

date/time         : 2011-12-02, 14:35:51, 560ms
computer name     : BRC_VOL_2
user name         : charlesr
operating system  : Windows XP Service Pack 3 build 2600
system language   : English
system up time    : 2 hours 46 minutes
program up time   : 13 minutes 15 seconds
processors        : 4x Intel(R) Core(TM) i5 CPU       M 520  @ 2.40GHz
physical memory   : 2339/3063 MB (free/total)
free disk space   : (C:) 378.61 GB (T:) 60.78 GB
display mode      : 1600x900, 32 bit
process id        : $106c
allocated memory  : 37.78 MB
command line      : RecorderApp.exe /786696
executable        : RecorderApp.exe
exec. date/time   : 2011-01-18 13:50
version           : 6.16.2.241
madExcept version : 2.7k
exception class   : EOleException
exception message : Cannot drop the table '#TAXON_OCCURRENCE', because it does not exist or you do not have permission.

main thread ($116c):
00000000 ???                                 
00450cb9 RecorderApp.exe Classes              CheckSynchronize
004d4ce7 RecorderApp.exe Forms                TApplication.WndProc
004529d0 RecorderApp.exe Classes              StdWndProc
7e4196c2 user32.dll                           DispatchMessageA
004d527b RecorderApp.exe Forms                TApplication.ProcessMessage
004d52b2 RecorderApp.exe Forms                TApplication.HandleMessage
004d1dc1 RecorderApp.exe Forms                TCustomForm.ShowModal
00998a13 RecorderApp.exe FormActions 1144 +35 TdmFormActions.actExportExecute
00451d1b RecorderApp.exe Classes              TBasicAction.Execute
004bf67d RecorderApp.exe ActnList             TContainedAction.Execute
004c031f RecorderApp.exe ActnList             TCustomAction.Execute
00451bef RecorderApp.exe Classes              TBasicActionLink.Execute
004c5e3b RecorderApp.exe Menus                TMenuItem.Click
004c70ef RecorderApp.exe Menus                TMenu.DispatchCommand
004c7ea6 RecorderApp.exe Menus                TPopupList.WndProc
004c7df5 RecorderApp.exe Menus                TPopupList.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 $11f4:
7c90e514 ntdll.dll                 KiFastSystemCallRet
7c90df48 ntdll.dll                 NtWaitForMultipleObjects
7c80958a 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 ($116c) at:
4ec67f66 gdiplus.dll               

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

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

thread $1724:
7c90e514 ntdll.dll     KiFastSystemCallRet
7c90df48 ntdll.dll     NtWaitForMultipleObjects
7c80958a kernel32.dll  WaitForMultipleObjectsEx
7c80a110 kernel32.dll  WaitForMultipleObjects

thread $1274:
7c90e514 ntdll.dll                 KiFastSystemCallRet
7c90daa8 ntdll.dll                 NtReplyWaitReceivePortEx
0042b939 RecorderApp.exe madExcept CallThreadProc
0042b97b RecorderApp.exe madExcept ThreadExceptFrame
>> created by thread $11cc at:
77e7d10d RPCRT4.dll               

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

thread $17b4:
7c90e514 ntdll.dll  KiFastSystemCallRet
7c90da48 ntdll.dll  NtRemoveIoCompletion

thread $1398:
7c90e514 ntdll.dll                 KiFastSystemCallRet
7c90df48 ntdll.dll                 NtWaitForMultipleObjects
7c80958a kernel32.dll              WaitForMultipleObjectsEx
0042b939 RecorderApp.exe madExcept CallThreadProc
0042b97b RecorderApp.exe madExcept ThreadExceptFrame
>> created by main thread ($116c) at:
77e062d0 advapi32.dll             

thread $16b0:
7c90e514 ntdll.dll  KiFastSystemCallRet
7c90da48 ntdll.dll  NtRemoveIoCompletion

thread $1478:
7c90e514 ntdll.dll                 KiFastSystemCallRet
7c90d218 ntdll.dll                 NtDelayExecution
7c8023eb kernel32.dll              SleepEx
7c802450 kernel32.dll              Sleep
0042b939 RecorderApp.exe madExcept CallThreadProc
0042b97b RecorderApp.exe madExcept ThreadExceptFrame
>> created by thread $17b4 at:
775309b3 ole32.dll                 

thread $137c:
7c90e514 ntdll.dll                 KiFastSystemCallRet
7c90daa8 ntdll.dll                 NtReplyWaitReceivePortEx
0042b939 RecorderApp.exe madExcept CallThreadProc
0042b97b RecorderApp.exe madExcept ThreadExceptFrame
>> created by thread $1274 at:
77e7d10d RPCRT4.dll               

DatabaseOutput ($638):
7c90e514 ntdll.dll                                      KiFastSystemCallRet
7c90df58 ntdll.dll                                      NtWaitForSingleObject
7c8025d5 kernel32.dll                                   WaitForSingleObjectEx
7c80253d kernel32.dll                                   WaitForSingleObject
004510f8 RecorderApp.exe Classes                        TThread.Synchronize
0045118c RecorderApp.exe Classes                        TThread.Synchronize
008fb3e9 RecorderApp.exe ThreadedDatabaseOutput 176  +5 TThreadedDatabaseOutput.HandleException
008fb395 RecorderApp.exe ThreadedDatabaseOutput 163 +16 TThreadedDatabaseOutput.Execute
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
00573ee0 RecorderApp.exe ADODB                          TADOCommand.Execute
00573ec0 RecorderApp.exe ADODB                          TADOCommand.Execute
005c502a RecorderApp.exe DatabaseAccessADO      903 +11 TdmDatabase.ExecuteSQL
005ccb3f RecorderApp.exe DatabaseOutput         705  +3 TDatabaseOutput.CleanupTempTables
005cc89b RecorderApp.exe DatabaseOutput         682 +46 TDatabaseOutput.Execute
00404d6e RecorderApp.exe System                         @HandleFinally
7c92ab7c ntdll.dll                                      RtlUnwind
00404b62 RecorderApp.exe System                         @HandleAnyException
77126bd1 oleaut32.dll                                   VariantChangeType
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
00573ee0 RecorderApp.exe ADODB                          TADOCommand.Execute
00573ec0 RecorderApp.exe ADODB                          TADOCommand.Execute
005c502a RecorderApp.exe DatabaseAccessADO      903 +11 TdmDatabase.ExecuteSQL
005cc790 RecorderApp.exe DatabaseOutput         657 +21 TDatabaseOutput.Execute
008fb356 RecorderApp.exe ThreadedDatabaseOutput 157 +10 TThreadedDatabaseOutput.Execute
0042ba06 RecorderApp.exe madExcept                      HookedTThreadExecute
00450d90 RecorderApp.exe Classes                        ThreadProc
00405470 RecorderApp.exe System                         ThreadWrapper
0042b939 RecorderApp.exe madExcept                      CallThreadProc
0042b97b RecorderApp.exe madExcept                      ThreadExceptFrame
>> created by main thread ($116c) at:
008fb0e6 RecorderApp.exe ThreadedDatabaseOutput 100  +1 TThreadedDatabaseOutput.Create

modules:
00340000 C4DLL.DLL             1.0.0.1          T:\Recorder 6 Server
003b0000 MS5User.Dll           5.0.0.4          T:\Recorder 6 Server
00400000 RecorderApp.exe       6.16.2.241       T:\Recorder 6 Server
01430000 ms5cnv.dll            5.0.0.10         T:\Recorder 6 Server
01c40000 odbcint.dll           3.525.1132.0     C:\WINDOWS\system32
01f20000 DpoFeedb.dll          5.0.0.3765       C:\Program Files\DigitalPersona\Bin
01fe0000 btmmhook.dll          5.5.0.8400       C:\WINDOWS\system32
02660000 LMIRfsClientNP.dll    2.1.3.0          C:\WINDOWS\system32
02780000 DropboxExt.14.dll     1.0.0.14         C:\Documents and Settings\charlesr\Application Data\Dropbox\bin
02cc0000 xpsp2res.dll          5.1.2600.5512    C:\WINDOWS\system32
02f90000 btkeyind.dll                           C:\Program Files\WIDCOMM\Bluetooth Software
03090000 DpoSet.dll            5.0.0.3765       C:\Program Files\DigitalPersona\Bin
04180000 SQLOLEDB.RLL          2000.85.1132.0   C:\Program Files\Common Files\System\Ole DB
04190000 msadcer.dll           2.81.1132.0      C:\Program Files\Common Files\System\msadc
04700000 DpFbview.dll          5.0.0.3765       C:\Program Files\DigitalPersona\Bin
066a0000 Normaliz.dll          6.0.5441.0       C:\WINDOWS\system32
10000000 MS5.Dll               5.0.0.12         T:\Recorder 6 Server
10930000 PortableDeviceApi.dll 5.2.5721.5145    C:\WINDOWS\system32
20000000 xpsp3res.dll          5.1.2600.5512    C:\WINDOWS\system32
3d930000 WININET.dll           7.0.6000.17103   C:\WINDOWS\system32
3dfd0000 iertutil.dll          7.0.6000.17103   C:\WINDOWS\system32
3e1c0000 ieframe.dll           7.0.6000.17103   C:\WINDOWS\system32
4dd00000 sqloledb.dll          2000.85.1132.0   C:\Program Files\Common Files\System\Ole DB
4de10000 msado15.dll           2.81.3012.0      C:\Program Files\Common Files\System\ado
4ec50000 gdiplus.dll           5.2.6002.22509   C:\WINDOWS\WinSxS\x86_Microsoft.Windows.GdiPlus_6595b64144ccf1df_1.0.6002.22509_x-ww_c7dad023
55600000 FwcWsp.dll            4.0.3442.654     C:\Program Files\Microsoft Firewall Client 2004
59a60000 dbghelp.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
60390000 dfdll.dll             4.0.30319.1      c:\WINDOWS\Microsoft.NET\Framework\v4.0.30319
603b0000 mscoreei.dll          4.0.30319.237    c:\WINDOWS\Microsoft.NET\Framework\v4.0.30319
60510000 dfshim.dll            4.0.31106.0      c:\WINDOWS\system32
60e30000 MSDATL3.dll           2.81.1132.0      C:\Program Files\Common Files\System\Ole DB
61880000 OLEACC.dll            7.0.2600.6153    C:\WINDOWS\system32
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.30.2107.0      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.3012.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.5768    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.6108    C:\WINDOWS\system32
76980000 LINKINFO.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
76bf0000 PSAPI.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.6089    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.6058    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.6154  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            7.0.6000.17103   C:\WINDOWS\system32
79000000 mscoree.dll           4.0.31106.0      c:\WINDOWS\system32
79060000 MSVCR100_CLR0400.dll  10.0.30319.1     C:\WINDOWS\system32
79140000 clr.dll               4.0.30319.239    c:\WINDOWS\Microsoft.NET\Framework\v4.0.30319
7c340000 MSVCR71.dll           7.10.3052.4      C:\Documents and Settings\charlesr\Application Data\Dropbox\bin
7c3a0000 MSVCP71.dll           7.10.3077.0      C:\Documents and Settings\charlesr\Application Data\Dropbox\bin
7c800000 kernel32.dll          5.1.2600.5781    C:\WINDOWS\system32
7c900000 ntdll.dll             5.1.2600.6055    C:\WINDOWS\system32
7c9c0000 shell32.dll           6.0.2900.6072    C:\WINDOWS\system32
7e290000 SHDOCVW.dll           6.0.2900.5921    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

Charles Roper
Digital Development Manager | Field Studies Council
http://www.field-studies-council.org | https://twitter.com/charlesroper | https://twitter.com/fsc_digital

charlesroper's Website

8 Reply by charlesroper

  • charlesroper
  • charlesroper
  • Digital Development Manager
  • Offline
  • From: Field Studies Council
  • Registered: 26-03-2006
  • Posts: 906

Re: Export to NBN Zipped Access problem

Anyone have any word on this problem? We need to export data to a partner, but this problem is preventing us from doing so.

John: The enhanced error reporting you talk about, is this something we need to enable? The error report I posted above looks the same as the ones generated by previous versions of Recorder; i.e., not enhanced.

Charles Roper
Digital Development Manager | Field Studies Council
http://www.field-studies-council.org | https://twitter.com/charlesroper | https://twitter.com/fsc_digital

charlesroper's Website

9 Reply by sallyrankin

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

Re: Export to NBN Zipped Access problem

Have you considered using Problems V2.zip from http://forums.nbn.org.uk/uploads.php to see whether it could be a data problem? The documentation in the zip file explains the xml reports and batch updates it contains for detecting and resolving problems that Mike Weideli and I have seen in Recorder databases over the years. A Google site search for ‘Cannot drop the table '#TAXON_OCCURRENCE’ didn’t return anything useful but googling ‘NBN Forum List index out of bounds’ took me to http://forums.nbn.org.uk/viewtopic.php?id=903 where there are some examples. I think the causes of these particular problems have been fixed but you may have data in the system from before they were fixed or other problems.

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

10 Reply by charlesroper

  • charlesroper
  • charlesroper
  • Digital Development Manager
  • Offline
  • From: Field Studies Council
  • Registered: 26-03-2006
  • Posts: 906

Re: Export to NBN Zipped Access problem

Hi Sally,

Could you please attach the "Problems V2.zip" to this thread as the downloads page is no longer part of this forum. Or is it available elsewhere?

Cheers,
Charles

Charles Roper
Digital Development Manager | Field Studies Council
http://www.field-studies-council.org | https://twitter.com/charlesroper | https://twitter.com/fsc_digital

charlesroper's Website

11 Reply by MikeWeideli

  • MikeWeideli
  • Administrator
  • Offline
  • From: Littlefield Consultancy
  • Registered: 05-07-2006
  • Posts: 2,645

Re: Export to NBN Zipped Access problem

Current version attached.

Post's attachments

ProblemsV2.zip 41.86 kb, 4 downloads since 2013-05-02 

You don't have the permssions to download the attachments of this post.
Mike Weideli

MikeWeideli's Website