1 Topic by RobLarge

  • RobLarge
  • RobLarge
  • Veteran
  • Offline
  • From: Wiltshire
  • Registered: 15-07-2008
  • Posts: 812

Topic: Contribute to recording scheme error

We are getting an error when trying to contribute to a recording scheme. The underlying filter works (I have tested it & the EXPORT_FILTERS.LAST_EXPORT_DATE field is set to today's date) but I have never contributed to the scheme before (RECORDING_SCHEME.LAST_CONTRIBUTION_DATE is null).

When I try to contribute to the scheme I get the attached message.

Has anyone else seen this?

I subsequently tested using a recording scheme which had contributed successfully in the past, this time it ran through without error.

Finally, in SQLSMS I edited the RECORDING_SCHEME.LAST_CONTRIBUTION_DATE of the recording scheme which caused the error, setting it to a date a long way in the past and it ran to completion without issue.

So it looks like I cannot run a contribution to a scheme for which I have never contributed before, but I can for schemes where I have contributed before.

HELP

Post's attachments

Error-73526344040475.txt 25.06 kb, 3 downloads since 2014-01-30 

You don't have the permssions to download the attachments of this post.
Rob Large
Wildlife Sites Officer
Wiltshire & Swindon Biological Records Centre

RobLarge's Website

2 Reply by RobLarge (edited by RobLarge 30-01-2014 16:57:55)

  • RobLarge
  • RobLarge
  • Veteran
  • Offline
  • From: Wiltshire
  • Registered: 15-07-2008
  • Posts: 812

Re: Contribute to recording scheme error

OK a little more clarity.

It turns out that my confusion about the problem is due to a) My inability to properly read dialog messages AND b) a rather perverse bit of dialog wording.

When attempting to contribute to a recording scheme for the first time a dialog pops up asking whether you wish to contribute all records or just today's records. The question itself seems odd, since why would you wish to submit today's records any more than any other specific date?

Oddness notwithstanding, the dialog says that if you want to return just today's records click yes, or to return all records click no. To my mind it would be more logical to have the options the other way around, since it seems far more likely that you would want to return all records rather than just a very few.

So, this morning I was clicking yes when I should have clicked no. Since there has been no data entered today, the filter was returning no records and that was the cause of the crash above. I should have known that as the crash was almost instantaneous, whereas the filter usually takes a few minutes to run.

So. I successfully managed to run the scheme contribution later on, but then ran it again as a test. Now I no longer get asked whether I want to do just today's (because the contribution date is now set to today's date), instead the filter runs, returning no records entered since today and then crashes exactly the same way as above.

So there's the problem, returning no data causes the crash, that ought to be an easy fix.

Rob Large
Wildlife Sites Officer
Wiltshire & Swindon Biological Records Centre

RobLarge's Website

3 Reply by RobLarge

  • RobLarge
  • RobLarge
  • Veteran
  • Offline
  • From: Wiltshire
  • Registered: 15-07-2008
  • Posts: 812

Re: Contribute to recording scheme error

Just checking up. Has this (crashing when no records selected) been logged as a bug?

Rob Large
Wildlife Sites Officer
Wiltshire & Swindon Biological Records Centre

RobLarge's Website

4 Reply by MikeWeideli

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

Re: Contribute to recording scheme error

Rob

I can reproduce this and it has been logged as a bug (Issue No. 466)

Mike

Mike Weideli

MikeWeideli's Website

5 Reply by RobLarge

  • RobLarge
  • RobLarge
  • Veteran
  • Offline
  • From: Wiltshire
  • Registered: 15-07-2008
  • Posts: 812

Re: Contribute to recording scheme error

Thanks Mike, while I'm at it though I have had some other thoughts on this functionality. I realise that this comes under the heading 'aspiration', rather than a priority (and in any case we have a good workaround).

There is currently no means of directly (within the UI) editing the date of last submission to a scheme. This means that if a submission is run but reveals flaws in the data and needs to be re-run, it is necessary to edit the date by other means. Related to that, the database does not currently record submission history, so if the situation I have just described does occur, there is no way to rollback to a previous submission date.

It would be good to log this also somewhere.

Rob Large
Wildlife Sites Officer
Wiltshire & Swindon Biological Records Centre

RobLarge's Website

6 Reply by MikeWeideli

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

Re: Contribute to recording scheme error

Rob

I didn't knowe that. On surface of it looks like you should be able to edit the date as you can edit the other fields, but as you point out you can't. Will log both the points  as a development.

