1 Reply by Sarah Shaw

  • Sarah Shaw
  • Veteran
  • Offline
  • Registered: 23-06-2006
  • Posts: 267

Re: Bug with filter tool in Observation hierarchy - can anyone reproduce??

During testing of V6.9.1 Charles Roper reported the following problem when filtering on Taxon in the Observation Hierarchy:

When filtering on a taxon name using the Observations hierarchy filter tool, Recorder's memory usage grows to an unusually large size and then throws an exception (EOleException: Object was open).

To recreate:

1. Select a taxon occurrence in the hierarchy.
2. Click the filter icon.
3. Select a Taxon Name.
Type taxon name e.g. ‘Lampyris noctiluca’ and click OK to run the filter.

Can anyone reproduce this problem in V6.7.2 and/or is anyone having similar problems?

You can also run the following SQL against the NBN database in Query Analyser or in Access:

select calculation_sql from usable_field where usable_Field_key = 'ABABABAB00000086'

The result you should get from this query is:

SELECT TXO.Taxon_Occurrence_Key AS ItemKey FROM Taxon T, Taxon_Version TV, Taxon_Occurrence TXO, Taxon_List_Item TLI, Taxon_Determination TD WHERE TLI.Taxon_List_Item_Key = TD.Taxon_List_Item_Key AND TXO.Taxon_Occurrence_Key = TD.Taxon_Occurrence_Key AND TV.Taxon_Version_Key = TLI.Taxon_Version_Key AND T.Taxon_Key = TV.Taxon_Key AND Preferred = True AND Item_Name

Please let me know if you are having problems with this, or if you do not get the result above for the query provided.


Many thanks,

Sarah

Sarah Shaw
Biodiversity Information Assistant
JNCC

Sarah Shaw
Biodiversity Information Assistant
JNCC

2 Reply by brianmiller (edited by brianmiller 12-09-2006 08:15:01)

  • brianmiller
  • Veteran
  • Offline
  • Registered: 10-05-2006
  • Posts: 113

Re: Bug with filter tool in Observation hierarchy - can anyone reproduce??

Having tried this in 6.7.2.77 I do not get the same problem. It filters fine. Rather scarily the first species at the top of our Obs Hierarchy is Glow-Worm!

Interestingly I could not get the SQL to work in Query Analyser, but I could in Enterprise Manager and it produced the result as required.

Hope this helps

Brian

Brian Miller
(Conservation Officer (Buckinghamshire), BBOWT)

brianmiller's Website

3 Reply by Sarah Shaw (edited by Sarah Shaw 12-09-2006 12:12:59)

  • Sarah Shaw
  • Veteran
  • Offline
  • Registered: 23-06-2006
  • Posts: 267

Re: Bug with filter tool in Observation hierarchy - can anyone reproduce??

Thanks for that Brian.

We just want to get an idea of how many other people have this problem so that if necessary Dorset software can provide a fix for it.

Kind regards,

Sarah

Sarah Shaw
Biodiversity Information Assistant
JNCC

4 Reply by cporter

  • cporter
  • Member
  • Offline
  • From: Ulster Museum, Belfast, NI
  • Registered: 26-05-2006
  • Posts: 15

Re: Bug with filter tool in Observation hierarchy - can anyone reproduce??

When I try to filter Taxon Name using Version 6.7.2.77 I get syntax errors for all the condition choices. 

The 'Is Equal To' condition produces the following exception error:

Exception occurred in application Recorder 6 at 18/09/2006 09:05:23.
Version : 6.7.2.77

Exception path:
EOleException : Line 2: Incorrect syntax near '='

Last event\actions:
  TfrmSurveyDetails created
  TfrmSurveyDetails destroyed
  TfrmTaxonOccurrences created
  TfrmTaxonOccurrences destroyed
  TfrmSurveyDetails created
  TfrmSurveyDetails destroyed
  TfrmTaxonOccurrences created
  TfrmTaxonOccurrences destroyed
  TfrmSurveyDetails created

Operating System : Windows XP  5.01.2600  Service Pack 2
Physical Memory available : 1,047,004 KB

DLLs loaded:
  advapi32.dll (5.1.2600.2180)
  comctl32.dll (5.82.2900.2180)
  comdlg32.dll (6.0.2900.2180)
  gdi32.dll (5.1.2600.2180)
  HHCtrl.ocx (5.2.3790.1280)
  kernel32.dll (5.1.2600.2180)
  mpr.dll (5.1.2600.2180)
  MS5.Dll (5.0.0.12)
  MS5User.Dll (5.0.0.4)
  odbc32.dll (3.525.1117.0)
  ole32.dll (5.1.2600.2595)
  oleaut32.dll (5.1.2600.2180)
  shell32.dll (6.0.2900.2620)
  user32.dll (5.1.2600.2622)
  version.dll (5.1.2600.2180)
  winmm.dll (5.1.2600.2180)
  winspool.drv (5.1.2600.2180)

Information has been saved to the file R:\LastError.txt

'Is Not Equal To' produces: EOleException : Line 2: Incorrect syntax near '<'
'Starts With' and 'Contains' produce: EOleException : Incorrect syntax near the keyword 'LIKE'

However when I run the SQL in query analyser it produces the expected result. 

Catherine

Catherine

cporter's Website

5 Reply by Sarah Shaw

  • Sarah Shaw
  • Veteran
  • Offline
  • Registered: 23-06-2006
  • Posts: 267

Re: Bug with filter tool in Observation hierarchy - can anyone reproduce??

Hi Catherine

Thanks for trying this out. I have come across a problem when filtering on comments and description fields, and have also had some inconsistent results (which I have reported to Dorset software) but nothing along these lines.

My copy of V6.7.2.77 seems to filter ok on taxon name. Could you give me an example - what taxon did you try to filter on and in which list?

Many thanks for your help,

Sarah

Sarah Shaw
Biodiversity Information Assistant
JNCC

Sarah Shaw
Biodiversity Information Assistant
JNCC