1 Reply by Paul Leonard

  • Paul Leonard
  • Member
  • Offline
  • From: Rotherham BRC
  • Registered: 22-01-2010
  • Posts: 36

Re: Problem reporting on taxon records for a place ...

... using Report Wizard. I am currently having no success at all extracting taxon records for a place using the Report Wizard. The 'last error' message relating to my most recent attempt is as follows:

Exception occurred in application Recorder 6 at 25/01/2010 11:56:26.
Version : 6.13.2.176

Exception path:
EOleException : The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.#REPORT_OUTPUT______________________________________________________________________________________________________0000000002FB' and the index name 'IX_OCCURRENCE_KEY'. The duplicate key value is (SR000416000AH084, T)
TExceptionPath : An error occurred executing the following SQL:
CREATE UNIQUE CLUSTERED INDEX IX_OCCURRENCE_KEY ON "#REPORT_OUTPUT" (OCCURRENCE_KEY, [TYPE])

Last event\actions:
  TdlgWizard created
  TfrmFilterResult deactivated
  TfrmLocations activated
  TfrmLocations deactivated
  TfrmFilterResult activated
  TfrmFilterResult deactivated
  TfrmLocations activated
  TfrmLocations deactivated
  TfrmFilterResult activated

Operating System : Windows XP  5.01.2600  Service Pack 3
Physical Memory available : 2,091,204 KB

DLLs loaded:
  advapi32.dll (5.1.2600.5512)
  comctl32.dll (5.82.2900.5512)
  comdlg32.dll (6.0.2900.5512)
  gdi32.dll (5.1.2600.5698)
  gdiplus.dll (5.1.3102.5581)
  HHCtrl.ocx (5.2.3790.4110)
  kernel32.dll (5.1.2600.5512)
  mpr.dll (5.1.2600.5512)
  MS5.Dll (5.0.0.12)
  MS5User.Dll (5.0.0.4)
  odbc32.dll (3.525.1132.0)
  ole32.dll (5.1.2600.5512)
  oleaut32.dll (5.1.2600.5512)
  shell32.dll (6.0.2900.5512)
  user32.dll (5.1.2600.5512)
  version.dll (5.1.2600.5512)
  winmm.dll (5.1.2600.5512)
  winspool.drv (5.1.2600.5512)

Please can someone shed some light on what is going wrong here to a relatively new Recorder user?

Many thanks.

Biological Records Officer
Rotherham MBC
Rotherham Biological Records Centre

2 Reply by johnvanbreda

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

Re: Problem reporting on taxon records for a place ...

Hi Paul

Does this happen if you try a really simple set of attributes, e.g. just the sample date, spatial ref and taxon name? Or does it only happen when you introduce a certain attribute into the report?

John van Breda
Biodiverse IT

johnvanbreda's Website

3 Reply by Paul Leonard

  • Paul Leonard
  • Member
  • Offline
  • From: Rotherham BRC
  • Registered: 22-01-2010
  • Posts: 36

Re: Problem reporting on taxon records for a place ...

Hi John,
This seems to be happening with queries of all complexities - but not necessarily consistently. I successfully extracted all Wood Warbler records from the database yesterday but was unable to report on species recorded in my back garden! The crux of it seems to be when I ask for a 'report about a place' using the wizard. It doesn't matter whether the site has a complex sub-site heirarchy or whether its a simple, single tier site, or whether I'm asking for a single species or a large suite. If I search by taxon record, it seems OK. This is really driving me to distraction at the moment and is preventing me from responding to external data requests.

Kind regards,

Paul

Biological Records Officer
Rotherham MBC
Rotherham Biological Records Centre

4 Reply by johnvanbreda

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

Re: Problem reporting on taxon records for a place ...

Hi Paula
Just wondering if this still happens, and if it occurs in the latest version of Recorder, 6.15.4?

John van Breda
Biodiverse IT

johnvanbreda's Website

5 Reply by charliebarnes

  • charliebarnes
  • Veteran
  • Offline
  • From: Greater Lincolnshire
  • Registered: 07-09-2008
  • Posts: 1,396

Re: Problem reporting on taxon records for a place ...

johnvanbreda wrote:

Just wondering if this still happens, and if it occurs in the latest version of Recorder, 6.15.4?

John - on 6.16.2.241 I get the same error. Steps to reproduce using the report wizard:

1. Report about a place <-- this appears to be the cause.
2. Place names
3. Select a single location
4. Include taxon information
5. Selected information
6. All taxa from list
7. Select a designation that will pull out some species
8. New layout
9. Select multiple attributes <-- and this appears to be the cause.
10. No sorting

Selecting only one attribute does not appear to trigger the error (unless you click continue on error handler dialog, and go back and uncheck all but of the attributes - I guess some SQL tables/indices aren't cleared - if you don't quit recorder, the error seems to keep appearing regardless)

Charlie Barnes
Information Officer
Greater Lincolnshire Nature Partnership

charliebarnes's Website

6 Reply by johnvanbreda

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

Re: Problem reporting on taxon records for a place ...

Charlie,
Thanks very much for the detailed report. You are right, the problem stems from certain combinations of attributes when used for a place report. I've fixed it in the code so this should work in the next release of Recorder.
Best wishes

John van Breda
Biodiverse IT

johnvanbreda's Website