1 Topic by KatherineERIC

  • KatherineERIC
  • New member
  • Offline
  • Registered: 13-10-2014
  • Posts: 2

Topic: NBN Exchange format error

Hi there,

I've been exporting records in batches using the NBN Exchange add-in and had no problems until trying to export the final batch. I keep getting an error: Internal exception occurred in the NBN exchange addin. Stored procedure: nbn_exchange_basic_update
The exception message is: string or binary data would be truncated

Any ideas? I'd really appreciate some advice bearing in mind the Natural England deadline is today - oops!

Many thanks in advance,
Katherine

2 Reply by AndyFoy

  • AndyFoy
  • Consultant
  • Offline
  • Registered: 09-08-2006
  • Posts: 219

Re: NBN Exchange format error

Katherine

Looking at that stored procedure, the only possible truncation that stands out is if you have any Samples where the Spatial Reference is longer than 30 characters.  That sounds very unlikely but is it possible in your data?

Andy

Andy Foy
Systems Manager
Greenspace Information for Greater London (GiGL) CIC
www.gigl.org.uk

3 Reply by KatherineERIC

  • KatherineERIC
  • New member
  • Offline
  • Registered: 13-10-2014
  • Posts: 2

Re: NBN Exchange format error

Andy - you were right! Somehow lat/long has appeared in the spatial ref for one particular dataset. Thanks so much for your help, much appreciated.

Katherine

Katherine Pinnock
ERIC North East Coordinator
Environmental Records Information Centre North East