1 Reply by atheta

  • atheta
  • Member
  • Offline
  • Registered: 31-05-2007
  • Posts: 12

Re: R6 preloaded reports - JNCC H1 Duplicate records

Reports > Run > JNCC > Housekeeping Reports > H1 Duplicate Records.................does anyone know if this report actually works?  Having selected a survey, for example one with only a handful of records in it, I get the hourglass which presumably tells me that a report is being prepared but nothing happens. After about an hour, I get both fed up and the "R6 not responding" message. Any comments would be appreciated. Can readers have a go and let me know what results they get?

2 Reply by johnvanbreda

  • johnvanbreda
  • Administrator
  • Offline
  • From: UK
  • Registered: 27-04-2006
  • Posts: 1,237

Re: R6 preloaded reports - JNCC H1 Duplicate records

Hi Atheta,

I'm pretty sure this report is working, it's just slow depending on how many records you have. Have you tried leaving it overnight?

Best Wishes

John van Breda
Biodiverse IT

johnvanbreda's Website

3 Reply by Lynn Heeley

  • Lynn Heeley
  • Administrator
  • Offline
  • Registered: 03-07-2008
  • Posts: 345

Re: R6 preloaded reports - JNCC H1 Duplicate records

Hi Atheta,

There is actually a problem with this report currently (possibly others too) - an error in the SQL code relating to a collate conflict in the equal operation. We are currently updating the reports for 6.14 so I will try and post you a new one when its available.

Cheers,
Lynn

4 Reply by Lynn Heeley

  • Lynn Heeley
  • Administrator
  • Offline
  • Registered: 03-07-2008
  • Posts: 345

Re: R6 preloaded reports - JNCC H1 Duplicate records

Hi Atheta,

Evidently Mike Weideli updated these a while ago so that they ran a bit quicker, he has supplied me with the newer versions which appear to be working correctly. Many thanks Mike. You can download them from here: http://forums.nbn.org.uk/uploads.php?file=JNCC_H1_Duplicates.xml and http://forums.nbn.org.uk/uploads.php?file=JNCC_H2_Duplicates.xml

Hope this helps.
Cheers,
Lynn

5 Reply by atheta

  • atheta
  • Member
  • Offline
  • Registered: 31-05-2007
  • Posts: 12

Re: R6 preloaded reports - JNCC H1 Duplicate records

Thanks Lynn and John - I will have a look at the downloaded files and let you know how I get on