1 Topic by derek coleman

  • derek coleman
  • Member
  • Offline
  • Registered: 03-11-2009
  • Posts: 26

Topic: SxBRC report fails

The Geographic area/Location report 'SxBrc detailed species list' I used to run successfully is currently failing with the message

There is an error in the SQL code. The error message is ‘String or binary data would be truncated’

I have just upgraded to 6.22, although it also failed at 6.18.

Any help much appreciated

2 Reply by Purgle Linham

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

Re: SxBRC report fails

This thread might be of help...
http://forums.nbn.org.uk/viewtopic.php?id=389

Purgle Linham
Wiltshire & Swindon Biological Records Centre

Purgle Linham's Website

3 Reply by MikeWeideli

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

Re: SxBRC report fails

The length of the sort order field is wrong in this report, but this hasn't been a problem before as the full length of the field wasn't being used. A revised version of the XML report is attached or you can alter the length of the sort order to 30 characters  in the xml file by opening it in notepad.  The change is required in the Create table part of the report at the very top.   Sort_Order VARCHAR(30).

Post's attachments

SxBrc Detailed Species List.xml 8.27 kb, 3 downloads since 2014-09-11 

You don't have the permssions to download the attachments of this post.
Mike Weideli

MikeWeideli's Website

4 Reply by derek coleman

  • derek coleman
  • Member
  • Offline
  • Registered: 03-11-2009
  • Posts: 26

Re: SxBRC report fails

Many thanks.  Report now working.