Mike Weideli

MikeWeideli's Website

7 Reply by RobLarge

  • RobLarge
  • RobLarge
  • Veteran
  • Offline
  • From: Wiltshire
  • Registered: 15-07-2008
  • Posts: 812

Re: Contribute to recording scheme error

Thanks again, having discussed this quite a bit lately with colleagues who are more involved in the submissions than I, I have a lot of other things in this general area that I could point out, but am surprised that more people have not mentioned them. I suspect this is because (as here in Wiltshire) very few of our county recorders use R6, so we are having to find ways to manage data exchanges between R6 & MapMate (or other systems), which necessitates some post-processing of the submission  output into a suitable format.

The most obvious problem that I can find, from our perspective, is that the filter underlying the submission process is, as far as I can tell, entirely made up of inclusions. That is to say it is designed to include selected Surveys, Tags or higher taxa. There is no option to exclude specific items.

This means that while we can export and process data for a county recorder who uses Mapmate and manage the submission dates effectively, we do not have an effective way of excluding data which originated from that recorder (unless it went in prior to the last submission date). Well we could keep all that recorder's data in a single survey and then filter on the relevant higher taxa and include all surveys except that one, but this means that the filter must be edited every time a new survey is added which might contain records of that taxon group.

Rob Large
Wildlife Sites Officer
Wiltshire & Swindon Biological Records Centre

RobLarge's Website

8 Reply by MikeWeideli

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

Re: Contribute to recording scheme error

I  have registered a requirement to investigate this further (Issue 467). Being a self contained process, it might be  a good candidate for an addin.

Mike Weideli

MikeWeideli's Website

9 Reply by Purgle Linham

  • Purgle Linham
  • Veteran
  • Offline
  • From: Wiltshire
  • Registered: 30-03-2009
  • Posts: 99

Re: Contribute to recording scheme error

Hi
In relation the the above I have been trying to generate an export filter to query all vascular plant records for the VCR but have found that it crashes each time. I've revalidated the entire database and run the problems xml and these are both clear.

The filter was created by dragging and dropping all phyla from the vascular plant checklist with no other filters. I did the same for bryophytes (dragging the 3 classes into the filter) and it worked fine. I then tried again with just Coniferophyta which again crashed  (message below). i then tried again with each separate family within conifersm building up so all were in the filter and these were all fine. I then tried dragging just Pinopsida and again this works ok.

The only thing that seems different between the Coniferophyta phylum and Pinopsida class is that there is not a record in our database specifically for the former and there is for the latter. But the latter filter pulls out everything from Pinopsida and below so I can't see why this would affect things. It might provide a clue though?

I've just spent about a week trying to make this work so am once again rather fed up with the filter function. It just doesn't seem to be fit for purpose to share data with County Recorders or recording schemes.

Thanks
Purgle


date/time         : 2014-06-02, 16:11:22, 604ms
computer name     : WWT-0124
user name         : Purglel
registered owner  : user
operating system  : Windows 7 Service Pack 1 build 7601
system language   : English
system up time    : 6 hours 41 minutes
program up time   : 1 hour 6 minutes
processors        : 2x Intel(R) Pentium(R) CPU G630 @ 2.70GHz
physical memory   : 1282/3488 MB (free/total)
free disk space   : (C:) 178.51 GB
display mode      : 1920x1080, 32 bit
process id        : $ebc
allocated memory  : 83.57 MB
command line      : RecorderApp.exe /6882296
executable        : RecorderApp.exe
exec. date/time   : 2014-03-24 12:48
version           : 6.22.2.274
compiled with     : Delphi 7
madExcept version : 3.0n
callstack crc     : $5b5c45c7, $ec657322, $ec657322
exception number  : 1
exception class   : EOleException
exception message : Invalid object name '#SURVEY'.

