|
The technical forum of the NBN Trust for use by the Network. It includes discussions and announcements on the NBN Atlas, Recorder 6 and Indicia |
You are not logged in. Please login or register.
Forum → Recorder Troubleshooting and Bug Reports → XML report error in v6.25
Hi
So since upgrading to 6.25 and restoring our report files which were removed in the process, we're now getting the attached error with a report which is based on Mike's 'QUICK REPORT - From Polygon on Map' report. I can send you the report separately - its seems you can only add one file per message on here.
Thanks
I think a field length must have changed. Probably the sort code. If you email me the file by I will fix.
Thanks Mike, will do.
Hi, I've also had a new XML report error since upgrading to v6.25. It relates to the detailed species list (Sxbrc Detailed Species List ) which now states "there is an error in te SQL code. The error message is: 'String or binary data would be truncated'. I used to get this error following one of the previous upgrades but it got resolved follwoign another upgrade but has sadly reappeared after the latest upgrade. Is it easy to find which field name is being truncated and can the character length in the field be easily increased to resolve it? or is it not as simple as that?
Many thanks
Phil
Yorkshire Wildlife Trust
Hi Phil
The error for us was that 'Sort_Order VARCHAR(30)' needs to be 'Sort_Order VARCHAR(36)'. It works fine now (bar a few odd bits such as taxonomic order changing)
Looking at that SxBRC report it has the above as 30 so try changing it to 36 characters and hopefully it will run ok.
Purgle
Ah brilliant, Thanks Purgle. I'll give that a try.
Many thanks
Forum → Recorder Troubleshooting and Bug Reports → XML report error in v6.25
Powered by PunBB 1.4.6, supported by Informer Technologies, Inc.