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]