main thread ($9e8):
0059bba6 RecorderApp.exe ADODB                      TADOCommand.Execute
0059bb00 RecorderApp.exe ADODB                      TADOCommand.Execute
0059bae0 RecorderApp.exe ADODB                      TADOCommand.Execute
005f0e02 RecorderApp.exe DatabaseAccessADO  907 +11 TdmDatabase.ExecuteSQL
005fafa3 RecorderApp.exe DatabaseOutput    1144 +16 TDatabaseOutput.RemoveTempSurveyDataRecurse
005fa7d5 RecorderApp.exe DatabaseOutput    1114  +7 TDatabaseOutput.RemoveTempSurveyData
005f86b5 RecorderApp.exe DatabaseOutput     678 +38 TDatabaseOutput.Execute
009f8562 RecorderApp.exe RecordingSchemes   319 +10 TSchemeManager.CreateContributionZIP
009f7f17 RecorderApp.exe RecordingSchemes   223 +22 TSchemeManager.ExportFileToScheme
009f7a89 RecorderApp.exe RecordingSchemes   160 +43 TSchemeManager.ContributeToScheme
004eed56 RecorderApp.exe Menus                      TMenuItem.Click
004efff3 RecorderApp.exe Menus                      TMenu.DispatchCommand
004f0daa RecorderApp.exe Menus                      TPopupList.WndProc
004f0cf9 RecorderApp.exe Menus                      TPopupList.MainWndProc
00430c3c RecorderApp.exe Classes                    StdWndProc
75d22e3c user32.dll                                 DispatchMessageA
004fe2fb RecorderApp.exe Forms                      TApplication.ProcessMessage
004fe332 RecorderApp.exe Forms                      TApplication.HandleMessage
004fe562 RecorderApp.exe Forms                      TApplication.Run
00a95918 RecorderApp.exe RecorderApp        414 +79 initialization
7740ee1a kernel32.dll                               BaseThreadInitThunk

thread $6cc:
77976a42 ntdll.dll                 NtWaitForMultipleObjects
75ac6a88 KERNELBASE.dll            WaitForMultipleObjectsEx
7740be29 kernel32.dll              WaitForMultipleObjectsEx
75d262f3 user32.dll                MsgWaitForMultipleObjectsEx
75d237f2 user32.dll                MsgWaitForMultipleObjects
00476bed RecorderApp.exe madExcept CallThreadProcSafe
00476c57 RecorderApp.exe madExcept ThreadExceptFrame
7740ee1a kernel32.dll              BaseThreadInitThunk
>> created by main thread ($9e8) at:
7740dd8d kernel32.dll              CreateThread

thread $6d8:
77976a42 ntdll.dll     NtWaitForMultipleObjects
7740ee1a kernel32.dll  BaseThreadInitThunk

thread $9ac:
77976a42 ntdll.dll                 NtWaitForMultipleObjects
00476bed RecorderApp.exe madExcept CallThreadProcSafe
00476c57 RecorderApp.exe madExcept ThreadExceptFrame
7740ee1a kernel32.dll              BaseThreadInitThunk
>> created by main thread ($9e8) at:
7740dd8d kernel32.dll              CreateThread

thread $1718:
77976a62 ntdll.dll                 NtWaitForSingleObject
75ac1796 KERNELBASE.dll            WaitForSingleObjectEx
7740c3ce kernel32.dll              WaitForSingleObjectEx
7740c37d kernel32.dll              WaitForSingleObject
00476bed RecorderApp.exe madExcept CallThreadProcSafe
00476c57 RecorderApp.exe madExcept ThreadExceptFrame
7740ee1a kernel32.dll              BaseThreadInitThunk
>> created by main thread ($9e8) at:
7740dd8d kernel32.dll              CreateThread

thread $fcc:
77976a72 ntdll.dll     NtWaitForWorkViaWorkerFactory
7740ee1a kernel32.dll  BaseThreadInitThunk

thread $8c4:
77976a72 ntdll.dll     NtWaitForWorkViaWorkerFactory
7740ee1a kernel32.dll  BaseThreadInitThunk

thread $1724:
77976a72 ntdll.dll     NtWaitForWorkViaWorkerFactory
7740ee1a kernel32.dll  BaseThreadInitThunk

