1 Reply by KCUNN

  • KCUNN
  • Member
  • Offline
  • Registered: 18-03-2007
  • Posts: 10

Re: Report Wizard error on species name

Hi Sarah,

When trying to report on a survey the following Error occured.

Exception occurred in application Recorder 6 at 17/12/2007 12:14:43.
Version : 6.10.4.120

Exception path:
EOleException : String or binary data would be truncated
TExceptionPath : An error occurred executing the following SQL:
UPDATE "#REPORT_OUTPUT" SET #REPORT_OUTPUT.[Taxon Latin Name] = Index_Taxon_Name.Preferred_Name FROM #REPORT_OUTPUT LEFT JOIN INDEX_TAXON_NAME ON INDEX_TAXON_NAME.TAXON_LIST_ITEM_KEY=#REPORT_OUTPUT.LIST_ITEM_KEY AND INDEX_TAXON_NAME.SYSTEM_SUPPLIED_DATA=1 WHERE #REPORT_OUTPUT.TYPE = 'T'

I managed to isolate it to one species name: Philadelphus coronarius x microphyllus x pubescens = P. x virginalis,
Taxon list Item Key NHMSYS0001753997

There seems to be an error with this name in the species dictionary for some reason.


Keith Cunningham ( Volunteer )
Durham Biodiversity Data Service
Hosted by Durham Wildlife Trust[/b]

2 Reply by Sarah Shaw

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

Re: Report Wizard error on species name

Hi Keith

Many thanks for reporting this - the same error was also reported by Brian Miller last week - see following post for details http://forums.nbn.org.uk/viewtopic.php?id=493.

The problem is the '=' character in the taxon name - there are over 600 hundred names in the dictionary that contain this character.

We're currently discussing with the NHM how best to deal with this - it will either be in a dictionary update or a change to the software.

If you could 'subscribe' to the above post that would be great - that way I can keep yourself and Brian informed and let you know when we are likely to be able to provide a fix.

Best wishes,

Sarah Shaw
Biodiversity Information Assistant
JNCC