26 Reply by MikeWeideli

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

Re: TVK errors, reporting and filtering

Thanks. This is going to take a while to investigate.

Mike Weideli

MikeWeideli's Website

27 Reply by robtaylor

  • robtaylor
  • Member
  • Offline
  • Registered: 13-11-2014
  • Posts: 20

Re: TVK errors, reporting and filtering

Thanks Mike,
Your quick responses are appreciated.
So it seems that Vascular plants and Bryophites are the ones causing the issue for us. I am looking at SQL trace to see if I can fathom at what point the error is occurring, can I help with providing any further info?
Rob

28 Reply by MikeWeideli

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

Re: TVK errors, reporting and filtering

The most likely problem will be a field which is concatenated or calculated in some way. We had problems in the past with the temporary table having some  fields which were too short.  Upgrading to R6 Version 6.22 and using the 6.22 version of the addin should have fixed  these, so it looks like a new problem. Any help you can give in identifying the cause would be appreciated

Mike Weideli

MikeWeideli's Website

29 Reply by robtaylor

  • robtaylor
  • Member
  • Offline
  • Registered: 13-11-2014
  • Posts: 20

Re: TVK errors, reporting and filtering

Hi Mike,
Is there a report or another test I can run whose output could help you?
Thanks
Rob

30 Reply by MikeWeideli

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

Re: TVK errors, reporting and filtering

Can you please check for me what the field lengths are in stored procedure nbn_exchange_create_tables  Specifically is grid Reference set to varchar(40).

Mike Weideli

MikeWeideli's Website

31 Reply by robtaylor

  • robtaylor
  • Member
  • Offline
  • Registered: 13-11-2014
  • Posts: 20

Re: TVK errors, reporting and filtering

Hi Mike,
Sorry for the delay, I have been on annual leave and catching up after, the SP is attached, the gridref variable type is varchar(30).

Post's attachments

nbn_exchange_create_tables.txt 2.51 kb, 12 downloads since 2015-04-24 

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

32 Reply by robtaylor

  • robtaylor
  • Member
  • Offline
  • Registered: 13-11-2014
  • Posts: 20

Re: TVK errors, reporting and filtering

Hi Mike,
Is there any other info i can provide?
Thanks
Rob

33 Reply by MikeWeideli

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

Re: TVK errors, reporting and filtering

The Grid Ref field is slightly shorter than the maximum  allowed in R6. Do you now enough to change this to 40 characters. From within SQL Server  tools it would be necessary to right click and choose modify procedure, then change the   grid ref length from 30  to 40 and run the script.  There should  also be a  log file (export_log.txt) which will either be in the Report or Addin folder. If this is there is may it tell us a bit more about what is happening.

Mike Weideli

MikeWeideli's Website

34 Reply by kbalmer

  • kbalmer
  • Veteran
  • Offline
  • From: Bedford
  • Registered: 12-05-2006
  • Posts: 162

Re: TVK errors, reporting and filtering

I have just stumbled across the "Greenfinch" issue mentioned earlier in this thread with records for
Chloris chloris entered on checklist BIRDS British Ornithologists' Union British List (Categories A, B, C)
not being a synonym for
Carduelis chloris entered on checklist British Ornithologists' Union categories D and E

I think our dictionaries are up-to-date (2Z)?

I see that the NBN Gateway shows these as two separate species https://data.nbn.org.uk/Taxa/NHMSYS0000530248 and https://data.nbn.org.uk/Taxa/NHMSYS0021002985

Is this still considered to be synonym issue (rather than two separate species) and is any action occuring to fix it please?

Regards, Keith

kbalmer's Website