modules:
001d0000 C4DLL.DLL              1.0.0.1            \\wwtsql01\recorder6
00240000 MS5User.Dll            5.0.0.4            \\wwtsql01\recorder6
003b0000 ms5cnv.dll             5.0.0.10           \\wwtsql01\recorder6
00400000 RecorderApp.exe        6.22.2.274         \\wwtsql01\recorder6
01cb0000 security.dll           6.1.7600.16385     C:\Windows\system32
05fe0000 GotoKey2.dll                              \\wwtsql01\recorder6\Addins
06a60000 NBNExchangeAddinNu.dll                    \\wwtsql01\recorder6\Addins
079b0000 ProjectRuck3.ocx                          \\wwtsql01\recorder6\Addins
07b80000 ShowUnchecked.ocx      6.0.0.13           \\wwtsql01\recorder6\Addins
07d90000 StdValLib.dll          6.15.1.230         \\wwtsql01\recorder6\Addins
07f70000 SurveyDelete.ocx       6.0.0.29           \\wwtsql01\recorder6\Addins
0f9a0000 VBAJET32.DLL           6.0.1.9431         C:\Windows\system32
0f9c0000 expsrv.dll             6.0.72.9589        C:\Windows\system32
10000000 MS5.Dll                5.0.0.12           \\wwtsql01\recorder6
55b60000 msjet40.dll            4.0.9756.0         C:\Windows\system32
56050000 sqloledb.dll           6.1.7601.17514     C:\Program Files\Common Files\System\Ole DB
5af20000 mswstr10.dll           4.0.9756.0         C:\Windows\system32
5afc0000 comsvcs.dll            2001.12.8530.16385 C:\Windows\system32
5b100000 oledb32.dll            6.1.7601.17514     C:\Program Files\Common Files\System\Ole DB
5b1e0000 msado15.dll            6.1.7601.17857     C:\Program Files\Common Files\System\ado
5b9d0000 msjtes40.dll           4.0.9756.0         C:\Windows\system32
5ba20000 msjetoledb40.dll       4.0.9756.0         C:\Windows\system32
5ba80000 HHCtrl.ocx             6.1.7600.16385     C:\Windows\system32
5c250000 msadox.dll             6.1.7601.17857     C:\Program Files\Common Files\System\ado
5c2f0000 msjro.dll              6.1.7601.17857     C:\Program Files\Common Files\System\ado
5c320000 odbccp32.dll           6.1.7601.17632     C:\Windows\system32
63ed0000 msadrh15.dll           6.1.7600.16385     C:\Program Files\Common Files\System\ado
63f10000 msadce.dll             6.1.7601.17514     C:\Program Files\Common Files\System\msadc
640e0000 odbc32.dll             6.1.7601.17514     C:\Windows\system32
66620000 DBNETLIB.DLL           6.1.7600.16385     C:\Windows\system32
69b10000 msxml4.dll             4.20.9876.0        c:\Windows\system32
6aad0000 wsock32.dll            6.1.7600.16385     C:\Windows\system32
6aae0000 msader15.dll           6.1.7600.16385     C:\Program Files\Common Files\System\ado
6cab0000 MSJINT40.DLL           4.0.9756.0         C:\Windows\system32
6d8a0000 SHFolder.dll           6.1.7600.16385     C:\Windows\system32
6de30000 winspool.drv           6.1.7601.17514     C:\Windows\system32
6e000000 avcuf32.dll            3.10.9180.5065     C:\Program Files\Bitdefender\Endpoint\Signatures\AVC\AVC3_00243_001
70190000 comctl32.dll           5.82.7601.18201    C:\Windows\WinSxS\x86_microsoft.windows.common-controls_6595b64144ccf1df_5.82.7601.18201_none_ec80f00e8593ece5
713b0000 odbcint.dll            6.1.7600.16385     C:\Windows\system32
71400000 msjter40.dll           4.0.9756.0         C:\Windows\system32
71420000 SQLOLEDB.RLL           6.1.7600.16385     C:\Program Files\Common Files\System\Ole DB
71440000 netbios.dll            6.1.7600.16385     C:\Windows\system32
718c0000 msadcer.dll            6.1.7600.16385     C:\Program Files\Common Files\System\msadc
718d0000 MSDATL3.dll            6.1.7600.16385     C:\Program Files\Common Files\System\Ole DB
719c0000 OLEDB32R.DLL           6.1.7600.16385     C:\Program Files\Common Files\System\Ole DB
725f0000 mpr.dll                6.1.7600.16385     C:\Windows\system32
72e30000 ntdsapi.dll            6.1.7600.16385     C:\Windows\system32
72e50000 rasadhlp.dll           6.1.7600.16385     C:\Windows\system32
736d0000 fwpuclnt.dll           6.1.7601.18283     C:\Windows\System32
73800000 WINNSI.DLL             6.1.7600.16385     C:\Windows\system32
73810000 IPHLPAPI.DLL           6.1.7601.17514     C:\Windows\system32
738c0000 MSDART.DLL             6.1.7600.16385     C:\Windows\system32
73c40000 ATL.DLL                3.5.2284.0         C:\Windows\system32
73d90000 winmm.dll              6.1.7601.17514     C:\Windows\system32
73dd0000 olepro32.dll           6.1.7601.17514     C:\Windows\system32
74000000 wkscli.dll             6.1.7601.17514     C:\Windows\system32
74010000 NETAPI32.dll           6.1.7601.17887     C:\Windows\system32
746b0000 gdiplus.dll            6.1.7601.18120     C:\Windows\WinSxS\x86_microsoft.windows.gdiplus_6595b64144ccf1df_1.1.7601.18120_none_72d2e82386681b36
74840000 uxtheme.dll            6.1.7600.16385     C:\Windows\system32
74880000 dwmapi.dll             6.1.7600.16385     C:\Windows\system32
748b0000 Comctl32.dll           6.10.7601.17514    C:\Windows\WinSxS\x86_microsoft.windows.common-controls_6595b64144ccf1df_6.0.7601.17514_none_41e6975e2bd6f2b2
74e50000 version.dll            6.1.7600.16385     C:\Windows\system32
74ee0000 wshtcpip.dll           6.1.7600.16385     C:\Windows\System32
75060000 credssp.dll            6.1.7601.18409     C:\Windows\system32
750a0000 bcryptprimitives.dll   6.1.7600.16385     C:\Windows\system32
75150000 netutils.dll           6.1.7601.17514     C:\Windows\system32
75160000 rsaenh.dll             6.1.7600.16385     C:\Windows\system32
75240000 DNSAPI.dll             6.1.7601.17570     C:\Windows\system32
75350000 msv1_0.DLL             6.1.7601.18409     C:\Windows\system32
753a0000 wship6.dll             6.1.7600.16385     C:\Windows\System32
753b0000 mswsock.dll            6.1.7601.18254     C:\Windows\system32
753f0000 CRYPTSP.dll            6.1.7600.16385     C:\Windows\system32
75520000 srvcli.dll             6.1.7601.17514     C:\Windows\system32
75590000 SECUR32.DLL            6.1.7601.18443     C:\Windows\system32
755b0000 bcrypt.dll             6.1.7600.16385     C:\Windows\system32
75690000 cryptdll.dll           6.1.7600.16385     C:\Windows\system32
75880000 SSPICLI.DLL            6.1.7601.18443     C:\Windows\system32
758f0000 CRYPTBASE.dll          6.1.7600.16385     C:\Windows\system32
75900000 SXS.DLL                6.1.7601.17514     C:\Windows\system32
75960000 RpcRtRemote.dll        6.1.7601.17514     C:\Windows\system32
759e0000 MSASN1.dll             6.1.7601.17514     C:\Windows\system32
75ac0000 KERNELBASE.dll         6.1.7601.18409     C:\Windows\system32
75b50000 CRYPT32.dll            6.1.7601.18277     C:\Windows\system32
75cd0000 NSI.dll                6.1.7600.16385     C:\Windows\system32
75d10000 user32.dll             6.1.7601.17514     C:\Windows\system32
75e40000 SHLWAPI.dll            6.1.7601.17514     C:\Windows\system32
75ea0000 WS2_32.dll             6.1.7601.17514     C:\Windows\system32
75ef0000 ole32.dll              6.1.7601.17514     C:\Windows\system32
76050000 CLBCatQ.DLL            2001.12.8530.16385 C:\Windows\system32
760e0000 shell32.dll            6.1.7601.18429     C:\Windows\system32
76d30000 oleaut32.dll           6.1.7601.17676     C:\Windows\system32
76fc0000 USP10.dll              1.626.7601.18009   C:\Windows\system32
77060000 comdlg32.dll           6.1.7601.17514     C:\Windows\system32
770e0000 GDI32.dll              6.1.7601.18275     C:\Windows\system32
772f0000 sechost.dll            6.1.7600.16385     C:\Windows\SYSTEM32
77310000 RPCRT4.dll             6.1.7601.18205     C:\Windows\system32
773c0000 kernel32.dll           6.1.7601.18409     C:\Windows\system32
774a0000 IMM32.DLL              6.1.7601.17514     C:\Windows\system32
775f0000 advapi32.dll           6.1.7601.18247     C:\Windows\system32
77690000 msvcrt.dll             7.0.7601.17744     C:\Windows\system32
77930000 ntdll.dll              6.1.7601.18247     C:\Windows\SYSTEM32
77a80000 MSCTF.dll              6.1.7600.16385     C:\Windows\system32
77b50000 LPK.dll                6.1.7601.18177     C:\Windows\system32

processes:
0000 Idle                    0 0   0
0004 System                  0 0   0
0140 smss.exe                0 0   0
0210 csrss.exe               0 0   0
0244 wininit.exe             0 0   0
0254 csrss.exe               1 0   0
0278 services.exe            0 0   0
0288 lsass.exe               0 0   0
0290 lsm.exe                 0 0   0
02d8 winlogon.exe            1 0   0
0334 svchost.exe             0 0   0
0394 svchost.exe             0 0   0
03d0 svchost.exe             0 0   0
0410 svchost.exe             0 0   0
044c svchost.exe             0 0   0
0498 svchost.exe             0 0   0
057c svchost.exe             0 0   0
0630 spoolsv.exe             0 0   0
064c svchost.exe             0 0   0
0698 armsvc.exe              0 0   0
06f4 EndpointIntegration.exe 0 0   0
07f0 epag.exe                0 0   0
08a0 svchost.exe             0 0   0
09b8 EndpointService.exe     0 0   0
0c10 Console.exe             1 45  25  normal       C:\Program Files\Bitdefender\Endpoint
0c58 taskhost.exe            1 26  24  normal       C:\Windows\system32
0ca8 Dwm.exe                 1 23  3   high         C:\Windows\system32
0cc8 Explorer.EXE            1 908 689 normal       C:\Windows
0d54 GoogleCrashHandler.exe  0 0   0
0db8 svchost.exe             0 0   0
0f0c VMonitor.exe            1 16  11  normal       C:\Program Files\Vimicro Corporation\VMUVC
0f60 MSOSYNC.EXE             1 64  24  normal       C:\Program Files\Microsoft Office\Office14
0f80 ONENOTEM.EXE            1 18  6   normal       C:\Program Files\Microsoft Office\Office14
086c SearchIndexer.exe       0 0   0
05ac mobsync.exe             1 9   8   normal       C:\Windows\System32
0c20 IAStorDataMgrSvc.exe    0 0   0
006c LMS.exe                 0 0   0
0e58 UNS.exe                 0 0   0
0fc0 OUTLOOK.EXE             1 833 539 normal       C:\Program Files\Microsoft Office\Office14
0854 OSPPSVC.EXE             0 0   0
0454 chrome.exe              1 610 108 normal       C:\Program Files\Google\Chrome\Application
0e4c chrome.exe              1 11  4   normal       C:\Program Files\Google\Chrome\Application
07ac chrome.exe              1 237 1   normal       C:\Program Files\Google\Chrome\Application
16a8 Dropbox.exe             1 111 62  normal       C:\Users\purglel\AppData\Roaming\Dropbox\bin
15d0 chrome.exe              1 577 1   below normal C:\Program Files\Google\Chrome\Application
0914 chrome.exe              1 323 1   below normal C:\Program Files\Google\Chrome\Application
0ebc RecorderApp.exe         1 239 193 normal       \\wwtsql01\recorder6
0c38 audiodg.exe             0 0   0
0ea8 MSACCESS.EXE            1 284 147 normal       C:\Program Files\Microsoft Office\Office14
089c chrome.exe              1 128 1   normal       C:\Program Files\Google\Chrome\Application
13cc WUDFHost.exe            0 0   0
14e0 prevhost.exe            1 9   4   normal       C:\Windows\system32
0ee4 EXCEL.EXE               1 228 81  normal       C:\PROGRA~1\MICROS~1\Office14
1224 WmiPrvSE.exe            0 0   0
1358 TrustedInstaller.exe    0 0   0

hardware:
+ Computer
  - ACPI x86-based PC
+ Disk drives
  - ST250DM000-1BD141
  - USB Flash Disk USB Device
+ Display adapters
  - Intel(R) HD Graphics Family (driver 8.15.10.2559)
+ DVD/CD-ROM drives
  - ATAPI iHAS122   C
+ Human Interface Devices
  - HID-compliant consumer control device
  - HID-compliant device
  - USB Input Device
  - USB Input Device
  - USB Input Device
+ IDE ATA/ATAPI controllers
  - Intel(R) Desktop/Workstation/Server Express Chipset SATA AHCI Controller (driver 10.6.0.1002)
+ Keyboards
  - HID Keyboard Device
+ Mice and other pointing devices
  - HID-compliant mouse
+ Monitors
  - Generic PnP Monitor
+ Network adapters
  - Atheros AR8151 PCI-E Gigabit Ethernet Controller (NDIS 6.20) (driver 2.0.4.4)
+ Portable Devices
  - PL USB WORK
+ Ports (COM & LPT)
  - Communications Port (COM1)
  - Printer Port (LPT1)
+ Processors
  - Intel(R) Pentium(R) CPU G630 @ 2.70GHz
  - Intel(R) Pentium(R) CPU G630 @ 2.70GHz
+ Sound, video and game controllers
  - Realtek High Definition Audio (driver 6.0.1.6511)
+ Storage volume shadow copies
  - Generic volume shadow copy
  - Generic volume shadow copy
  - Generic volume shadow copy
  - Generic volume shadow copy
  - Generic volume shadow copy
  - Generic volume shadow copy
+ System devices
  - 2nd Generation Intel(R) Core(TM) Processor Family DRAM Controller - 0100 (driver 9.2.0.1026)
  - ACPI Fan
  - ACPI Fan
  - ACPI Fan
  - ACPI Fan
  - ACPI Fan
  - ACPI Fixed Feature Button
  - ACPI Power Button
  - ACPI Thermal Zone
  - ACPI Thermal Zone
  - Composite Bus Enumerator
  - Direct memory access controller
  - File as Volume Driver
  - High Definition Audio Controller
  - High precision event timer
  - Intel(R) 6 Series/C200 Series Chipset Family PCI Express Root Port 1 - 1C10 (driver 9.2.0.1016)
  - Intel(R) 6 Series/C200 Series Chipset Family PCI Express Root Port 5 - 1C18 (driver 9.2.0.1016)
  - Intel(R) 6 Series/C200 Series Chipset Family SMBus Controller - 1C22 (driver 9.2.0.1011)
  - Intel(R) 82801 PCI Bridge - 244E
  - Intel(R) 82802 Firmware Hub Device
  - Intel(R) H61 Express Chipset Family LPC Interface Controller - 1C5C (driver 9.2.0.1016)
  - Intel(R) Management Engine Interface
  - Microsoft ACPI-Compliant System
  - Microsoft System Management BIOS Driver
  - Microsoft Virtual Drive Enumerator Driver
  - Motherboard resources
  - Motherboard resources
  - Motherboard resources
  - Motherboard resources
  - Motherboard resources
  - Numeric data processor
  - PCI bus
  - PCI standard PCI-to-PCI bridge
  - Plug and Play Software Device Enumerator
  - Printer Port Logical Interface
  - Programmable interrupt controller
  - Remote Desktop Device Redirector Bus
  - System board
  - System board
  - System CMOS/real time clock
  - System timer
  - Terminal Server Keyboard Driver
  - Terminal Server Mouse Driver
  - UMBus Enumerator
  - UMBus Enumerator
  - UMBus Root Bus Enumerator
  - Volume Manager
+ Universal Serial Bus controllers
  - Generic USB Hub
  - Generic USB Hub
  - Generic USB Hub
  - Intel(R) 6 Series/C200 Series Chipset Family USB Enhanced Host Controller - 1C26 (driver 9.2.0.1021)
  - Intel(R) 6 Series/C200 Series Chipset Family USB Enhanced Host Controller - 1C2D (driver 9.2.0.1021)
  - USB Composite Device
  - USB Mass Storage Device
  - USB Root Hub
  - USB Root Hub

Purgle Linham
Wiltshire & Swindon Biological Records Centre

Purgle Linham's Website

10 Reply by MikeWeideli

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

Re: Contribute to recording scheme error

The error is the result of there filter returning no records. This is happening because Conferophyta is considered an obsolete  level in the taxonomic hierarchy.  The conifers are  pointing to the Phylum Tracheophyta which includes all vascular plants. The classes under this are Magnoliopsida,Pinopsida,Equisetopsida,Ginkgoopsida and Lycopodiopsida. This  is why the class is returning a valid result. Tracheophyta is on the list of additional names and if you use this as the starting point to expand the hierarchy you should  get all the vascular plants. The fact that this is on the List of Additional Names suggest that this is a change in structure which has come about since the list of vascular plants was produced.

The error message is occuring only as indirect result of there being no records returned for Coniferophyta. What should  happens is that there should simply be no records returned and  no an error message.

What I would like to see happening is that when expanding hierrachies, if the starting point is  considered an obsolete level then a message appears explaining this, so that a valid level can be chosen.

Mike Weideli

MikeWeideli's Website

11 Reply by Purgle Linham

  • Purgle Linham
  • Veteran
  • Offline
  • From: Wiltshire
  • Registered: 30-03-2009
  • Posts: 99

Re: Contribute to recording scheme error

Thanks Mike. I'm trying this out now - so far I seem to get a discrepancy of about 6,000 records less in the export filter built on the Phym Trachaeophyta (as you outlined above) compared with running a report wizard query on the Vascular Plant checklist. I also get a slightly different figure between the outputs when I run the filter as a contribution to a scheme instead of through the export filter. I'm not sure what's being included/excluded so need to examine the outputs next.

Purgle

Purgle Linham
Wiltshire & Swindon Biological Records Centre

Purgle Linham's Website

12 Reply by RobLarge (edited by RobLarge 09-06-2014 15:37:59)

  • RobLarge
  • RobLarge
  • Veteran
  • Offline
  • From: Wiltshire
  • Registered: 15-07-2008
  • Posts: 812

Re: Contribute to recording scheme error

OK, I have been working on this a bit and have resolved the reason why the export filter produces a different result to the contribute to schemes function. On Purgle's Trachyophyta query the difference is about 1100 records which are returned by the export filter, but not when contributing to schemes. The difference is entirely composed of confidential records.

When using the export filter, with the export confidential option checked a dialog warns that there are confidential records, but allows you to go ahead if you wish. With contribute to schemes there is no such dialog and it is not possible to export any confidential record. Whilst I can understand the reasoning behind this, I regard it as a flaw which has the potential to make my life rather difficult in some circumstances.

This has highlighted a broader problem with the way Recorder handles confidentiality and sensitive species. Basically confidentiality is assigned to individual taxon occurrences (for example when a landowner allows us survey access, but does not wish to have data published more widely - as is their right), but in its unaltered form R6 has no way of dealing with sensitive species. We have got around this by creating a taxon designation "Wiltshire confidential taxon" for species which we regard as sensitive (i.e. data not for public consumption at full resolution, or in some cases at all). I have also set up an attribute for the report wizard which returns true when either a record is confidential, or is of a sensitive species. Output from the wizard is also post-processed before sending data out of the LRC to remove such data, or reduce its spatial resolution, and/or obscure some of the other attributes as appropriate.

The problem comes when exporting to the NBN (and I hadn't previously appreciated this fully). The export addin produces a T/F field called "sensitive", but what this actually contains is whether or not the record is marked as confidential, so in order to correctly populate this field we have to run a batch update periodically which marks all records of sensitive species as confidential. However, this means that records of sensitive species (which we do want to give the NBN, in a controlled manner) are indistinguishable from those from surveys which the owner has requested be kept strictly confidential.

The Natural England MoA requires that we upload records of sensitive species, but as it stands we might also be uploading data which breaches the confidentiality of client landowners. My head is spinning right now, trying to work out how to put this mess right. Any ideas gratefully accepted.

Now returning to the original issue. The report wizard (returning all taxa from the vascular plants & stoneworts list) returns 11,000 more records than the export filter on Tracheophyta. A few of the additionals are stoneworts (which are not true vascular plants), but the vast majority are Ferns.

Finally a dictionary error, the class Pteridophyta, should be included in Trachyophyta, but it is not in the list you provided above Mike, and nor is it in the dictionary. Ferns are vascular plants too. Can you correct this, or should I tell Chris?

Rob Large
Wildlife Sites Officer
Wiltshire & Swindon Biological Records Centre

RobLarge's Website

13 Reply by MikeWeideli

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

Re: Contribute to recording scheme error

I think we can deal with this either through Recorder or via the addin.  Priorities for changes  are now  being decided by the Recorder 6 Steering Group, so all I can do is raise it as a requirement. I will ask Chris about the Pteridophyta.

Mike Weideli

MikeWeideli's Website

14 Reply by RobLarge

  • RobLarge
  • RobLarge
  • Veteran
  • Offline
  • From: Wiltshire
  • Registered: 15-07-2008
  • Posts: 812

Re: Contribute to recording scheme error

Thanks Mike, I know I am going to have to sort out our sensitive records issue myself, but the mismatch between R6 confidential and NBN sensitive remains a problem. I wonder how others handle it.

Rob Large
Wildlife Sites Officer
Wiltshire & Swindon Biological Records Centre

RobLarge's Website